Index

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

A

ADD SUPPLEMENTAL LOG, 4.1.2.7.2

ADD SUPPLEMENTAL LOG DATA, 4.1.2.7.3

ADD SUPPLEMENTAL LOG DATA clause of ALTER DATABASE, 4.1.2.7.5

ADD SUPPLEMENTAL LOG GROUP clause of ALTER TABLE

conditional log groups, 4.1.2.7.3

unconditional log groups, 4.1.2.7.2

ADD_OUTBOUND procedure, 4.2.3, 4.2.4.2

ADD_SUBSET_OUTBOUND_RULES procedure, 5.4.1.2

ADD_TABLE_RULES procedure, 5.4.1.3

ALL_APPLY view, 6.3.2, 11.3

ALL_APPLY_ERROR view, 11.7.4, 11.7.5

ALL_CAPTURE_EXTRA_ATTRIBUTES view, 7.2.4

ALL_PROPAGATION view, 12.2.1

ALL_XSTREAM_INBOUND view, 11.2

ALL_XSTREAM_INBOUND_PROGRESS view, 11.5

ALL_XSTREAM_OUTBOUND view, 5.3.1, 6.3.1

ALL_XSTREAM_OUTBOUND_PROGRESS view, 6.3.5

ALTER DATABASE statement

ADD SUPPLEMENTAL LOG DATA clause, 4.1.2.7.5

DROP SUPPLEMENTAL LOG DATA clause, 4.1.2.7.6

ALTER TABLE statement

ADD SUPPLEMENTAL LOG DATA clause

conditional log groups, 4.1.2.7.3

unconditional log groups, 4.1.2.7.2

ADD SUPPLEMENTAL LOG GROUP clause

conditional log groups, 4.1.2.7.3

unconditional log groups, 4.1.2.7.2

DROP SUPPLEMENTAL LOG GROUP clause, 4.1.2.7.4

ALTER_INBOUND procedure, 10.5

ALTER_OUTBOUND procedure, 5.2.4, 5.4.1.1, 5.4.2.1

apply handlers, 8.1

outbound servers, B.3.3

apply process

Oracle Real Application Clusters, 3.7.1.4

trace files, 7.1.3.3

apply user, 3.3.3

XStream In, 10.5

ARCHIVELOG mode

capture process

Recovery Manager, 3.7.4

XStream Out, 4.1.2.4

B

buffered queues

Transparent Data Encryption, 3.7.2.3

C

capture process, 3.3

changes captured

DDL changes, B.1.2.3

NOLOGGING keyword, B.1.2.5

UNRECOVERABLE clause for SQL*Loader, B.1.2.6

UNRECOVERABLE SQL keyword, B.1.2.5

checkpoint retention time, 3.2.9.3

checkpoints, 3.2.9

fast recovery area, 3.7.4

maximum checkpoint SCN, 3.2.9.2

online redefinition, B.1.2.4

Oracle Label Security (OLS), B.1.5

Oracle Real Application Clusters, 3.7.1.1

Recovery Manager, 3.7.4

required checkpoint SCN, 3.2.9.1

schema restrictions, B.1.2.1

supplemental logging, 4.1.2.7

table type restrictions, B.1.2.2

trace files, 7.1.3.1

Transparent Data Encryption, 3.7.2.1

CDBs

XStream In, 8.6.4

XStream Out, 3.7.6

configuring, 4.2.4.1

configuring multiple, 4.2.4.2

character sets

SQL generation, 2.5.3

checkpoint retention time, 3.2.9.3

checkpoints, 3.2.9

client applications

XStream

example, A.1

commit_scn_from_position LCR attribute, 3.4.1

conflict resolution, 8.1

outbound server, B.3.3

connect user, 3.6.4

CREATE_INBOUND procedure, 9.2

CREATE_OUTBOUND procedure, 4.2.1

D

data types

SQL generation, 2.5.3

database links

XStream Out, 4.1.2.3

demos

file-based replication, 1.3.2.1

ID key LCRs, 3.2.2.1.1

SQL generation, 2.5.6

XStream, A.1

dependency scheduling

outbound servers, B.3.3

direct path load

capture processes, B.1.2.6

distributed transactions

XStream Out, 3.5

DROP SUPPLEMENTAL LOG DATA clause of ALTER DATABASE, 4.1.2.7.6

DROP SUPPLEMENTAL LOG GROUP clause, 4.1.2.7.4

DROP_INBOUND procedure, 10.7

DROP_OUTBOUND procedure, 5.6

E

eager errors, 10.6.3

eager_size apply parameter, 8.4.1

F

fast recovery area

capture processes, 3.7.4

flashback data archive

XStream In, 8.6.2

XStream Out, 3.7.3

G

GET_COMMA, 11.7.3

GET_DDL_TEXT member function, 11.7.3

GET_ERROR_MESSAGE function, 11.7.4, 11.7.5

GET_OBJECT_NAME member function, 11.7.3

GET_OBJECT_OWNER member function, 11.7.3

GET_SOURCE_DATABASE_NAME member function, 11.7.3

GET_VALUES member function, 11.7.3

I

ID key LCRs, 3.2.2.1

demo, 3.2.2.1.1

inbound server

data types, C.1.1

large transactions, 8.4.1

inbound servers, 8.2

applied high position, 8.3

applied low position, 8.3

apply user, 8.5

changing, 10.5

configuring, 9.2

DDL changes

current schema, C.1.4

ignored, C.1.3

dropping, 10.7

eager errors, 10.6.3

Oracle Label Security (OLS), C.1.5

positions, 8.3

monitoring, 11.5

preparing for, 9.1

processed low position, 8.3

spill position, 8.3

INCLUDE_EXTRA_ATTRIBUTE procedure, 7.2.4

initialization parameters

XStream In, 9.1.2

XStream Out, 4.1.2.5, 4.1.2.5

instantiation system change number, 3.3.6

IS_NULL_TAG member function, 11.7.3

K

keystores

XStream Out, 3.7.2.3

L

last sent position

monitoring, 6.3.3

logical change records (LCRs), 1.1

commit_scn_from_position attribute, 3.4.1

DDL LCRs

current_schema, C.1.4

getting information about, 11.7.3

ID key LCRs, 3.2.2.1

missing, 7.2.2

missing attributes, 7.2.4

scn_from_position attribute, 3.4.1

sequence LCRs, 2.1.4

M

max_parallelism apply parameter, 8.4.1

maximum checkpoint SCN, 3.2.9.2

multitenant architecture

XStream In, 8.6.4

XStream Out, 3.7.6

N

NOLOGGING mode

capture process, B.1.2.5

O

OCIXStreamOutAttach(), 7.2.1

online redefinition

capture process, B.1.2.4

ORA-03135 error, 12.2.2

Oracle Label Security (OLS)

capture processes, B.1.5

inbound servers, C.1.5

Oracle Real Application Clusters

interoperation with Oracle Streams, 3.7.1.1

interoperation with XStream In, 8.6.1

interoperation with XStream Out, 3.7.1.2, 3.7.1.4

queues, 3.7.1.2

Oracle Streams, 1.1

queues

Oracle Real Application Clusters, 3.7.1.2

Oracle Streams Performance Advisor

XStream, 2.4

outbound servers, 3.3

apply handlers, B.3.3

apply user, 3.3.3

capture processes, 3.3

configuration options, 4.1.1

configuring, 4.2

conflict resolution, B.3.3

connect user, 3.6, 3.6.4

changing, 5.2.4

data types, B.3.1

DDL changes

ignored, B.3.2

dependency scheduling, B.3.3

dropping, 5.6

monitoring, 6.3

preparing for, 4.1

processed low position, 3.4.2

monitoring, 6.3.5

rules

adding, 5.4.1

removing, 5.4.2

SET_ENQUEUE_DESTINATION procedure, B.3.3

SET_EXECUTE procedure, B.3.3

statistics

monitoring, 6.3.4

streaming network transmission, 3.4.3

substitute key columns, B.3.3

tags, B.3.3

transactions

monitoring, 6.3.3

P

PDBs

XStream In, 8.6.4

XStream Out, 3.7.6

configuring, 4.2.4.1

positions

applied high position, 8.3, 11.5

applied low position, 8.3, 11.5

processed low position, 3.4.2, 6.3.5, 8.3, 11.5

spill position, 8.3, 11.5

XStream, 2.1.5

XStream In, 8.3

monitoring, 11.5

XStream Out, 3.4

processed low position, 3.4.2

monitoring, 6.3.5

propagation, 3.3.1

propagations

queue-to-queue

Oracle Real Application Clusters, 3.7.1.2

Transparent Data Encryption, 3.7.2.2

Q

queues

Oracle Real Application Clusters, 3.7.1.2

R

Recovery Manager

capture processes

archived redo log files, 3.7.4

REMOVE_RULE procedure, 5.4.2.3

REMOVE_SUBSET_OUTBOUND_RULES procedure, 5.4.2.2

REMOVE_XSTREAM_ADM procedure, 5.7

replication

configuring

supplemental logging, 4.1.2.7

XStream, 1.3.1

required checkpoint SCN, 3.2.9.1

restrictions

XStream In, C

XStream Out, B

rule-based transformations, 1.1, 7.2.2, 8.1

restrictions, B.5

rules, 1.1, 8.1

restrictions, B.4

XStream

monitoring, 6.5

XStream Out, 5.4

custom conditions, 5.4.1.3

S

scn_from_position LCR attribute, 3.4.1

security

trusted user model, 1.5

untrusted user model, 1.5

XStream In, 8.5

component-level, 8.5.2

XStream Out, 3.6

client, 3.6.1

component-level, 3.6.2

sequence LCRs, 2.1.4

SET_ENQUEUE_DESTINATION procedure

outbound servers, B.3.3

SET_EXECUTE procedure

outbound servers, B.3.3

SET_MESSAGE_TRACKING procedure, 7.2.2

SET_TRIGGER_FIRING_PROPERTY procedure, 8.2.6

source database, 3.3

split and merge, 3.3.6

SQL generation

character sets, 2.5.4

data types, 2.5.3

examples, 2.5.5

XStream, 2.5

character sets, 2.5.3

demo, 2.5.6

formats, 2.5.2

interfaces, 2.5.1

SQL*Loader

capture processes, B.1.2.6

statistics

XStream Out, 6.3.4

Streams pool, 7.2.5

XStream In, 9.1.3

XStream Out, 4.1.2.6

substitute key columns

outbound servers, B.3.3

supplemental logging, 4.1.2.7

T

U

UNRECOVERABLE clause

SQL*Loader

capture process, B.1.2.6

UNRECOVERABLE SQL keyword

capture process, B.1.2.5

UTL_SPADV package

XStream, 2.4.4

V

V$PROPAGATION_RECEIVER view, 7.2.5

V$SESSION view, 6.2

V$STREAMS_CAPTURE view, 7.2.5

V$STREAMS_POOL_STATISTICS view, 7.2.5

V$XSTREAM_CAPTURE view, 7.2.2

V$XSTREAM_OUTBOUND_SERVER view, 6.3.3, 6.3.4, 6.3.6

X

XA interface, 3.5

XStream

client applications

example, A.1

configuring, 4, 9, A

demos, A.1

diagnosing problems, 7.1, 12.1

managing, 5, 10

overview, 5.1

monitoring, 6, 11

outbound servers, 6.3

rules, 6.5

Oracle Streams Performance Advisor, 2.4

positions, 2.1.5

security, 3.6, 8.5

session information, 6.2

SQL generation, 2.5

troubleshooting, 7, 12

client application, 7.2.1, 7.2.5

inbound servers, 12.2.1

missing LCR attributes, 7.2.4

missing LCRs, 7.2.2

ORA-03135 error, 12.2.2

use cases, 1.3

replication, 1.3.1

sharing data in files, 1.3.2

UTL_SPADV package, 2.4.4

XStream In

applied high position, 8.3

applied low position, 8.3

apply user, 10.5

configuring, 9.2

eager errors, 10.6.3

inbound servers, 8.2

initialization parameters, 9.1.2

position, 11.5

positions, 8.3

preparing for, 9.1

processed low position, 8.3

spill position, 8.3

Streams pool, 9.1.3

triggers, 8.2.6

XStream Out, 3.1

ARCHIVELOG mode, 4.1.2.4

configuration options, 4.1.1

configuring, 4.2

database links, 4.1.2.3

distributed transactions, 3.5

dropping components, 5.6, 10.7

ID key LCRs, 3.2.2.1

initialization parameters, 4.1.2.5, 4.1.2.5

monitoring, 6.3

outbound servers, 3.3

positions, 3.4

preparing for, 4.1

process, 6.3.6

processed low position, 3.4.2, 6.3.5

rules, 5.4

sequence LCRs, 2.1.4

statistics, 6.3.4

streaming network transmission, 3.4.3

Streams pool, 4.1.2.6

transactions, 6.3.3

XStream In, 8

flashback data archive, 8.6.2

interoperation with Oracle Real Application Clusters, 8.6.1

interoperation with transportable tablespaces, 8.6.3

large transactions, 8.4.1

restrictions, C

XStream Out, 3

flashback data archive, 3.7.3

propagation

Oracle Real Application Clusters, 3.7.1.2

removing configuration, 5.7

restrictions, B

rule restrictions, B.4

rule-based transformation restrictions, B.5

staging

Oracle Real Application Clusters, 3.7.1.2

Transparent Data Encryption, 3.7.2.3