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

Home -> Community -> Mailing Lists -> Oracle-L -> Procedure to DROP a 700 GB Table in 10gR2 ?

Procedure to DROP a 700 GB Table in 10gR2 ?

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Mon, 22 Jan 2007 23:47:42 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF3020027679D3@BLRKECMSG11.ad.infosys.com>

Folks

In a 3 TB TEST Database in 10gR2, a 700 GB Table needs to be DROPPED.

This Table is present in a Unique Tablespace.

Which of the following Options is Most Advisable w.r.t. performance, speed & ease of Drop:-

  1. DROP the Respective Tablespace including contents
  2. Truncate the Table -> Drop the Table
  3. Drop the Table
  4. Some Other Option?

Thanks indeed

Received on Mon Jan 22 2007 - 12:17:42 CST

Original text of this message

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