Oracle 11g中recyclebin已經是靜態參數,線上不能修改,11grecyclebin

來源:互聯網
上載者:User

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> 


 

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.