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).

Reply via email to