Index

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

A

ABORT_GLOBAL_INSTANTIATION procedure, 10.2

ABORT_SCHEMA_INSTANTIATION procedure, 10.2

ABORT_TABLE_INSTANTIATION procedure, 10.2

ADD SUPPLEMENTAL LOG, 9.1.2.1

ADD SUPPLEMENTAL LOG DATA, 9.1.2.2

ADD SUPPLEMENTAL LOG DATA clause of ALTER DATABASE, 9.1.2.4

ADD SUPPLEMENTAL LOG DATA clause of ALTER TABLE, 20.4

ADD SUPPLEMENTAL LOG GROUP clause of ALTER TABLE

conditional log groups, 9.1.2.2

unconditional log groups, 9.1.2.1

alert log

Streams best practices, 14.2.7

ALTER DATABASE statement

ADD SUPPLEMENTAL LOG DATA clause, 9.1.2.4

DROP SUPPLEMENTAL LOG DATA clause, 9.1.2.5

ALTER TABLE statement

ADD SUPPLEMENTAL LOG DATA clause, 20.4

conditional log groups, 9.1.2.2

unconditional log groups, 9.1.2.1

ADD SUPPLEMENTAL LOG GROUP clause

conditional log groups, 9.1.2.2

unconditional log groups, 9.1.2.1

DROP SUPPLEMENTAL LOG GROUP clause, 9.1.2.3

ALTER_APPLY procedure

removing the DDL handler, 9.3.4.3

removing the tag value, 9.4.2.2

setting the DDL handler, 9.3.4.2

setting the tag value, 4.1, 4.4, 9.4.2.1

applied SCN, 1.4.8

apply process, 1.4

applied SCN, 1.4.8

apply handlers, 1.4.4.6

apply servers

troubleshooting, 13.2.3

apply user

best practices, 17.1.1

best practices

configuration, 17.2

operation, 17.3

conflict handlers, 1.4.4.6

conflict resolution, 1.4.4.5, 3

constraints, 1.4.4.1

contention, 13.2.1, 13.2.2

creating, 9.3.1

datatypes applied

heterogeneous environments, 5.1.2.2

DDL changes, 1.4.5

CREATE TABLE AS SELECT, 1.4.5.5

current schema, 1.4.5.3

data structures, 1.4.5.2

ignored, 1.4.5.1

system-generated names, 1.4.5.4

DDL handlers, 1.4.2.2

creating, 9.3.4.1

monitoring, 12.2.2.2

removing, 9.3.4.3

setting, 9.3.4.2

dependencies, 1.4.3

barrier transactions, 1.4.3.6

troubleshooting, 13.2.2

virtual dependency definitions, 1.4.3.5, 9.3.5, 12.2.3

DML changes, 1.4.4

heterogeneous environments, 5.1.2.3

DML handlers, 1.4.2.2

creating, 9.3.3.1

heterogeneous environments, 5.1.2.1.4

monitoring, 12.2.2.1

setting, 9.3.3.2

error handlers, 1.4.2.2

heterogeneous, 5.1.2.1.6

errors

best practices, 17.2.2, 17.3.1

heterogeneous environments, 5.1.2, 5.2.3

database links, 5.1.2.1.1

example, 19.4.1

high-watermark, 1.4.8

ignore SCN, 1.4.6

index-organized tables, 1.4.4.4

instantiation SCN, 1.4.6

key columns, 1.4.4.1

LOBs, 11.4.1

low-watermark, 1.4.8

managing, 9.3

message handlers

heterogeneous environments, 5.1.2.1.5

monitoring, 12.2

apply handlers, 12.2.2

oldest SCN, 1.4.7

point-in-time recovery, 9.7.3

parallelism

best practices, 17.2.1

parameters

commit_serialization, 13.2.2

parallelism, 13.2.2

performance, 13.2.3

substitute key columns, 1.4.4.2

heterogeneous environments, 5.1.2.1.2, 5.1.2.1.3, 5.1.2.1.4, 5.1.2.1.5, 5.1.2.1.6

removing, 9.3.2.2

setting, 9.3.2.1

tables, 1.4.4

apply handlers, 1.4.4.6

column discrepancies, 1.4.4.3

tags, 4.4

monitoring, 12.3.2

removing, 9.4.2.2

setting, 9.4.2.1

triggers

firing property, 1.4.9

ON SCHEMA clause, 1.4.9

troubleshooting, 13

error queue, 13.2.4

update conflict handlers

monitoring, 12.2.5

ARCHIVELOG mode

capture process, 18.2, 19.2

B

backups

online

Streams, 4.3

Streams best practices, 14.2.4

batch processing

capture process best practices, 15.3.2

best practices

Streams replication, 13

alert log, 14.2.7

apply, 17

apply errors, 17.2.2, 17.3.1

apply process configuration, 17.2

apply process operation, 17.3

apply process parallelism, 17.2.1

apply user, 17.1.1

archive log threads, 14.3.1

automate configuration, 14.1.4

backups, 14.2.4

batch processing, 15.3.2

capture, 15

capture process configuration, 15.2

capture process operation, 15.3

capture process parallelism, 15.2.1

capture process queue, 14.2.3

checkpoint retention, 15.2.2

conflict resolution, 17.1.3

data dictionary build, 15.3.1

database configuration, 14.1

database operation, 14.2

DDL replication, 14.2.2

destination database, 17.1

global name, 14.2.1

heartbeat table, 15.1.3

instantiation SCN, 17.1.2

prepare for instantiation, 15.3.1

propagation, 16

propagation latency, 16.1.2

queue-to-queue propagation, 16.1.1

RAC databases, 14.3

removing, 14.2.8

restarting propagation, 16.2.1

SDU, 16.1.3

source database, 15.1

statistics collection, 14.2.5

storage, 14.1.2

Streams administrator, 14.1.3

STRMMON, 14.2.6

supplemental logging, 15.1.2

buffered queues, 1.3.1

C

capture process, 1.2.1

ARCHIVELOG mode, 18.2, 19.2

best practices

batch processing, 15.3.2

configuration, 15.2

data dictionary build, 15.3.1

operation, 15.3

prepare for instantiation, 15.3.1

creating, 9.1.1

DBID

changing, 9.5

global name

changing, 9.5

heterogeneous environments, 5.1.1

log sequence number

resetting, 9.7.1

parallelism

best practices, 15.2.1

supplemental logging, 1.2.1.2, 2.2.3

managing, 9.1.2

change cycling

avoidance

tags, 4.5

checkpoint retention

best practices, 15.2.2

column lists, 3.6.1.2

COMPARE_OLD_VALUES procedure, 3.4.1, 9.3.6.4

COMPATIBLE initialization parameter, 18.2, 19.2

conflict resolution, 3

best practices, 17.1.3

column lists, 3.6.1.2

conflict handlers, 3.3, 3.4, 3.5, 3.6

custom, 3.6.2

interaction with apply handlers, 1.4.4.6

modifying, 9.3.6.2

prebuilt, 3.6.1

removing, 9.3.6.3

setting, 9.3.6.1

data convergence, 3.6.1.4

DISCARD handler, 3.6.1.1.2

MAXIMUM handler, 3.6.1.1.3

example, 20.4

latest time, 3.6.1.1.3

MINIMUM handler, 3.6.1.1.4

OVERWRITE handler, 3.6.1.1.1

resolution columns, 3.6.1.3

time-based, 3.6.1.1.3

example, 20.4

preparing for, 20.3

conflicts

avoidance, 3.5

delete, 3.5.2.2

primary database ownership, 3.5.1

uniqueness, 3.5.2.1

update, 3.5.2.3

delete, 3.2.3

detection, 3.4

identifying rows, 3.4.2

monitoring, 12.2.4

stopping, 3.4.1, 9.3.6.4

DML conflicts, 3.1

foreign key, 3.2.4

transaction ordering, 3.3

types of, 3.2

uniqueness, 3.2.2

update, 3.2.1, 3.2.2, 3.2.3, 3.2.4

constructing

LCRs, 11.4.4

CREATE TABLE statement

AS SELECT

apply process, 1.4.5.5

CREATE_APPLY procedure

tags, 4.1, 4.4

D

datatypes

heterogeneous environments, 5.1.2.2

DBA_APPLY view, 12.2.2.2, 12.2.2.2, 12.3.2

DBA_APPLY_CONFLICT_COLUMNS view, 12.2.5

DBA_APPLY_DML_HANDLERS view, 12.2.2.1

DBA_APPLY_INSTANTIATED_OBJECTS view, 12.4.2

DBA_APPLY_KEY_COLUMNS view, 12.2.1

DBA_APPLY_TABLE_COLUMNS view, 12.2.4

DBA_CAPTURE_PREPARED_DATABASE view, 12.4.1

DBA_CAPTURE_PREPARED_SCHEMAS view, 12.4.1

DBA_CAPTURE_PREPARED_TABLES view, 12.4.1

DBA_LOG_GROUPS view, 12.1.1

DBA_RECOVERABLE_SCRIPT view, 13.1

DBA_RECOVERABLE_SCRIPT_BLOCKS view, 13.1

DBA_RECOVERABLE_SCRIPT_ERRORS view, 13.1

DBA_RECOVERABLE_SCRIPT_PARAMS view, 13.1

DBID (database identifier)

capture process

changing, 9.5

DBMS_STREAMS package, 9.4

DBMS_STREAMS_ADM package, 1.1.1

preparation for instantiation, 2.2.1

tags, 4.2

DDL handlers, 1.4.2.2

creating, 9.3.4.1

monitoring, 12.2.2.2

removing, 9.3.4.3

setting, 9.3.4.2

DDL replication

best practices, 14.2.2

dependencies

apply processes, 1.4.3

DISCARD conflict resolution handler, 3.6.1.1.2

DML handlers, 1.4.2.2, 1.4.4.6

creating, 9.3.3.1

LOB assembly, 11.4.2

monitoring, 12.2.2.1

setting, 9.3.3.2

unsetting, 9.3.3.3

DROP SUPPLEMENTAL LOG DATA clause of ALTER DATABASE, 9.1.2.5

DROP SUPPLEMENTAL LOG GROUP clause, 9.1.2.3

E

ENQUEUE procedure, 11.2

error handlers, 1.4.4.6

LOB assembly, 11.4.2

error queue

apply process, 13.2.4

heterogeneous environments, 5.1.5

EXECUTE member procedure, 9.3.3.1, 9.3.4.1

explicit capture, 1.2.2

Export

OBJECT_CONSISTENT parameter, 2.5.1, 10.3.3

Oracle Streams, 10.4.1

F

flashback queries

Streams replication, 12.5

G

GET_BASE_TABLE_NAME member function, 9.3.4.1

GET_COMMAND_TY, 9.3.4.1

GET_COMMIT_SCN member function, 9.3.3.1

GET_OBJECT_NAME member function, 9.3.3.1, 19.4.1

GET_OBJECT_OWNER member function, 9.3.3.1

GET_SCN member function, 9.3.3.1, 9.3.4.1

GET_SCN_MAPPING procedure, 9.7.2, 12.5

GET_SOURCE_DATABASE_NAME member function, 9.3.4.1

GET_TAG function, 9.4.1.2, 12.3.1

GET_TAG member function, 9.3.3.1, 9.3.4.1

GET_TRANSACTION_ID member function, 9.3.3.1, 9.3.4.1

GET_VALUES member function, 9.3.3.1

global name

best practices, 14.2.1

capture process

changing, 9.5

GLOBAL_NAMES initialization parameter, 18.2, 19.2

H

heartbeat table

Streams best practices, 15.1.3

heterogeneous information sharing, 5

non-Oracle to non-Oracle, 5.3

non-Oracle to Oracle, 5.2

apply process, 5.2.3

capturing changes, 5.2.1

instantiation, 5.2.4

user application, 5.2.1

Oracle to non-Oracle, 5.1

apply process, 5.1.2

capture process, 5.1.1

database links, 5.1.2.1.1

datatypes applied, 5.1.2.2

DML changes, 5.1.2.3

DML handlers, 5.1.2.1.4

error handlers, 5.1.2.1.6

errors, 5.1.5

instantiation, 5.1.2.4

message handlers, 5.1.2.1.5

staging, 5.1.1

substitute key columns, 5.1.2.1.2, 5.1.2.1.3, 5.1.2.1.4, 5.1.2.1.5, 5.1.2.1.6

transformations, 5.1.3

high-watermark, 1.4.8

I

ignore SCN, 1.4.6

Import

Oracle Streams, 10.4.1

STREAMS_CONFIGURATION parameter, 2.3.2.3, 2.5.2.2

STREAMS_INSTANTIATION parameter, 2.5.2.1, 10.3.3

index-organized tables

apply process, 1.4.4.4

instantiation, 2

aborting preparation, 10.2

Data Pump, 2.3

database, 10.3.4

example, 10.3, 19.4.1, 19.4.2, 20.4, 20.4

Data Pump export/import, 10.3.1

original export/import, 10.3.3

RMAN CONVERT DATABASE, 10.3.4.2

RMAN DUPLICATE, 10.3.4.1

RMAN TRANSPORT TABLESPACE, 10.3.2

transportable tablespace, 10.3.2

Export/Import, 2.5

heterogeneous environments

non-Oracle to Oracle, 5.2.4

Oracle to non-Oracle, 5.1.2.4

monitoring, 12.4

Oracle Streams, 10.4.1

preparation for, 2.2

preparing for, 2.1, 10.1

RMAN, 2.4

setting an SCN, 10.4

DDL LCRs, 10.4.2

export/import, 10.4.1

supplemental logging specifications, 2.1

instantiation SCN, 1.4.6

best practices, 17.1.2

IS_TRIGGER_FIRE_ONCE function, 1.4.9

J

JOB_QUEUE_PROCESSES initialization parameter, 18.2, 19.2

L

LCRs. See logical change records

LOB assembly, 11.4.2

LOBs

Oracle Streams, 11.4

apply process, 11.4.1

constructing, 11.4.4

log sequence number

Streams capture process, 9.7.1

logical change records (, 9.3.3.1

logical change records (LCRs)

constructing, 11.2

DDL LCRs

current_schema, 1.4.5.3

enqueuing, 11.2

executing, 11.3

DDL LCRs, 11.3.2

row LCRs, 11.3.1

getting information about, 9.3.4.1

LOB columns, 11.4, 11.4.4, 11.5

apply process, 11.4.1

requirements, 11.4.3

LONG columns, 11.5

requirements, 11.5

LONG RAW columns, 11.5

requirements, 11.5

managing, 11

requirements, 11.1

LONG datatype

Oracle Streams, 11.5

LONG RAW datatype

Oracle, 11.5

low-watermark, 1.4.8

M

MAINTAIN_GLOBAL procedure, 6.2, 6.2.2

MAINTAIN_SCHEMAS procedure, 6.2, 6.2.4

MAINTAIN_SIMPLE_TTS procedure, 6.2, 6.2.3, 6.2.3

MAINTAIN_TABLES procedure, 6.2, 6.2.5

MAINTAIN_TTS procedure, 6.2, 6.2.3, 6.2.3

MAXIMUM conflict resolution handler, 3.6.1.1.3

latest time, 3.6.1.1.3

MINIMUM conflict resolution handler, 3.6.1.1.4

monitoring

apply process, 12.2

apply handlers, 12.2.2

DDL handlers, 12.2.2.2

update conflict handlers, 12.2.5

conflict detection, 12.2.4

DML handlers, 12.2.2.1

instantiation, 12.4

Oracle Streams

replication, 12

STRMMON, 14.2.6

supplemental logging, 12.1

tags, 12.3

apply process value, 12.3.2

current session value, 12.3.1

O

OBJECT_CONSISTENT parameter

Export utility, 2.5.1, 10.3.3

oldest SCN, 1.4.7

point-in-time recovery, 9.7.3

ON SCHEMA clause

of CREATE TRIGGER

apply process, 1.4.9

optimizer

statistics collection

best practices, 14.2.5

ORA-01403 error, 13.2.4.2.2

ORA-23605 error, 13.2.4.2.3

ORA-23607 error, 13.2.4.2.4

ORA-24031 error, 13.2.4.2.5

ORA-26687 error, 13.2.4.2.6

ORA-26688 error, 13.2.4.2.7

ORA-26689 error, 13.2.4.2.8

Oracle Data Pump

Import utility

STREAMS_CONFIGURATION parameter, 2.3.2.3

instantiations, 10.3.1

Streams instantiation, 2.3

Oracle Real Application Clusters

Streams best practices, 14.3

archive log threads, 14.3.1

global name, 14.3.2

propagations, 14.3.3

queue ownership, 14.3.4

Oracle Streams

adding databases, 19.8

adding objects, 19.6

conflict resolution, 3

Export utility, 10.4.1

heterogeneous information sharing, 5

Import utility, 10.4.1

initialization parameters, 18.2, 19.2

instantiation, 2.1, 10.4.1

LOBs, 11.4

logical change records (LCRs)

managing, 11

LONG datatype, 11.5

migrating to from Advanced Replication, A

point-in-time recovery, 9.7

replication, 1, 8

adding databases, 8.2, 8.4

adding objects, 8.1, 8.3

best practices, 13

configuring, 6, 7

monitoring, 12

subsetting, 1.1.3

troubleshooting, 13

rules, 1.1.1

sample environments

replication, 18, 19, 20

supplemental logging, 1.2.1.2

managing, 9.1.2

tags, 4

OVERWRITE conflict resolution handler, 3.6.1.1.1

P

point-in-time recovery

Oracle Streams, 9.7

POST_INSTANTIATION_SETUP procedure, 6.2, 6.2.2, 6.2.3, 6.2.3

PRE_INSTANTIATION_SETUP procedure, 6.2, 6.2.2, 6.2.3, 6.2.3

PREPARE_GLOBAL_INSTANTIATION procedure, 2.2, 10.1

PREPARE_SCHEMA_INSTANTIATION procedure, 2.2, 10.1

PREPARE_TABLE_INSTANTIATION procedure, 2.2, 10.1

propagation

best practices, 16

broken propagations, 16.2.1

configuration, 16.1

propagation latency, 16.1.2

propagation operation, 16.2

queue-to-queue propagation, 16.1.1

restarting propagation, 16.2.1

SDU, 16.1.3

propagations, 1.3.2

creating, 9.2.2

database links

creating, 18.3, 19.3, 19.3, 19.8

queue-to-queue, 9.2.2

Q

queues

buffered queues, 1.3.1

commit-time, 5.2.2

growth

best practices, 14.2.3

transactional, 5.2.2

queue-to-queue propagation

best practices, 16.1.1

R

RECOVER_OPERATION procedure, 13.1

Recovery Manager

CONVERT DATABASE command

Streams instantiation, 10.3.4.2

DUPLICATE command

Streams instantiation, 10.3.4.1

Streams instantiation, 2.4

TRANSPORT TABLESPACE command

Streams instantiation, 10.3.2

replication, 8

adding databases, 8.2, 8.4, 19.8

adding objects, 8.1, 8.3, 19.6

configuration errors

recovering, 13.1

configuring, 6, 7

bi-directional, 6.2.1.1.3

database, 6.2.2

DBMS_STREAMS_ADM package, 6.2

DDL changes, 6.2.1.1.1

Enterprise Manager, 6.1

preparation, 6.2.1

schemas, 6.2.4

scripts, 6.2.1.1.4

tables, 6.2.5

tablespace, 6.2.3

heterogeneous single source example, 19

migrating to Streams, A

multiple source example, 20

Oracle Streams, 1

best practices, 13

simple single source example, 18

resolution columns, 3.6.1.3

rules, 1.1.1

system-created

subset, 1.1.3

tags, 4.2

S

SDU

Streams best practices, 16.1.3

SET_DML_HANDLER procedure, 3.6.2

setting a DML handler, 9.3.3.2

unsetting a DML handler, 9.3.3.3

SET_GLOBAL_INSTANTIATION_SCN procedure, 10.4, 10.4.2

SET_KEY_COLUMNS procedure, 1.4.4.2

removing substitute key columns, 9.3.2.2

setting substitute key columns, 9.3.2.1

SET_OBJECT_NAME member procedure, 19.4.1

SET_PARAMETER procedure

apply process, 13.2.2

SET_RULE_TRANSFORM_FUNCTION procedure, 19.4.1

SET_SCHEMA_INSTANTIATION_SCN procedure, 10.4, 10.4.2

SET_TABLE_INSTANTIATION_SCN procedure, 10.4

SET_TAG procedure, 4.1, 9.4.1.1

SET_TRIGGER_FIRING_PROPERTY procedure, 1.4.9

SET_UPDATE_CONFLICT_HANDLER procedure, 3.6.1

modifying an update conflict handler, 9.3.6.2

removing an update conflict handler, 9.3.6.3

setting an update conflict handler, 9.3.6.1

staging

buffered queues, 1.3.1

heterogeneous environments, 5.1.1

STREAMS_CONFIGURATION parameter

Data Pump Import utility, 2.3.2.3

Import utility, 2.3.2.3, 2.5.2.2

STREAMS_INSTANTIATION parameter

Import utility, 2.5.2.1, 10.3.3

STRMMON, 14.2.6

supplemental logging, 1.2.1.2

capture process

managing, 9.1.2

column lists, 3.6.1.2

conditional log groups, 1.2.1.2

DBA_LOG_GROUPS view, 12.1.1

example, 20.4

instantiation, 2.1

monitoring, 12.1

preparation for instantiation, 2.2.3, 10.1

Streams best practices, 15.1.2

unconditional log groups, 1.2.1.2

system change numbers (SCN)

applied SCN for an apply process, 1.4.8

oldest SCN for an apply process, 1.4.7

point-in-time recovery, 9.7.3

system-generated names

apply process, 1.4.5.4

T

tags, 4

ALTER_APPLY procedure, 4.1, 4.4

apply process, 4.4

change cycling

avoidance, 4.5

CREATE_APPLY procedure, 4.1, 4.4

examples, 4.5

getting value for current session, 9.4.1.2

managing, 9.4

monitoring, 12.3

apply process value, 12.3.2

current session value, 12.3.1

online backups, 4.3

removing value for apply process, 9.4.2.2

rules, 4.2

include_tagged_lcr parameter, 4.2

SET_TAG procedure, 4.1

setting value for apply process, 9.4.2.1

setting value for current session, 9.4.1.1

transformations

heterogeneous environments

Oracle to non-Oracle, 5.1.3

rule-based, 1.1.2

creating, 19.4.1

example, 19.4.1

transportable tablespace

Streams instantiation, 10.3.2

triggers

firing property, 1.4.9

system triggers

on SCHEMA, 1.4.9

troubleshooting

apply process, 13

error queue, 13.2.4

performance, 13.2.3

Oracle Streams

replication, 13

V

V$DATABASE view

supplemental logging, 12.1.2

V$STREAMS_APPLY_SERVER view, 13.2.3

V$STREAMS_TRANSACTION view, 10.1

virtual dependency definitions, 1.4.3.5

object dependencies, 1.4.3.5.2

managing, 9.3.5.2

monitoring, 12.2.3.2

value dependencies, 1.4.3.5.1

managing, 9.3.5.1

monitoring, 12.2.3.1