You don't say which version you are using but some versions of 8 had a problem with desc and synonyms. Try desc sys.dba_audit_trail and see if that works. I know this was a problem in early 8.0 (8.03, 8.0.4) but thought it was fixed by 8i.
John [EMAIL PROTECTED] wrote: >Hi, > >Is this characteristic of a bug or is the Oracle Architecture ? > >SQL> desc dba_audit_exists >ERROR: >ORA-24372: invalid object for describe > > >SQL> select count(*) from dba_audit_exists; > > COUNT(*) >---------- > 0 > >SQL> desc dba_audit_exists > Name Null? Type > ----------------------------------------- -------- ---------------------------- > OS_USERNAME VARCHAR2(255) > USERNAME VARCHAR2(30) > USERHOST VARCHAR2(128) > TERMINAL VARCHAR2(255) > TIMESTAMP NOT NULL DATE > OWNER VARCHAR2(30) > OBJ_NAME VARCHAR2(128) > ACTION_NAME VARCHAR2(27) > NEW_OWNER VARCHAR2(30) > NEW_NAME VARCHAR2(128) > OBJ_PRIVILEGE VARCHAR2(16) > SYS_PRIVILEGE VARCHAR2(40) > GRANTEE VARCHAR2(30) > SESSIONID NOT NULL NUMBER > ENTRYID NOT NULL NUMBER > STATEMENTID NOT NULL NUMBER > RETURNCODE NOT NULL NUMBER > > > >Sinardy > > >> -----Original Message----- >>From: Sinardy Xing >>Sent: 08 April 2002 11:41 >>Subject: anyone see my DBA_AUDIT_TRAIL ??? >> >>Hi guys, >> >>Please help me solved this >> >> >>SQL> show user >>USER is "SYS" >> >> >>SQL> select owner, object_name, object_type from all_objects where object_name = >'DBA_AUDIT_TRAIL'; >> >>OWNER OBJECT_NAME OBJECT_TYPE >>------------------------------ ------------------------------ ------------------ >>SYS DBA_AUDIT_TRAIL VIEW >>PUBLIC DBA_AUDIT_TRAIL SYNONYM >> >> >>SQL> desc DBA_AUDIT_TRAIL >>ERROR: >>ORA-24372: invalid object for describe >> >> >>Why I can not describe my DBA_AUDIT_TRAIL ? >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
