OraFAQ Forum: Server Utilities » Import table with different name

Home » RDBMS Server » Server Utilities » Import table with different name

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

Import table with different name [message #206406]

Wed, 29 November 2006 23:08

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

Report message to a moderator

Re: Import table with different name [message #206428 is a reply to message #206406]

Thu, 30 November 2006 00:43

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Import table with different name [message #206449 is a reply to message #206406]

Thu, 30 November 2006 01:53

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

Report message to a moderator

Re: Import table with different name [message #560261 is a reply to message #206406]

Wed, 11 July 2012 10:12

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

Report message to a moderator

Re: Import table with different name [message #560266 is a reply to message #560261]

Wed, 11 July 2012 10:25

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

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

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

Report message to a moderator

Re: Import table with different name [message #560272 is a reply to message #560270]

Wed, 11 July 2012 11:47

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

Senior Member
Account Moderator

But it is irrelevant and so useless for the current question.

Regards
Michel

Report message to a moderator

Re: Import table with different name [message #560276 is a reply to message #560272]

Wed, 11 July 2012 11:59

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.

Report message to a moderator

Previous Topic:	Loading Multiple Input files into multiple tables
Next Topic:	sql loader error records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 20:21:14 CST 2025