Wednesday, 7 January 2015

AutoPatch error ORA-38301 can not perform DDL/DML over objects in Recycle Bin

Error:
AutoPatch error:
The following ORACLE error:

ORA-38301: can not perform DDL/DML over objects in Recycle Bin


occurred while executing the SQL statement:

DROP TABLE AD_DEFERRED_JOBS

AutoPatch error:
Error compiling invalid objects

You should check the file
/oracle/bhus/bhusappl/admin/BHUS_806_BALANCE/log/u7446446.log

for errors.

[applbhus@husas01t 7446446]$

Solution:
SQL> ALTER SESSION SET recyclebin = OFF;
SQL> ALTER SYSTEM SET recyclebin = ON;

Then drop the tables AD_DEFERRED_JOBS and FND_INSTALL_PROCESSES then restart the patch again in new session

Ref:  Note 265253.1  10g Recyclebin Features And How To Disable it( _recyclebin )

No comments: