Home » RDBMS Server » Server Administration » unable to see dba_audit_trail (oralce 11g -- 11.2.0.3.0)
unable to see dba_audit_trail [message #654440] Wed, 03 August 2016 01:32 Go to next message
Prakash Singh
Messages: 1
Registered: August 2016
Junior Member
SQL> desc dba_audit_trail;
ERROR:
ORA-24372: invalid object for describe


--plz help me...
Re: unable to see dba_audit_trail [message #654441 is a reply to message #654440] Wed, 03 August 2016 01:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Ask your DBA to grant you access to it (if you are allowed to have this access).

Re: unable to see dba_audit_trail [message #654445 is a reply to message #654441] Wed, 03 August 2016 02:42 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Or if it really doesn't exist, connect to SYS and run cataudit.sql to create it.
conn SYS AS SYSDBA
@?/rdbms/admin/cataudit.sql
Re: unable to see dba_audit_trail [message #654449 is a reply to message #654445] Wed, 03 August 2016 03:24 Go to previous message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
24372, 00000, "invalid object for describe"
// *Cause:  The object to be described is not valid.
//          It either has compilation or authorization errors.
// *Action: The object to be described must be valid.
Previous Topic: Oracle Universal installer stucks - GUI issue?
Next Topic: how connect with 12c
Goto Forum:
  


Current Time: Thu Mar 28 14:24:30 CDT 2024