Re: # of Indexes

From: Suhen Pather <pathers5_at_telkom.co.za>
Date: Tue, 27 Jun 2000 10:11:25 +0200
Message-Id: <10541.110508@fatcity.com>

Hi

You do not need to export/import to move those indexes to another = tablespace.
However that is a nice way of doing it since it removes fragmentation from = tablespace.
You can however rebuild those indexes to another tablespace and leave the = current data in that tablespace.
It should not give you a difference in no. of indexes using the indexfile = or dba_indexes.
I stand under vorrection though

alter index owner.index_name rebuild tablespace index_tablespace;

This should help you move those indexes..

Regards
Suhen Pather
Oracle DBA
Telkom SA

>>> Rajesh_at_ohitelecom.com 06/27/00 09:04AM >>>
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 ?=20

Thanks for help....
Rajesh
--=20
Author: Rajesh Dayal
  INET: Rajesh_at_ohitelecom.com=20

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 - 03:11:25 CDT