ORA-00942: table or view does not exist while creating the table

223 Views Asked by At

I am creating a table in an oracle database using a statement like this:

 CREATE TABLE T_MY_NEW_TABLE (
      ID        VARCHAR2(10 char) not null,
      VERSION   NUMBER(4),
      SOME_ID   VARCHAR2(10 char) not null,
      constraint PK_MY_NEW_TABLE primary key(ID)
 );

This script usually runs fine. But sometimes I get the error: ORA-00942: table or view does not exist. Which doesn't make any sense to me. What is the error supposed to mean? I am creating a new table. The table that I am creating should not exist. But oracle want it to exist, so I can create it?

It must be something else. And only the error is misleading?

I tried to create a new table. I expected the new table to be created. Sometimes I am getting the error ORA-00942 instead of the created table.

0

There are 0 best solutions below