May 2010 Blog Posts (17)

Transport the tablespace Same OS platform

You want to transport tablespaces using RMAN backups instead of performing the transportable tablespaces operation on the live production database.

From here also http://mohamedazar.wordpress.com/2010/05/29/transport-the-tablespace-on-same-os-platform/

Source Database : MYTEST

Target Database : MYDB

Transportable…

Continue

Added by Mohamed Azar on May 29, 2010 at 5:53am — No Comments

SOA Case Studies

Have companies been able to realize the promise of SOA? Here is the proof

Financial

Bank of Baroda

First Horizon

Guardian

Helvetia Patria

Synovus Financial

AFLAC Inc.

Standard Bank South Africa

Large Australian bank uses SOA for introducing new products

Large Scandinavian bank uses SOA to reduce personal loan origination…
Continue

Added by SOA Trainer on May 28, 2010 at 9:34am — No Comments

Avail online Oracle Demantra Training: Starts 29th May 2010

Our new batch of online Oracle Demantra Training is commencing on 29 May 2010.



Why this training is…
Continue

Added by Focusthread Ltd on May 28, 2010 at 4:42am — No Comments

Avail online Oracle ERP Development Training- Starts 29th May 2010

Our new online course on Oracle ERP Development Training is commencing on 29th May, 2010



Why this training is necessary?




Oracle Enterprise Resource Planning (ERP) promotes a fully integrated systems approach, enables companies to cut costs, operate more efficiently, be more responsive to Client demand, reduce turnover and assist staff in reaching peak…
Continue

Added by Focusthread Ltd on May 28, 2010 at 4:22am — No Comments

Avail online Oracle Demantra Training- Starts 29th May 2010



Our new batch of online Oracle Demantra Training is commencing on
29 May 2010.



Why this training is…
Continue

Added by Focusthread Ltd on May 28, 2010 at 3:07am — No Comments

Create duplicate database using rman

You want to use RMAN to create a duplicate database on the same server by using RMAN backups.

Source database name is MYTEST

Target (duplicate) database name is MYDB

This is the simple steps to create a duplicate database

You can read from here…

Continue

Added by Mohamed Azar on May 25, 2010 at 11:33am — No Comments

Self-Service Human Resource (SSHR)

Self-Service Human Resource



SSHR stands for Self-Service Human resource. In Organizations this particular module helps in managing self service

functions at both manager level as well as employee level. One basic

advantage in using SSHR is it saves your time & money by giving the

related functions access to employee for changing their Personal

information for eg.: if an… Continue

Added by abhishek sharma on May 25, 2010 at 3:41am — No Comments

Update under the hood ... and some extreme side effects

If you want to read about how UPDATE works at block level and some ugly cases where you can flood the blocks and waste space, follow this link for English version UPDATE under the hood ...and some extreme side effects... or follow this link for Spanish text UPDATE interno... y sus efectos secundarios.



Hope you find it useful, please… Continue

Added by Ignacio Ruiz on May 24, 2010 at 5:00am — No Comments

Restoring old Optimizer Statistics for troubleshooting purpose

Since 10g, we do not simply overwrite old optimizer statistics by gathering new. Instead, the old optimizer statistics are automatically historized and kept for one month by default, so that they can be restored easily if that should be desired. Here we go with a short demonstration of restoring historic optimizer statistics…

Continue

Added by Uwe Hesse on May 19, 2010 at 8:10am — No Comments

Granule size

I wrote about Granule size and some example (and fake to test from granule 4M -> 16M when have memory limited)
http://surachartopun.com/2010/05/granule-size.html

Added by Surachart Opun on May 18, 2010 at 1:10pm — No Comments

Character Set migration Oracle 11g

When i tried to transport the tablespace from linux to windows, during import it shows charachter set error, so I just looked on linux database and windows database character set is different .

Linux is WE8IS08859P1

Windows is AR8ISO8859P6

So i plan to migrate the charater set of windows and change to WE8IS08859P1 character set. Here I provided step by step guide , How to migrate character set. I play with…

Continue

Added by Mohamed Azar on May 18, 2010 at 4:45am — 1 Comment

Oracle HRMS Job Opportunity

I have an excellent opportunity (Permanent) with a client of mine in Kansas City for a senior level Oracle HRMS (Payroll) and Oracle Financials Expert. I have a full job description I can send your way if you or anyone you know might have interest!



• This position will be responsible for the business requirements analysis, process modeling standards, and related business process documentation for both commercial off the shelf (COTS) and custom application environments.

• Leads…

Continue

Added by Jill Dryer on May 17, 2010 at 10:38am — No Comments

Index Dynamics - Part 3

Continuing with this series, where you can explore real life observations for regular Index behavior, within a living ERP system. This post present final results for this experiment, both in English Index Dynamics - Part 3 and Spanish Dinamica de Indices - Parte 3. I'll share a small recommendation derived from experiment: try not rebuild indexes before high… Continue

Added by Ignacio Ruiz on May 12, 2010 at 5:00am — No Comments

BACKUP AND RECOVERY: BLOCK RECOVERY IN RMAN

Block media recovery recovers an individual corrupt datablock or set of datablocks within a datafile. In cases when a small number of blocks

require media recovery, you can selectively restore and recover damaged

blocks rather than whole datafiles.
More please visit.…



Continue

Added by Rajeshkumar Govindarajan on May 7, 2010 at 3:30am — No Comments

Index Dynamics - Part 2

More than a year ago started a series of posts about Index Dynamics (initial post click here), don't know why, but updates on Oracle Community were miserably forgotten... anyway, today will resume and share with you real life results with a set of indexes from a live ERP system, armed with tools like statement ANALYZE INDEX and table INDEX_STATS. Full English text is available here… Continue

Added by Ignacio Ruiz on May 6, 2010 at 6:00am — No Comments

BLOCK RECOVERY Without Having RMAN Backup

Block media recovery recovers an individual corrupt datablock or set of datablocks within a datafile. In cases when a small number of blocks

require media recovery, you can selectively restore and recover damaged

blocks rather than whole datafiles.




for more information and reference

please…
Continue

Added by Rajeshkumar Govindarajan on May 5, 2010 at 1:30pm — 2 Comments

Command Line History and Editing in SQL*Plus and RMAN on Linux

In windows you have option of using up and down arrows for previously used sql statements and rman commands. But in Linux operation system with in sql*plus and rman prompt, not possible to use the up arrows and edit the previous used commands and statements.…
Continue

Added by Rajeshkumar Govindarajan on May 5, 2010 at 5:30am — No Comments

Monthly Archives

2016

2015

2014

2013

2012

2011

2010

2009

2008

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Steps to Follow When Developing Interactive Children’s eBooks

Today, just getting a book published and made available in print isn’t enough. As printed books will only reach half of your audience base. Publishers can now increase their sales by developing books in a format that is preferred by your readers. Publishers are already recognizing the disruption brought about by eBooks.…

Continue

Posted by Alvaro Dee on December 3, 2016 at 12:25am

Recover a deleted folder

Specifically to solve caused by- starting up you see, our own laptop or computer publisher, Right after that using [HKEY_CLASSES_ROOT\ftp] Add a vital dubbed recovering files from sd card "ShellFolder" When it comes to cord cost point "E436EBB6-524F-11CE-9F53-0020AF0BA770, The mistake do just stop developing, With out a reactivate or other behavior applicable.…

Continue

Posted by Rachel C on December 1, 2016 at 10:09pm

4 Things to Know About the GREATEST Function in Oracle

The GREATEST function in Oracle is one that is helpful, but I haven't seen used very often. If you do use it, keep these things in mind.
What Is The GREATEST Function?
The first thing to know about the function is what it does.
GREATEST finds the greatest value in a list of provided values.
The syntax is:
GREATEST ( expr1, [ expr_n] )
You provide it with a set of expressions, and the function will find the greatest of…
Continue

Posted by Ben Brumm on November 27, 2016 at 10:00am

Oracle E-Business Suite Training

Tekslate.com is the Industry leader in providing  Oracle E-Business Suite Training across the globe. Our online training methodology focus on hands on experience of Oracle EBS.

The objective of this training is to provide hands on experience and in depth understanding of the following modules of Oracle E-Business Suite Training.

Course Modules: 

  • Understanding…
Continue

Posted by Mohd Azher on November 17, 2016 at 10:24pm

© 2016   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service