0 Replies Latest reply: Sep 29, 2009 6:05 AM by 715498 RSS

    special error object exists but desc is not returning results

    715498
      When I am running this query:
      select OWNER,OBJECT_NAME from dba_objects where OBJECT_NAME like '%DBCont%';
      Output:
      OWNER OBJECT_NAME
      ------------------------------ --------------------------------------------------------------------------------------------------------------------------------
      REPO2 WEBM2111254219370497
      REPO2 WEBM31170943931472
      REPO2 WEBM91183727189816
      REPO2 WEBM91238484534562
      REPO2 WmRDBContainer

      When I am doing :
      SQL> desc REPO2.WmRDBContainer
      ERROR:
      ORA-04043: object REPO2.WmRDBContainer does not exist

      But other's desc OWNER.OBJECT_NAME ; works fine

      Please help with reason.
      Database version is 9.2.0.8.0