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


Oracle LazyDBA home page