Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Extracting DDL/INSERT Statements from Oracle 9i Dump

SOLVED
Go to solution
Edward Mugerwa
Occasional Advisor

Extracting DDL/INSERT Statements from Oracle 9i Dump

Dear All;

Please help me devise a method of extracting insert statements from my corrupt oracle dump file.

I really appreciate it;
Edward Mugerwa
6 REPLIES
GGA
Trusted Contributor

Re: Extracting DDL/INSERT Statements from Oracle 9i Dump

hello

dry strings dumpfile ?
regards
gga
Mugilvannan
Valued Contributor

Re: Extracting DDL/INSERT Statements from Oracle 9i Dump

Yes, you can. Please consider this rule:

Using imp/exp accross different Oracle versions: If exp and imp are used to export data from an Oracle database with a different version than the database in which is imported, then the following rules apply:

1. exp must be of the lower version
2. imp must match the target version.
If U need a helping hand, U will find one at the end of your arm
Virgil Chereches_2
Frequent Advisor
Solution

Re: Extracting DDL/INSERT Statements from Oracle 9i Dump

You can use imp show=Y with your dump file.

Best regards,
Virgil

Arunvijai_4
Honored Contributor

Re: Extracting DDL/INSERT Statements from Oracle 9i Dump

Edward Mugerwa
Occasional Advisor

Re: Extracting DDL/INSERT Statements from Oracle 9i Dump

Using the imp option show=y helps you to extract the info u need to generate the required statements
Thanks All
Frank de Vries
Respected Contributor

Re: Extracting DDL/INSERT Statements from Oracle 9i Dump

For extracting ddl use indexfile method,
so in your parfile specify

indexfile=
rows=no

and that will do nothing but create
a file where all DDL statements.

regards,



Look before you leap