Re: 10g recyclebin with 9i SQL*Plus clients

On Mon, 20 Nov 2006 09:56:53 -0800, "old dirtbeard" <dirtbeard_at_pacbell.net> wrote:

>(1) What permission needs to be added to system account to purge the
>dba_recyclebin?

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9018.htm#sthref9585

"
DBA_RECYCLEBIN This clause is valid only if you have SYSDBA system privilege. It lets you remove all objects from the system-wide recycle bin, and is equivalent to purging the recycle bin of every user. This operation is useful, for example, before backward migration.
"

>(2) Is there any work-around for the users with the 9i clients to purge
>their own recyclebin?

$ ./sqlplus test/test_at_test102

SQL*Plus: Release 9.2.0.8.0 - Production on Mon Nov 20 18:22:56 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> purge user_recyclebin;
SP2-0734: unknown command beginning "purge user..." - rest of line ignored.

SQL> begin execute immediate 'purge user_recyclebin'; end;   2 /

PL/SQL procedure successfully completed.

>(3) Is there a way to disable the recyclebin?

 Set parameter RECYCLEBIN to OFF.
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams174.htm#sthref722

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