Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
dbms_propagation_adm.alter_propagation(
propagation_name IN VARCHAR2,
rule_set_name IN VARCHAR2 DEFAULT NULL,
remove_rule_set IN BOOLEAN DEFAULT FALSE,
negative_rule_set_name IN VARCHAR2 DEFAULT NULL,
remove_negative_rule_set IN BOOLEAN DEFAULT FALSE);
Creates a propagation and specifies the source queue, destination queue, and any rule set for the propagation.
A propagation propagates messages in a local source queue to a destination queue. The destination queue might or might not be in the same database as the source queue.
dbms_propagation_adm.create_propagation(
propagation_name IN VARCHAR2,
source_queue IN VARCHAR2,
destination_queue IN VARCHAR2,
destination_dblink IN VARCHAR2 DEFAULT NULL,
rule_set_name IN VARCHAR2 DEFAULT NULL,
negative_rule_set_name IN VARCHAR2 DEFAULT NULL,
queue_to_queue IN BOOLEAN DEFAULT NULL,
-- the following two parameters are ONLY used by the split-merge api
original_propagation_name IN VARCHAR2 DEFAULT NULL,
auto_merge_threshold IN NUMBER DEFAULT NULL);
Drops a propagation and deletes all captured and user-enqueued messages for the destination queue in the source queue. Also removes the schedule for propagation from the source to destination queue.
dbms_propagation_adm.drop_propagation(
propagation_name IN VARCHAR2,
drop_unused_rule_sets IN BOOLEAN DEFAULT FALSE);