Indexes = Y is a valid parameter for Exp. Been there at least since version
7. And it still exists in 8i.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:tt93mfjam5n02c_at_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:33:37 CDT
