Hi folks

Iam having problem with dropping the tablesapce.
I dropped all the tables in the tablespace and tried to issue drop tablespace. Then it is complaining
SQL0282N Table space "MMAX_IP" cannot be dropped because at least one of the
tables in it, "MAXDATA.INV_PERPETUAL_B", has one or more of its parts in
another table space. SQLSTATE=55024


It looks like the table i have dropped have index in different tablespace.
When i dropped the table the index was not removed.
Should i be removing the index first before i drop the table ???

I need to drop the tablesapce now and it is not allowing me to do it.
Does any body here have any solution for this


Thanks
Prasad

Indexes are dropped with table. Make sure you drop all the tables which reside in that tablespace. I have noticed that message myself and droping all the tables will do it for you.

dollar