RE: Weird Objects in DBA_SEGMENTS

  • From: "April Wells" <awells@xxxxxxxxxxxx>
  • To: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 16 Apr 2008 13:07:28 -0500

RATHER annoying?  Eesh.


Yeah, on 10g and I thought I disabled this feature on the warehouse.
Apparently not.





From: Mercadante, Thomas F (LABOR)
Sent: Wednesday, April 16, 2008 12:55 PM
To: April Wells; oracle-l@xxxxxxxxxxxxx
Subject: RE: Weird Objects in DBA_SEGMENTS




Log onto the segment owner via sqlplus and issue a "purge recyclebin"
command.  Thse will go away.


You didn't say - but you are 10g.  Now when you drop anything, it goes
into the recyclebin.

Rather annoying if you ask me!




From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of April Wells
Sent: Wednesday, April 16, 2008 1:42 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Weird Objects in DBA_SEGMENTS

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 




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.





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

Other related posts: