RE: Import INDEXFILE option doesn't work.

From: Totx <zunda_at_softhome.net>
Date: Mon, 22 Oct 2001 17:24:36 -0500
Message-ID: <9r1dfu$7vh2@tid.tid.es>

Is the *.dmp file generated with the EXPORT utility with the indexes=y option?

You must generate the indexes in your *.dmp EXPORT and then, generate the index_file file
with the import utility.

Bye!

Charles J. Fisher <cfisher_at_rhadmin.org> escribió en el mensaje de noticias Pine.LNX.4.33.0110220839520.8222-100000_at_galt.rhadmin.org...
> Because my import was running so slow, I took some advice here and
> specified INDEXES=n, and got the data into the system faster.
>
> Now, I would like to recreate the indexes.
>
> I decided to try the INDEXFILE option, using the method outlined by Jason
> Couchman in his 8i OCP book on page 800.
>
> The problem is that the SQL file generated by the INDEXFILE option is just
> a bunch of REMed CREATE/ALTER TABLE statements.
>
> I read in an Oracle 7 book on exp/imp that interspersed in these REMed
> directives should be uncommented INDEX directives; why don't I see them?
>
> ----------------------------------------------------------------------

---

> / Charles J. Fisher | "Those who do not understand
UNIX /
> / cfisher_at_rhadmin.org | are condemned to reinvent it,
/
> / http://rhadmin.org:81 | poorly." -- Henry Spencer
/
> --------------------------------------------------------------------------
-
>
Received on Mon Oct 22 2001 - 17:24:36 CDT