Home » RDBMS Server » Server Administration » Dropping empty Tablespace
Dropping empty Tablespace [message #245940] Tue, 19 June 2007 06:52 Go to next message
rons
Messages: 18
Registered: June 2007
Location: Scottland
Junior Member
Hi,

SQL> select * from dba_segments  where tablespace_name = 'DATA_ALL' ;

no rows selected

SQL> select * from dba_extents  where tablespace_name = 'DATA_ALL' ;

no rows selected

SQL>


Is it safe to drop tablespace using
drop tablespace DATA_ALL including contents and datafiles;


Regards,
Rons
Re: Dropping empty Tablespace [message #245958 is a reply to message #245940] Tue, 19 June 2007 07:22 Go to previous message
Michel Cadot
Messages: 65079
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Previous Topic: Shutdown Immediate Timeout
Next Topic: Configure shmmax on solaris
Goto Forum:
  


Current Time: Thu Jul 20 20:00:55 CDT 2017

Total time taken to generate the page: 0.10221 seconds