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.
SAP Knowledge Base Article - Preview