Home » RDBMS Server » Server Utilities » expdp with remap_schema? (Oracle11g)
expdp with remap_schema? [message #496990] Thu, 03 March 2011 09:18 Go to next message
espresso1976
Messages: 2
Registered: March 2011
Junior Member
Hi,

is it possible to remap the database schema during export?

Our developers have their databases stored within individual schemas and i want to provide a dumpfile that each developer is possible to easily import to his schema.
But when i want to impdp the dumpfile i have to know the schema name within the dumpfile to do a remap to the individual developers schema -> so providing a specific schema name for within the dumpfile would be great.

Or is there any other idea to solve my problem?
At the moment i'm getting the ORA-39146, schema does not exist on importing the database...

Thanks,
Carsten
Re: expdp with remap_schema? [message #496993 is a reply to message #496990] Thu, 03 March 2011 09:29 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

consider including SCHEMA_NAME as part for dump filename.
Re: expdp with remap_schema? [message #496998 is a reply to message #496990] Thu, 03 March 2011 10:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post your export and import commands.
Or better, copy and paste what you did and got.

Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

[Updated on: Thu, 03 March 2011 10:13]

Report message to a moderator

Re: expdp with remap_schema? [message #497165 is a reply to message #496998] Fri, 04 March 2011 04:02 Go to previous message
espresso1976
Messages: 2
Registered: March 2011
Junior Member
Hi,

sorry for not using the Posting Guidelines.

My Oracle version is 11.2.0.1.0.

The impdp command that i'm calling from a batch file (Windows) is:

impdp.exe product_username_sw/password1 job_name=impdp_oracle11g
directory=data_pump_dir dumpfile=test.Ora11g.de-DE.dmp
table_exists_action=replace
exclude=USER:"='product_username_sw'",
PACKAGE_BODY:"='HELPERS_PKG'"
logfile=impdp.test.Ora11g.de-DE.dmp.log
remap_schema=product:product_username_sw

As the batch file should be used for every user (without
specifying a schema name would be great), it would be
cool if the remap_schema could be specified generically
- the used schema name contains the user specific username part.

So i thought it would be great if every user could use expdp
and maps his specific schema name "product_username_sw" to a
generic one like "product" during export. But that doesn't seem
possible?

So at the moment i'm importing a dumpfile that does not contain
a schema called "product" and i'm getting the ORA-39146 = schema
does not exist - error.

A specification like remap_schema=*:product_username_sv for
impdp would also be great. Is something like that possible?

regards,
Carsten

[Updated on: Fri, 04 March 2011 05:46]

Report message to a moderator

Previous Topic: remove all dependencies on tablespace
Next Topic: ORA-01555: snapshot too old
Goto Forum:
  


Current Time: Fri Mar 29 03:07:51 CDT 2024