Hi Mauricio,
You cannot get the SQL statement for a select statement from the
normal audit trail. If you have 9i then you can use Fine Grained Audit
(FGA) to do this. There are some papers on normal audit on my site and
also some stuff on FGA if you are interested.
See my site at
Hi
The version is Oracle 8i, so
is there a way to retrieve the sql statement?
could the v$sql view or v$sqltext view be useful?
regards
Arup Nanda [EMAIL PROTECTED] wrote:
You haven't specified the Oracle version. If it's 9i, you could use Fine Grained Auditing (FGA) to get the exact SQLs.
You haven't specified the Oracle version. If it's
9i, you could use Fine Grained Auditing (FGA) to get the exact
SQLs.
Hope this helps.
Arup
- Original Message -
From:
Mauricio Vélez
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 29, 2003 1:39