Re: drop table

The space cost comment came from a post I read where it was asserted that Oracle was issing an out of space message where objects in the recycle bin were holding the room. I should have followed up prior to posting based on this but at the time I didn't remember the info was just something I read rather than encountered.

A search at metalinks shows several bugs related to the recycle bin but none that would seem to be related to a failure to allow the recyle bin object space to be reused. Unless perhaps such a failure would be a side-effect from one of the LOB related bugs. If Oracle fails to rename the LOB index and the index does not show as being in the recycle bin would Oracle be able to reuse the space? Anyway for anyone who expects to make use of the feature here are the significant bug reports I was able to find.

LOB INDEX DOESN'T GET RE-NAMED WITH BIN$XXX IN RECYCLEBIN ON DROP TABLE 4033889
RECYCLE BIN DOES NOT SHOWS ANYTHING AFTER DROPPING TABLE 3523082
DELETED OBJECT VERSION IS NOT PLACED IN THE WASTEBASKET 1461730
USER_TABLES VIEW SHOWS DROPPED OBJECTS IN THE RECYCLE BIN 3937613

HTH -- Mark D Powell -- Received on Tue Dec 21 2004 - 08:39:30 CST