Re: BIN$ tables

ALTER SYSTEM SET recyclebin = "OFF" SCOPE=BOTH should work, ie actually drop a table instead of 'renaming' it into the recyclebin

Andre

2006/11/7, Mark W. Farnham <mwf_at_rsiz.com>:
>
> If you don't want to use the feature that allows you to recover the table
> without recovering to a point in time before the drop, then drop table
> .....
> purge;
> is the syntax you should use.
>
> I'm not aware of a way to make this the default behavior, but I've never
> really looked into it.
>
> Read about the recycle bin to learn how to purge it.
>
> Regards,
>
> mwf
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org
> ]On
> Behalf Of vnr1995
> Sent: Tuesday, November 07, 2006 11:29 AM
> To: oracle-l_at_freelists.org
> Subject: BIN$ tables
>
> Hi,
>
> I have found in a schema 3000 tables of the following type:
> BIN$IU+04Dm/akXgRAADut3aZw==$0
>
> Any idea?
>
>
> Thanks,
> Ven
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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