Re: Import INDEXFILE option doesn't work.

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Mon, 22 Oct 2001 11:30:13 -0500
Message-ID: <9r1he1$rlt$1@news.gte.com>

If you did an exp INDEXES=N, there's no index DDL in the INDEXFILE upon imp INDEXFILE=???. Get another exp with INDEXES=y and rows=n, then do the imp show=y INDEXFILE=??? on the new file to get the DDL for implicitly created indexes.

-Kevin

"Charles J. Fisher" <cfisher_at_rhadmin.org> wrote in message news: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 - 11:30:13 CDT