| import using wild card? [message #175859] |
Mon, 05 June 2006 14:42  |
SLKRR
Messages: 11
Registered: May 2006
Location: Recife, Brasil
|
Junior Member |
|
|
Is it possible to import using a wildcard character to grab a group of tables? We were running a large import over the weekend, and it failed somewhere in the middle. There are several hundred tables. We have to use ignore=y to get it to work, but if we re-run it this way, it will load duplicate data into all the tables that already succeeded (as I understand it).
The original database is corrupted - we only have the dmp file to work with, so we don't have a list of all of the various tables. If there is no way to use a wildcard for the table names, is there a way to generate a list of all of the tables contained in the dmp? This would at least allow us to reload the ones that failed one by one.
Thanks for you help.
|
|
|
|
|
|
| Re: import using wild card? [message #175878 is a reply to message #175859] |
Mon, 05 June 2006 16:18  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> a way to generate a list of all of the tables contained in the dmp
use indexfile option.
Please search the forum before asking
More information in documentation
>>allow us to reload the ones that failed one by one.
Your import log file should display all the tables that errored out.
You can also write a simple sql script that will generate the list of tables you want from dictionary and user the list along with parfile option in export/import.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
