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: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 8 Nov 2006 10:48:29 +0000
Message-ID: <7765c8970611080248m7f46b4f9g4162072e49837af@mail.gmail.com>


On 11/7/06, Mercadante, Thomas F (LABOR) < Thomas.Mercadante_at_labor.state.ny.us> wrote:
>
> Ven,
>
> You must be in 10g.
>
> Every time you drop an object, it goes into the recycle bin. One of the
> most stupid ideas I have ever heard of. This ain't a desktop from
> criminy sakes.

see I think it's a potentially great feature, and here is a possible illustration of it. 3000 dropped tables is an awful lot, so it suggests to me that either this is an very actively developed database or more likely IMO there is a great potential improvement opportunity here by moving the application to using GTTs rather than continually dropping and recreating real objects. The recycle bin as db usage indicator, who'd have thunk it..

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 08 2006 - 04:48:29 CST

Original text of this message

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