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!

Moving Large amount of data using IMPDP with network link

User444780-OCDec 10 2013 — edited Dec 11 2013

Hi Guru,

Here we are having a requirement to move 2TB of data from production to non-prod using Network_link parameter. What is the process to make it fast.

Previously we did it but it took 7 days for importing data and index .

Here i am having an idea can you please guide me is it good to make import faster .

Step 1) import only metadata .

Step 2) import only table data using table_exists_action=append or truncate.( Here indexes are allready created in step 1 and import will be fast as per my plan.)

Please help me the better way if we can.

Thanks & Regards,

Venkata Poorna Prasad.S

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2014

Added on Dec 10 2013

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

8 comments

5,454 views