DESC not working correctly
518698Jun 16 2006 — edited Feb 14 2008I 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.