OraFAQ Forum: Server Utilities » Skip One table while Import (exp/imp)

Home » RDBMS Server » Server Utilities » Skip One table while Import (exp/imp)

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

Skip One table while Import (exp/imp) [message #455712]

Wed, 12 May 2010 11:53

madhavamanohar
Messages: 58
Registered: February 2009

Member

Dear Friends,

How to skip one table while import in traditional exp/imp not in DP.

Thanks
Manohar

[Updated on: Wed, 12 May 2010 11:54]

Report message to a moderator

Re: Skip One table while Import (exp/imp) [message #455714 is a reply to message #455712]

Wed, 12 May 2010 12:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How to skip one table while import in traditional exp/imp not in DP.
One very UGLY & BRUTE FORCE effective way would be precreate table with wrong columns then imp ignore=yes

The result would be lots of errors, but no data loaded; effectively skipping the table.

Report message to a moderator

Re: Skip One table while Import (exp/imp) [message #455716 is a reply to message #455712]

Wed, 12 May 2010 12:14

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

Senior Member
Account Moderator

This is not possible unless using a brute force way like BlackSwan one or a hack on Oracle tables that you can find on the web.

Regards
Michel

[Updated on: Wed, 12 May 2010 12:14]

Report message to a moderator

Re: Skip One table while Import (exp/imp) [message #455729 is a reply to message #455716]

Wed, 12 May 2010 13:08

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If there aren't many tables in export file, you could try with TABLES parameter: name all but the one you don't want ("tab4", for example):

imp un/pw file=export.dmp tables=(tab1, tab2, tab3, tab5)

Or, why wouldn't you import all tables, and then drop the one you don't need?

os> imp un/pw file=export.dmp
sql> drop table tab4;

Report message to a moderator

Re: Skip One table while Import (exp/imp) [message #455733 is a reply to message #455729]

Wed, 12 May 2010 13:16

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

I am guessing it is huge and user doesn't want to waste the time or not have the space to accommodate the import.

Report message to a moderator

Previous Topic:	Import/export Log file
Next Topic:	DIM-00014: Cannot open the Windows NT Service Control

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 01:52:30 CST 2025