On Feb 3, 11:03 am, dba cjb <chris.br
...@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
> regards
> 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-parame...
).
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.
