| imp utility [message #286818] |
Mon, 10 December 2007 03:10  |
dirish
Messages: 232
Registered: November 2006
|
Senior Member |
|
|
Hi Friends,
I have done a full export.
In a schema, i have 2000 tables. I want to import only 1998 tables. Is there a way to create a par file to specify ignore the names of the 2 tables which I don't want to import instead of specifying the names of the 1998 tables.
Thank you,
Dirish
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: imp utility [message #286968 is a reply to message #286865] |
Mon, 10 December 2007 13:38  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
| Littlefoot wrote on Mon, 10 December 2007 06:03 |
If possible, I'd rather import all 2000 tables and afterwards drop those 2.
|
Or if these two tables are HUGE and you want to avoid them getting in there in the first place, create a junk table with the same name, a number(1) column and have the import fail on that table.
However, it will look ugly as you will get an error message for each row it tries to INSERT.
Or, if none of the objects exist, pre-create the structure of the two tables, use the INGORE=N parameter and the import will just plain fail on those twotables.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
