I got this exception please suggest me how i can resolve the issue.
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.
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.