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

old dirtbeard wrote:
> Hello,
>
> The server is 10g, but we still have some 9i SQL*Plus clients. If they fail
> to include a purge option on their drop table statements:
>
> drop table bob purge;
>
> They will accumulate dropped tables in their recyclebin, and the 9i version
> of SQL*Plus does not support the command:
>
> purge recycyclebin;
>
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Mon Nov 20 09:54:29 2006
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> SQL> purge recyclebin;
> SP2-0734: unknown command beginning "purge recy..." - rest of line ignored.
> SQL>
>
> When I am logged in as system using a 10g client, and try to purge the
> dba_recyclebin, I do not have sufficient priviledges:
>
> SQL> purge dba_recyclebin;
> purge dba_recyclebin
> *
> ERROR at line 1:
> ORA-01031: insufficient privileges
>
> This poses several questions, I suppose:
>
> (1) What permission needs to be added to system account to purge the
> dba_recyclebin?
> (2) Is there any work-around for the users with the 9i clients to purge
> their own recyclebin?
> (3) Is there a way to disable the recyclebin?
>
> Thank you very much.
>
> DS

The best solution would be to upgrade the client. There are more issues potentially at work here than just the recyclebin.

But what is the issue you are trying to address to purging the recyclebin? Unless there is a security issue it can be ignored.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org