Oracle | DBMS

Oracle DBMS_REPUTIL Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Note Advanced Replication has been dropped from version 12.2 with the sole exception being this one package from which essentially all functionality has been removed.

AUTHID DEFINER

Dependencies

DBMS_INTERNAL_TRIGGER

Documented Yes

First Available 7.3.4

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbmsgen.sql

Subprograms

If false, do not forward/defer the update dbms_reputil.replication_is_on RETURN BOOLEAN;

BEGIN

        IF dbms_reputil.replication_is_on THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      T

      

      PL/SQL procedure successfully completed.

REPLICATION_OFF

Stop replication dbms_reputil.replication_off;

exec dbms_reputil.replication_off;

      

      PL/SQL procedure successfully completed.

REPLICATION_ON

Start replication dbms_reputil.replication_on;

exec dbms_reputil.replication_on;

      

      PL/SQL procedure successfully completed.