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.
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:
- full exp.
- imp rows=n and constraints=n (to build structure)
- disable triggers
- imp rows=y
- 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