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.
Purpose
Provides programs for starting, stopping, and configuring the Streams capture process. The source of the captured changes is the redo logs, and the repository for the captured changes is a queue.
dbms_capture_adm.alter_capture(
capture_name IN VARCHAR2,
rule_set_name IN VARCHAR2 DEFAULT NULL,
remove_rule_set IN BOOLEAN DEFAULT FALSE,
start_scn IN NUMBER DEFAULT NULL,
use_database_link IN BOOLEAN DEFAULT NULL,
first_scn IN NUMBER DEFAULT NULL,
negative_rule_set_name IN VARCHAR2 DEFAULT NULL,
remove_negative_rule_set IN BOOLEAN DEFAULT FALSE,
capture_user IN VARCHAR2 DEFAULT NULL,
checkpoint_retention_time IN NUMBER DEFAULT NULL,
start_time IN TIMESTAMP DEFAULT NULL,
oldest_scn IN NUMBER DEFAULT NULL);
Extracts the data dictionary of the current database to the redo logs and automatically specifies database supplemental logging for all primary key and unique key columns
Overload 1
dbms_capture_adm.build;
exec dbms_capture_adm.build;
Overload 2
dbms_capture_adm.build(first_scn OUT NUMBER);
-- database must be in archivelog mode
set serveroutput on
DECLARE
scnout NUMBER;
BEGIN
dbms_capture_adm.build(scnout);
dbms_output.put_line(scnout);
END;
/
dbms_capture_adm.create_capture(
queue_name IN VARCHAR2,
capture_name IN VARCHAR2,
rule_set_name IN VARCHAR2 DEFAULT NULL,
start_scn IN NUMBER DEFAULT NULL,
source_database IN VARCHAR2 DEFAULT NULL,
use_database_link IN BOOLEAN DEFAULT FALSE,
first_scn IN NUMBER DEFAULT NULL,
logfile_assignment IN VARCHAR2 DEFAULT 'IMPLICIT',
negative_rule_set_name IN VARCHAR2 DEFAULT NULL,
capture_user IN VARCHAR2 DEFAULT NULL,
checkpoint_retention_time IN NUMBER DEFAULT 60,
start_time IN TIMESTAMP DEFAULT NULL,
source_root_name IN VARCHAR2 DEFAULT NULL,
capture_class IN VARCHAR2 DEFAULT 'streams');
Creates sync capture process. If the specified capture_name is already in use an exception is raised.
dbms_capture_adm.create_sync_capture(
queue_name IN VARCHAR2,
capture_name IN VARCHAR2,
rule_set_name IN VARCHAR2,
capture_user IN VARCHAR2 DEFAULT NULL);
Performs the synchronization necessary for instantiating all the tables in the database at another database and can enable supplemental logging for key columns or all columns in these tables
dbms_capture_adm.prepare_global_instantiation(
supplemental_logging IN VARCHAR2 DEFAULT 'KEYS',
container
IN VARCHAR2 DEFAULT 'CURRENT');
SELECT supplemental_log_data_min, supplemental_log_data_pk, supplemental_log_data_ui
FROM v$database;
Performs the synchronization necessary for instantiating all tables in the schema at another database and can enable supplemental logging
dbms_capture_adm.prepare_schema_instantiation(
schema_name IN VARCHAR2,
supplemental_logging IN VARCHAR2 DEFAULT 'KEYS',
container IN VARCHAR2 DEFAULT 'CURRENT');
Performs the synchronization necessary for instantiating the table at another database and can enable supplemental logging for key columns or all columns in the table
dbms_capture_adm.prepare_table_instantiation(
table_name IN VARCHAR2,
supplemental_logging IN VARCHAR2 DEFAULT 'KEYS',
container IN VARCHAR2 DEFAULT 'CURRENT');