| General Information |
| Purpose |
Not documented |
| Source |
{ORACLE_HOME}/rdbms/admin/prvthxstr.plb |
| First Available |
11.2.0.1 |
| Dependencies |
| ANYDATA |
DBMS_STREAMS_ADM_UTL |
| DBA_APPLY |
DBMS_STREAMS_LCR_INT |
| DBA_CAPTURE |
DBMS_SYSTEM |
| DBA_STREAMS_RULES |
DBMS_UTILITY |
| DBA_USERS |
DBMS_XSTREAM_ADM |
| DBA_XSTREAM_ADMINISTRATOR |
DBMS_XSTREAM_AUTH |
| DBA_XSTREAM_INBOUND |
DBMS_XSTREAM_GG_ADM |
| DBA_XSTREAM_INBOUND_PROGRESS |
DBMS_XSTREAM_UTL_IVK |
| DBA_XSTREAM_OUTBOUND |
GLOBAL_NAME |
| DBA_XSTREAM_OUTBOUND_PROGRESS |
GV_$XSTREAM_CAPTURE |
| DBA_XSTREAM_OUT_SUPPORT_MODE |
GV_$XSTREAM_MESSAGE_TRACKING |
| DBA_XSTREAM_RULES |
GV_$XSTREAM_OUTBOUND_SERVER |
| DBMS_APPLY_ADM |
GV_$XSTREAM_TRANSACTION |
| DBMS_APPLY_ADM_INTERNAL |
PROPS$ |
| DBMS_AQADM |
STREAMS$_APPLY_MILESTONE |
| DBMS_ASSERT |
STREAMS$_APPLY_PROCESS |
| DBMS_CAPTURE_ADM |
STREAMS$_CAPTURE_PROCESS |
| DBMS_CAPTURE_ADM_INTERNAL |
XSTREAM$_PRIVILEGES |
| DBMS_LOGREP_LIB |
XSTREAM$_SERVER |
| DBMS_LOGREP_UTIL |
XSTREAM$_SUBSET_RULES |
| DBMS_RULE_ADM |
XSTREAM$_SYSGEN_OBJS |
| DBMS_STREAMS_ADM |
|
|
| Security Model |
Execute is granted to EXECUTE_CATALOG_ROLE role |
| |
ADD_XSTREAM_ADMIN_PRIVILEGE (new in 11.2.0.2)  |
| Undocumented |
dbms_xstream_adm_utl.add_xstream_admin_privilege(grantee IN VARCHAR2, privs_offset IN NUMBER); |
| TBD |
| |
| APPLY_EXISTS |
| Undocumented |
dbms_xstream_adm_utl.apply_exists(
svr_name IN VARCHAR2,
canon_svr_name OUT VARCHAR2)
RETURN BOOLEAN; |
DECLARE
b BOOLEAN;
cname user_tables.table_name%TYPE;
retval VARCHAR2(30);
BEGIN
dbms_utility.canonicalize('zzyzx', cname, 16);
IF dbms_xstream_adm_utl.apply_exists(cname, retval) THEN
dbms_output.put_line('TRUE: ' || retval);
ELSE
dbms_output.put_line('FALSE: ' || retval);
END IF;
END;
/ |
| |
| CHECK_SVR_NAME |
| Undocumented |
dbms_xstream_adm_utl.check_svr_name(
svr_name IN VARCHAR2,
must_exist IN BOOLEAN,
canon_svr_name OUT VARCHAR2,
is_outbound IN BOOLEAN); |
| TBD |
| |
| CHECK_SVR_TYPE |
| Undocumented |
dbms_xstream_adm_utl.check_svr_type(
canon_svr_name IN VARCHAR2,
is_outbound IN BOOLEAN); |
| exec dbms_xstream_adm_utl.check_svr_type('ORA2MS', TRUE); |
| |
| CLEAN_APPLY_SPILL (new in 11.2.0.2) |
| Undocumented |
dbms_xstream_adm_utl.clean_apply_spill(canon_apply_name IN VARCHAR2); |
DECLARE
cname user_tables.table_name%TYPE;
BEGIN
dbms_utility.canonicalize('uwclass.servers', cname, 16);
dbms_xstream_adm_utl.clean_apply_spill(cname);
END;
/ |
| |
| CONVERT_SCN_TO_POS (new in 11.2.0.2) |
| Undocumented |
dbms_xstream_adm_utl.convert_scn_to_pos(scn IN NUMBER, pos OUT RAW); |
set serveroutput on
DECLARE
r RAW(32);
BEGIN
dbms_xstream_adm_utl.convert_scn_to_pos(dbms_asyncrpc_push.get_scn, r);
dbms_output.put_line(r);
END;
/ |
| |
| CREATE_XOUT_CAPTURE (new in 11.2.0.2) |
| Undocumented |
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); |
| TBD |
| |
| DEL_GEN_RULE |
| Undocumented |
dbms_xstream_adm_utl.del_gen_rule(
rule_name IN VARCHAR2,
canon_invoker IN VARCHAR2); |
| TBD |
| |
| DEL_SUBSET_RULES |
| Undocumented |
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); |
| TBD |
| |
| DEL_XSERVER |
| Undocumented |
dbms_xstream_adm_utl.del_xserver(canon_server_name IN VARCHAR2); |
| TBD |
| |
| DROP_GEN_RULE |
| Undocumented |
dbms_xstream_adm_utl.drop_gen_rule(
rule_name IN VARCHAR2,
canon_invoker IN VARCHAR2); |
| TBD |
| |
| DROP_OUTBOUND |
| Undocumented |
dbms_xstream_adm_utl.drop_outbound(
server_name IN VARCHAR2,
canon_invoker IN VARCHAR2); |
| TBD |
| |
| DROP_OUTBOUND_RULES |
| Undocumented |
dbms_xstream_adm_utl.drop_outbound_rules(
canon_svr_name IN VARCHAR2,
canon_invoker IN VARCHAR2); |
| TBD |
| |
| ENABLE_GG_XSTREAM_FOR_STREAMS (new in 11.2.0.2) |
| Undocumented |
dbms_xstream_adm_utl.enable_gg_xstream_for_streams(enable IN BOOLEAN); |
| exec dbms_xstream_adm_utl.enable_gg_xstream_for_streams(TRUE); |
| |
| GET_CAP_N_QUEUE |
| Undocumented |
dbms_xstream_adm_utl.get_cap_n_queue( |
| TBD |
| |
| GET_LOCAL_CAPTURE (new in 11.2.0.2) |
| Undocumented |
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); |
| TBD |
| |
| GET_OUTBOUND_SRCDB |
| Undocumented |
dbms_xstream_adm_utl.get_outbound_srcdb(canon_server IN VARCHAR2) RETURN VARCHAR2; |
| TBD |
| |
| GET_STREAMS_RULES |
| Undocumented |
dbms_xstream_adm_utl.get_streams_rule(...); |
| TBD |
| |
| HAS_TABLE_RULE |
| Undocumented |
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; |
| TBD |
| |
| INS_GEN_OBJ |
| Undocumented |
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); |
| TBD |
| |
| INS_SUBSET_RULES |
| Undocumented |
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); |
| TBD |
| |
| IS_GG_XSTREAM_FOR_STREAMS (new in 11.2.0.2) |
| Undocumented |
dbms_xstream_adm_utl.is_gg_xstream_for_streams RETURN BOOLEAN; |
set serveroutput on
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;
/ |
| |
| IS_SYSGEN_OBJ |
| Undocumented |
dbms_xstream_adm_utl.is_sysgen_obj(
canon_object_owner IN VARCHAR2,
canon_object_name IN VARCHAR2,
object_type IN VARCHAR2)
RETURN BOOLEAN; |
| TBD |
| |
| IS_UNCOMMITTED_XOUT (new in 11.2.0.2) |
| Undocumented |
dbms_xstream_adm_utl.is_uncommitted_xout(server_name IN VARCHAR2) RETURN BOOLEAN; |
set serveroutput on
BEGIN
IF dbms_xstream_adm_utl.is_uncommitted_xout('ZZYZX') THEN
dbms_output.put_line('TRUE');
ELSE
dbms_output.put_line('FALSE');
END IF;
END;
/ |
| |
| NUM_SUBSCRIBERS |
| Returns the number of subscribers on the named queue |
dbms_xstream_adm_utl.num_subscribers(canon_qowner IN VARCHAR2, canon_qname IN VARCHAR2)
RETURN BINARY_INTEGER |
set serveroutput on
DECLARE
i PLS_INTEGER;
BEGIN
i := dbms_xstream_adm_utl.num_subscribers('UWCLASS', 'XQ');
dbms_output.put_line(i);
END;
/ |
| |
| REMOVE_GEN_RULE |
| Undocumented |
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); |
| TBD |
| |
| REMOVE_XSTREAM_ADMIN_PRIVILEGE (new in 11.2.0.2) |
| Undocumented |
dbms_xstream_adm_utl.remove_xstream_admin_privilege(grantee IN VARCHAR2, privs_outset IN NUMBER); |
| TBD |
| |
| SET_APPLY_STARTSCN (new in 11.2.0.2) |
| Undocumented |
dbms_xstream_adm_utl.set_apply_startscn(
canon_apply_name IN VARCHAR2,
canon_start_scn IN NUMBER,
status IN OUT NUMBER); |
| TBD |
| |
| SET_CAPTURE_STARTSCN (new in 11.2.0.2) |
| Undocumented |
dbms_xstream_adm_utl.set_capture_startscn(
canon_srv_name IN VARCHAR2,
canon_start_scn IN NUMBER,
status IN OUT NUMBER,
cap_oldest_scn IN OUT NUMBER); |
| TBD |
| |
| SET_OUTBOUND_STARTSCN (new in 11.2.0.2) |
| Undocumented |
dbms_xstream_adm_utl.set_outbound_startscn(
canon_srv_name IN VARCHAR2,
canon_start_scn IN NUMBER,
status IN OUT NUMBER); |
| TBD |
| |
| START_OUTBOUND (new in 11.2.0.2) |
| Undocumented |
dbms_xstream_adm_utl.start_outbound(canon_server IN VARCHAR2); |
| TBD |
| |
| STOP_OUTBOUND (new in 11.2.0.2) |
| Undocumented |
dbms_xstream_adm_utl.stop_outbound(canon_server IN VARCHAR2, force IN BOOLEAN); |
| TBD |
| |
| UPD_XSERVER |
| Undocumented |
dbms_xstream_adm_utl.upd_xserver(
canon_server_name IN VARCHAR2,
usr_comment IN VARCHAR2); |
| TBD |
| |
| UPD_XSERVER_CAPINFO |
| Undocumented |
dbms_xstream_adm_utl.upd_xserver_capinfo(
canon_server_name IN VARCHAR2,
canon_capture IN VARCHAR2,
canon_cap_srcdb IN VARCHAR2,
comment IN VARCHAR2); |
| TBD |
| |
| VALID_SUBSET_RULES |
| Undocumented |
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; |
| TBD |
