Oracle 10g incorporated the idea of a recycle bin for dropped objects. You have to manually purge the dropped objects to remove them permanently.
http://www.orafaq.com/node/968 http://www.rampant-books.com/art_liu_10g_flashback_feat.htm Axton Grams On Thu, Jun 5, 2008 at 11:45 AM, Ravi <[EMAIL PROTECTED]> wrote: > When I run the following query to look for space being takedn up by remedy > tables, I get a segment_name called: BIN$P9nIvT+TSejgRAADut5Q1w==$0. Anyone > know what this is? > > select segment_name, segment_type, bytes from user_segments where > SEGMENT_TYPE='TABLE' order by bytes asc; > > SEGMENT_NAME SEGMENT_TYPE BYTES > -------------------------------- ----------------- ---------- > BIN$P9nIvT+TSejgRAADut5Q1w==$0 TABLE 184549376 > > TIA > Ravi > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

