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

paulyibinyi發表於2010-09-30
ORMObject

In this Document
  
  
  
  

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 :

- What Do All 10g Flashback Features Rely on and what are their Limitations ?


 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7199859/viewspace-675184/，如需轉載，請註明出處，否則將追究法律責任。

相關文章