Extracting DDL/INSERT Statements from Oracle 9i Dump

[Edward Mugerwa]

Dear All;

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

I really appreciate it;
Edward Mugerwa

[GGA]

hello

dry strings dumpfile ?
regards
gga

[Mugilvannan]

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.

[Virgil Chereches_2 · Accepted solution]

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

Best regards,
Virgil

[Arunvijai_4]

http://searchoracle.techtarget.com/ateQuestionNResponse/0,289625,sid41_cid615857_tax294550,00.html?track=NL-334&ad=493251

-Arun

[Edward Mugerwa]

Using the imp option show=y helps you to extract the info u need to generate the required statements
Thanks All

[Frank de Vries]

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,