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
Utility package supporting heterogeneous streams replication and GoldenGate
AUTHID
DEFINER
Dependencies
ALL_USERS
DBMS_LOGREP_LIB
DBMS_XSTREAM_GG_ADM
ANYDATA
DBMS_LOGREP_UTIL
DBMS_XSTREAM_UTL_IVK
DBA_APPLY
DBMS_LOGREP_UTIL_INVOK
PROPS$
DBA_CAPTURE
DBMS_RULE_ADM
STREAMS$_APPLY_MILESTONE
DBA_GOLDENGATE_RULES
DBMS_STANDARD
STREAMS$_APPLY_PROCESS
DBA_STREAMS_RULES
DBMS_STREAMS_ADM
STREAMS$_CAPTURE_PROCESS
DBA_XSTREAM_RULES
DBMS_STREAMS_ADM_UTL
STREAMS$_CAPTURE_SERVER
DBMS_APPLY_ADM
DBMS_STREAMS_DECL
XSTREAM$_PRIVILEGES
DBMS_APPLY_ADM_INTERNAL
DBMS_STREAMS_LCR_INT
XSTREAM$_SERVER
DBMS_AQADM
DBMS_SYSTEM
XSTREAM$_SUBSET_RULES
DBMS_ASSERT
DBMS_UTILITY
XSTREAM$_SYSGEN_OBJS
DBMS_CAPTURE_ADM
DBMS_XSTREAM_ADM
_DBA_GGXSTREAM_INBOUND
DBMS_CAPTURE_ADM_INTERNAL
DBMS_XSTREAM_AUTH
_DBA_GGXSTREAM_OUTBOUND
DBMS_CAPTURE_ADM_IVK
DBMS_XSTREAM_AUTH_IVK
Documented
No
First Available
11.2
Security Model
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role.
dbms_xstream_adm_utl.alter_outbound(
canon_svr_name IN VARCHAR2
canon_capture IN VARCHAR2
canon_invoker IN VARCHAR2
oldest_scn IN BINARY_INTEGER
processed_lwm_scn IN BINARY_INTEGER
flags IN BINARY_INTEGER);
dbms_xstream_adm_utl.create_xout_capture(
queue_name IN VARCHAR2,
canon_capture IN VARCHAR2,
canon_invoker IN VARCHAR2,
source_database IN VARCHAR2,
capture_user IN VARCHAR2,
enable_procedure IN BOOLEAN,
source_root_name IN VARCHAR2);
dbms_xstream_adm_utl.del_subset_rules(
canon_server_name IN VARCHAR2,
canon_ins_rule IN VARCHAR2,
canon_upd_rule IN VARCHAR2,
canon_del_rule IN VARCHAR2,
canon_rules_owner IN VARCHAR2);
dbms_xstream_adm_utl.get_cap_n_queue(
canon_server_name IN VARCHAR2,
canon_capture OUT VARCHAR2,
canon_cap_src_db OUT VARCHAR2,
canon_cap_src_root OUT VARCHAR2,
canon_queue_owner OUT VARCHAR2,
canon_queue_name OUT VARCHAR2,
is_outbound IN BOOLEAN);
dbms_xstream_adm_utl.get_local_capture(
canon_qowner IN VARCHAR2,
canon_qname IN VARCHAR2,
canon_capture IN OUT VARCHAR2,
canon_cap_src_db IN OUT VARCHAR2);
dbms_xstream_adm_utl.get_procedure_rules(
canon_strms_name IN VARCHAR2,
streams_type IN VARCHAR2,
inclusion_rule IN BOOLEAN,
rule_list_out OUT dbms_utility.uncl_array,
rule_cnt OUT NUMBER);
dbms_xstream_adm_utl.get_streams_rule(
canon_strms_name IN VARCHAR2,
streams_type IN VARCHAR2,
table_cnt IN NUMBER,
canon_tab_owners IN dbms_utility.name_array,
canon_tab_names IN dbms_utility.name_array,
schema_cnt IN NUMBER,
canon_schemas IN dbms_utility.name_array,
inclusion_rule IN BOOLEAN,
rule_list OUT dbms_utility.uncl_array,
rule_cnt OUT NUMBER,
include_dml IN BOOLEAN,
include_ddl IN BOOLEAN,
source_db IN VARCHAR2,
source_root IN VARCHAR2);
dbms_xstream_adm_utl.has_table_rule(
canon_table_owner IN VARCHAR2,
canon_table_name IN VARCHAR2,
canon_strm_name IN VARCHAR2,
streams_type IN VARCHAR2)
RETURN BOOLEAN;
dbms_xstream_adm_utl.ins_gen_obj(
canon_server_name IN VARCHAR2,
canon_object_owner IN VARCHAR2,
canon_object_name IN VARCHAR2,
object_type IN VARCHAR2);
dbms_xstream_adm_utl.ins_subset_rules(
canon_server_name IN VARCHAR2,
ins_rule IN VARCHAR2,
upd_rule IN VARCHAR2,
del_rule IN VARCHAR2,
canon_invoker IN VARCHAR2);
DECLARE
b BOOLEAN;
BEGIN
IF dbms_xstream_adm_utl.is_gg_xstream_for_streams THEN
dbms_output.put_line('TRUE');
ELSE
dbms_output.put_line('FALSE');
END IF;
END;
/
dbms_xstream_adm_utl.remove_gen_rule(
rule_name IN VARCHAR2,
streams_type IN VARCHAR2,
streams_name IN VARCHAR2,
canon_invoker IN VARCHAR2,
inclusion_rule IN BOOLEAN);
dbms_xstream_adm_utl.valid_subset_rules(
canon_svr_name IN VARCHAR2,
canon_ins_rule IN VARCHAR2,
canon_upd_rule IN VARCHAR2,
canon_del_rule IN VARCHAR2,
canon_rules_owner IN VARCHAR2)
RETURN BOOLEAN;