Oracle 11g中recyclebin已经是静态参数，在线不能修改

最新推荐文章于 2022-06-23 13:02:31 发布

msdnchina

最新推荐文章于 2022-06-23 13:02:31 发布

阅读量2.1k

点赞数

分类专栏： Oracle DB

本文链接：https://blog.csdn.net/msdnchina/article/details/45245655

版权

Oracle DB 专栏收录该内容

773 篇文章 3 订阅

订阅专栏


[oracle@rhel63single ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 20 17:19:32 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

 

ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2260088 bytes
Variable Size             612369288 bytes
Database Buffers          448790528 bytes
Redo Buffers                5517312 bytes
Database mounted.
Database opened.
SQL> SQL> SQL> SQL> 

SQL> SQL> 
SQL> show parameter recyc

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_recycle                  string
db_recycle_cache_size                big integer 0
recyclebin                           string      on

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


SQL> 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 this
option


SQL> alter system set recyclebin=off scope=spfile;

System altered.

SQL>