ORA-04067: not executed, rule set "SYS.RULESET$_XXXX" does not exist
Error
*******************
LOGMINER: Begin mining logfile for session 101 thread 1 sequence 96795, /mob_arch/archCRMTRFP/crmtrfp_arch_1_654707213_96795.arc Tue Feb 14 01:31:44 2012 krvxerpt: Errors detected in process 147, role preparer. krvxifc: Exception 4067 raised in filter callback. Errors in file /crmdb/oracle11g/base/diag/rdbms/strmob/STRMOB/trace/STRMOB_ms02_9822424.trc: ORA-04067: not executed, rule set "SYS.RULESET$_5960" does not exist krvxerpt: Errors detected in process 147, role preparer. krvxmrs: Leaving by exception: 4067
************************ ************************
Solution:
DECLARE
rs_name VARCHAR2(64); -- Variable to hold rule set name
BEGIN
SELECT RULE_SET_OWNER||'.'||RULE_SET_NAME
INTO rs_name
FROM DBA_CAPTURE
WHERE CAPTURE_NAME='<CAPTURE_NAME>';
DBMS_RULE_ADM.GRANT_OBJECT_PRIVILEGE(
privilege => SYS.DBMS_RULE_ADM.EXECUTE_ON_RULE_SET,
object_name => rs_name,
grantee => '<STRM_USER>);
END;
|