2154498 - Empty tablespace cannot be dropped | SAP Knowledge Base Article

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 with Oracle , Problem

About this page

This 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.