Extracting SQL from Export files

From: Mike Hartas <mike.hartas_at_centers.co.uk>
Date: 1997/06/24
Message-ID: <33AFB611.6BD9@centers.co.uk>#1/1

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 Tue Jun 24 1997 - 00:00:00 CDT