Home » RDBMS Server » Server Utilities » Import table with different name
Import table with different name [message #206406] Wed, 29 November 2006 23:08 Go to next message
himang
Messages: 282
Registered: March 2005
Location: Bangalore
Senior Member

Hi experts,
We have a table in Oracle9i database with around 14 million records and we would like to import that table into 10g database with similar structure. We have exported the table from 9i database and would like to import the table into 10g database within same schema name with different table name as we already have the table with same name in 10g database in same schema. Is it possible to import a table with different table name?

We have a way around to import the table into 10g database in another schema and then push the data into our main table but want to know whether the above requirement is possible.

Thanks in advance.

Regards
Himanshu
Re: Import table with different name [message #206428 is a reply to message #206406] Thu, 30 November 2006 00:43 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, that's not possible. Import first tries to CREATE a table (which will fail if the table already exists, but you can suppress the error message using IGNORE=Y qualifier) and then inserts data into it.

There's no way to change table name during import session.

However, *cough, cough* (don't crucify me, please), you *might* try to edit the .DMP file (using some hex editor) and change table name, save changes and run import. But I'm not sure this pain is worth while.
Re: Import table with different name [message #206449 is a reply to message #206406] Thu, 30 November 2006 01:53 Go to previous messageGo to next message
himang
Messages: 282
Registered: March 2005
Location: Bangalore
Senior Member

I was also pretty much sure that it is not possible. Didn’t got any option as well and never read it anywhere. But one of the person told it is possible, so just wanted to double check.

Thanks anyway.

Regards
Himanshu
Re: Import table with different name [message #560261 is a reply to message #206406] Wed, 11 July 2012 10:12 Go to previous messageGo to next message
Suresh_ram1986
Messages: 2
Registered: May 2012
Location: India
Junior Member
Hi,

This option is available only from Oracle 11g.
You can use REMAP_TABLE to import the data with different table from 11g.

Thanks & Regards
Suresh.R
Re: Import table with different name [message #560266 is a reply to message #560261] Wed, 11 July 2012 10:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no REMAP_TABLE option with "imp" (in any version).

Regards
Michel

[Updated on: Wed, 11 July 2012 10:30]

Report message to a moderator

Re: Import table with different name [message #560270 is a reply to message #560266] Wed, 11 July 2012 11:26 Go to previous messageGo to next message
Suresh_ram1986
Messages: 2
Registered: May 2012
Location: India
Junior Member
You can use REMAP_TABLE in import datapump from 11g.
Below is the syntax.

impdp schemaname DIRECTORY=dpump_dir1 DUMPFILE=expschema.dmp TABLES=schemaname.table_name REMAP_TABLE=schemaname.table_name:table_name_new

Regards
Suresh.R
Re: Import table with different name [message #560272 is a reply to message #560270] Wed, 11 July 2012 11:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But it is irrelevant and so useless for the current question.

Regards
Michel
Re: Import table with different name [message #560276 is a reply to message #560272] Wed, 11 July 2012 11:59 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Earth to clueless newbie, Suresh_ram1986:

please avoid resurrecting dead zombie threads from 5+ years ago; especially with 100% useless & irrelevant responses.
Previous Topic: Loading Multiple Input files into multiple tables
Next Topic: sql loader error records
Goto Forum:
  


Current Time: Thu Mar 28 06:29:22 CDT 2024