| urgent hep how to create sys.aud table [message #50612] |
Mon, 25 March 2002 05:57  |
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  |
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)
/
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
