Re: Indexes - how to get details?

I think it's easiest to use the "indexfile" feature of import. Do the following:

1. Export the table (structure only) via:

exp username/password file=filename tables=(table_list) rows=n

This will run fast because no table data is written to the export file, only the table and index structure.

Then, to get the index creation DDL, run import as follows:

imp username/password file=filename indexfile=filename.sql

The index file isn't pretty, but everything is there, and you can edit before executing, if you like. Received on Tue Sep 12 1995 - 00:00:00 CEST