Tuesday, July 24, 2012

ORCL - Data Pump

We need move 10g production data into 11g test so we could test advance system upgrade, there are three upgrade methods offered to upgrade database from 10g to 11g.
  1. Database Upgrade Assistant (DBUA)
  2. Manual Upgrade (Oracle provided scripts)
  3. Export/Import (exp/imp, or expdp/impdp)
Using data pump looks promising, I prefer using Oracle EM, rather than manually following the steps:
1 impdp user/pass full=y directory =test_dir logfile=exp.log dumpfile=exp.dmp
2 copy dump file to new server
3 create database in new server with same tablespaces as source database -- IS IT NECESSARY?! (if different structure)
4 impdp user/pass full=y directory =test_dir logfile=exp.log dumpfile=exp.dmp

I used EM and finally got this error:
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOOK_FOR_OBJECT 
looks some problem with temp tablespace:
assign the temp tablespace to the schema owner as Oracle is probably using whatever default TEMP tablespace is specified for the database.
SQL> alter user advance temporary tablespace TEMP;
At leaset I was able to login through PL/SQL developer.

helpful links:

No comments:

Post a Comment