When trying to drop an empty tablespace, it fails with the error bellow:
BR0280I BRSPACE time stamp: 2015-03-15 12.36.45
BR1070I Searching for segments in tablespace <TABLESPACE> ...
BR0285I This action can take several seconds/minutes - be patient...
BR0280I BRSPACE time stamp: 2015-03-15 12.36.47
BR1072E Tablespace <TABLESPACE> contains <n> object(s) - option 'force' can be used to drop it
When querying DBA_SEGMENTS, it returns no rows for the tablespace:
SQL> select count(*) from dba_segments where tablespace_name = '<TABLESPACE>';
- SAP systems with Oracle RAC database
- Not restricted to a product or product version
- Any Operating System
delete, remote, tsdrop, segment, brtools, br*tools, cascade, object, owner, oracle , KBA , BC-DB-ORA , Oracle , BC-DB-ORA-DBA , Database Administration , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.