Re: Weird Objects in DBA_SEGMENTS

They are recycle bin objects. Query dba_recyclebin to see them..

Thanks
Riyaj

On Wed, Apr 16, 2008 at 12:42 PM, April Wells <awells_at_netspend.com> wrote:

> I have spent the morning cleaning out a tablespace in an attempt to
> reclaim 800 GB of space and clean up my production data warehouse. To this
> end… I ran a BUNCH of
>
>
>
> ALTER TABLE <table> move tablespace <tablespace>;
>
>
>
> It "appeared" clean… nothing in dba_tables or dba_indexes.
>
>
>
> However, my life can't be that simple.
>
>
>
> 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.
>
>
>
> There are, however, apparently no actual extents… because
>
> select * from dba_extents where tablespace_name = 'STAGEDAT01';
>
> returns only the plan table that I want to drop anyway
>
>
>
> anyone have any ideas on what these BIN segments are?
>
>
>
> Thanks in advance.
>
> ajw
>
>
>
> ------------------------------
>
>
> Confidentiality Notice!
> This electronic transmission and any attached documents or other
> writings are confidential and are for the sole use of the intended
> recipient(s) identified above. This message may contain information
> that is privileged, confidential or otherwise protected from
> disclosure under applicable law. If the receiver of this
> information is not the intended recipient, or the employee, or
> agent responsible for delivering the information to the intended
> recipient, you are hereby notified that any use, reading,
> dissemination, distribution, copying or storage of this information
> is strictly prohibited. If you have received this information in
> error, please notify the sender by return email and delete the
> electronic transmission, including all attachments from your
> system.
>
>

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