Re: Weird Objects in DBA_SEGMENTS

Who is the owner of those objects in dba_recyclebin though ? May be those objects are owned by different user?

Also, what are the values for type and operation columns? You could try purge dba_recyclebin, but that will clean up recyclebin from all schemas though.

Cheers
Riyaj Shamsudeen
The Pythian Group
www.pythian.com

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

> But emptying the recycle bin doesn't get rid of them…
>
>
>
> SQL> purge recyclebin;
>
>
>
>
>
>
> ------------------------------
>
> *From:* Riyaj Shamsudeen [mailto:riyaj.shamsudeen_at_gmail.com]
> *Sent:* Wednesday, April 16, 2008 12:46 PM
> *To:* April Wells
> *Cc:* oracle-l_at_freelists.org
> *Subject:* 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