Pre-installation steps Check free space. For installation of oracle you will need at least following space: 4GB at $ORACLE_HOME (etc....
Copying schemas w/o user passwords This scenario is used when different passwords are used in source and target databases and...
To proceed with this tutorial you need to have target database. If you want to duplicate database to completely new...
Set the SID Set the unique SID of new database at your environment. Example of UNIX command: #example of C...
Check for uncompiled or wrongly compiled objects Execute this SQL command: COLUMN object_name FORMAT A30 SELECT owner, object_type, object_name, status...
Check for existing redolog groups On UNIX filesystem redologs are stored in folder /oracle/<SID>/origlog<X> and mirrored in folder /oracle/<SID>/mirrlog<X> You...