Re: Import INDEXFILE option doesn't work.

On Mon, 22 Oct 2001 13:50:35 GMT, "Charles J. Fisher" <cfisher_at_rhadmin.org> wrote:

>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 /
>---------------------------------------------------------------------------
>

hmm..perhaps there are no other indexes than primary keys and unique keys in your data model?

PK-indexes and unique indxes are created implicitely by the ALTER TABLE ADD CONSTRAINT-Statement.

You can read the dumpfile with any editor and check for CREATE INDEX-Statements.

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Mon Oct 22 2001 - 10:14:07 CDT