Home » RDBMS Server » Server Utilities » Skip One table while Import (exp/imp)
Skip One table while Import (exp/imp) [message #455712] Wed, 12 May 2010 11:53 Go to next message
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 Go to previous messageGo to next message
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.
Re: Skip One table while Import (exp/imp) [message #455716 is a reply to message #455712] Wed, 12 May 2010 12:14 Go to previous messageGo to next message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
Littlefoot
Messages: 21687
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;
Re: Skip One table while Import (exp/imp) [message #455733 is a reply to message #455729] Wed, 12 May 2010 13:16 Go to previous message
joy_division
Messages: 4950
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.
Previous Topic: Import/export Log file
Next Topic: DIM-00014: Cannot open the Windows NT Service Control
Goto Forum:
  


Current Time: Fri Sep 17 08:11:29 CDT 2021