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: 64111
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: Mon Dec 05 20:59:34 CST 2016

Total time taken to generate the page: 0.05707 seconds