DBMS_UTILITIES.ANALYZE_SCHEMA Fails

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jrunyan
Posts: 7
Joined: Fri 28 Sep 2007 21:50

DBMS_UTILITIES.ANALYZE_SCHEMA Fails

Post by jrunyan » Tue 08 Dec 2009 19:17

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!

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Wed 09 Dec 2009 08:46

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.

Post Reply