Creating a Rule that specificies a list of ORA-99999 to report on
EdGrimmJun 2 2010 — edited Jun 3 2010I am totally lost. Trying to create a rule under notification that either excludes or includes a given list of ORA-99999. For example, I want to create a rule that fires when the oracle errors(ORA-99999) is not equal to certain ora-99999 numbers.
Second, I want to be able to filter which ora-00600 errors are fired. For example, I dont want to rule to fire for an ora-00600 with a deadlock condition but i do want to fire all other ora-00600.
What I am basically asking is how do you filter the firing when creating a rule. Any examples would be most helpful.
Hope I was not too vague.
Thanks in advance
Ed Grimm