RE: Weird tables created by oracle?

From: Mercadante, Thomas F $LABOR$ <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 15 Mar 2007 11:09:02 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08C26@EXCNYSM0A1AJ.nysemail.nyenet>

David,

You are in 10g, correct? This is the recycle bin. These appear when you drop objects.

You can get rid of this by using the "purge recyclebin" command.

Tom

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

-----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.

This message is from FDM Group Plc, and may contain information that is confidential or privileged. If you are not the intended recipient, please delete the message and any attachments and notify the sender. This email is not intended to create legally binding commitments on behalf of FDM Group Plc, nor do its contents reflect the corporate views or policies of FDM. Any unauthorised disclosure, use or dissemination, either whole or partial, is prohibited. FDM Group Plc is a private limited company registered in England (Reg. No. 2542980).

This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk

--

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

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 15 2007 - 10:09:02 CDT