Re: Is there a way to copy indexes ??

"TC" <donotuse_at_donotuse.com> wrote in message news:<pREna.254789$Zo.48692_at_sccrnsc03>...
> Possibly I did not quite understand the question. Why will you need to
> "copy"
> when you are upgrading the database ?
>
> If "upgrade schema" means moving objects in a schema to another database
> instance with upgraded version, the export dump will already contain all
> that is required to recreate the index ?
>
> Am I missing something here ?
>
> //tc
>
> "Subrahmanyam Arya" <avsrk_at_mailcity.com> wrote in message
> news:25c1993e.0304170749.461bd01d_at_posting.google.com...
> > Hi all,
> >
> > Is there a way to copy indexes if one were to upgrade shcema from one
> > version to other ?? If the associated partitioned tables have very
> > large data, is it worth copying them or just renaming will suffice ???
> >
> > -thx,
> > Sri

Hi there,

No i meant upgrading the internal schema number( between release to release) and moving or copying data with in the same database instance between different releases / schema versions. I was wanting to know if there is a way to copy indexes from one schema version to another schema version and is it really worth copying if they have lots of data.

-thx,
Sri Received on Fri Apr 18 2003 - 15:40:24 CEST