Recyclebin

[ndisang]

See, there are some exceptions of the recycle bin policy.
Not sure, but I belive objects of the SYSTEM tablespace are not covered by the recycle bin. Also Dictionary managed tablespaces are not covered. So check if u do not create objects in the system tablespace, and also that the tablespace u use is locally managed. Or better create a new locally managed tablespace, create a new table there, drop it and then see if it operates

Regards
Boris

BORE,
You are soooooooooooooo right. I just wanted to test the feature so I just went in as SYSTEM and of course was doing all that stuff on SYSTEM tbs. Now I went in as an ordinary schema fella and whalaa!!!...thanks a bundle...

[PAVB]

are you doing your tests loggin into the system as SYSTEM?

You are either a very dangerous or a very lucky person... or both