Re: Is there a way to copy indexes ??

Ok

I do not think copying indexes can be an option at all.

Rebuild the indexes and keep things simple :-)

//tc

"Subrahmanyam Arya" <avsrk_at_mailcity.com> wrote in message news:25c1993e.0304180540.8f46ade_at_posting.google.com... > "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