Re: Extracting SQL from Export files

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 .

You can use the UNIX 'strings' command to get the commands out of the export file. You can then either edit by hand or better still write a small Perl script. Make sure you don't 'compress extents' when you export else the storage clauses will all be incorrect.

Even better solution, IMHO, is to buy Designer 2000, reverse engineer, and then use it for all your change control to your production databases.

Steve Phelan. Received on Tue Jun 24 1997 - 00:00:00 CDT