Re: 10g Recycle Bin

On Wed, 30 Aug 2006 13:15:35 -0700, DA Morgan <damorgan_at_psoug.org> wrote:

>No and use is not optional unless you use the PURGE keyword with every drop.

 It is optional; there's the recyclebin parameter (which was promoted from the undocumented _recyclebin parameter in previous versions), and it's even session-level alterable.

SQL> drop table t;

Table dropped

SQL> select object_name, original_name, type from user_recyclebin;

OBJECT_NAME                    ORIGINAL_NAME                    TYPE
------------------------------ --------------------------------
-------------------------
BIN$HEKBQ6oM54ngQKjAZgEMWg==$0 T                                TABLE

SQL> purge user_recyclebin;

Done

SQL> create table t (id number);

Table created

SQL> alter session set recyclebin=off;

Session altered

SQL> drop table t;

Table dropped

SQL> select object_name, original_name, type from user_recyclebin;

OBJECT_NAME                    ORIGINAL_NAME                    TYPE
------------------------------ --------------------------------
-------------------------

SQL>

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool