All Replication Configuration Views

The types of replication include Streams, Change Data Capture (CDC), Advanced Queuing (AQ) and Advanced Replication.

STREAMS CONFIGURATION VIEWS - ADMINISTRATIVE
DBA_STREAMS_ADMINISTRATOR
DBA_STREAMS_NEWLY_SUPPORTED
DBA_STREAMS_UNSUPPORTED
DBA_STREAMS_MESSAGE_CONSUMERS
DBA_STREAMS_MESSAGE_RULES
DBA_STREAMS_ADD_COLUMN (New from 10.2)
DBA_STREAMS_DELETE_COLUMN (New from 10.2)
DBA_STREAMS_RENAME_COLUMN (New from 10.2)
DBA_STREAMS_RENAME_SCHEMA (New from 10.2)
DBA_STREAMS_RENAME_TABLE (New from 10.2)
DBA_HIST_BUFFERED_QUEUES (New from 10.2)
DBA_HIST_BUFFERED_SUBSCRIBERS (New from 10.2)
DBA_HIST_STREAMS_POOL_ADVICE (New from 10.2)
V$STREAMS_POOL_ADVICE
V$STREAMS_TRANSACTION

STREAMS CONFIGURATION VIEWS - CAPTURE
DBA_CAPTURE
DBA_CAPTURE_PARAMETERS
DBA_CAPTURE_EXTRA_ATTRIBUTES
DBA_HIST_STREAMS_CAPTURE (New from 10.2)
V$STREAMS_CAPTURE

STREAMS CONFIGURATION VIEWS - APPLY
DBA_APPLY
DBA_APPLY_PARAMETERS
DBA_APPLY_ENQUEUE
DBA_APPLY_ERROR
DBA_APPLY_EXECUTE
DBA_APPLY_PROGRESS
DBA_APPLY_SPILL_TXN
DBA_APPLY_KEY_COLUMNS
DBA_APPLY_TABLE_COLUMNS
DBA_APPLY_OBJECT_DEPENDENCIES (New from 10.2)
DBA_APPLY_VALUE_DEPENDENCIES (New from 10.2)
DBA_HIST_STREAMS_APPLY_SUM (New from 10.2)
V$STREAMS_APPLY_COORDINATOR
V$STREAMS_APPLY_READER
V$STREAMS_APPLY_SERVER

STREAMS CONFIGURATION VIEWS - PROPAGATION
DBA_PROPAGATION
DBA_QUEUE_SCHEDULES
V$PROPAGATION_RECEIVER
V$PROPAGATION_SENDER

STREAMS CONFIGURATION VIEWS - RULES
DBA_RULES
DBA_RULE_SETS
DBA_RULE_SET_RULES
DBA_STREAMS_RULES
DBA_STREAMS_GLOBAL_RULES
DBA_STREAMS_SCHEMA_RULES
DBA_STREAMS_TABLE_RULES
DBA_EVALUATION_CONTEXTS
DBA_EVALUATION_CONTEXT_TABLES
DBA_EVALUATION_CONTEXT_VARS
V$RULE
V$RULE_SET
V$RULE_SET_AGGREGATE_STATS

STREAMS CONFIGURATION VIEWS - INSTANTIATION
DBA_CAPTURE_PREPARED_DATABASE
DBA_CAPTURE_PREPARED_SCHEMAS
DBA_CAPTURE_PREPARED_TABLES
DBA_APPLY_INSTANTIATED_GLOBAL
DBA_APPLY_INSTANTIATED_OBJECTS
DBA_APPLY_INSTANTIATED_SCHEMAS

STREAMS CONFIGURATION VIEWS - SUPPLEMENTAL LOGGING
DBA_LOG_GROUPS
DBA_LOG_GROUP_COLUMNS
DBA_CAPTURE_PREPARED_TABLES
DBA_CAPTURE_PREPARED_SCHEMAS
DBA_CAPTURE_PREPARED_DATABASE
V$DATABASE (columns FORCE_LOGGING SUPPLEMENTAL_LOG_DATA_*)

STREAMS CONFIGURATION VIEWS - HANDLERS
DBA_APPLY_DML_HANDLERS (For DML Handler)
DBA_APPLY (For DDL Handler column DDL_HANDLER)

STREAMS CONFIGURATION VIEWS - CONFLICT HANDLERS
DBA_APPLY_CONFLICT_COLUMNS
DBA_APPLY_TABLE_COLUMNS

STREAMS CONFIGURATION VIEWS - TRANSFORMATION
DBA_TRANSFORMATIONS
DBA_STREAMS_TRANSFORM_FUNCTION
DBA_STREAMS_TRANSFORMATIONS (New from 10.2)

STREAMS CONFIGURATION VIEWS - LOGMINER
DBA_LOGMNR_LOG
DBA_LOGMNR_PURGED_LOG
DBA_LOGMNR_SESSION
V$LOGMNR_CONTENTS
V$LOGMNR_DICTIONARY
V$LOGMNR_LOGS
V$LOGMNR_PARAMETERS
V$LOGMNR_DICTIONARY_LOAD (New from 10.2)
V$LOGMNR_LATCH (New from 10.2)
V$LOGMNR_PROCESS (New from 10.2)
V$LOGMNR_SESSION (New from 10.2)
V$LOGMNR_STATS (New from 10.2)

STREAMS CONFIGURATION VIEWS - FLASHBACK QUERY
FLASHBACK_TRANSACTION_QUERY

STREAMS CONFIGURATION VIEWS - DBLINK
DBA_DB_LINKS
V$DBLINK

STREAMS CONFIGURATION VIEWS - JOBS
DBA_JOBS
DBA_JOBS_RUNNING
V$SCHEDULER_RUNNING_JOBS (New from 10.2)

STREAMS CONFIGURATION VIEWS - ARCHIVE LOG/REDO LOG FILES
DBA_REGISTERED_ARCHIVED_LOG
V$ARCHIVED_LOG
V$LOG
V$LOGFILE
V$LOGHIST

STREAMS CONFIGURATION VIEWS - TRANSACTIONS
V$TRANSACTION
V$GLOBAL_TRANSACTION
V$TRANSACTION_ENQUEUE
V$STREAMS_TRANSACTION (New from 10.2)

CHANGE DATA CAPTURE (CDC) CONFIGURATION VIEWS
CHANGE_PROPAGATIONS
CHANGE_PROPAGATION_SETS
CHANGE_SETS
CHANGE_SOURCES
CHANGE_TABLES
DBA_SOURCE_TABLES
DBA_SOURCE_TAB_COLUMNS
DBA_PUBLISHED_COLUMNNS
DBA_SUBSCRIPTIONS
DBA_SUBSCRIBED_TABLES
DBA_SUBSCRIBED_COLUMNS

ADVANCED QUEUING (AQ) CONFIGURATION VIEWS - ENQUEUE AND DEQUEUE
aq$

ADVANCED QUEUING (AQ) CONFIGURATION VIEWS - QUEUE
DBA_QUEUES
DBA_QUEUE_SUBSCRIBERS
DBA_QUEUE_PUBLISHERS
QUEUE_PRIVILEGES
V$QUEUE
V$AQ


ADVANCED QUEUING (AQ) CONFIGURATION VIEWS - QUEUE TABLE
DBA_QUEUE_TABLES

ADVANCED QUEUING (AQ) CONFIGURATION VIEWS - MESSAGING
DBA_AQ_AGENTS
DBA_AQ_AGENT_PRIVS

ADVANCED REPLICATION CONFIGURATION VIEWS
DBA_REPCATLOG
DBA_REPCAT_REFRESH_TEMPLATES
DBA_REPCAT_TEMPLATE_OBJECTS
DBA_REPCAT_TEMPLATE_PARMS
DBA_REPCAT_TEMPLATE_SITES
DBA_REPCAT_USER_AUTHORIZATIONS
DBA_REPCAT_USER_PARM_VALUES
DBA_REPCOLUMN
DBA_REPCOLUMN_GROUP
DBA_REPCONFLICT
DBA_REPDDL
DBA_REPGENOBJECTS
DBA_REPGROUP
DBA_REPGROUPED_COLUMN
DBA_REPGROUP_PRIVILEGES
DBA_REPKEY_COLUMNS
DBA_REPOBJECT
DBA_REPPARAMETER_COLUMN
DBA_REPPRIORITY
DBA_REPPRIORITY_GROUP
DBA_REPPROP
DBA_REPRESOLUTION
DBA_REPRESOLUTION_METHOD
DBA_REPRESOLUTION_STATISTICS
DBA_REPRESOL_STATS_CONTROL
DBA_REPSITES
DBA_REPSITES_NEW
DBA_RGROUP
V$REPLPROP
V$REPLQUEUE

Oracle data dictionary views

Oracle dynamic performance views

DBA_PUBLISHED_COLUMNS

DBA_PUBLISHED_COLUMNS describes all source table columns in the database which have been published for the source tables. This view is intended for use by Change Data Capture publishers.

Related View

USER_PUBLISHED_COLUMNS describes the source table columns owned by the current user which have been published for the source tables. This view does not display the CHANGE_TABLE_SCHEMA or CHANGE_TABLE_NAME columns.

Column	Datatype	NULL	Description
CHANGE_SET_NAME	VARCHAR2(30)	NOT NULL	Name of the change set
CHANGE_TABLE_SCHEMA	VARCHAR2(30)	NOT NULL	Associated change table owner
CHANGE_TABLE_NAME	VARCHAR2(30)	NOT NULL	Associated change table name
PUB_ID	NUMBER	NOT NULL	Publication identifier
SOURCE_SCHEMA_NAME	VARCHAR2(30)	NOT NULL	Table owner in the source database
SOURCE_TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name in the source database
COLUMN_NAME	VARCHAR2(30)	NOT NULL	Column name
DATA_TYPE	VARCHAR2(106)		Column datatype
DATA_LENGTH	NUMBER	NOT NULL	Column length (in bytes)
DATA_PRECISION	NUMBER		Decimal precision for NUMBER datatypes; binary precision for FLOAT datatypes; NULL for all other datatypes
DATA_SCALE	NUMBER		Digits to the right of a decimal point in a number
NULLABLE	VARCHAR2(1)		Indicates whether NULLs are allowed (Y) or not (N)

Oracle data dictionary views

Oracle dynamic performance views

DBA_INVALID_OBJECTS

1. DBA_INVALID_OBJECTS is new in 11g.

2. Run utlrp.sql to recompile any remaining stored PL/SQL and Java code, and the invalid objects are stored in DBA_INVALID_OBJECTS.

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

Verify that all expected packages and classes are valid:

SQL> SELECT count(*) FROM dba_invalid_objects;

SQL> SELECT distinct object_name FROM dba_invalid_objects;

The DBA_INVALID_OBJECTS is defined with query:

select "OWNER", "OBJECT_NAME", "SUBOBJECT_NAME", "OBJECT_ID", "DATA_OBJECT_ID",

"OBJECT_TYPE", "CREATED", "LAST_DDL_TIME", "TIMESTAMP", "STATUS",

"TEMPORARY", "GENERATED", "SECONDARY", "NAMESPACE", "EDITION_NAME"

from DBA_OBJECTS

where STATUS = 'INVALID' and

(OBJECT_TYPE != 'TYPE' or

(OBJECT_TYPE='TYPE' and SUBOBJECT_NAME is null))

Oracle data dictionary views

Oracle dynamic performance views