Re: Weird Objects in DBA_SEGMENTS

On Wed, 2008-04-16 at 12:42 -0500, April Wells wrote: [...]
>
> The paranoid dba on my left shoulder urged me to look at dba_segments…
> so I did.
>
>
>
> select owner, segment_name, partition_name, tablespace_name,
> segment_type from dba_segments where tablespace_name = 'STAGEDAT01';
>
>
>
> there are a bunch of segments named similar to
>
>
>
> BIN$Rxl0mZVtGWjgRAADupYzGQ==$0
>
>
>
> They “apparently” are tables and indexes.
[...]
>
> anyone have any ideas on what these BIN segments are?

Recycle bin objec ts.

>SQL Purge dba_recyclebin;

And turn recycling off if you want to.

-- 
S. Anthony Sequeira
++
You first parents of the human race... who ruined yourself for an apple,
what might you have done for a truffled turkey?
		-- Brillat-savarin, "Physiologie du Gout"
++

--
http://www.freelists.org/webpage/oracle-l