Index

A

ADD_AUTO_CDR_COLUMN_GROUP procedure 13.3.1
ADD_AUTO_CDR_DELTA_RES procedure 13.3.2
ADD_AUTO_CDR procedure 13.3.1
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
ADD SUPPLEMENTAL LOG 4.1.2.7.2
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
ALL_APPLY_ERROR view 11.10.4, 11.10.5
ALL_APPLY view 6.4.2, 11.4
ALL_CAPTURE_EXTRA_ATTRIBUTES view 7.2.4
ALL_GG_AUTO_CDR_COLUMN_GROUPS view 13.5.3
ALL_GG_AUTO_CDR_COLUMNS view 13.5.2
ALL_GG_AUTO_CDR_TABLES view 13.5.1
ALL_PROPAGATION view 12.2.1
ALL_XSTREAM_INBOUND_PROGRESS view 11.6
ALL_XSTREAM_INBOUND view 11.2
ALL_XSTREAM_OUTBOUND_PROGRESS view 6.4.5
ALL_XSTREAM_OUTBOUND view 5.3.1, 6.4.1
ALTER_AUTO_CDR_COLUMN_GROUP procedure 13.4.2
ALTER_AUTO_CDR procedure 13.4.1
ALTER_INBOUND procedure 10.5
ALTER_OUTBOUND procedure 5.2.4, 5.4.1.1, 5.4.2.1
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
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
column groups 13.2.4
column lists 10.6.6.4
commit_scn_from_position LCR attribute 3.4.1
COMPARE_OLD_VALUES procedure 10.6.4.2
conflict resolution 8.1
- collision handling 10.6.6.7
- column lists 10.6.6.4
- conflict handlers 10.6.3, 10.6.4, 10.6.5, 10.6.6
  - custom 10.6.6.8
  - prebuilt 10.6.6.2
  - removing 10.6.7.2
  - setting 10.6.7.1
- data convergence 10.6.6.6
- IGNORE handler 10.6.6.3
- MAX_AND_EQUALS handler 10.6.6.3
- MAXIMUM handler 10.6.6.3
- MIN_AND_EQUALS handler 10.6.6.3
- MINIMUM handler 10.6.6.3
- outbound server B.3.3
- OVERWRITE handler 10.6.6.3
- resolution columns 10.6.6.5
conflicts 10.6
- avoidance 10.6.5
  - delete 10.6.5.2.2
  - primary database ownership 10.6.5.1
  - sequences 10.6.5.2.1
  - uniqueness 10.6.5.2.1
  - update 10.6.5.2.3
- delete 10.6.2.3
- detection 10.6.4
  - identifying rows 10.6.4.3
  - stopping 10.6.4.2, 10.6.8
- DML conflicts 10.6.1
- foreign key 10.6.2.4
- transaction ordering 10.6.3
- types of 10.6.2
- uniqueness 10.6.2.2
- update 10.6.2.1, 10.6.2.2, 10.6.2.3, 10.6.2.4
connect user 3.6.4
CREATE_INBOUND procedure 9.2
CREATE_OUTBOUND procedure 4.2.1

D

database links
- XStream Out 4.1.2.3
data types
- SQL generation 2.5.3
DBA_APPLY_DML_CONF_HANDLERS view 11.7
DBA_APPLY_REPERROR_HANDLERS view 11.8
DBA_GG_PROC_OBJECT_EXCLUSION view 14.4, 14.4.3
DBA_GG_PROCEDURE_ANNOTATION view 14.4
DBA_GG_SUPPORTED_PACKAGES view 14.4, 14.4.1
DBA_GG_SUPPORTED_PROCEDURES view 14.4, 14.4.2
DBA_REPLICATION_PROCESS_EVENTS view 6.3, 11.3
DBMS_XSTREAM_ADM package 5.3.1
demos
- file-based replication 1.3.2.1
- ID key LCRs 3.2.2.2
- 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
DML conflict handlers 10.6.7.1, 10.6.7.2
- displaying information about 11.7
DROP_INBOUND procedure 10.9
DROP_OUTBOUND procedure 5.6
DROP SUPPLEMENTAL LOG DATA clause of ALTER DATABASE 4.1.2.7.6
DROP SUPPLEMENTAL LOG GROUP clause 4.1.2.7.4

E

eager_size apply parameter 8.4.1
eager errors 10.7.4
error handlers
- displaying information about 11.8
error handling 10.7.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.10.3
GET_DDL_TEXT member function 11.10.3
GET_ERROR_MESSAGE function 11.10.4, 11.10.5
GET_OBJECT_NAME member function 11.10.3
GET_OBJECT_OWNER member function 11.10.3
GET_SOURCE_DATABASE_NAME member function 11.10.3
GET_VALUES member function 11.10.3
GG_PROCEDURE_REPLICATION_ON procedure 14.2

H

HANDLE_COLLISIONS procedure 10.6.6.7

I

ID key LCRs 3.2.2.1
- demo 3.2.2.2
IGNORE conflict resolution handler 10.6.6.3
inbound servers 8.2
- applied high position 8.3
- applied low position 8.3
- apply user 8.5
  - changing 10.5
- configuring 9.2
- data types C.1.1
- DDL changes
  - current schema C.1.4
  - ignored C.1.3
- dropping 10.9
- eager errors 10.7.4
- large transactions 8.4.1
- Oracle Label Security (OLS) C.1.5
- positions 8.3
  - monitoring 11.6
- 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
INSERT_PROCREP_EXCLUSION_OBJ procedure 14.3
instantiation system change number 3.3.6
IS_NULL_TAG member function 11.10.3

K

keystores
- XStream Out 3.7.2.3

L

last sent position
- monitoring 6.4.3
LCRIDs 2.1.6
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.10.3
- ID key LCRs 3.2.2.1
- missing 7.2.2, 12.2.3
- missing attributes 7.2.4
- scn_from_position attribute 3.4.1
- sequence LCRs 2.1.4

M

MAX_AND_EQUALS conflict resolution handler 10.6.6.3
max_parallelism apply parameter 8.4.1
maximum checkpoint SCN 3.2.9.2
MAXIMUM conflict resolution handler 10.6.6.3
message_tracking_frequency apply parameter 12.2.3
MIN_AND_EQUALS conflict resolution handler 10.6.6.3
MINIMUM conflict resolution handler 10.6.6.3
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 GoldenGate 13.1
- conflict detection and resolution 13.2.1
  - column groups 13.2.4, 13.5.2, 13.5.3
  - delta 13.2.3
  - latest timestamp 13.2.2
  - piecewise LOB updates 13.2.4
  - tables configured for 13.5.1
- procedural replication 14, 14.2
  - excluding objects 14.3
- supported packages 14.4.1
- supported procedures 14.4.2, 14.4.3
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.4
- preparing for 4.1
- processed low position 3.4.2
  - monitoring 6.4.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.4.4
- streaming network transmission 3.4.3
- substitute key columns B.3.3
- tags B.3.3
- transactions
  - monitoring 6.4.3
OVERWRITE conflict resolution handler 10.6.6.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.6
- applied low position 8.3, 11.6
- processed low position 3.4.2, 6.4.5, 8.3, 11.6
- spill position 8.3, 11.6
- XStream 2.1.5
- XStream In 8.3
  - monitoring 11.6
- XStream Out 3.4
processed low position 3.4.2
- monitoring 6.4.5
propagations 3.3.1
- queue-to-queue
  - Oracle Real Application Clusters 3.7.1.2
- Transparent Data Encryption 3.7.2.2
PURGE_TOMBSTONES procedure 13.4.3

Q

queues
- Oracle Real Application Clusters 3.7.1.2

R

Recovery Manager
- capture processes
  - archived redo log files 3.7.4
REMOVE_AUTO_CDR_COLUMN_GROUP procedure 13.4.5
REMOVE_AUTO_CDR_DELTA_RES procedure 13.4.6
REMOVE_AUTO_CDR procedure 13.4.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
- sequences 10.6.5.2.1
- XStream 1.3.1
required checkpoint SCN 3.2.9.1
resolution columns 10.6.6.5
restrictions
- XStream In C
- XStream Out B
rule-based transformations 1.1, 7.2.2, 8.1, 12.2.3
- restrictions B.5
rules 1.1, 8.1
- restrictions B.4
- XStream
  - monitoring 6.6
- 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
sequences 10.6.5.2.1
- replication 10.6.5.2.1
SET_DML_CONFLICT_HANDLER procedure 10.6.6.2
SET_DML_HANDLER procedure 10.6.6.8
SET_ENQUEUE_DESTINATION procedure
- outbound servers B.3.3
SET_EXECUTE procedure
- outbound servers B.3.3
SET_MESSAGE_TRACKING procedure 7.2.2, 12.2.3
SET_REPERROR_HANDLER procedure 10.7.1
SET_TRIGGER_FIRING_PROPERTY procedure 8.2.6
source database 3.3
split and merge 3.3.6
SQL*Loader
- capture processes B.1.2.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
statistics
- XStream Out 6.4.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
- column lists 10.6.6.4

T

tags
- outbound server B.3.3
Transparent Data Encryption
- buffered queues 3.7.2.3
- capture processes 3.7.2.1
- propagations 3.7.2.2
transportable tablespaces
- interoperation with XStream In 8.6.3
triggers
- XStream In 8.2.6
troubleshooting
- XStream 7, 12

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, 12.2.3
V$XSTREAM_OUTBOUND_SERVER view 6.4.3, 6.4.4, 6.4.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
- event history 6.3, 11.3
- LCRIDs 2.1.6
- managing 5, 10
  - overview 5.1
- monitoring 6, 11
  - outbound servers 6.4
  - rules 6.6
- Oracle Streams Performance Advisor 2.4
- positions 2.1.5
- replication
  - sequences 10.6.5.2.1
- security 3.6, 8.5
- sequences 10.6.5.2.1
- 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, 12.2.3
  - 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
  - conflicts 10.6
  - eager errors 10.7.4
  - inbound servers 8.2
  - initialization parameters 9.1.2
  - position 11.6
  - 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.9
  - ID key LCRs 3.2.2.1
  - initialization parameters 4.1.2.5
  - monitoring 6.4
  - outbound servers 3.3
  - positions 3.4
  - preparing for 4.1
  - process 6.4.6
  - processed low position 3.4.2, 6.4.5
  - rules 5.4
  - sequence LCRs 2.1.4
  - statistics 6.4.4
  - streaming network transmission 3.4.3
  - Streams pool 4.1.2.6
  - transactions 6.4.3
XStream In 8
- conflicts 10.6
- 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-based transformation restrictions B.5
- rule restrictions B.4
- staging
  - Oracle Real Application Clusters 3.7.1.2
- Transparent Data Encryption 3.7.2.3