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"

Reply via email to