5 Replies Latest reply: Aug 4, 2011 11:50 AM by 837078 RSS

    ORA-04043: object xxx does not exist

    837078
      Hi All,

      Why am seeing this error? - Unable to create but not existing??!!


      SQL> CREATE TABLE ABC(
      2 SCHEDULEID NUMBER,
      3 TASKID NUMBER,
      4 CREDENTIALS VARCHAR2(128),
      5 constraint ABC_PK PRIMARY KEY(SCHEDULEID, TASKID)
      6 );
      CREATE TABLE ABC(
      *
      ERROR at line 1:
      ORA-00955: name is already used by an existing object


      SQL> desc ABC
      ERROR:
      ORA-04043: object ABC does not exist


      Thanks!