Oracle | DBMS_STREAMS_PUB

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

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, else N dbms_streams_pub_rpc.min_supp_logging_enabled RETURN VARCHAR2;

SELECT dbms_streams_pub_rpc.min_supp_logging_enabled;

      

      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

Related Topics

DBMS_RECOVERABLE_SCRIPT

DBMS_STREAMS

DBMS_STREAMS_ADM

DBMS_STREAMS_ADM_UTL_INT

DBMS_STREAMS_AUTH

DBMS_STREAMS_CONTROL_ADM

DBMS_STREAMS_RPC_INTERNAL

DBMS_STREAMS_TABLESPACE_ADM

What's New In 21c

What's New In 23c

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

DBSecWorx