Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: BIN$ tables still exist after DROP and/with PURGE in tablespace.

Re: BIN$ tables still exist after DROP and/with PURGE in tablespace.

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 11 Apr 2007 08:04:45 -0700
Message-ID: <1176303879.871953@bubbleator.drizzle.com>


limyujeen_at_gmail.com wrote:
> I'm facing a very unique problem and I say unique because I can't seem
> to find a duplicate case as the one I am facing.
>
> -> Oracle, Release 10.1.0.4.0
>
> The situation is like this... some very large tables have been dropped
> and the recycle bin for that schema has been purged.
>
> When viewing the objects in the tablespace, I can still see "BIN
> $LZWEAt3ATFngRAASeZ5J1Q==$0" with the OWNER of the schema which I have
> just purged!
>
> I've queried the recyclebin. And no rows were returned. I've queried
> the dba_recyclebin, some rows were returned, but the specific BIN$
> table that I've mentioned above did not exist.
>
> The big catch is that the tablespace is full. The tables that were
> dropped consisted mainly of table partitions. They were purged but
> still use up space in the tablespace having the names such as BIN$...
>
> Is there a way I can purge these system files from the tablespace?
>
> There's no data in the recycle bin, what else can I do to drop the
> unwanted data from the tablespace?

SELECT owner, object_name, object_type
FROM dba_objects
WHERE object_name = "BIN$LZWEAt3ATFngRAASeZ5J1Q==$0";

What is it telling you?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Apr 11 2007 - 10:04:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US