|Subject:||10g recyclebin with 9i SQL*Plus clients|
|Posted by:||old dirtbeard (dirtbea…@pacbell.net)|
|Date:||Mon, 20 Nov 2006|
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:
SQL*Plus: Release 22.214.171.124.0 - Production on Mon Nov 20 09:54:29 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
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.
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;
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
(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.