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....
Received on Tue Jun 27 2000 - 03:17:18 CDT