DBMSREPUTIL.REPLICATIONON is correct to turn ON replication - Oracle Replication

Q.  Which one of the following way is correct to turn ON replication?
- Published on 12 Aug 15

a. DBMS_REPUTIL_REPLICATION=ON
b. DBMS_REPUTIL.REPLICATION=ON
c. DBMS_REPUTIL.REPLICATION_ON
d. All of the above

ANSWER: DBMS_REPUTIL.REPLICATION_ON
 

    Discussion

  • Nirja Shah   -Posted on 18 Sep 15
    - DBMS_REPUTIL contains subprograms to generate shadow tables, triggers, and packages for table replication, as well as subprograms to generate wrappers for replication of standalone procedure invocations and packaged procedure invocations.

    - This package is referenced only by the generated code.

    - Replication_on procedure - This procedure reenables replication of changes after replication has been temporarily suspended.

    - Syntax
    DBMS_REPUTIL.REPLICATION_ON();

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)