Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
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