How do you find dbms_error_code numbers? How can I display a description of an Oracle error in SQL*Plus?
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.