copying DB1 (production) to DB2 (testing) Data Pump vs Import/Export
Date: Wed, 17 Sep 2008 23:18:58 -0700 (PDT)
delete all files from folder oradata\DB2\
alter database backup controlfile to trace; shutdown immediate;
copy all files from folder oradata\DB1 to oradata\DB2 in oradata\DB2 directory delete all control files control01.ctl control02.ctl control03.ctl
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
change 'REUSE' to 'SET' and 'NORESETLOGS' to 'RESETLOGS' in line 'ALTER DATABASE OPEN' add 'RESETLOGS' change 'DB1' to 'DB2'
save file to .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ędowskiReceived on Thu Sep 18 2008 - 01:18:58 CDT