Hi,

some one could tel me how can i do to duplicate schema (no rows) onto
the same base ?

thank's

On Wed, 18 May 2011 05:44:57 -0700, eliot06 wrote:

Create new schema, export only metadata and import into the new schema.



--
http://mgogala.byethost5.com

On 18 mai, 14:56, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> 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

On Wed, 18 May 2011 06:13:24 -0700, eliot06 wrote:
So? This time you can use the file.



--
http://mgogala.byethost5.com

On May 18, 9:30*am, Mladen Gogala <gogala.mla... (AT) gmail (DOT) com> wrote:
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

On May 19, 5:45*am, onedbguru <onedbg... (AT) yahoo (DOT) com> wrote:
meaganasfree2rhyme00 (AT) gmail (DOT) com the real adult child as orphaned
belonging to slipknot has been robbed for everything no hopes,
wishes,dreams or beliefs