Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

purge dba_recyclebin as dba system

846231Oct 27 2011 — edited Oct 27 2011

Hi all,

Why can not SYSTEM dba user can not purge dba_recyclebin?

SQL> connect system/manager
Connected.
SQL> l
1* purge dba_recyclebin
SQL> /
purge dba_recyclebin
*
ERROR at line 1:
ORA-01031: insufficient privileges

I thank you all.....

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 24 2011

Added on Oct 27 2011

#general-database-discussions

2 comments

1,307 views