Re: Extracting SQL from Export files

Have a look in the ORACLE magazine Code Depot and Tips. There are a number of scripts and routines that will extract info from your database into SQL-DDL scripts, and even one that will resize your database.

Wayne Linton
Shell Canada Ltd.

Mike Hartas wrote:
>
> Hi,
> I am in the process of creating a test database for Oracle applications
> and will soon be "tidying up" the production database. To do this i need
> to be able to adjust the storage parameters for tables, indexes and
> primary keys etc.
> For the tables and indexes i can use the 'indexfile' option of import,
> but how can
> i extract other sql statements form an export file or from the database?
> (i have tried exporting with show=y to a logfile but the file needs
> substantial editing).
> The database version is 7.3.2.3 running on Seqent. Please help!
>
> Thanks .
Received on Wed Jul 02 1997 - 00:00:00 CDT