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.
Tiene que estar conectado y contar con un contrato de mantenimiento vigente para ver los artículos de conocimiento premium.
© ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center