Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EXPDP --> IMPDP speed

R. RoyalJan 20 2013 — edited Jan 23 2013

Hi,
Oracle version: 10g
O.S: Windows 2003

I've 2 oracle instance: ORCL1 (schema TOM) on machine1 and ORCL2 (schema SAM) on machine2
I'd like to import the schema TOM into schema SAM.
TOM schema size is 300 GB

I exported TOM with following parfile:

SCHEMAS=TOM
DIRECTORY=TOM_DIR
DUMPFILE=exp_tom_%U.dmp
LOGFILE=exp_tom.log 
filesize=30GB
JOB_NAME=EXP_JOB

and created about 10 dump files in more of 30 hours

Now I need import into schema SAM, but I'd like to import faster

Which parameter can I add at following imp parfile to speed up the import?

schemas=TOM
remap_schema=TOM:SAM
logfile=imp_sam.log
directory=SAM_DIR
DUMPFILE=exp_tom_%U.dmp
exclude=statistics
job_name=IMP_JOB

Thanks in advance!

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2013

Added on Jan 20 2013

#database-key-features, #export-import-sql-loader-external-tables

8 comments

7,938 views