How do you find dbms_error_code numbers? How can I display a description of an Oracle error in SQL*Plus?
Error at line 1:
ORA-04098: trigger 'SYSTEM.LOG_ERRORS_TRIG' is invalid and failed re-validation
ORA-00903: invalid table name
Well, the ORA- errors can all be found in the Error Message guide (full documentation can be found on technet.oracle.com). The error you list is saying that a trigger named LOG_ERRORS_TRIG owned by the SYSTEM ID is invalid because there is an invalid table name being referenced in that trigger. You need to find that trigger code and go from there.
Dig Deeper on Oracle error messages
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.