Re: duplicate schema on the same base
From: Meaganasfree2rhyme00_at_gmail.com <meaganasfree2rhyme00_at_gmail.com>
Date: Sun, 29 May 2011 01:46:15 -0700 (PDT)
Message-ID: <2ef42750-3f41-413a-a954-c1becd8880ff_at_q14g2000prh.googlegroups.com>
On May 19, 5:45 am, onedbguru <onedbg..._at_yahoo.com> wrote:
> On May 18, 9:30 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
>
> > On Wed, 18 May 2011 06:13:24 -0700, eliot06 wrote:
> > > 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
>
> > So? This time you can use the file.
>
> > --http://mgogala.byethost5.com
>
> impdp system DIRECTORY=data_pump_dir schemas=USER1
> remap_schema=USER1:NEWUSER content=METADATA_ONLY logfile=impdp.log
> network_link=REMOTE
>
> creates newuser with the schema from USER1.
>
> In this example, you need to create a database link called remote that
> points to the database. System will need to be granted
> DATAPUMP_{EXP,IMP}_FULL_DATABASE
meaganasfree2rhyme00_at_gmail.com the real adult child as orphaned belonging to slipknot has been robbed for everything no hopes, wishes,dreams or beliefs Received on Sun May 29 2011 - 03:46:15 CDT
Date: Sun, 29 May 2011 01:46:15 -0700 (PDT)
Message-ID: <2ef42750-3f41-413a-a954-c1becd8880ff_at_q14g2000prh.googlegroups.com>
On May 19, 5:45 am, onedbguru <onedbg..._at_yahoo.com> wrote:
> On May 18, 9:30 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
>
> > On Wed, 18 May 2011 06:13:24 -0700, eliot06 wrote:
> > > 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
>
> > So? This time you can use the file.
>
> > --http://mgogala.byethost5.com
>
> impdp system DIRECTORY=data_pump_dir schemas=USER1
> remap_schema=USER1:NEWUSER content=METADATA_ONLY logfile=impdp.log
> network_link=REMOTE
>
> creates newuser with the schema from USER1.
>
> In this example, you need to create a database link called remote that
> points to the database. System will need to be granted
> DATAPUMP_{EXP,IMP}_FULL_DATABASE
meaganasfree2rhyme00_at_gmail.com the real adult child as orphaned belonging to slipknot has been robbed for everything no hopes, wishes,dreams or beliefs Received on Sun May 29 2011 - 03:46:15 CDT