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

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1164045990.214440_at_bubbleator.drizzle.com...
> 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

Thank you for your response. This server is being used by university data management students and they are running SQL DDL statements over and over as they debug their programs (they may need to recreate and drop the same tables dozens of times and it just adds a great deal of clutter on their screens and a great deal of wasted storage on the server).

I really cannot upgrade all of the clients as they are logging in from their home machines, there are labs on campus that will not get new images until January, etc. I would like to be able to work-around this to get through the end of the semester.

Thank you,

doug Received on Mon Nov 20 2006 - 12:22:43 CST