Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Dropping a 700 GB Tablespace in a Test Database Efficiently ?

Re: Dropping a 700 GB Tablespace in a Test Database Efficiently ?

From: LS Cheng <exriscer_at_gmail.com>
Date: Tue, 24 Apr 2007 01:02:15 +0200
Message-ID: <6e9345580704231602w7b2e89c0u5738dd595ba48dcf@mail.gmail.com>


what if you rm the files directly

On 4/23/07, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:
>
> Folks
>
>
>
> An internal Test Database has 1 of it's Tablespace's of 700 GB which in
> turn Contains only 1 Table. What is the ideal Approach to DROP the same?
>
>
>
> Personally I think the following approach is most *efficient*:-
>
> SQL> DROP TABLESPACE <Name> INCLUDING CONTENTS AND DATAFILES;
>
>
>
> OTHER possible Approaches:-
>
>
>
> SQL> TRUNCATE TABLE <Name>;
>
> SQL> DROP TABLE <Name> PURGE; followed by the Command SQL> DROP TABLESPACE
> <Name> INCLUDING CONTENTS AND DATAFILES;
>
>
>
> Database Oracle Version 10gR2
>
>
>
> Seek Advice folks
>
>
>
> Thanks indeed
>
>
>
>
>
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this e-mail
> or its contents to any other person and any such actions are unlawful. This
> e-mail may contain viruses. Infosys has taken every reasonable precaution to
> minimize this risk, but is not liable for any damage you may sustain as a
> result of any virus in this e-mail. You should carry out your own virus
> checks before opening the e-mail or attachment. Infosys reserves the right
> to monitor and review the content of all messages sent to or from this
> e-mail address. Messages sent to or from this e-mail address may be stored
> on the Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 23 2007 - 18:02:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US