I am auditing SELECT errors in an Oracle database. When issuing a statement like this:
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.