sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 故障案例 >

案例:Oracle报错performing DML/DDL operation over object in bin解决办法

时间:2016-06-24 12:37   来源:Oracle研究中心   作者:惜分飞   点击:

天萃荷净 运维DBA在巡检时发现alert日志文件中出现Oracle报错performing DML/DDL operation over object in bin,分析原因为回收站中的对象执行了dml或者ddl操作导致

1、Oracle数据库alert日志文件报错

Thu Jul 21 09:49:38 2011
performing DML/DDL operation over object in bin.
Thu Jul 21 09:51:02 2011
performing DML/DDL operation over object in bin.

2、Oracle案例分析

1)确认回收站功能启用
SQL> show parameter recyclebin;

NAME TYPE VALUE
———————————— ———– ——————————
recyclebin string ON
如果是OFF,使用alter system set recyclebin=on;开启回收站功能

2)创建和删除表
SQL> create table t_drop
2 as
3 select * from tab;

Table created.

SQL> drop table t_drop;

Table dropped.
SQL> show recyclebin;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
—————- —————————— ———— ——————-
T_DROP BIN$qIuF4JHvDJDgQKjADAsarA==$0 TABLE 2011-07-21:09:46:52

3)查看回收站表中数据
SQL> select * from “BIN$qIuF4JHvDJDgQKjADAsarA==$0″;

TNAME TABTYPE CLUSTERID
—————————— ——- ———-
T TABLE
TAB_CRM_CLIENT TABLE
TEST_COUNT TABLE
V_TEST VIEW
TEST TABLE
T_DROP TABLE
TAB_OLCM TABLE

7 rows selected.

4)对回收站中数据进行dml操作
SQL> delete from “BIN$qIuF4JHvDJDgQKjADAsarA==$0″;
delete from “BIN$qIuF4JHvDJDgQKjADAsarA==$0″
*
ERROR at line 1:
ORA-38301: can not perform DDL/DML over objects in Recycle Bin

5)对回收站中数据进行ddl操作
SQL> drop table “BIN$qIuF4JHvDJDgQKjADAsarA==$0″;
drop table “BIN$qIuF4JHvDJDgQKjADAsarA==$0″
*
ERROR at line 1:
ORA-38301: can not perform DDL/DML over objects in Recycle Bin

6)查看回收站,错误重现
Thu Jul 21 09:56:44 2011
performing DML/DDL operation over object in bin.
Thu Jul 21 09:57:19 2011
performing DML/DDL operation over object in bin.

7)说明
由于对回收站中的对象执行了dml或者ddl操作导致alert报类此做。在回收站中不能执行ddl或者dml操作


--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之案例:Oracle报错performing DML/DDL operation over object in bin解决办法

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/513.html

Oracle研究中心

关键词:

Oracle报错performing DML/DDL operation over object in bin解决办法