A few months ago I´ve created a dbspace to store a database. Now this database is not in use anymore, so I´ve dropped it and I´m trying to drop the dbspace, but I can´t because there is a TBLSpace tablespace in it. The dbspace use to have 6 chunks and just one of them was empty, so I´ve already dropped it, but the other five are not empty. It seems that the TBLSpace tablespace is fragmented between this 5 chunks. Can I drop this TBLSpace tablespace? How can I do it?
Thanks for any help.
Fernanda.

Maybe you can't drop an individual chunk, but you should be able to drop the entire dbspace if it's empty of user data. Or else, which error is reporting when you try?

The tablespaces are for internal organization of data and you can't touch them... and you should not need to.

Regards

Iñaki