dbTalk Databases Forums  

expdp and impdp with schema change

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss expdp and impdp with schema change in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Werner Hofmann
 
Posts: n/a

Default expdp and impdp with schema change - 04-28-2009 , 04:38 AM






Hallo,

I have a full pump of a db with schema s1.
Now I want to make a impdp to the same database but to schema s2.
Is this possible to do?

Werner

Reply With Quote
  #2  
Old   
Werner Hofmann
 
Posts: n/a

Default Re: expdp and impdp with schema change - 04-28-2009 , 05:26 AM






Werner Hofmann wrote:

Quote:
Hallo,

I have a full pump of a db with schema s1.
Now I want to make a impdp to the same database but to schema s2.
Is this possible to do?

Werner
Ths solution:
impdp <import description> remap_schema=old_schema:new_schema

In my case this was working except the types were not imported.
This could be, because I use Oracle 10.1

Werner


Reply With Quote
  #3  
Old   
sybrandb@hccnet.nl
 
Posts: n/a

Default Re: expdp and impdp with schema change - 04-30-2009 , 03:16 PM



On Tue, 28 Apr 2009 11:38:22 +0200, Werner Hofmann
<superomega (AT) t-online (DOT) de> wrote:

Quote:
Hallo,

I have a full pump of a db with schema s1.
Now I want to make a impdp to the same database but to schema s2.
Is this possible to do?

Werner
The documentation, which you are refusing to read, instructs you to
use REMAP_SCHEMA.
Please refrain from asking questions for which you can easily and with
little effort find the answer yourself.

Thank you.

---
Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #4  
Old   
Shakespeare
 
Posts: n/a

Default Re: expdp and impdp with schema change - 05-01-2009 , 09:49 AM



sybrandb (AT) hccnet (DOT) nl schreef:
Quote:
On Tue, 28 Apr 2009 11:38:22 +0200, Werner Hofmann
superomega (AT) t-online (DOT) de> wrote:

Hallo,

I have a full pump of a db with schema s1.
Now I want to make a impdp to the same database but to schema s2.
Is this possible to do?

Werner

The documentation, which you are refusing to read, instructs you to
use REMAP_SCHEMA.
Please refrain from asking questions for which you can easily and with
little effort find the answer yourself.

Thank you.

---
Sybrand Bakker
Senior Oracle DBA
Which the OP found out two days ago...... do it seems he DID read the docs.

Shakespeare


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.