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: Sinardy Xing 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).