Re: Extracting SQL from Export files

In article <33AFB611.6BD9_at_centers.co.uk>, Mike Hartas <mike.hartas_at_centers.co.uk> writes
>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 .
>

Mike,

All the table info is in the 'indexfile' - you'll just have to delete those 'REM ' statements... an easy job with Unix utilities...

Andy

-- 
Andy Hardy