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