Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DESC not working correctly

518698Jun 16 2006 — edited Feb 14 2008
I am using sqldeveloper 1.0.0.14.22 connecting to oracle 9.2.0.7 on AIX 5.3.

I am unable to desc tables in sqldeveloper, but I can in sqlplus. They are not synonyms:


select owner, object_name, object_type, object_id, created
from dba_objects where object_name = 'PS_PRT_SPECS_UC'

OWNER OBJECT_NAME OBJECT_TYPE OBJECT_ID CREATED
------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------ ---------------------- -------------------------
SYSADM PS_PRT_SPECS_UC TABLE 116636 02-MAY-06
SYSADM PS_PRT_SPECS_UC INDEX 116654 02-MAY-06

desc sysadm.PS_PRT_SPECS_UC
ERROR:
--------------------------------------------
ERROR: object PS_PRT_SPECS_UC does not exist

1 rows selected

<from sqlplus>
SQL> desc SYSADM.PS_PRT_SPECS_UC
Name Null? Type
----------------------------------------- -------- ----------------------------
KEY1 NOT NULL VARCHAR2(65)
OPRID NOT NULL VARCHAR2(30)
DATETIME_STAMP DATE
JOB_REQ_NBR NOT NULL VARCHAR2(6)
DESCRLONG LONG

I can desc other obects though:
desc dbadmn.AUDIT_ARCHIVE
Name Null Type
------------------------------ -------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SESSIONID NOT NULL NUMBER
LOGON DATE
USERID VARCHAR2(30)
LOGOFF DATE
LOGICAL_READS NUMBER(10)
...

Any help would be appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2008
Added on Jun 16 2006
19 comments
6,098 views