GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Oracle streams DBMS_APPLY_ADM.SET_PARAMETER questions

edited Apr 11, 2013 12:20AM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered ✓
Hi,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center