Tuesday, June 28, 2011

Cloning of database through OEM

It  is a very simple and fastest way to clone a database through OEM(Oracle Enterprise Manager)

First of all set  DB_CREATE_FILE_DEST as follows on target database.

SQL>Alter system  set DB_CREATE_FILE_DEST=   'D:\app\Bishwanath\product\11.2.0\dbhome_1\oradata';


After this follow the wizard one by one as provided in the link below:



Enjoy:-)