On 11/7/06, Mercadante, Thomas F (LABOR) < Thomas.Mercadante@xxxxxxxxxxxxxxxxx> 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