userimage

SQL Error: ORA-00604: error occurred at recursive SQL level 1

I got this exception please suggest me how i can resolve the issue.

Error report:
SQL Error: ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_COL1) violated
00604. 00000 -  "error occurred at recursive SQL level %s"
*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.

userimage

Hey ,I got the same issue.....

Actually it was saying that unique key constraint means,inserting the duplicate values, but i got this issue while creating the view(create or replace view some_view_name ) with the 2 columns as same.

EX: create or replace view  sample_view as select s.student_id, s.student_id from student s where subject like ' Maths';

Its  a very strange behaviour.

Answer is