Re: BIN$ tables

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
  • Date: Wed, 8 Nov 2006 10:48:29 +0000

On 11/7/06, Mercadante, Thomas F (LABOR) <
Thomas.Mercadante@xxxxxxxxxxxxxxxxx> wrote:


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

Other related posts: