We are using TOAD 9.5 displaying tablespaces of a 126.96.36.199 database.
And, we are looking to drop empty tablespaces after the OATM migration during this initial test run.
In several tablespaces(one is GLD for example) TOAD shows space utilized(solid color) by objects.
When I use SQL select count(*) from dba_segments where tablespace_name = ‘GLD’, the query returns a count of zero. When I select ‘objects’ when GLD is highlighted there is no data displayed. So, what should I believe, the tablespaces that have no segment count can be dropped? or Is TOAD seeing something that I am not recognizing?
Thanks in advance,