Search Results add_subset_rules

Overview

SYS.DBMS_XSTREAM_ADM is the Oracle-supplied administrative package that configures and maintains Oracle Streams / XStream replication components within the database. In Oracle EBS 12.1.1 and 12.2.2 environments, this package underpins the data replication infrastructure used for advanced deployment topologies such as read-only snapshots, multi-node configurations, and integrations requiring change data capture between source and target databases. The package is defined with AUTHID CURRENT_USER, meaning that procedures execute with the privileges of the invoking user rather than the package owner, which has direct implications for grants and execution under the APPS schema.

The package exposes a series of constants used to reset configuration state, including RESET_PARAMETERS, RESET_HANDLERS, RESET_PROGRESS, and RESET_ALL, as well as tracing constants action_trace and action_memory. These control how Streams metadata is cleaned up or traced when components are altered or dropped, including the queue infrastructure referenced by administrative routines such as remove_queue operations.

Key Procedures and Functions

The documented API surface consists of 57 procedures and functions grouped into outbound, inbound, rule, propagation, and maintenance categories.

• Outbound server management: CREATE_OUTBOUND creates an outbound server plus the necessary queue and capture; ALTER_OUTBOUND modifies it; ADD_OUTBOUND and DROP_OUTBOUND attach or remove an outbound server.
• Subset rules: ADD_SUBSET_OUTBOUND_RULES and REMOVE_SUBSET_OUTBOUND_RULES add or remove subsetting rules for an outbound server.
• Inbound server management: CREATE_INBOUND, ALTER_INBOUND, and DROP_INBOUND manage inbound servers.
• GoldenGate interoperability: ENABLE_GG_XSTREAM_FOR_STREAMS and IS_GG_XSTREAM_FOR_STREAMS configure and query GoldenGate XStream support.
• Rule creation: ADD_GLOBAL_RULES, ADD_SCHEMA_RULES, ADD_TABLE_RULES, and ADD_SUBSET_RULES attach rules to captures or apply processes.
• Propagation rules: ADD_SUBSET_PROPAGATION_RULES, ADD_TABLE_PROPAGATION_RULES, ADD_SCHEMA_PROPAGATION_RULES, and ADD_GLOBAL_PROPAGATION_RULES define how changes propagate to queues.
• Catalog maintenance: PURGE_SOURCE_CATALOG removes obsolete source catalog entries.

Tables Accessed

The ETRM metadata does not record any tables referenced by this package through APPS synonyms, which is expected because DBMS_XSTREAM_ADM operates almost entirely on SYS-owned Streams dictionary views and internal queue tables rather than on EBS application tables. It reads and writes Streams metadata objects such as capture, propagation, apply, and rule definitions, and manipulates the underlying Advanced Queuing queue tables (for example, those behind an outbound server) when servers are created, altered, or dropped. Queue removal operations invoked through this API therefore affect SYS-managed AQ tables and Streams catalog entries rather than EBS business data.

Usage Notes

DBMS_XSTREAM_ADM is invoked from SQL*Plus or custom PL/SQL during the setup and teardown of Streams/XStream replication in EBS environments, and it is referenced by seven other packages documented in ETRM. Because of its AUTHID CURRENT_USER definition, execution requires that the calling schema have the necessary privileges on underlying Streams objects, and in EBS contexts it is typically run by a DBA account rather than directly by APPS.

It is not called from standard EBS forms or concurrent programs. Administrative operations that remove queue infrastructure—the area associated with searches for "remove_queue"—are logically tied to the DROP_OUTBOUND, DROP_INBOUND, and reset procedures of this package, since dropping a server removes its associated queue. Customers using Streams-based EBS configurations should confirm component state before invoking these destructive routines, as removal of queues and capture objects interrupts replication until recreated.