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, 16.4

ADD SUPPLEMENTAL LOG GROUP clause of ALTER TABLE

conditional log groups, 9.1.2.2

unconditional log groups, 9.1.2.1

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, 16.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

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.3

troubleshooting, 13.2.2

virtual dependency definitions, 1.4.3.1, 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

heterogeneous environments, 5.1.2, 5.2.3

database links, 5.1.2.1.1

example, 15.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

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, 14.2, 15.2

B

backups

online

Streams, 4.3

buffered queues, 1.3.1

C

capture process, 1.2.1

ARCHIVELOG mode, 14.2, 15.2

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

supplemental logging, 1.2.1.2, 2.2.3

managing, 9.1.2

change cycling

avoidance

tags, 4.5

column lists, 3.6.1.2

COMPARE_OLD_VALUES procedure, 3.4.1, 9.3.6.4

COMPATIBLE initialization parameter, 14.2, 15.2

conflict resolution, 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, 16.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, 16.4

preparing for, 16.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

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, 15.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

capture process

changing, 9.5

GLOBAL_NAMES initialization parameter, 14.2, 15.2

H

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, 15.4.1, 15.4.2, 16.4, 16.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

IS_TRIGGER_FIRE_ONCE function, 1.4.9

J

JOB_QUEUE_PROCESSES initialization parameter, 14.2, 15.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

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

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 Streams

adding databases, 15.8

adding objects, 15.6

conflict resolution, 3

Export utility, 10.4.1

heterogeneous information sharing, 5

Import utility, 10.4.1

initialization parameters, 14.2, 15.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

configuring, 6, 7

monitoring, 12

subsetting, 1.1.3

troubleshooting, 13

rules, 1.1.1

sample environments

replication, 14, 15, 16

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

propagations, 1.3.2

creating, 9.2.2

database links

creating, 14.3, 15.3, 15.3, 15.8

queue-to-queue, 9.2.2

Q

queues

buffered queues, 1.3.1

commit-time, 5.2.2

transactional, 5.2.2

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, 15.8

adding objects, 8.1, 8.3, 15.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, 15

migrating to Streams, A

multiple source example, 16

Oracle Streams, 1

simple single source example, 14

resolution columns, 3.6.1.3

rules, 1.1.1

system-created

subset, 1.1.3

tags, 4.2

S

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, 15.4.1

SET_PARAMETER procedure

apply process, 13.2.2

SET_RULE_TRANSFORM_FUNCTION procedure, 15.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

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, 16.4

instantiation, 2.1

monitoring, 12.1

preparation for instantiation, 2.2.3, 10.1

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, 15.4.1

example, 15.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.1

object dependencies, 1.4.3.1.2

managing, 9.3.5.2

monitoring, 12.2.3.2

value dependencies, 1.4.3.1.1

managing, 9.3.5.1

monitoring, 12.2.3.1