Database Utilities (MOSC)

MOSC Banner

Trying to use data pump to move 2TB schema from one database to another...getting slow performance.

edited Jul 9, 2010 6:13PM in Database Utilities (MOSC) 5 commentsAnswered
I am trying to move a schema from one database (on HPUX) to another database (on LINUX x86-64).  The method I am trying to use is data pump impdp via the network_link option in which I have the two servers connected directly to each other via a crossover cable.  The schema is very large(~2TB in size) in which the biggest table has 1.4 billion rows.  I am using the parallel option with degree 6 in impdp.  It does the largest tables first, and by looking at longops in the source database, it is going to take 17 hours just for

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center