performing DML/DDL operation over object in bin ORA-38301

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.7
Information 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 :

SQL> create table t (t number);

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

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/