Oracle | DBMS_STREAMS_PUB

Oracle DBMS_STREAMS_PUB_RPC Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Undocumented Streams tools granted to PUBLIC

Streams was deprecated 03-Jan-2018 but this package still exists in 23ai

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