Re: duplicate schema on the same base

From: onedbguru <onedbguru_at_yahoo.com>
Date: Thu, 19 May 2011 05:45:16 -0700 (PDT)
Message-ID: <4dfba232-a6af-4cc4-bddf-64bbaf3a159e_at_e26g2000vbz.googlegroups.com>



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 Received on Thu May 19 2011 - 07:45:16 CDT

Original text of this message