This discussion is archived
0 Replies Latest reply: Sep 29, 2009 4:05 AM by 715498 RSS

special error object exists but desc is not returning results

715498 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points