Blogs >> Technology >>
Evaluation Context Objects are Invalid
Following DB objects of type Evaluation Context are invalid.
AQ$_WF_NOTIFICATION_OUT_V
AQ$_WF_JAVA_DEFERRED_V
AQ$_WF_ERROR_V
AQ$_WF_DEFERRED_V
AQ$_WF_JAVA_ERROR_V
Sol:
1. Connect as applsys
connect applsys/<password>
-- This step should validate the evaluation context
exec dbms_rule_adm.create_rule_set('TEST','<evaluation context name>');
-- After using the test rule set, drop it
exec dbms_rule_adm.drop_rule_set('TEST');
Apply the same commands for every invalid evaluation context's
2. Verify if the evaluation contexts are valid
select object_name, object_type, owner, status
from dba_objects
wherew status = 'INVALID'
and object_type = 'EVALUATION CONTEXT';
|