Tablespace half filled but no objects
Dear All,
Iam describing a problem as described below:
I have a tablespace that is 1.5gb in size and I find it half filled. But I dont find any objects in the tablespace. I have checked for the presence of tables,indexes etc in that table but not have found any. Also none of the users have it as their default tablespace. I need to move the contents of this tablespace to some other tablespace and then drop it. Could someone throw light on how to go ahead. Also could someone throw light on how to find out what the tablespace contains.
Regards,
K.Diwakar