OraFAQ Forum: Server Utilities » Rename Table while Using Datapump Import

Home » RDBMS Server » Server Utilities » Rename Table while Using Datapump Import (11g Enterprise)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rename Table while Using Datapump Import [message #579970]

Mon, 18 March 2013 08:09

mpunktmayer
Messages: 3
Registered: March 2013

Junior Member

Hello,

I have a Datapump Export File which was created in Schema mode.
I have to import the tabelles in a new database where a have to use the REMAP SCHEMA Parameter.
Additionaly I would like to add a prefix to tablenames.

For example:
original tablename: THE_TABLE
Name after import: IMP_THE_TABLE

Is there a way to add a prefix while using Datapump Import?

[Updated on: Mon, 18 March 2013 08:10]

Report message to a moderator

Re: Rename Table while Using Datapump Import [message #579986 is a reply to message #579970]

Mon, 18 March 2013 11:13

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

REMAP_TABLE

Regards
Michel

Report message to a moderator

Re: Rename Table while Using Datapump Import [message #579987 is a reply to message #579986]

Mon, 18 March 2013 11:19

mpunktmayer
Messages: 3
Registered: March 2013

Junior Member

I already know this parameter ... but I have about 300 Tables.
By using REMPA TABLE I have to rename every table. I look for an option where I can add ab specified prefix to EVERY table I import.

Report message to a moderator

Re: Rename Table while Using Datapump Import [message #579993 is a reply to message #579987]

Mon, 18 March 2013 11:47

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I already know this parameter .

And how could we know you know this parameter if you don't tell us?
And what is the problem to generate 300 of such options with a single SQL query?

Regards
Michel

Report message to a moderator

Re: Rename Table while Using Datapump Import [message #580010 is a reply to message #579993]

Tue, 19 March 2013 03:13

mpunktmayer
Messages: 3
Registered: March 2013

Junior Member

Sorry... my question wasn't precious enough.

It seems that there is no way to general add a prefix.
Of course it's easy to create the lines by using SQL but in this way the script isn't reusable for other Schemas.

Report message to a moderator

Re: Rename Table while Using Datapump Import [message #580032 is a reply to message #580010]

Tue, 19 March 2013 08:58

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

So you write some code that generates the correct script for each schema.

Report message to a moderator

Previous Topic:	datadump 11g to 10g
Next Topic:	SQL Loader - Skipping one column which shouldnot

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 16:48:16 CST 2025