Symptom
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>';
COUNT(*)
----------
0
Read more...
Environment
- SAP systems with Oracle RAC database
- Not restricted to a product or product version
- Any Operating System
Product
Keywords
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 page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.