RE: # of Indexes

Hi,

the fastest way to move indexes is to rebuild them in another tablespace with
ALTER INDEX index_name REBUILD STORAGE (storage pars) TABLESPACE tablespace_name;

Regards, Richard Klavers

Tel.: 00 31 (0)79 371 2543
Fax: 00 31 (0)79 371 2529
E-mail: r.klavers_at_arbeidsbureau.nl
Zoetermeer, the Netherlands

> ----------
> Van: Weerd de E.C. Kirsten[SMTP:Kirsten.deWeerd_at_Oranjewoud.nl]
> Antwoord naar: ORACLE-L_at_fatcity.com
> Verzonden: dinsdag 27 juni 2000 11:14
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: RE: # of Indexes
>
> I've been investigating a similar situation a while back, and if I
> remember
> correctly it does indeed concern primary key-indexes that are not created
> with the indexfile.
> In the indexfile however you can also find the creation-scripts for the
> tables. They are remarked out. In there you should also find the creation
> of
> primary keys. So edit the script to create tables in one TS, indexes and
> primary keys in another TS, then import the data.
>
> Roughly that should do it, I think, but some of the gods will surely
> correct
> me where I am wrong !
>
> Greets,
>
>
> Kirsten
>
> > -----Original Message-----
> >
> > Hi All,
> > I have to move all indexes of a schema from one Tablespace to another
> > Tablespace (currently Tables as well as Indexes are in the same TS ;-((.
> >
> >
> > But when I query DBA_OBJECTS/DBA_INDEXES for that schema the no of
> > indexes come to be 179. When I export the objects of that schema and
> > create the indexfile (by importing ) then no of Indexes is coming to be
> > 89 only. Could someone point out that why is this difference? Is this
> > because of System created indexes for unique/primery keys ? If yes then
> > is there any way out to move those indexes to diff Tablespace ?
> >
> > Thanks for help....
> > Rajesh
> --
> Author: Weerd de E.C. Kirsten
> INET: Kirsten.deWeerd_at_Oranjewoud.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jun 27 2000 - 04:26:17 CDT