Oracle | DBMS

Oracle DBMS_REPUTIL Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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;

REPLICATION_ON

Start replication dbms_reputil.replication_on;

exec dbms_reputil.replication_on;