When I Create New Table from Oracle Sql Developer. I get this error

0
votes

Error Messages:

ORA-00604: error occurred at recursive SQL level 1

ORA-00942: table or view does not exist

1
oracleoracle-sqldeveloper

1 Answers

0
votes

You're living a dangerous life.

Never, ever create anything in SYS (nor SYSTEM) schema.

Who knows what might be wrong ... maybe you dropped some SYS-owned object. Maybe there's a trigger which does "something" when you create a table.

There's nothing obvious in what you posted. Table, as is, creates normally:

SQL> show user
USER is "SCOTT"
SQL> create table table1
  2  (id varchar2(20) not null,
  3   ivoice varchar2(20) not null
  4  );

Table created.

SQL>