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.