Q

Trigger error in SQL*Plus

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.

This was first published in March 2004

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close