Oracle 11g中recyclebin已经是静态参数,在线不能修改
来源:互联网 发布:淘宝小孩的皮裤 编辑:程序博客网 时间:2024/05/30 04:09
[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>
0 0
- Oracle 11g中recyclebin已经是静态参数,在线不能修改
- Oracle 11g中recyclebin参数的微小变化
- 11g中_serial_direct_read是动态参数,可以在线修改
- oracle 11g 回收站(recyclebin)的使用
- 在11g中alter system set recyclebin = off 报错 recyclebin 参数在11g和10g中的区别
- 在11g中alter system set recyclebin = off 报错 recyclebin 参数在11g和10g中的区别
- 在11g中alter system set recyclebin = off 报错 recyclebin 参数在11g和10g中的区别
- ORACLE 10G中的RecycleBin
- 修改Oracle 11g 内存参数
- ORACLE 11g 修改db_unique_name参数
- Oracle闪回技术之三 Oracle 11g Oracle RecycleBin (回收站)管理一
- Oracle闪回技术之三 Oracle 11g Oracle RecycleBin (回收站)管理二
- Oracle 10g New Feature:MAXTRANS参数已经废弃
- Oracle Recyclebin
- oracle recyclebin
- Oracle Recyclebin
- Oracle Recyclebin
- Oracle Recyclebin
- 木板墙问题
- 【原创】独家报道冷链行业新能量黑狗生鲜宅配
- 当你在浏览器地址栏输入一个URL后回车,将会发生的事情?
- c#抽象类和接口
- Adb connection Error / adb server is out of date.killing的解决办法
- Oracle 11g中recyclebin已经是静态参数,在线不能修改
- 理解RegisterClass
- request_region与release_region
- Node Interleaving: Enable or Disable?
- C API 通过ODBC 连接数据库MYSQL
- Log4j输出格式控制--log4j的PatternLayout参数含义
- 获取IOS的设备类型
- LeetCode 141 Linked List Cycle
- 2015 申请苹果个人开发者账号