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, 8-3

ABORT_SCHEMA_INSTANTIATION procedure, 8-3

ABORT_TABLE_INSTANTIATION procedure, 8-3

ADD SUPPLEMENTAL LOG DATA clause of ALTER DATABASE, 7-7

ADD SUPPLEMENTAL LOG DATA clause of ALTER TABLE

conditional log groups, 7-6

unconditional log groups, 7-5

ADD SUPPLEMENTAL LOG GROUP clause of ALTER TABLE

conditional log groups, 7-6

unconditional log groups, 7-5

ALTER DATABASE statement

ADD SUPPLEMENTAL LOG DATA clause, 7-7

DROP SUPPLEMENTAL LOG DATA clause, 7-8

ALTER TABLE statement

ADD SUPPLEMENTAL LOG DATA clause

conditional log groups, 7-6

unconditional log groups, 7-5

ADD SUPPLEMENTAL LOG GROUP clause

conditional log groups, 7-6

unconditional log groups, 7-5

DROP SUPPLEMENTAL LOG GROUP clause, 7-7

ALTER_APPLY procedure

removing the DDL handler, 7-23

removing the tag value, 7-35

setting the DDL handler, 7-22

setting the tag value, 4-2, 4-7, 7-34

applied SCN, 1-32

apply process, 1-14

applied SCN, 1-32

apply handlers, 1-22

apply servers

troubleshooting, 11-5

conflict handlers, 1-22

heterogeneous environments, 5-5

conflict resolution, 1-21, 3-1

constraints, 1-17

contention, 11-2, 11-4

creating, 7-12

datatypes applied

heterogeneous environments, 5-5

DDL changes, 1-26

CREATE TABLE AS SELECT, 1-29

current schema, 1-28

data structures, 1-27

ignored, 1-26

system-generated names, 1-28

DDL handlers, 1-15

creating, 7-21

monitoring, 10-7

removing, 7-23

setting, 7-22

dependent transactions, 11-4

DML changes, 1-17

heterogeneous environments, 5-6

DML handlers, 1-15

creating, 7-16

heterogeneous environments, 5-5

monitoring, 10-6

setting, 7-19

error handlers, 1-15

heterogeneous environments, 5-5

heterogeneous environments, 5-3, 5-12

database links, 5-4

high-watermark, 1-32

ignore SCN, 1-30

index-organized tables, 1-21

instantiation SCN, 1-30

key columns, 1-17

LOBs, 9-13

low-watermark, 1-32

managing, 7-12

message handlers

heterogeneous environments, 5-5

monitoring, 10-4

apply handlers, 10-6

oldest SCN, 1-31

point-in-time recovery, 7-44

parameters

commit_serialization, 11-4

heterogeneous environments, 5-5

parallelism, 11-4

performance, 11-5

substitute key columns, 1-18

heterogeneous environments, 5-4, 5-5

removing, 7-16

setting, 7-14

tables, 1-17

apply handlers, 1-22

column discrepancies, 1-20

tags, 4-7

monitoring, 10-22

removing, 7-35

setting, 7-34

triggers

firing property, 1-32

ON SCHEMA clause, 1-34

troubleshooting, 11-1

error queue, 11-7

update conflict handlers

monitoring, 10-9

ARCHIVELOG mode

capture process, 12-3, 13-6

B

backups

online

Streams, 4-6

buffered queues, 1-12

monitoring, 10-10

apply processes, 10-20

capture processes, 10-12

propagations, 10-14, 10-15, 10-16, 10-17, 10-19

C

capture process, 1-6

ARCHIVELOG mode, 12-3, 13-6

creating, 7-2

DBID

changing, 7-35

global name

changing, 7-35

heterogeneous environments, 5-3

log sequence number

resetting, 7-38

supplemental logging, 1-9

managing, 7-4

change cycling

avoidance

tags, 4-8

column lists, 3-12

COMPARE_OLD_VALUES procedure, 3-5, 7-27

COMPATIBLE initialization parameter, 12-3, 13-5

conflict resolution, 3-1

column lists, 3-12

conflict handlers, 3-4, 3-5, 3-6, 3-8

custom, 3-15

interaction with apply handlers, 1-22

modifying, 7-25

prebuilt, 3-9

removing, 7-26

setting, 7-23

data convergence, 3-15

DISCARD handler, 3-10

MAXIMUM handler, 3-10

latest time, 3-11

MINIMUM handler, 3-12

OVERWRITE handler, 3-10

resolution columns, 3-14

time-based, 3-11

conflicts

avoidance, 3-6

delete, 3-7

primary database ownership, 3-6

uniqueness, 3-6

update, 3-8

delete, 3-3

detection, 3-5

identifying rows, 3-6

monitoring, 10-8

stopping, 3-5, 7-27

DML conflicts, 3-2

foreign key, 3-3

transaction ordering, 3-4

types of, 3-2

uniqueness, 3-3

update, 3-3

constructing

LCRs, 9-14

CREATE TABLE statement

AS SELECT

apply process, 1-29

CREATE_APPLY procedure

tags, 4-2, 4-7

D

datatypes

heterogeneous environments, 5-5

DBA_APPLY view, 10-7, 10-22

DBA_APPLY_CONFLICT_COLUMNS view, 10-9

DBA_APPLY_DML_HANDLERS view, 10-6

DBA_APPLY_INSTANTIATED_OBJECTS view, 10-24

DBA_APPLY_KEY_COLUMNS view, 10-5

DBA_APPLY_TABLE_COLUMNS view, 10-8

DBA_CAPTURE_PREPARED_DATABASE view, 10-23

DBA_CAPTURE_PREPARED_SCHEMAS view, 10-23

DBA_CAPTURE_PREPARED_TABLES view, 10-23

DBA_LOG_GROUPS view, 10-2

DBA_PROPAGATION view, 10-14, 10-15, 10-16, 10-17

DBID (database identifier)

capture process

changing, 7-35

DBMS_STREAMS package, 7-33

DBMS_STREAMS_ADM package, 1-4

tags, 4-3

DDL handlers, 1-15

creating, 7-21

monitoring, 10-7

removing, 7-23

setting, 7-22

DISCARD conflict resolution handler, 3-10

DML handlers, 1-15, 1-22

creating, 7-16

monitoring, 10-6

setting, 7-19

unsetting, 7-20

DROP SUPPLEMENTAL LOG DATA clause of ALTER DATABASE, 7-8

DROP SUPPLEMENTAL LOG GROUP clause, 7-7

E

ENQUEUE procedure, 9-5

error handlers, 1-22

error queue

apply process, 11-7

heterogeneous environments, 5-10

EXECUTE member procedure, 7-18, 7-22

explicit capture, 1-11

Export

OBJECT_CONSISTENT parameter, 2-13, 8-13

Oracle Streams, 2-13, 8-23

F

flashback queries

Streams replication, 10-26

G

GET_BASE_TABLE_NAME member function, 7-22

GET_BASE_TABLE_OWNER member function, 7-22

GET_COMMAND_TYPE member function, 7-22

GET_COMMIT_SCN member function, 7-18

GET_CURRENT_SCHEMA member function, 7-22

GET_LOGON_USER member function, 7-22

GET_OBJECT_NAME member function, 7-18, 7-22

GET_OBJECT_OWNER member function, 7-18, 7-22

GET_SCN member function, 7-18, 7-22

GET_SCN_MAPPING procedure, 7-42, 10-26

GET_SOURCE_DATABASE_NAME member function, 7-22

GET_TAG function, 7-34, 10-21

GET_TAG member function, 7-18, 7-22

GET_TRANSACTION_ID member function, 7-18, 7-22

GET_VALUES member function, 7-18

global name

capture process

changing, 7-35

GLOBAL_NAMES initialization parameter, 12-3, 13-5

H

heterogeneous information sharing, 5-1

non-Oracle to non-Oracle, 5-13

non-Oracle to Oracle, 5-11

apply process, 5-12

capturing changes, 5-12

instantiation, 5-13

user application, 5-12

Oracle to non-Oracle, 5-2

apply process, 5-3

capture process, 5-3

conflict handlers, 5-5

database links, 5-4

datatypes applied, 5-5

DML changes, 5-6

DML handlers, 5-5

error handlers, 5-5

errors, 5-10

instantiation, 5-7

message handlers, 5-5

parallelism, 5-5

staging, 5-3

substitute key columns, 5-4, 5-5

transformations, 5-10

high-watermark, 1-32

I

ignore SCN, 1-30

Import

Oracle Streams, 2-13, 8-23

STREAMS_CONFIGURATION parameter, 2-9, 2-14

STREAMS_INSTANTIATION parameter, 2-14, 8-13

index-organized tables

apply process, 1-21

instantiation, 2-1

aborting preparation, 8-3

example, 8-4

Data Pump export/import, 8-4

original export/import, 8-13

RMAN, 8-15

transportable tablespaces, 8-8

export/import

Data Pump and original, 2-2

heterogeneous environments

non-Oracle to Oracle, 5-13

Oracle to non-Oracle, 5-7

monitoring, 10-23

Oracle Streams, 8-23

preparing for, 2-2, 8-2

setting an SCN, 8-22

DDL LCRs, 8-25

export/import, 8-23

supplemental logging specifications, 2-3

instantiation SCN, 1-30

IS_TRIGGER_FIRE_ONCE function, 1-32

J

JOB_QUEUE_PROCESSES initialization parameter, 12-3, 13-5

L

LCRs. See logical change records

LOBs

Oracle Streams, 9-9

apply process, 9-13

constructing, 9-14

log sequence number

Streams capture process, 7-38

logical change records (LCRs)

constructing, 9-3

DDL LCRs

current_schema, 1-28

enqueuing, 9-3

getting information about, 7-18, 7-22

LOB columns, 9-9, 9-14

apply process, 9-13

requirements, 9-11

LONG columns, 9-9

requirements, 9-10

LONG RAW columns, 9-9

requirements, 9-10

managing, 9-1

requirements, 9-2

LONG datatype

Oracle Streams, 9-9

LONG RAW datatype

Oracle Streams, 9-9

low-watermark, 1-32

M

MAINTAIN_TABLESPACES procedure, 7-29

MAXIMUM conflict resolution handler, 3-10

latest time, 3-11

MINIMUM conflict resolution handler, 3-12

monitoring

apply process, 10-4

apply handlers, 10-6

DDL handlers, 10-7

update conflict handlers, 10-9

conflict detection, 10-8

DML handlers, 10-6

instantiation, 10-23

Oracle Streams

replication, 10-1

supplemental logging, 10-2

tags, 10-21

apply process value, 10-22

current session value, 10-21

O

OBJECT_CONSISTENT parameter

Export utility, 2-13, 8-13

oldest SCN, 1-31

point-in-time recovery, 7-44

ON SCHEMA clause

of CREATE TRIGGER

apply process, 1-34

ORA-01403 error, 11-8

ORA-23605 error, 11-10

ORA-23607 error, 11-11

ORA-24031 error, 11-11

ORA-26679 error, 9-12

ORA-26687 error, 11-12

ORA-26688 error, 11-14

ORA-26689 error, 11-15

Oracle Data Pump

Import utility

STREAMS_CONFIGURATION parameter, 2-9

instantiations, 8-4

Oracle Streams

adding databases, 13-9

adding objects, 13-7

conflict resolution, 3-1

Data Pump, 2-2

example environments

replication, 12-1, 13-1, 14-1

Export utility, 2-2, 2-13, 8-23

heterogeneous information sharing, 5-1

Import utility, 2-2, 2-13, 8-23

initialization parameters, 12-3, 13-5

instantiation, 2-2, 8-23

LOBs, 9-9

logical change records (LCRs)

managing, 9-1

LONG datatype, 9-9

migrating to from Advanced Replication, A-1

point-in-time recovery, 7-38

replication, 1-1

adding databases, 6-14, 6-34

adding objects, 6-7, 6-25

configuring, 6-1

monitoring, 10-1

subsetting, 1-5

troubleshooting, 11-1

rules, 1-3

supplemental logging, 1-9

managing, 7-4

tags, 4-1

OVERWRITE conflict resolution handler, 3-10

P

point-in-time recovery

Oracle Streams, 7-38

PREPARE_GLOBAL_INSTANTIATION procedure, 2-2, 8-2

PREPARE_SCHEMA_INSTANTIATION procedure, 2-2, 8-2

PREPARE_TABLE_INSTANTIATION procedure, 2-2, 8-2

propagations, 1-12

creating, 7-10

Q

queues

buffered queues, 1-12

R

replication

migrating to Streams, A-1

Oracle Streams, 1-1

adding databases, 6-14, 6-34, 13-9

adding objects, 6-7, 6-25, 13-7

configuring, 6-1

heterogeneous single source example, 13-1

multiple source example, 14-1

simple single source example, 12-1

resolution columns, 3-14

rules, 1-3

system-created

subset, 1-5

tags, 4-3

S

SET_DML_HANDLER procedure, 3-15

setting a DML handler, 7-19

unsetting a DML handler, 7-20

SET_GLOBAL_INSTANTIATION_SCN procedure, 8-22, 8-25

SET_KEY_COLUMNS procedure, 1-18

removing substitute key columns, 7-16

setting substitute key columns, 7-14

SET_PARAMETER procedure

apply process, 11-4

SET_SCHEMA_INSTANTIATION_SCN procedure, 8-22, 8-25

SET_TABLE_INSTANTIATION_SCN procedure, 8-22

SET_TAG procedure, 4-2, 7-33

SET_TRIGGER_FIRING_PROPERTY procedure, 1-32

SET_UPDATE_CONFLICT_HANDLER procedure, 3-9

modifying an update conflict handler, 7-25

removing an update conflict handler, 7-26

setting an update conflict handler, 7-23

staging

buffered queues, 1-12

monitoring, 10-10

heterogeneous environments, 5-3

STREAMS_CONFIGURATION parameter

Data Pump Import utility, 2-9

Import utility, 2-9, 2-14

STREAMS_INSTANTIATION parameter

Import utility, 2-14, 8-13

supplemental logging, 1-9

capture process

managing, 7-4

column lists, 3-12

conditional log groups, 1-9

DBA_LOG_GROUPS view, 10-2

instantiation, 2-3

monitoring, 10-2

unconditional log groups, 1-9

system change numbers (SCN)

applied SCN for an apply process, 1-32

oldest SCN for an apply process, 1-31

point-in-time recovery, 7-44

system-generated names

apply process, 1-28

T

tags, 4-1

ALTER_APPLY procedure, 4-2, 4-7

apply process, 4-7

change cycling

avoidance, 4-8

CREATE_APPLY procedure, 4-2, 4-7

examples, 4-8

getting value for current session, 7-34

managing, 7-33

monitoring, 10-21

apply process value, 10-22

current session value, 10-21

online backups, 4-6

removing value for apply process, 7-35

rules, 4-3

include_tagged_lcr parameter, 4-4

SET_TAG procedure, 4-2

setting value for apply process, 7-34

setting value for current session, 7-33

transformations

heterogeneous environments

Oracle to non-Oracle, 5-10

rule-based, 1-5

triggers

firing property, 1-32

system triggers

on SCHEMA, 1-34

troubleshooting

apply process, 11-1

error queue, 11-7

performance, 11-5

Oracle Streams

replication, 11-1

V

V$BUFFERED_PUBLISHERS view, 10-12

V$BUFFERED_QUEUES view, 10-11, 10-17, 10-20

V$BUFFERED_SUBSCRIBERS view, 10-17, 10-20

V$DATABASE view

supplemental logging, 10-4

V$PROPAGATION_RECEIVER view, 10-19

V$PROPAGATION_SENDER view, 10-14, 10-15, 10-16

V$STREAMS_APPLY_SERVER view, 11-5