Re: Import INDEXFILE option doesn't work.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 22 Oct 2001 23:21:28 +0200
Message-ID: <tt93mfjam5n02c@corp.supernews.com>

An indexes=y option in exp does not exist, at least not in 8i and before.

Regards,

Sybrand Bakker
Senior Oracle DBA

"Totx" <zunda_at_softhome.net> wrote in message news:9r1dfu$7vh2_at_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 - 16:21:28 CDT