Re: Weird tables created by oracle?

  • From: "A. Coskan Gundogar" <gundogar@xxxxxxxxx>
  • To: David.Moss@xxxxxxxxxxxx
  • Date: Thu, 15 Mar 2007 17:02:14 +0200

%99 percent they are the tables in the recycle bin

If you drop a table without purge statement Oracle Keeps it in recycle bin

The right statement for passing the recyclebin is

Drop table xxx purge;

If you want to disable all the recyclebin operation

for 10g R2

alter system set recyclebin=off;

for 10g R1 --the parameter is undocumented

alter system set _recyclebin=false;


For viewing the contents in recyclebin you can use

show recyclebin
or
select * from user_recyclebin

to purge all the deleted  for only one schema

purce recyclebin;

to purge all the deleted for all schemas (must be sysdba)

purce dba_recyclebin;




On 3/15/07, David Moss <David.Moss@xxxxxxxxxxxx> wrote:


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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2007