Skip to Main Content
  • Questions
  • ORA-00604: error occurred at recursive SQL level

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, zhu.

Asked: April 10, 2025 - 5:23 am UTC

Last updated: April 14, 2025 - 6:56 am UTC

Version: Oracle 11.2.0.4

Viewed 1000+ times

You Asked

Hi,Tom:
The recycle bin is empty, and no DDL statements similar to
drop BIN$MmWdiJOqKt7gY0eQFAotmw==$0 were executed.

However, the following error was reported:

Caused by: java.sql.BatchUpdateException: ORA-00604: error occurred at recursive SQL level 1
ORA-38301: can not perform DDL/DML over objects in Recycle Bin

After performing the following operations, the error no longer occurred:

I disabled the SPACE ADVISOR.
BEGIN
DBMS_AUTO_TASK_ADMIN.disable(client_name => 'auto space advisor',operation => NULL,window_name => NULL);
END;
/
I dropped the table that caused the error and then recreated it.

I don't know the reason for this issue. Could you provide some guidance?

Thank you very much!
Best Regards

and Connor said...

It is going to be hard to determine that after the fact unfortunately. If it happens again, you could activate a trace on the advisor job.

But....The automatic task infrastructure was brand new back in version 11, so I'm unsurprised that it may have had some bugs.

Its time to upgrade from 11.2 :-)

Rating

  (2 ratings)

Comments

A reader, April 11, 2025 - 10:48 am UTC

Hi, Connor,
Thanks a lot for answering my question.

Best Regards
Connor McDonald
April 14, 2025 - 6:56 am UTC

glad we could help

More to Explore

DBMS_AUTO_TASK_ADMIN

More on PL/SQL routine DBMS_AUTO_TASK_ADMIN here