RE: # of Indexes

It is available on Oracle 7, but in Oracle 7 you cannot rebuild them without locking the table.
In Oracle 8i, all ur DML against the table can continue. Oracle is able to maintain the
consistency of data even without locking the table.So the table is online and available.

Sanjeev

-----Original Message-----
From: Rajesh Dayal [mailto:Rajesh_at_ohitelecom.com] Sent: Wednesday, June 28, 2000 2:44 AM
To: Multiple recipients of list ORACLE-L Subject: RE: # of Indexes

Hi Ruth,

   Even I was thinking in same direction... You made me tense when you wrote that I have to be on Oracle 8 or 8i. I checked back manuals (on technet), this option is available on 7.3 as well ( I have to perform this activity on both 7.3 and 8.0.5).

   Thanks for replying anyway ....

Cheers,
Rajesh

-----Original Message-----
Gramolini
Sent: Tuesday, June 27, 2000 8:19 PM
To: Multiple recipients of list ORACLE-L

The easy way to do this is to spool the output of this statement; select 'alter index '||owner||'.'||index_name||' rebuild tablespace YOUR_TS_NAME;' from all_indexes;

Then run the spooled file and this will rebuild all of your indexes in the
the required tablespace.

I believe you have to be in Oracle8 or 8i.

Regards,
Ruth G.
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, June 27, 2000 3:04 AM

> 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: Rajesh Dayal
> INET: Rajesh_at_ohitelecom.com
>
> 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).
>

-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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).
-- 
Author: Rajesh Dayal
  INET: Rajesh_at_ohitelecom.com

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