Re: impdp approach
From: dba cjb <chris.brown_at_providentinsurance.co.uk>
Date: Tue, 7 Feb 2012 08:37:42 -0800 (PST)
Message-ID: <8118564d-2b09-4637-a046-42a7e05e09a8_at_b18g2000vbz.googlegroups.com>
On Feb 5, 2:12 am, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> 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
>
> > 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.
Date: Tue, 7 Feb 2012 08:37:42 -0800 (PST)
Message-ID: <8118564d-2b09-4637-a046-42a7e05e09a8_at_b18g2000vbz.googlegroups.com>
On Feb 5, 2:12 am, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> 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
>
> > 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 Received on Tue Feb 07 2012 - 10:37:42 CST