First, No need to drop indexes,
Second, You can rebuild it without droping.

And Last but not least, you have 200 tables and 200 indexes (This is not
bad practice)
Actually you might have 200 primary keys each for one table and each
primary key is indexes. This is good for joining while making queries.


Regards,

Jigar Sutaria
Database Engineer
Elitecore Technologies Ltd.


-----Original Message-----
From: SIDDY SOWA
[mailto:oracledba-ezmlmshield-x47760739.[Email address protected]
Sent: Friday, October 29, 2004 6:14 PM
To: LazyDBA Discussion
Subject: Indexes and tables in one tablespace

Hello Evryone,
Thank God its Friday!
But I have a headache, and please help, so that I get
a peaceful weekend.

My developers have placed about 200 indexes in the
same tablespace with about 200 tables.

We all know that this is not a good practice, not at
all. My first thought is to drop the indexes one after
the other and rebuild them in a different tablespace,
say indx_tbs, but this will of course take that long.

Could anyone think of a quicker way of doing this?

My sincere gratitude in advance.
Siddy



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page