copying DB1 (production) to DB2 (testing) Data Pump vs Import/Export

From: <norbert.urzedowski_at_gmail.com>
Date: Wed, 17 Sep 2008 23:18:58 -0700 (PDT)
Message-ID: <5cfd849f-c941-489b-b6db-9b88c6aeee61@l42g2000hsc.googlegroups.com>


set ORACLE_SID=DB2
shutdown immediate;
exit

delete all files from folder oradata\DB2\

set ORACLE_SID=DB1
alter database backup controlfile to trace; shutdown immediate;
exit

copy all files from folder oradata\DB1 to oradata\DB2 in oradata\DB2 directory delete all control files control01.ctl control02.ctl control03.ctl

set ORACLE_SID=DB1
startup
exit

in admin\DB1\udump dir look for the newest file with .trc extension

remove everything before 'startup nomount' in this line 'CREATE CONTROLFILE REUSE DATABASE "DB1" NORESETLOGS NOARCHIVELOG'
change 'REUSE' to 'SET' and 'NORESETLOGS' to 'RESETLOGS' in line 'ALTER DATABASE OPEN' add 'RESETLOGS' change 'DB1' to 'DB2'

save file to .sql

set ORACLE_SID=DB2
@DB2.sql

That is the way i did it for long time (might be helpful). Now i want something more advanced.
How to do exactly same thing with Data Pump? Any hints? Of course path to tablespaces are different.

---
Norbert Urzędowski
Received on Thu Sep 18 2008 - 01:18:58 CDT

Original text of this message