Specifies a file to receive index-creation statements.
When this parameter is specified, index-creation statements for the requested mode are extracted and written to the specified file, rather than used to create indexes in the database. No database objects are imported.
If the Import parameter
CONSTRAINTS is set to
y, then Import also writes table constraints to the index file.
The file can then be edited (for example, to change storage parameters) and used as a SQL script to create the indexes.
Perform the following steps to use this feature:
Import using the
INDEXFILE parameter to create a file of index-creation statements.
Edit the file, making certain to add a valid password to the
Rerun Import, specifying
(This step imports the database objects while preventing Import from using the index definitions stored in the export file.)
Execute the file of index-creation statements as a SQL script to create the index.
INDEXFILE parameter can be used only with the