Great Thanks!


-----Original Message-----
From: Michael Peel [mailto:[Email address protected]
Sent: Thursday, April 03, 2008 10:19 AM
To: Sikyala, Raquel [USA]
Subject: RE: How do I drop a tablespace and reclaim disk space

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text


Alter tablespace <tablespace_name> offline; Drop tablespace
<tablespace_name> including contents and datafiles;

Michael Peel


-----Original Message-----
From: Sikyala Raquel [USA]
[Email address protected]
Sent: 03 April 2008 15:12
To: LazyDBA Discussion
Subject: How do I drop a tablespace and reclaim disk space

I need to drop a tablespace that is empty. Nothing has been written to
it. How do I drop a tablespace and reclaim disk space?




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it and
do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ

AccuRead Limited Registered Number: 3076187 England GSL UK Limited
Registered Number: 3333860 England Global Solutions Limited Registered
Number: 3189802 England
**********************************************************************




Oracle LazyDBA home page