5 Replies Latest reply on Aug 4, 2011 4:50 PM by 837078

    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!