Devart Forums

The following anonymous block fails using ORAScript component:

BEGIN
-- Suggested By Oracle
-- Use Analyze Schema to avoid analyze SYS, SYSTEM objects
-- Use same amount of percent to get best performace
DBMS_Utility.Analyze_Schema('MAIN', 'ESTIMATE', '',10,'');

DBMS_Utility.Analyze_Schema('ARCHIVE', 'ESTIMATE', '',10,'');

DBMS_Utility.Analyze_Schema('GLOBAL', 'ESTIMATE', '',10,'');

DBMS_Utility.Analyze_Schema('CWS', 'ESTIMATE', '',10,'');
END;
ORA-38301: can not perform DDL/DML over objects in Recycle Bin
ORA-06512: at "SYS.DBMS_DDL", line 245
ORA-06512: at "SYS.DBMS_UTILITY", line 513
ORA-06512: at line 5
Error Offset: 0

The Recycle Bin has been purged.

Any help would be appreciated.

Thanks!

This problem is not related to ODAC. It will occur if you execute your SQL in any tool for Oracle.
I don't know the cause of this problem.