Site icon IT Tutorial

ORA-00604: error occurred at recursive SQL level 1

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 )

 

Exit mobile version