Re: impdp approach
Date: Sat, 4 Feb 2012 18:12:02 -0800 (PST)
On Feb 3, 11:03 am, dba cjb <chris.br..._at_providentinsurance.co.uk> wrote:
> oracle 11.2. / on windows
> I need to import a select list of tables & packages from a schema on a
> source database
> I will also need to consider ( perhaps using scripts )constraints/
> indexes & stats also
> If anyone can give me any helpfull advice before starting & known
> pitfalls to avoid I would be gratefull
> Chris B
Well as already noted imdp over a network link can work pretty well and has a lot of powerful filtering built into it already ... ( one old post of mine with an example is right here http://grumpyolddba.blogspot.com/2011/01/combining-impdp-remap-parameters.html ).
Tools like Toad can do a decent job also without being terribly complicated to setup.
I have done some tricky and fairly complicated things at times using plsql to generate scripts ( using utl file ) that has the impdp coding in it. The old plsql to generate utility commands ( or sql ) tricks you know.
The main pitfall to avoid is to not test enough and to make sure you have an environment close and very close if you can to where your production target looks like. Received on Sat Feb 04 2012 - 20:12:02 CST