Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Weird tables created by oracle?
this are recycle bin entries and are generated in 10g when you drop a table . you can read more about it in the 10g manuals. ----- Original Message ---- From: David Moss <David.Moss@fdmgroup.com> To: Oracle-L@FreeLists.org Sent: Thursday, March 15, 2007 9:52:00 AM 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-lReceived on Thu Mar 15 2007 - 11:04:34 CDT
![]() |
![]() |