Oracle 11g中recyclebin已經是靜態參數,線上不能修改,11grecyclebin
[oracle@rhel63single ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 20 17:19:32 2015Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL> startup ORACLE instance started.Total System Global Area 1068937216 bytesFixed Size 2260088 bytesVariable Size 612369288 bytesDatabase Buffers 448790528 bytesRedo Buffers 5517312 bytesDatabase mounted.Database opened.SQL> SQL> SQL> SQL> SQL> SQL> SQL> show parameter recycNAME TYPE VALUE------------------------------------ ----------- ------------------------------buffer_pool_recycle stringdb_recycle_cache_size big integer 0recyclebin string onSQL> alter system set recyclebin=off;alter system set recyclebin=off *ERROR at line 1:ORA-02096: specified initialization parameter is not modifiable with thisoptionSQL> alter system set recyclebin=off scope=both;alter system set recyclebin=off scope=both *ERROR at line 1:ORA-02096: specified initialization parameter is not modifiable with thisoptionSQL> alter system set recyclebin=off scope=spfile;System altered.SQL>