impdp approach

[dba cjb]

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

[onedbguru]

On Feb 3, 11:03 am, dba cjb <chris.br...@providentinsurance.co.uk>
wrote:

You can {em|im}port and include/exclude whatever you need. See:
http://docs.oracle.com/cd/E11882_01/server.112/e10701/dp_import.htm#i1007761
for the include/exclude parameters. No pitfalls yet - but YMMV so TEST
TEST TEST and TEST again.

[John Hurley]

On Feb 3, 11:03 am, dba cjb <chris.br...@providentinsurance.co.uk>
wrote:

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.

[dba cjb]

On Feb 5, 2:12 am, John Hurley <hurleyjo...@yahoo.com> wrote:
> 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 herehttp://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.

I have managed first stage of data importing
/ just struggling to import a materialized view as a table ...I can
do it as a table but not as a materialized view

Chris B

PS thanks for the help /examples

[John Hurley]

cjb:

# I have managed first stage of  data importing / just struggling to

import a materialized view as a table  ...I can do it as a table but

not as a materialized view ...

We don't use many materialized views here just a couple of on the data
warehouse side.

If you are struggling I would not import it via impdp ... just execute
sql on the receiving side to recreate the materialized view. Tools
like Toad and many others can give you a script to re-create it if not
readily available ( and if you can connect in to source database with
relevant credentials ).