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: BIN$ tables

Re: BIN$ tables

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Tue, 7 Nov 2006 10:55:17 -0800 (PST)
Message-ID: <20061107185517.69797.qmail@web51309.mail.yahoo.com>


Or we can use drop table <tablename> purge;    

  Which will make sure that Drop is working the way it used to work earlier means no recyclebin    

  Sanjay

Dennis Williams <oracledba.williams_at_gmail.com> wrote:

    David,   

I haven't had the opportunity to use 10g yet, but I like your opinion that overall this is a great feature, and wonder what the experience of others has been.

    One of the quickest way to shut down a production application is to have two screens before you, one for test, one for production. Enter the drop table command into the wrong screen. The second easiest is to have a script lying about which conveniently begins with DROP TABLE, followed by CREATE TABLE. Have that executed at the wrong time on the wrong system, and catastrophe ensues. I have usually exported the small static tables weekly just to be able to recover from this problem.    

  But I can see this can be frustrating when working with large tables because an additional step is required in order to release the space.    

  Dennis Williams  



Sponsored Link

Get a free Motorola Razr! Today Only! Choose Cingular, Sprint, Verizon, Alltel, or T-Mobile.
--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 07 2006 - 12:55:17 CST

Original text of this message

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