I am auditing SELECT errors in an Oracle database. When issuing a statement like this:
SELECT os_username,
username,
userhost,
TIMESTAMP,
owner,
obj_name,
action_name,
returncode,
sql_bind,
sql_text
FROM dba_audit_trail
WHERE timestamp > TRUNC (SYSDATE) AND returncode = 1445
ORDER BY TIMESTAMP;
the audit trail will have multiple ORA-1445 or ORA-1446 errors but Windows SQL*Plus has no errors.
If I look at the SQL_TXT column from dba_audit_trail in SQL Nav I see the query
SELECT dba_audit_trail.*,ROWID FROM dba_audit_trail;
I believe that the 'ROWID' was added by SQL Nav which is causing the ORA-01445.
The data grid has been set to be updateable [UPDATEABLE(ON)]
Toggle off the UPDATEABLE button shown in the attached screenshot.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center