OS: AIX 5.3L, Oracle 10g R2, BAAN V.
our BAAN experienced user uses the function in BAAN to drop multiple tables (sometimes was the whole company). But as He showed me that there is no purge of that fucntion, so alll the dropped tables went to recyclebin (dba_recyclebin). Then they cumulated and costed little problem when I used the Database Control, responded very slow. I have to use "purge recyclebin" of SQL to clean out them, then the responsed is back to normal. Is there other way by BAAN to drop and purge the table at same time?

As with any other underscore parameter, setting this parameter is not recommended unless advised by Oracle Support Services.

On 10gR2 recyclebin is a initialization parameter and by default its ON.
We can disable recyclebin by using the following commands:

SQL> ALTER SESSION SET recyclebin = OFF;
SQL> ALTER SYSTEM SET recyclebin = OFF;

Alternatively,


RELEASE 1
ALTER SYSTEM SET "_recyclebin"=FALSE SCOPE = BOTH;
ALTER SESSION SET "_recyclebin"=FALSE; (just for the current session)

RELEASE 2
ALTER SYSTEM SET recyclebin = OFF;
ALTER SESSION SET recyclebin = OFF; (just for the current session)

The dropped objects, when recyclebin was ON will remain in the recyclebin even if we set the recyclebin parameter to OFF.

You might consider changing your ref drops to drop with PURGE option. (i.e. drop table <tablename> purge;) which will remove it from the recyclebin.

You can look up more info @ http://forums.oracle.com/forums

Please post in the right forum the next time.