Re: duplicate schema on the same base
From: eliot06 <p.hirth_at_gmail.com>
Date: Wed, 18 May 2011 06:13:24 -0700 (PDT)
Message-ID: <f7c86f82-ad3c-4b66-bbb7-9e49d431d961_at_h12g2000pro.googlegroups.com>
On 18 mai, 14:56, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Wed, 18 May 2011 05:44:57 -0700, eliot06 wrote:
> > Hi,
>
> > some one could tel me how can i do to duplicate schema (no rows) onto
> > the same base ?
>
> > thank's
>
> Create new schema, export only metadata and import into the new schema.
>
> --http://mgogala.byethost5.com
Date: Wed, 18 May 2011 06:13:24 -0700 (PDT)
Message-ID: <f7c86f82-ad3c-4b66-bbb7-9e49d431d961_at_h12g2000pro.googlegroups.com>
On 18 mai, 14:56, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Wed, 18 May 2011 05:44:57 -0700, eliot06 wrote:
> > Hi,
>
> > some one could tel me how can i do to duplicate schema (no rows) onto
> > the same base ?
>
> > thank's
>
> Create new schema, export only metadata and import into the new schema.
>
> --http://mgogala.byethost5.com
usualy i use networklink into impdp like :
impdp system DIRECTORY=data_pump_dir schemas=USER1 content=METADATA_ONLY logfile=impdp.log network_link=REMOTE
and it is not necessary to create an export dump !!but the remote is not the same base Received on Wed May 18 2011 - 08:13:24 CDT