Re: Weird tables created by oracle?

Hi David,

They are objects "saved" in the recyclebin. To get rid of them use:

   PURGE RECYCLEBIN; To not have them in the first place add PURGE to your DROPings -

   DROP ... PURGE; To see what they were:

   select object_name,type,original_name from recyclebin;

To learn more (i.e. how to restore them) - check the fine manuals!

HTH
Michael Garfield Sörensen, CeDeT

Quoting David Moss <David.Moss_at_fdmgroup.com>:

> 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