Re: BIN$ tables

  • From: "Andre van Winssen" <dreveewee@xxxxxxxxx>
  • To: mwf@xxxxxxxx
  • Date: Tue, 7 Nov 2006 19:14:06 +0100

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@xxxxxxxx>:


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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx
]On
Behalf Of vnr1995
Sent: Tuesday, November 07, 2006 11:29 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l



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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2006