We have an Oracle 10.2.0.3 database with PeopleSoft running on the server. The OS is Solaris 5.9.
For one particular SQL statement we are seeing ORA-01410 (Invalid ROWID) error, for which to generate a trace we would like to create a logon trigger as:
create or replace trigger sysadmlog
alter session set events '1410 trace name errorstack level 3';
Some of our associates advice that, if the above created trigger becomes invalid then it may not allow new connections for SYSADM user to the database.
Please advice if creating LOGON Trigger(s) like above may have any impact on the database?
For any queries, kindly let me know.