SAP Knowledge Base Article - Preview

2154498 - Empty tablespace cannot be dropped

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

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

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.