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

最新推荐文章于 2025-07-14 09:22:56 发布

原创最新推荐文章于 2025-07-14 09:22:56 发布 · 2.2k 阅读

0 ·

CC 4.0 BY-SA版权

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

本文详细介绍了如何在Oracle数据库中设置回收站、禁用回收站以及相关参数的配置方法，包括如何通过SQL命令操作这些设置，并解释了回收站的作用与重要性。


[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>