6 Replies Latest reply: Nov 20, 2012 3:40 AM by 975202 RSS

    Disable recyclebin problem

    626620
      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