Oracle | DBMS_STREAMS_PUB

Oracle DBMS_STREAMS_PUB_RPC 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.

Purpose Undocumented Streams tools granted to PUBLIC

Streams was deprecated 03-Jan-2018 but this package still exists in 21c.

AUTHID CURRENT_USER

Dependencies

DBMS_LOGREP_UTIL	DBMS_STREAMS_ADM	DBMS_STREAMS_DATAPUMP_UTIL
DBMS_PRIV_CAPTURE	DBMS_STREAMS_DATAPUMP	DBMS_STREAMS_RPC

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvthsrp.plb

Subprograms

GET_EXPORT_DML_SCN

MIN_SUPP_LOGGING_ENABLED

NEED_SCN

GET_EXPORT_DML_SCN

Undocumented dbms_streams_pub_rpc.get_export_dml_scn( canon_schema IN VARCHAR2, canon_tablename IN VARCHAR2, cookie IN VARCHAR2, flashback_scn IN NUMBER) RETURN NUMBER;

TBD

MIN_SUPP_LOGGING_ENABLED

Returns 'Y' if minimum supplemental logging is enabled dbms_streams_pub_rpc.min_supp_logging_enabled RETURN VARCHAR2;

SELECT dbms_streams_pub_rpc.min_supp_logging_enabled

      FROM dual;

      

      MIN_SUPP_LOGGING_ENABLED

      ------------------------

      Y

NEED_SCN

Undocumented dbms_streams_pub_rpc.need_scn( db_link IN VARCHAR2, interest_num OUT NUMBER, cookie IN OUT VARCHAR2);

TBD