Home » RDBMS Server » Backup & Recovery » import using wild card?
import using wild card? [message #175859] Mon, 05 June 2006 14:42 Go to next message
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 #175860 is a reply to message #175859] Mon, 05 June 2006 14:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
imp help=yes
imp show=yes
when all else fails, RTFM found at http;//tahiti.oracle.com
In this case the Utilities manual
Re: import using wild card? [message #175878 is a reply to message #175859] Mon, 05 June 2006 16:18 Go to previous message
Mahesh Rajendran
Messages: 10707
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.
Previous Topic: import error ORA-01552
Next Topic: exp problem
Goto Forum:
  


Current Time: Thu Mar 28 06:11:50 CDT 2024