Oracle | DBMS_XSTREAM_ADM

Oracle DBMS_XSTREAM_ADM_INTERNAL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Xstreams Heterogeneous Replication Administrative Utilities

AUTHID DEFINER

Dependencies

ALL_USERS	DBMS_STANDARD	GG$_PACKAGE_MAPPING
DBA_EDITIONS	DBMS_STREAMS_ADM	GLOBAL_NAME
DBA_GG_SUPPORTED_PACKAGES	DBMS_STREAMS_ADM_UTL	GOLDENGATE$_CONTAINER_RULES
DBA_TAB_PRIVS	DBMS_UTILITY	GOLDENGATE$_PRIVILEGES
DBMS_APPLY_ADM_INTERNAL	DBMS_XSTREAM_ADM	PLITBLM
DBMS_ASSERT	DBMS_XSTREAM_AUTH_IVK	REPL$_PROCESS_EVENTS
DBMS_CAPTURE_ADM_INTERNAL	DBMS_XSTREAM_GG_ADM	RULE_ID_SEQ$
DBMS_LOGREP_LIB	DBMS_XSTREAM_UTL_IVK	XSTREAM$_SERVER
DBMS_LOGREP_UTIL	DUAL

Documented No

First Available 11.2

Security Model Owned by SYS with no privileges granted

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

Subprograms

ADD_CONTAINER_RULE	INS_XSERVER	REMOVE_CONTAINER_RULE_BY_ID
CONVERT_POSITION_INTERNAL	POPULATE_SCRIPT_ARRAY	REMOVE_GOLDENGATE_PRIVILEGE
DELETE_REPLICATION_EVENTS	REMOVE_CONTAINER_RULE	UPDATE_XSERVER_CONNECT_USER
GET_OPTIONAL_PRIVILEGES

ADD_CONTAINER_RULE

Add a new container role dbms_xstream_adm_internal.add_container_rule( capture_name IN VARCHAR2, canon_filter_rule IN VARCHAR2, inclusion_rule IN BOOLEAN, escale_char IN CHAR, wildcard_flag IN BOOLEAN);

TBD

CONVERT_POSITION_INTERNAL

Undocumented dbms_xstream_adm_internal.convert_position_internal( position IN RAW, version IN BINARY_INTEGER, newposition OUT RAW)

TBD

DELETE_REPLICATION_EVENTS

Delete an XSTREAM replication event dbms_xstream_adm_internal.delete replication_events( streams_name IN VARCHAR2, streams_type IN VARCHAR2, process_type IN VARCHAR2, event_name IN VARCHAR2, include_error IN BOOLEAN, event_time_in IN TIMESTAMP);

TBD

GET_OPTIONAL_PRIVILEGES

Undocumented dbms_xstream_adm_internal.get_optional_privileges( optional_privileges IN VARCHAR2, privilege_table OUT dbms_utility.name_array, procrep_packages OUT dbms_utility.lname_array, procrep OUT BOOLEAN, procrep_allowed IN BOOLEAN, isogg IN BOOLEAN) RETURN NUMBER;

TBD

INS_XSERVER

Undocumented dbms_xstream_adm_internal.ins_xserver( canon_server_name IN VARCHAR2, canon_app_src_db IN VARCHAR2, canon_queue_owner IN VARCHAR2, canon_queue_name IN VARCHAR2, canon_capture_name IN VARCHAR2, canon_cap_src_db IN VARCHAR2, usr_comment IN VARCHAR2, flags IN NUMBER);

TBD

POPULATE_SCRIPT_ARRAY

Undocumented dbms_xstream_adm_internal.populate_script_array( is_grant IN BOOLEAN, script IN OUT dbms_xstream_auth_ivk.script_t, canon_grantee IN VARCHAR2, canon_privilege_type IN VARCHAR2, select_privilegeS IN BOOLEAN, optional_privilegeS IN VARCHAR2, canon_container IN VARCHAR2);

TBD

REMOVE_CONTAINER_RULE

Remove a container capture rule by the filter rule_name dbms_xstream_adm_internal.remove_container_rule( capture_name IN VARCHAR2, canon_filter_rule IN VARCHAR2, inclusion_rule IN BOOLEAN);

TBD

REMOVE_CONTAINER_RULE_BY_ID

Remove a container capture rule by its rule_id dbms_xstream_adm_internal.remove_container_rule_by_id( capture_name IN VARCHAR2, rule_id IN NUMBER);

TBD

REMOVE_GOLDENGATE_PRIVILEGE

Revoke a GoldenGate privilege dbms_xstream_adm_internal.remove_goldengate_privilege( canon_grantee IN VARCHAR2, canon_privilege_type IN NUMBER, canon_privilege_level IN NUMBER);

TBD

UPDATE_XSERVER_CONNECT_USER

Undocumented dbms_xstream_adm_internal.update_xserver_connect_user( canon_server_name IN VARCHAR2, connect_user IN VARCHAR2);

TBD