Oracle streams DBMS_APPLY_ADM.SET_PARAMETER questions
I have the following two questions about DBMS_APPLY_ADM.SET_PARAMETER
- How to display all Capture, Propagation, and Apply parameters? How to get the value of a certainCapture, Propagation, and Apply parameter?
- If I execute the following:
BEGIN
DBMS_APPLY_ADM.SET_PARAMETER(
apply_name => 'apply_stream',
parameter => 'disable_on_error',
value => 'n');
END;
/
Would that be permanent? In other words, I do not need to execute it every time I start the apply process?
Thanks a lot,
Hisham