Re: Import INDEXFILE option doesn't work.

Hi!

• On october 22 Charles J. Fisher wrote:

 CJF> Because my import was running so slow, I took some advice here and  CJF> specified INDEXES=n, and got the data into the system faster.

 CJF> Now, I would like to recreate the indexes.

 CJF> I decided to try the INDEXFILE option, using the method outlined by
 CJF> Jason 
 CJF> Couchman in his 8i OCP book on page 800.

 CJF> The problem is that the SQL file generated by the INDEXFILE option  CJF> is just a bunch of REMed CREATE/ALTER TABLE statements.

 CJF> I read in an Oracle 7 book on exp/imp that interspersed in these
 CJF> REMed  directives should be uncommented INDEX directives; why don't
 CJF> I see them?

Make sure you do it this way:

1) exp indexes=y
2) imp indexes=n
3) imp indexes=y indexfile=indfile.sql
4) preprocess  and run indfile.sql

Bye

[SQL Batch: Oracle automation] http://sqlbatch.com/sb/ Received on Mon Oct 22 2001 - 10:29:49 CDT