Home » RDBMS Server » Server Administration » urgent hep how to create sys.aud table
urgent hep how to create sys.aud table [message #50612] Mon, 25 March 2002 05:57 Go to next message
Helena
Messages: 42
Registered: February 2002
Member
I had a audit trail set up and by accident the sys.aud$ table was removed, now when I connect to the database I get this error messages:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-02002: error while writing to audit trail
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

can someone please help ASAP
Thanks
Re: urgent hep how to create sys.aud table [message #50614 is a reply to message #50612] Mon, 25 March 2002 07:19 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
Connect internal (sys) and run this script. It can be found in $ORACLE_HOME/rdbms/admin/sql.bsq.

create table aud$ /* audit trail table */
( sessionid number not null,
entryid number not null,
statement number not null,
timestamp# date not null,
userid varchar2("M_IDEN"),
userhost varchar2("M_HOST"),
terminal varchar2("M_TERM"),
action# number not null,
returncode number not null,
obj$creator varchar2("M_IDEN"),
obj$name varchar2("M_XDBI"),
auth$privileges varchar2("S_PRFL"),
auth$grantee varchar2("M_IDEN"),
new$owner varchar2("M_IDEN"),
new$name varchar2("M_XDBI"),
ses$actions varchar2("S_ACFL"),
ses$tid number,
logoff$lread number,
logoff$pread number,
logoff$lwrite number,
logoff$dead number,
logoff$time date,
comment$text varchar2("M_VCSZ"),
spare1 varchar2(255),
spare2 number,
obj$label raw(255), /* OBSOLETE: 8.0 and above */
ses$label raw(255), /* OBSOLETE: 8.0 and above */
priv$used number)
/
Previous Topic: minimum roles to connect to an instance
Next Topic: Re: Need Solaris Dumps & previous solved papers
Goto Forum:
  


Current Time: Tue Dec 24 22:39:50 CST 2024