Impdp - Full Database

From: Bill <billshatner71_at_googlemail.com>
Date: Fri, 2 Jul 2010 15:43:25 -0700 (PDT)
Message-ID: <eb4a24f6-dda7-4db4-8184-13071e51d8a7_at_d37g2000yqm.googlegroups.com>



Hi there.

I'm using impdp to import a full database.

Everything seemed to go well, except that the sequences didn't seem to match the old db.

There are numerous schema owners and lots of dependencies.

I was hoping to bring the database across in one go but I was wondering if anyone can recommend the steps for this situation.

My old method with exp/imp was:

  1. full exp.
  2. imp rows=n and constraints=n (to build structure)
  3. disable triggers
  4. imp rows=y
  5. imp indexes=y constraints=y

It worked but it took ages.

Any suggestions? I have looked at the Oracle 10g utilities documentation but couldn't see anything specific to this.

Thanks, Ed. Received on Fri Jul 02 2010 - 17:43:25 CDT

Original text of this message