Home » RDBMS Server » Server Utilities » Rename Table while Using Datapump Import (11g Enterprise)
Rename Table while Using Datapump Import [message #579970] Mon, 18 March 2013 08:09 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
REMAP_TABLE

Regards
Michel
Re: Rename Table while Using Datapump Import [message #579987 is a reply to message #579986] Mon, 18 March 2013 11:19 Go to previous messageGo to next message
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.
Re: Rename Table while Using Datapump Import [message #579993 is a reply to message #579987] Mon, 18 March 2013 11:47 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Rename Table while Using Datapump Import [message #580010 is a reply to message #579993] Tue, 19 March 2013 03:13 Go to previous messageGo to next message
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.
Re: Rename Table while Using Datapump Import [message #580032 is a reply to message #580010] Tue, 19 March 2013 08:58 Go to previous message
cookiemonster
Messages: 10961
Registered: September 2008
Location: Rainy Manchester
Senior Member
So you write some code that generates the correct script for each schema.
Previous Topic: datadump 11g to 10g
Next Topic: SQL Loader - Skipping one column which shouldnot
Goto Forum:
  


Current Time: Sat Sep 20 13:59:20 CDT 2014

Total time taken to generate the page: 0.06449 seconds