OraFAQ Forum: Server Administration » Dropping empty Tablespace

Home » RDBMS Server » Server Administration » Dropping empty Tablespace

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Dropping empty Tablespace [message #245940]

Tue, 19 June 2007 06:52

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

Report message to a moderator

Re: Dropping empty Tablespace [message #245958 is a reply to message #245940]

Tue, 19 June 2007 07:22

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes.

Regards
Michel

Report message to a moderator

Previous Topic:	Shutdown Immediate Timeout
Next Topic:	Configure shmmax on solaris

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 06:24:31 CST 2025