Skip Headers
Oracle® Database XStream Guide
12c Release 1 (12.1)

E17773-12
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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, 11.7
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
GET_DDL_TEXT member function, 11.7
GET_ERROR_MESSAGE function, 11.7, 11.7
GET_OBJECT_NAME member function, 11.7
GET_OBJECT_OWNER member function, 11.7
GET_SOURCE_DATABASE_NAME member function, 11.7
GET_VALUES member function, 11.7

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

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

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