RE: Weird tables created by oracle?
- From: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <David.Moss@xxxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
- Date: Thu, 15 Mar 2007 11:09:02 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Moss
Sent: Thursday, March 15, 2007 10:52 AM
To: Oracle-L@xxxxxxxxxxxxx
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
________________________________________________________________________
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
