RE: Weird tables created by oracle?

From: <jim.silverman_at_thomson.com>
Date: Thu, 15 Mar 2007 11:03:04 -0400
Message-ID: <E2157B37A63D2E4B9B00575021FC84D69A35B4@tshusmian2msg01.ERF.THOMSON.COM>

David, these are tables that have been DROPped and are now in the user's RECYCLEBIN. To get rid of them you can issue the SQL command

PURGE RECYCLEBIN There are also other variants of the PURGE command, as well as data dictionary views (e.g., USER_RECYCLEBIN); see the SQL Reference Manual for details.

Jim Silverman
Senior Systems Database Administrator
Solucient, LLC - A Thomson Company
Telephone: 734-669-7641

FAX:            734-930-7611
E-Mail:         jim.silverman_at_thomson.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Moss Sent: Thursday, March 15, 2007 10:52 AM
To: Oracle-L_at_freelists.org
Subject: Weird tables created by oracle?

Hi,

I was wondering if anyone knows how this tables came about:

SQL> run

  1  select     object_name,
  2     object_type
  3  from       all_objects
  4  where      owner='DAVIDMOSS'
  5  order by
  6     object_type,

7* object_name

OBJECT_NAME                    OBJECT_TYPE
------------------------------ -------------------

...

BIN$K5/32R4X/PvgQKjAAgAduA==$0 TABLE
BIN$K5/32R4Y/PvgQKjAAgAduA==$0 TABLE
...

24 rows selected.

SQL>

Do they serve a function? Are they safe to remove? I searched the net for similar looking tables but found nothing relevant, so if anyone has pointers they be very welcome :)

Thanks,

David.

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

Received on Thu Mar 15 2007 - 10:03:04 CDT