Index

A  B  C  D  E  F  G  H  I  L  M  N  O  P  Q  R  S  T  U  V  X 

A

ABORT_GLOBAL_INSTANTIATION procedure, 8.2.5
ABORT_SCHEMA_INSTANTIATION procedure, 8.2.5
ABORT_SYNC_INSTANTIATION procedure, 8.2.5
ABORT_TABLE_INSTANTIATION procedure, 8.2.5
ADD SUPPLEMENTAL LOG, 1.3.6.2
ADD SUPPLEMENTAL LOG DATA, 1.3.6.3
ADD SUPPLEMENTAL LOG DATA clause of ALTER DATABASE, 1.3.6.5
ADD SUPPLEMENTAL LOG GROUP clause of ALTER TABLE
conditional log groups, 1.3.6.3
unconditional log groups, 1.3.6.2
alert log
Streams best practices, 15.2.6
ALTER DATABASE statement
ADD SUPPLEMENTAL LOG DATA clause, 1.3.6.5
DROP SUPPLEMENTAL LOG DATA clause, 1.3.6.6
ALTER TABLE statement
ADD SUPPLEMENTAL LOG DATA clause
conditional log groups, 1.3.6.3
unconditional log groups, 1.3.6.2
ADD SUPPLEMENTAL LOG GROUP clause
conditional log groups, 1.3.6.3
unconditional log groups, 1.3.6.2
DROP SUPPLEMENTAL LOG GROUP clause, 1.3.6.4
ALTER_APPLY procedure
removing the tag value, 10.6.2.2
setting the tag value, 10.1, 10.4, 10.6.2.1
ANYDATA data type
queues
creating, 6.1
apply process
apply handlers, 1.2.5
apply user
best practices, 18.1.1
best practices
configuration, 18.2
operation, 18.3
conflict resolution, 9
creating, 7.1
data types applied
heterogeneous environments, 11.1.2.2
DML changes
heterogeneous environments, 11.1.2.3
DML handlers
heterogeneous environments, 11.1.2.1.5
error handlers
heterogeneous, 11.1.2.1.7
errors
best practices, 18.2.2, 18.3.1
heterogeneous environments, 11.1.2, 11.2.3
database links, 11.1.2.1.1
Oracle Database Gateways, 11.1.2.1.1
LOBs, 14.4.1
message handlers
heterogeneous environments, 11.1.2.1.6
oldest SCN
point-in-time recovery, 12.6.3
parallelism
best practices, 18.2.1
substitute key columns
heterogeneous environments, 11.1.2.1.3, 11.1.2.1.4, 11.1.2.1.5, 11.1.2.1.6, 11.1.2.1.7
tags, 10.4
monitoring, 10.7.2
removing, 10.6.2.2
setting, 10.6.2.1
update conflict handlers
monitoring, 9.8.2
ARCHIVELOG mode, 1.3.3
capture process, 5.1.1

B

backups
online
Streams, 10.3
Streams best practices, 15.2.4
batch processing
capture process best practices, 16.2.3
best practices
Streams replication, 14.5
alert log, 15.2.6
apply, 18
apply errors, 18.2.2, 18.3.1
apply process configuration, 18.2
apply process operation, 18.3
apply process parallelism, 18.2.1
apply user, 18.1.1
archive log threads, 15.3.1
automate configuration, 15.1.2
backups, 15.2.4
batch processing, 16.2.3
capture, 16
capture process’s queue, 15.2.3
capture process configuration, 16.1
capture process operation, 16.2
capture process parallelism, 16.1.2
capture user, 16.1.1
checkpoint retention, 16.1.3
conflict resolution, 18.1.3
data dictionary build, 16.2.2
database configuration, 15.1
database operation, 15.2
DDL replication, 1.2.6
destination database, 18.1
global name, 15.2.1
heartbeat table, 16.2.1
instantiation SCN, 18.1.2
Oracle Real Application Clusters (Oracle RAC) databases, 15.3
performance, 15.2.2
prepare for instantiation, 16.2.2
propagation, 17
propagation latency, 17.1.2
queue-to-queue propagation, 17.1.1
removing, 15.2.7
restarting propagation, 17.2.1
SDU, 17.1.3
statistics collection, 15.2.5
synchronous capture configuration, 16.3
bi-directional replication, 1.2.3, 1.2.7

C

capture process
ARCHIVELOG mode, 5.1.1
best practices
batch processing, 16.2.3
configuration, 16.1
data dictionary build, 16.2.2
operation, 16.2
prepare for instantiation, 16.2.2
capture user
best practices, 16.1.1
configuring, 5
creating, 5.1
DBID, 5.1
changing, 12.4
downstream capture, 1.2.2, 2.2.2.1
creating, 5.1
global name, 5.1
changing, 12.4
heterogeneous environments, 11.1.1
local capture, 1.2.2, 2.2.2.1
log sequence number
resetting, 12.6.1
parallelism
best practices, 16.1.2
parameters
merge_threshold, 12.3.2.1
message_tracking_frequency, 12.2
split_threshold, 12.3.2.1
preparing for, 5.1.1
supplemental logging, 1.3.6, 8.2.3
change cycling
avoidance
tags, 10.5
checkpoint retention
best practices, 16.1.3
column lists, 9.6.1.2
COMPARE function, 13.5
perform_row_dif parameter, 13.5.2
COMPARE_OLD_VALUES procedure, 9.4.1, 9.7.4
comparing database objects, 13.5
COMPATIBLE initialization parameter, 1.3.4
conflict resolution, 9
best practices, 18.1.3
column lists, 9.6.1.2
conflict handlers, 9.3, 9.4, 9.5, 9.6
custom, 9.6.2
modifying, 9.7.2
prebuilt, 9.6.1
removing, 9.7.3
setting, 9.7.1
data convergence, 9.6.1.4
DISCARD handler, 9.6.1.1.2
MAXIMUM handler, 9.6.1.1.3
latest time, 9.6.1.1.3
MINIMUM handler, 9.6.1.1.4
OVERWRITE handler, 9.6.1.1.1
resolution columns, 9.6.1.3
time-based, 9.6.1.1.3
conflicts
avoidance, 9.5
delete, 9.5.2.2
primary database ownership, 9.5.1
sequences, 9.5.2.1
uniqueness, 9.5.2.1
update, 9.5.2.3
delete, 9.2.3
detection, 9.4
identifying rows, 9.4.2
monitoring, 9.8.1
stopping, 9.4.1, 9.7.4
DML conflicts, 9.1
foreign key, 9.2.4
transaction ordering, 9.3
types of, 9.2
uniqueness, 9.2.2
update, 9.2.1, 9.2.2, 9.2.3, 9.2.4
CONVERGE procedure, 13.7
CREATE_APPLY procedure, 7.1
tags, 10.1, 10.4
CREATE_CAPTURE procedure, 5.1, 5.1.2.2
CREATE_COMPARISON procedure, 13.5
CREATE_PROPAGATION procedure, 6.2
CREATE_SYNC_CAPTURE procedure, 5.2.3

D

data
comparing, 13.5
custom, 13.5.5
cyclic, 13.5.4
purging results, 13.9
random, 13.5.3
rechecking, 13.8
subset of columns, 13.5.1
converging, 13.7
session tags, 13.7.3
data types
heterogeneous environments, 11.1.2.2
database links, 1.3.2
databases
adding for replication, 4.2.2, 4.3.2, 4.3.4
DBA_APPLY view, 10.7.2
DBA_APPLY_CONFLICT_COLUMNS view, 9.8.2
DBA_APPLY_INSTANTIATED_OBJECTS view, 8.6.2
DBA_APPLY_TABLE_COLUMNS view, 9.8.1
DBA_CAPTURE_PREPARED_DATABASE view, 8.6.1
DBA_CAPTURE_PREPARED_SCHEMAS view, 8.6.1
DBA_CAPTURE_PREPARED_TABLES view, 8.6.1
DBA_COMPARISON view, 13.6, 13.6.5, 13.6.6
DBA_COMPARISON_COLUMNS view, 13.6.3
DBA_COMPARISON_SCAN view, 13.6.4, 13.6.5, 13.6.6
DBA_COMPARISON_SCAN_VALUES view, 13.6.7
DBA_RECOVERABLE_SCRIPT view, 12.8
DBA_RECOVERABLE_SCRIPT_BLOCKS view, 12.8
DBA_RECOVERABLE_SCRIPT_ERRORS view, 12.8
DBA_RECOVERABLE_SCRIPT_PARAMS view, 12.8
DBA_SYNC_CAPTURE_PREPARED_TABS view, 8.6.1
DBID (database identifier)
capture process, 5.1
changing, 12.4
DBMS_CAPTURE_ADM package, 5
DBMS_COMPARISON package
buckets, 13.1.2
comparing database objects, 13.5
custom, 13.5.5
cyclic, 13.5.4
purging results, 13.9
random, 13.5.3
rechecking, 13.8
subset of columns, 13.5.1
converging database objects, 13.7
session tags, 13.7.3
monitoring, 13.6
parent scans, 13.1.3
preparation, 13.3
root scans, 13.1.3
scans, 13.1.1
Streams replication, 13.11
using, 13
DBMS_PROPAGATION_ADM package, 6
DBMS_STREAMS package, 10.6
DBMS_STREAMS_ADM package, 1.1.2, 5, 6
creating a capture process, 5.1
creating a propagation, 6.2
creating an apply process, 7.1
preparation for instantiation, 8.2.1
tags, 10.2
DDL replication
best practices, 1.2.6
directory objects, 2.2.3
creating, 4.2.2
DISCARD conflict resolution handler, 9.6.1.1.2
DML handlers
LOB assembly, 14.4.2
downstream capture, 1.2.2, 2.2.2.1
archived-log, 1.2.2
configuring, 2.2.5
log file transfer, 1.3.7
real-time, 1.2.2, 1.3.8
standby redo logs, 1.3.8
DROP SUPPLEMENTAL LOG DATA clause of ALTER DATABASE, 1.3.6.6
DROP SUPPLEMENTAL LOG GROUP clause, 1.3.6.4
DROP_COMPARISON procedure, 13.10

E

ENQUEUE procedure, 14.2
error handlers
LOB assembly, 14.4.2
error queue
heterogeneous environments, 11.1.5
Export
Oracle Streams, 8.5.1

F

flashback queries
Streams replication, 12.7

G

GET_MESSAGE_TRACKING function, 12.2
GET_SCN_MAPPING procedure, 12.6.2, 12.7
GET_TAG function, 10.6.1.2, 10.7.1
global name
best practices, 15.2.1
capture process, 5.1
changing, 12.4
GLOBAL_NAMES initialization parameter, 1.3.4
GRANT_REMOTE_ADMIN_ACCESS procedure, 5.1.3.1, 5.1.3.2.1

H

heartbeat table
Streams best practices, 16.2.1
heterogeneous information sharing, 11
non-Oracle to non-Oracle, 11.3
non-Oracle to Oracle, 11.2
apply process, 11.2.3
capturing changes, 11.2.1
instantiation, 11.2.4
user application, 11.2.1
Oracle to non-Oracle, 11.1
apply process, 11.1.2
capture process, 11.1.1
data types applied, 11.1.2.2
database links, 11.1.2.1.1
DML changes, 11.1.2.3
DML handlers, 11.1.2.1.5
error handlers, 11.1.2.1.7
errors, 11.1.5
instantiation, 11.1.2.4
message handlers, 11.1.2.1.6
staging, 11.1.1
substitute key columns, 11.1.2.1.3, 11.1.2.1.4, 11.1.2.1.5, 11.1.2.1.6, 11.1.2.1.7
transformations, 11.1.3
hub-and-spoke replication, 1.2.3, 1.2.7, 10.5.2
configuring, 2.2.6

I

Import
Oracle Streams, 8.5.1
STREAMS_CONFIGURATION parameter, 8.3.2.3
initialization parameters
COMPATIBLE, 1.3.4
GLOBAL_NAMES, 1.3.4
LOG_ARCHIVE_CONFIG, 1.3.4
LOG_ARCHIVE_DEST_n, 1.3.4
LOG_ARCHIVE_DEST_STATE_n, 1.3.4
LOG_BUFFER, 1.3.4
MEMORY_MAX_TARGET, 1.3.4
MEMORY_TARGET, 1.3.4
OPEN_LINKS, 1.3.4
PROCESSES, 1.3.4
SESSIONS, 1.3.4
SGA_MAX_SIZE, 1.3.4
SGA_TARGET, 1.3.4
SHARED_POOL_SIZE, 1.3.4
STREAMS_POOL_SIZE, 1.3.4
TIMED_STATISTICS, 1.3.4
UNDO_RETENTION, 1.3.4
instantiation, 2.2.2.6, 8
aborting preparation, 8.2.5
Data Pump, 8.3
database, 8.4.2
example
Data Pump export/import, 8.3.3
RMAN CONVERT DATABASE, 8.4.2.2
RMAN DUPLICATE, 8.4.2.1
RMAN TRANSPORT TABLESPACE, 8.4.1
transportable tablespace, 8.4.1
heterogeneous environments
non-Oracle to Oracle, 11.2.4
Oracle to non-Oracle, 11.1.2.4
monitoring, 8.6
Oracle Streams, 8.5.1
preparation for, 8.2
preparing for, 8.1, 8.2.4
RMAN, 8.4
setting an SCN, 8.5
DDL LCRs, 8.5.2
export/import, 8.5.1
supplemental logging specifications, 8.1
instantiation SCN
best practices, 18.1.2

L

LCRs. See logical change records
LOB assembly, 14.4.2
LOBs
Oracle Streams, 14.4
apply process, 14.4.1
log sequence number
Streams capture process, 12.6.1
LOG_ARCHIVE_CONFIG initialization parameter, 1.3.4
LOG_ARCHIVE_DEST_n initialization parameter, 1.3.4
LOG_ARCHIVE_DEST_STATE_n initialization parameter, 1.3.4
LOG_BUFFER initialization parameter, 1.3.4
logical change records (LCRs)
constructing, 14.2
enqueuing, 14.2
executing, 14.3
DDL LCRs, 14.3.2
row LCRs, 14.3.1
LOB columns, 14.4, 14.5
apply process, 14.4.1
requirements, 14.4.3
LONG columns, 14.5
requirements, 14.5
LONG RAW columns, 14.5
requirements, 14.5
managing, 14
requirements, 14.1
tracking, 12.2
XMLType, 14.4
LONG data type
Oracle Streams, 14.5
LONG RAW data type
Oracle, 14.5

M

MAINTAIN_GLOBAL procedure, 2.2, 2.2.4.1
MAINTAIN_SCHEMAS procedure, 2.2, 2.2.4.2, 2.2.5.2, 2.2.5.3, 2.2.6
MAINTAIN_SIMPLE_TTS procedure, 2.2, 2.2.5.1, 2.2.5.1
MAINTAIN_TABLES procedure, 2.2, 2.2.4.3
MAINTAIN_TTS procedure, 2.2, 2.2.5.1, 2.2.5.1
MAXIMUM conflict resolution handler, 9.6.1.1.3
latest time, 9.6.1.1.3
MEMORY_MAX_TARGET initialization parameter, 1.3.4, 1.3.5.1
MEMORY_TARGET initialization parameter, 1.3.4, 1.3.5.1
merge streams, 12.3
MERGE_STREAMS procedure, 12.3.2.2
MERGE_STREAMS_JOB procedure, 12.3.2.2
message tracking, 12.2, 12.2
message_tracking_frequency capture process parameter, 12.2
MINIMUM conflict resolution handler, 9.6.1.1.4
monitoring
apply process
update conflict handlers, 9.8.2
comparisons, 13.6
conflict detection, 9.8.1
instantiation, 8.6
tags, 10.7
apply process value, 10.7.2
current session value, 10.7.1

N

n-way replication, 1.2.3, 1.2.7, 10.5.1

O

objects
adding for replication, 4.2.1, 4.3.1, 4.3.3
oldest SCN
point-in-time recovery, 12.6.3
one-way replication, 1.2.7
OPEN_LINKS initialization parameter, 1.3.4
optimizer
statistics collection
best practices, 15.2.5
Oracle Data Pump
Import utility
STREAMS_CONFIGURATION parameter, 8.3.2.3
instantiations, 8.3.3
Streams instantiation, 8.3
Oracle Database Gateways
Oracle Streams, 11.1.2.1.1
Oracle Real Application Clusters
Streams best practices, 15.3
archive log threads, 15.3.1
global name, 15.3.2
propagations, 15.3.3
queue ownership, 15.3.4
Oracle Streams
conflict resolution, 9
DBMS_COMPARISON package, 13.11
Export utility, 8.5.1
heterogeneous information sharing, 11
Import utility, 8.5.1
instantiation, 8.1, 8.5.1
LOBs, 14.4
logical change records (LCRs)
managing, 14
LONG data type, 14.5
migrating to from Advanced Replication, A
Oracle Database Gateways, 11.1.2.1.1
point-in-time recovery, 12.6
replication, 1
adding databases, 4.2.2, 4.3.2, 4.3.4
adding objects, 4.2.1, 4.3.1, 4.3.3
adding to, 4
best practices, 14.5
configuring, 2, 3
managing, 12
sequences, 9.5.2.1
rules, 1.1.2
sequences, 9.5.2.1
tags, 10
XMLType, 14.4
Oracle Streams Performance Advisor, 15.2.2
OVERWRITE conflict resolution handler, 9.6.1.1.1

P

performance
Oracle Streams, 15.2.2
point-in-time recovery
Oracle Streams, 12.6
POST_INSTANTIATION_SETUP procedure, 2.2, 2.2.4.1, 2.2.5.1, 2.2.5.1
PRE_INSTANTIATION_SETUP procedure, 2.2, 2.2.4.1, 2.2.5.1, 2.2.5.1
PREPARE_GLOBAL_INSTANTIATION procedure, 8.2, 8.2.4
PREPARE_SCHEMA_INSTANTIATION procedure, 8.2, 8.2.4
PREPARE_SYNC_INSTANTIATION function, 8.2, 8.2.4
PREPARE_TABLE_INSTANTIATION procedure, 8.2, 8.2.4
PROCESSES initialization parameter, 1.3.4
propagation
best practices, 17
broken propagations, 17.2.1
configuration, 17.1
propagation latency, 17.1.2
propagation operation, 17.2
queue-to-queue propagation, 17.1.1
restarting propagation, 17.2.1
SDU, 17.1.3
propagation jobs
managing, 6.2
propagations
creating, 6, 6.2
managing, 6.2
PURGE_COMPARISON procedure, 13.9

Q

queues
ANYDATA
creating, 6.1
commit-time, 11.2.2
creating, 6
size
best practices, 15.2.3
transactional, 11.2.2
queue-to-queue propagation
best practices, 17.1.1

R

RECHECK function, 13.8
RECOVER_OPERATION procedure, 12.8
Recovery Manager
CONVERT DATABASE command
Streams instantiation, 8.4.2.2
DUPLICATE command
Streams instantiation, 8.4.2.1
Streams instantiation, 8.4
TRANSPORT TABLESPACE command
Streams instantiation, 8.4.1
replication
adding databases, 4.2.2, 4.3.2, 4.3.4
adding objects, 4.2.1, 4.3.1, 4.3.3
adding to, 4
bi-directional, 1.2.1, 2.2.2.4
configuration errors
recovering, 12.8
configuring, 2, 3
apply handlers, 1.2.5
ARCHIVELOG mode, 1.3.3
bi-directional, 1.2.3, 1.2.7
database, 2.2.4.1
database links, 1.3.2
DBMS_STREAMS_ADM package, 2.2
DDL changes, 1.2.6, 2.2.2.5
directory objects, 2.2.3
downstream capture, 1.2.2, 2.2.2.1, 2.2.5
Enterprise Manager, 2.1
hub-and-spoke, 1.2.3, 1.2.7, 2.2.6
initialization parameters, 1.3.4
instantiation, 2.2.2.6
local capture, 1.2.2, 2.2.2.1
log file transfer, 1.3.7
multiple-source environment, 3.2
n-way, 1.2.3, 1.2.7
one-way, 1.2.7
Oracle Streams pool, 1.3.5
preparation, 1
schemas, 2.2.4.2, 2.2.5.2, 2.2.5.3, 2.2.6
scripts, 2.2.2.2
single-source environment, 3.1
standby redo logs, 1.3.8
supplemental logging, 1.3.6
tables, 2.2.4.3
tablespace, 2.2.5.1
tablespaces, 2.2.5.1
tags, 2.2.2.4.1
hub-and-spoke, 1.2.1, 10.5.2
managing, 12
migrating to Streams, A
n-way, 1.2.1, 10.5.1
one-way, 1.2.1, 2.2.2.4
Oracle Streams, 1
best practices, 14.5
managing, 12
sequences, 9.5.2.1
split and merge, 12.3
resolution columns, 9.6.1.3
rule-based transformations, 1.2.4
rules, 1.1.2
system-created
tags, 10.2

S

SDU
Streams best practices, 17.1.3
sequences, 9.5.2.1
replication, 9.5.2.1
SESSIONS initialization parameter, 1.3.4
SET_DML_HANDLER procedure, 9.6.2
SET_GLOBAL_INSTANTIATION_SCN procedure, 8.5, 8.5.2
SET_MESSAGE_TRACKING procedure, 12.2
SET_SCHEMA_INSTANTIATION_SCN procedure, 8.5, 8.5.2
SET_TABLE_INSTANTIATION_SCN procedure, 8.5
SET_TAG procedure, 10.1, 10.6.1.1
SET_UP_QUEUE procedure, 6.1
SET_UPDATE_CONFLICT_HANDLER procedure, 9.6.1
modifying an update conflict handler, 9.7.2
removing an update conflict handler, 9.7.3
setting an update conflict handler, 9.7.1
SGA_MAX_SIZE initialization parameter, 1.3.4
SGA_TARGET initialization parameter, 1.3.4, 1.3.5.2
SHARED_POOL_SIZE initialization parameter, 1.3.4
split streams, 12.3
SPLIT_STREAMS procedure, 12.3.2.2
staging
heterogeneous environments, 11.1.1
statistics
Oracle Streams, 15.2.2
Streams pool
MEMORY_MAX_TARGET initialization parameter, 1.3.5.1
MEMORY_TARGET initialization parameter, 1.3.5.1
SGA_TARGET initialization parameter, 1.3.5.2
STREAMS_CONFIGURATION parameter
Data Pump Import utility, 8.3.2.3
Import utility, 8.3.2.3
STREAMS_MIGRATION procedure, A
STREAMS_POOL_SIZE initialization parameter, 1.3.4
STRMMON, 15.2.2
supplemental logging, 1.3.6
column lists, 9.6.1.2
instantiation, 8.1
preparation for instantiation, 8.2.3, 8.2.4
synchronous capture
best practices
configuration, 16.3
configuring, 5.2
preparing for, 5.2.1
system change numbers (SCN)
oldest SCN for an apply process
point-in-time recovery, 12.6.3

T

tags, 2.2.2.4.1, 10
ALTER_APPLY procedure, 10.1, 10.4
apply process, 10.4
change cycling
avoidance, 10.5
CONVERGE procedure, 13.7.3
CREATE_APPLY procedure, 10.1, 10.4
examples, 10.5
getting value for current session, 10.6.1.2
hub-and-spoke replication, 10.5
managing, 10.6
monitoring, 10.7
apply process value, 10.7.2
current session value, 10.7.1
n-way replication, 10.5
online backups, 10.3
removing value for apply process, 10.6.2.2
rules, 10.2
include_tagged_lcr parameter, 10.2
SET_TAG procedure, 10.1
setting value for apply process, 10.6.2.1
setting value for current session, 10.6.1.1
TIMED_STATISTICS initialization parameter, 1.3.4
tracking LCRs, 12.2
transformations
heterogeneous environments
Oracle to non-Oracle, 11.1.3
rule-based, 1.2.4, 1.2.4
transportable tablespace
Streams instantiation, 8.4.1

U

UNDO_RETENTION initialization parameter, 1.3.4

V

V$STREAMS_MESSAGE_TRACKING view, 12.2
V$STREAMS_POOL_ADVICE view, 1.3.5.3
V$STREAMS_TRANSACTION view, 8.2.4

X

XMLType
logical change records (LCRs), 14.4