| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsxstr.sql |
| First Available |
11.2 |
Constants  |
| Name |
Data Type |
Value |
| RESET_PARAMETERS |
BINARY_INTEGER |
1 |
| RESET_HANDLERS |
BINARY_INTEGER |
2 |
| RESET_ALL |
NUMBER |
2147483647 |
|
| Dependencies |
| DBA_APPLY |
DBMS_RULE_ADM |
| DBA_CAPTURE |
DBMS_STREAMS_ADM |
| DBA_XSTREAM_OUTBOUND |
DBMS_STREAMS_ADM_UTL |
| DBA_XSTREAM_RULES |
DBMS_STREAMS_DECL |
| DBMS_APPLY_ADM |
DBMS_UTILITY |
| DBMS_APPLY_ADM_INTERNAL |
DBMS_XSTREAM_ADM_UTL |
| DBMS_CAPTURE_ADM |
GLOBAL_NAME |
| DBMS_LOGREP_UTIL |
PLITBLM |
| DBMS_LOGREP_UTIL_INVOK |
|
|
| Security Model |
Execute is granted to EXECUTE_CATALOG_ROLE role |
| |
| ADD_OUTBOUND (new 11.2.0.2 parameter) |
Creates an Oracle XStream outbound server that dequeues logical change records (LCRs) from the specified queue
Overload 1 |
dbms_xstream_adm.add_outbound(
server_name IN VARCHAR2,
queue_name IN VARCHAR2 DEFAULT NULL,
source_database IN VARCHAR2 DEFAULT NULL,
table_names IN DBMS_UTILITY.UNCL_ARRAY,
schema_names IN DBMS_UTILITY.UNCL_ARRAY,
connect_user IN VARCHAR2 DEFAULT NULL,
comment IN VARCHAR2 DEFAULT NULL,
capture_name IN VARCHAR2 DEFAULT NULL,
start_scn IN NUMBER DEFAULT NULL,
start_time IN TIMESTAMP DEFAULT NULL); |
| TBD |
| Overload 2 |
dbms_xstream_adm.add_outbound(
server_name IN VARCHAR2,
queue_name IN VARCHAR2,
source_database IN VARCHAR2 DEFAULT NULL,
table_names IN VARCHAR2 DEFAULT NULL,
schema_names IN VARCHAR2 DEFAULT NULL,
connect_user IN VARCHAR2 DEFAULT NULL,
comment IN VARCHAR2 DEFAULT NULL,
capture_name IN VARCHAR2 DEFAULT NULL,
start_scn IN NUMBER DEFAULT NULL,
start_time IN TIMESTAMP DEFAULT NULL); |
| TBD |
| |
| ADD_SUBSET_OUTBOUND_RULES |
Adds subset rules to an outbound server configuration
Overload 1 |
dbms_xstream_adm.add_subset_outbound_rules(
server_name IN VARCHAR2,
table_name IN VARCHAR2,
condition IN VARCHAR2 DEFAULT NULL,
column_list IN DBMS_UTILITY.LNAME_ARRAY,
keep IN BOOLEAN DEFAULT TRUE); |
SELECT rule_owner, subsetting_operation, rule_name
FROM dba_xstream_rules
WHERE subsetting_operation IS NOT NULL; |
| Overload 2 |
dbms_xstream_adm.add_subset_outbound_rules(
server_name IN VARCHAR2,
table_name IN VARCHAR2,
condition IN VARCHAR2 DEFAULT NULL,
column_list IN VARCHAR2 DEFAULT NULL,
keep IN BOOLEAN DEFAULT TRUE); |
SELECT rule_owner, subsetting_operation, rule_name
FROM dba_xstream_rules
WHERE subsetting_operation IS NOT NULL; |
| |
| ALTER_INBOUND |
| Modifies an Oracle XStream inbound server |
dbms_xstream_adm.alter_inbound(
server_name IN VARCHAR2,
apply_user IN VARCHAR2 DEFAULT NULL,
comment IN VARCHAR2 DEFAULT NULL); |
| TBD |
| |
| ALTER_OUTBOUND (new 11.2.0.2 parameter) |
Modifies an Oracle XStream outbound server
Overload 1 |
dbms_xstream_adm.alter_outbound(
server_name IN VARCHAR2,
table_names IN DBMS_UTILITY.UNCL_ARRAY,
schema_names IN DBMS_UTILITY.UNCL_ARRAY,
add IN BOOLEAN DEFAULT TRUE,
capture_user IN VARCHAR2 DEFAULT NULL,
connect_user IN VARCHAR2 DEFAULT NULL,
comment IN VARCHAR2 DEFAULT NULL,
inclusion_rule IN BOOLEAN DEFAULT TRUE,
start_scn IN NUMBER DEFAULT NULL,
start_time IN TIMESTAMP DEFAULT NULL); |
| TBD |
| Overload 2 |
dbms_xstream_adm.alter_outbound(
server_name IN VARCHAR2,
table_names IN VARCHAR2 DEFAULT NULL,
schema_names IN VARCHAR2 DEFAULT NULL,
add IN BOOLEAN DEFAULT TRUE,
capture_user IN VARCHAR2 DEFAULT NULL,
connect_user IN VARCHAR2 DEFAULT NULL,
comment IN VARCHAR2 DEFAULT NULL,
inclusion_rule IN BOOLEAN DEFAULT TRUE,
start_scn IN NUMBER DEFAULT NULL,
start_time IN TIMESTAMP DEFAULT NULL); |
| TBD |
| |
| CREATE_INBOUND |
| Creates an Oracle XStream inbound server and its queue |
dbms_xstream_adm.create_inbound(
server_name IN VARCHAR2,
queue_name IN VARCHAR2,
apply_user IN VARCHAR2 DEFAULT NULL,
comment IN VARCHAR2 DEFAULT NULL); |
| TBD |
| |
| CREATE_OUTBOUND |
Creates an Oracle XStream outbound server, queue, and capture process to enable client
applications to stream out Oracle database changes encapsulated in logical change records (LCRs)
Overload 1 |
dbms_xstream_adm.create_outbound(
server_name IN VARCHAR2,
source_database IN VARCHAR2 DEFAULT NULL,
table_names IN VARCHAR2 DEFAULT NULL,
schema_names IN VARCHAR2 DEFAULT NULL,
capture_user IN VARCHAR2 DEFAULT NULL,
connect_user IN VARCHAR2 DEFAULT NULL,
comment IN VARCHAR2 DEFAULT NULL); |
| TBD |
| Overload 2 |
dbms_xstream_adm.create_outbound(
server_name IN VARCHAR2,
source_database IN VARCHAR2 DEFAULT NULL,
table_names IN DBMS_UTILITY.UNCL_ARRAY,
schema_names IN DBMS_UTILITY.UNCL_ARRAY,
capture_user IN VARCHAR2 DEFAULT NULL,
connect_user IN VARCHAR2 DEFAULT NULL,
comment IN VARCHAR2 DEFAULT NULL); |
| TBD |
| |
| DROP_INBOUND |
| Removes an inbound server configuration |
dbms_xstream_adm.drop_inbound(server_name IN VARCHAR2); |
| TBD |
| |
| DROP_OUTBOUND |
| Removes an outbound server configuration |
dbms_xstream_adm.drop_outbound(server_name IN VARCHAR2); |
| TBD |
| |
| ENABLE_GG_XSTREAM_FOR_STREAMS |
| Undocumented |
dbms_xstream_adm.enable_gg_xstream_for_streams(enable IN BOOLEAN DEFAULT TRUE); |
| exec dbms_xstream_adm.enable_gg_xstream_for_streams(FALSE); |
| |
| IS_GG_XSTREAM |
| Returns TRUE if the transaction is Golden Gate |
dbms_xstream_adm.is_gg_xstream_for_streams RETURN BOOLEAN; |
set serveroutput on
BEGIN
IF dbms_xstream_adm.is_gg_xstream_for_streams THEN
dbms_output.put_line('TRUE');
ELSE
dbms_output.put_line('FALSE');
END IF;
END;
/ |
| |
| REMOVE_SUBSET_OUTBOUND_RULES |
| Removes subset rules from an outbound server configuration |
dbms_xstream_adm.remove_subset_outbound_rules(
server_name IN VARCHAR2,
insert_rule_name IN VARCHAR2,
update_rule_name IN VARCHAR2,
delete_rule_name IN VARCHAR2); |
SELECT rule_owner, subsetting_operation, rule_name
FROM dba_xstream_rules
WHERE subsetting_operation IS NOT NULL; |
