This discussion is archived
6 Replies Latest reply: Nov 20, 2012 1:40 AM by 975202 RSS

Disable recyclebin problem

626620 Newbie
Currently Being Moderated
In Oracle® Database Administrator's Guide 11g Release 1 (11.1) Part Number B28310-04, it states

To disable the recycle bin:

ALTER SESSION SET recyclebin = OFF;
ALTER SYSTEM SET recyclebin = OFF;

I run the alter session OK, but the alter system gave me error:

12:18:30 SQL> ALTER SYSTEM SET recyclebin = OFF;
ALTER SYSTEM SET recyclebin = OFF
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this option

What is wrong here?

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points