Installation 10g
Pre-installation steps Check free space. For installation of oracle you will need at least following space: 4GB at $ORACLE_HOME (etc....
Duplicate database (Schema only)
Copying schemas w/o user passwords This scenario is used when different passwords are used in source and target databases and...
Duplicate database (Current incarnation)
To proceed with this tutorial you need to have target database. If you want to duplicate database to completely new...
Create a new database
Set the SID Set the unique SID of new database at your environment. Example of UNIX command: #example of C...
Object compilation
Check for uncompiled or wrongly compiled objects Execute this SQL command: COLUMN object_name FORMAT A30 SELECT owner, object_type, object_name, status...
Add new redolog group
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...