Database Administration (MOSC)

MOSC Banner

unable to drop tablespace

edited Dec 12, 2013 10:13AM in Database Administration (MOSC) 22 commentsAnswered
Oracle 11.2.0.3 with two node RAC
unable to drop tablespace..

SYS@soaprd1>drop tablespace uat_soainfra;
drop tablespace uat_soainfra
*
ERROR at line 1:
ORA-01549: tablespace not empty, use INCLUDING CONTENTS option


SYS@soaprd1>drop tablespace uat_soainfra including contents;
drop tablespace uat_soainfra including contents
*
ERROR at line 1:
ORA-01561: failed to remove all objects in the tablespace specified

There are no objects in the tablespace..

SYS@soaprd1>select 'drop table '||owner||'.'||table_name||' cascade constraints;' from dba_tables where tablespace_name='UAT_SOAINFRA';

no rows selected

How to drop this tablespace ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center