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