In this Document
Symptoms
Cause
Solution
References
Platforms: 1-914CU;
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7Information in this document applies to any platform.
***Checked for relevance on 16-Mar-2010***
Symptoms
The following message is produced in the Alert Log File constantly :performing DML/DDL operation over object in bin.
performing DML/DDL operation over object in bin.
Cause
The issue is caused by Unsupported Operations on objects in the recyclebin
There is a limitation on Flashback Drop Feature. You cannot use DML or DDL statements on objects in the recycle bin, while Oracle permits queries against objects stored in the recycle bin.
Please check the following Test Case :
Table created.
SQL> insert into t select rownum from tab;
10 rows created.
SQL> commit;
Commit complete.
SQL> drop table t;
Table dropped.
SQL> show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
T BIN$3aoHVu4DSgyrmBq+GbJiaw==$0 TABLE 2008-05-15:12:29:56
SQL> desc "BIN$3aoHVu4DSgyrmBq+GbJiaw==$0"
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
T NUMBER
SQL> select count(*) from "BIN$3aoHVu4DSgyrmBq+GbJiaw==$0";
COUNT(*)
-----------
10 rows selected.
SQL> update "BIN$3aoHVu4DSgyrmBq+GbJiaw==$0" set t=15;
update "BIN$3aoHVu4DSgyrmBq+GbJiaw==$0" set t=15
*
ERROR at line 1:
ORA-38301: can not perform. DDL/DML over objects in Recycle Bin
SQL> update "BIN$3aoHVu4DSgyrmBq+GbJiaw==$0" set t=15;
update "BIN$3aoHVu4DSgyrmBq+GbJiaw==$0" set t=15
*
ERROR at line 1:
ORA-38301: can not perform. DDL/DML over objects in Recycle Bin
Then check the Alert Log File, you will find the following message is produced :
performing DML/DDL operation over object in bin.
performing DML/DDL operation over object in bin.
Solution
Do not use DML or DDL statements on objects in the recycle bin.
For all the Limitations and Restrictions on Flashback Drop Feature, please check the following document :
Note 435998.1 - What Do All 10g Flashback Features Rely on and what are their Limitations ?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-675184/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7199859/viewspace-675184/