Re: Extracting sql scripts from EXPORT file

Gil wrote:
>
> Hello all,
> I would like to extract from an Oracle 8.0.4 export file
> the sql statements contained so I can change some parameters
> like tablespace_name, next size and so on, and execute them
> before import data.
> This could be possible setting the option 'show=y' with the
> 'imp' command but the result is bad: it is a terrible job changing
> this file to make it ready for the execution in sqlplus.
>
> Is there a better way ? Maybe some tools from third part....
>

Yes, imp ... indexfile=filename
In filename you'll find the create table and create index statements Example:

imp userid=system/xxxx indexfile=file.sql

file=export.DMP fromuser=user                   
rows=no grants=no                                          

Imp will create a file file.sql. file.sql will contain the create table, index
statements for the table indexes of user.

> Thank you,
> Bye.
> Gilberto.
Received on Fri Oct 27 2000 - 13:24:33 CEST