Oracle error
ORA-00604
ORA-00604: error occurred at recursive SQL level %s
What usually causes it
SQL that Oracle ran on your behalf failed: a dictionary query, a trigger, auditing or space management.
What to check first
The real problem is the error printed after this one in the stack. Logon and DDL triggers are frequent culprits.
Scripts that help
- Alert log errors in the last 24 hoursORA- and TNS- errors plus checkpoint warnings from the alert log, read through SQL. It can be slow when the alert log is very large.
- Disabled constraints and triggersConstraints and triggers someone switched off, often for a data load, and never switched back on.