I got ” ORA-00604: error occurred at recursive SQL level 1 ” error in Oracle database.
ORA-00604: error occurred at recursive SQL level 1
Details of error are as follows.
ORA-00604: error occurred at recursive SQL level 1 ORA-01653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
ORA-00604: error occurred at recursive SQL level 1 ORA-01115: IO error reading block from file (block # ) ORA-01110: data file 1: '+DATA/testdb/datafile/system.269.765749853'
ORA-00604: error occurred at recursive SQL level string Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables). Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support. SQL> drop user MSDBA cascade; ERROR at line 1:
ORA-00604: error occurred at recursive SQL level string
error occurred at recursive SQL level string
This ORA-00604 error is related to the error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).
If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support.
If you got this error during drop user in Oracle 11gR1, then run the following event.
SQL> alter session set events ‘10851 trace name context forever, level 2’; Session altered.
Then try to drop again.
SQL> drop user MSDBA cascade; User dropped.
If you got this error during the drop table, then try to drop table with purge option as follows.
SQL> DROP TABLE TABLE_NAME PURGE;
If you got this error with any trigger, then try to run the following parameter and try again as follows.
Alter system set "_system_trig_enabled"=FALSE;
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )