Re: Weird tables created by oracle?

%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_at_fdmgroup.com> 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
> ________________________________________________________________________
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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