Streams Extended Examples
ContentsOpens a new window
Opens a new window
Page 11 of 11

Index

AOpens a new window  COpens a new window  DOpens a new window  EOpens a new window  GOpens a new window  IOpens a new window  LOpens a new window  MOpens a new window  NOpens a new window  OOpens a new window  POpens a new window  QOpens a new window  ROpens a new window  SOpens a new window  TOpens a new window 

A

ADOpens a new window  ALOpens a new window  APOpens a new window  AROpens a new window 
ADD_COLUMN member procedure, 4.4Opens a new window
ADD_PAIR member procedure, 6.2Opens a new window, 6.4Opens a new window, 6.5Opens a new window, 6.7Opens a new window
ALTER TABLE statement
ADD SUPPLEMENTAL LOG DATA clause, 3.5Opens a new window
apply process
DML handlers
creating, 4.4Opens a new window
heterogeneous environments
example, 2.4.1Opens a new window
reenqueue captured LCRs, 4.4Opens a new window
ARCHIVELOG mode
capture process, 1.2Opens a new window, 2.2Opens a new window, 4.2Opens a new window

C

CAOpens a new window  CLOpens a new window  COOpens a new window 
capture process
ARCHIVELOG mode, 1.2Opens a new window, 2.2Opens a new window, 4.2Opens a new window
CLOSE_ITERATOR procedure, 6.3Opens a new window
COMPATIBLE initialization parameter, 1.2Opens a new window, 2.2Opens a new window
conflict resolution
MAXIMUM handler
example, 3.5Opens a new window
time-based
example, 3.5Opens a new window
preparing for, 3.4Opens a new window
constructing
LCRs, 5Opens a new window

D

DBOpens a new window  DEOpens a new window  DMOpens a new window 
DBMS_RULE package, 6Opens a new window
DBMS_RULE_ADM package, 6Opens a new window
DEQUEUE procedure
example, 4.4Opens a new window
DML handlers, 4.4Opens a new window

E

EVOpens a new window  EXOpens a new window 
EVALUATE procedure, 6.2Opens a new window, 6.3Opens a new window, 6.4Opens a new window, 6.5Opens a new window, 6.6Opens a new window, 6.7Opens a new window, 6.8Opens a new window
event contexts
example, 6.8Opens a new window
EXECUTE member procedure, 4.4Opens a new window

G

GEOpens a new window  GLOpens a new window 
GET_ALL_NAMES member function, 6.2Opens a new window, 6.3Opens a new window, 6.4Opens a new window, 6.5Opens a new window, 6.6Opens a new window, 6.7Opens a new window, 6.8Opens a new window
GET_COMMAND_TYPE member function, 4.4Opens a new window
GET_NEXT_HIT function, 6.3Opens a new window
GET_OBJECT_NAME member function, 2.4.1Opens a new window
GET_VALUE member function
rules, 6.2Opens a new window, 6.3Opens a new window, 6.4Opens a new window, 6.5Opens a new window, 6.6Opens a new window, 6.7Opens a new window, 6.8Opens a new window
GET_VALUES member function, 4.4Opens a new window
GLOBAL_NAMES initialization parameter, 1.2Opens a new window, 2.2Opens a new window

I

INOpens a new window 
instantiation
example, 2.4.1Opens a new window, 2.4.2Opens a new window, 3.5Opens a new window, 3.5Opens a new window

L

LOOpens a new window 
LOBs
logical change records containing, 5Opens a new window
Oracle Streams
constructing, 5Opens a new window
logical change records
LOBs, 5Opens a new window
logical change records (LCRs)
LOB columns, 5Opens a new window

M

MEOpens a new window 
messaging client
example, 4.4Opens a new window

N

n-way replication
example, 3Opens a new window

O

OROpens a new window 
Oracle Streams
adding databases, 2.8Opens a new window
adding objects, 2.6Opens a new window
initialization parameters, 1.2Opens a new window, 2.2Opens a new window
sample environments
LOBs, 5Opens a new window
replication, 1Opens a new window, 2Opens a new window, 3Opens a new window
single database, 4Opens a new window

P

PROpens a new window 
propagations
database links
creating, 1.3Opens a new window, 2.3Opens a new window, 2.3Opens a new window, 2.8Opens a new window

Q

QUOpens a new window 
queues
ANYDATA
dequeuing, 4.4Opens a new window

R

REOpens a new window  RUOpens a new window 
RE$NAME_ARRAY type, 6.5Opens a new window, 6.6Opens a new window, 6.7Opens a new window, 6.8Opens a new window
RE$NV_LIST type, 6.2Opens a new window, 6.4Opens a new window, 6.5Opens a new window, 6.5Opens a new window, 6.6Opens a new window, 6.7Opens a new window, 6.7Opens a new window, 6.8Opens a new window
RE$RULE_HIT_LIST type, 6.2Opens a new window, 6.4Opens a new window, 6.5Opens a new window, 6.6Opens a new window, 6.7Opens a new window, 6.8Opens a new window
RE$TABLE_ALIAS_LIST type, 6.5Opens a new window, 6.6Opens a new window, 6.7Opens a new window, 6.8Opens a new window
RE$TABLE_VALUE type, 6.5Opens a new window, 6.6Opens a new window, 6.7Opens a new window, 6.8Opens a new window
RE$TABLE_VALUE_LIST type, 6.5Opens a new window, 6.6Opens a new window, 6.7Opens a new window, 6.8Opens a new window
RE$VARIABLE_TYPE_LIST type, 6.2Opens a new window, 6.4Opens a new window, 6.6Opens a new window, 6.7Opens a new window, 6.8Opens a new window
RE$VARIABLE_VALUE type, 6.2Opens a new window, 6.3Opens a new window, 6.4Opens a new window, 6.6Opens a new window
RE$VARIABLE_VALUE_LIST type, 6.2Opens a new window, 6.3Opens a new window, 6.4Opens a new window, 6.6Opens a new window
reenqueue
captured LCRs, 4Opens a new window
replication
adding databases, 2.8Opens a new window
adding objects, 2.6Opens a new window
heterogeneous single source example, 2Opens a new window
multiple-source example, 3Opens a new window
n-way example, 3Opens a new window
simple single source example, 1Opens a new window
rules
event context
example, 6.8Opens a new window
example applications, 6Opens a new window
explicit variables
example, 6.2Opens a new window, 6.6Opens a new window
implicit variables
example, 6.7Opens a new window
iterative results
example, 6.3Opens a new window
MAYBE rules
example, 6.4Opens a new window
partial evaluation
example, 6.4Opens a new window
table data
example, 6.5Opens a new window, 6.6Opens a new window, 6.7Opens a new window

S

SEOpens a new window  SUOpens a new window 
SET_COMMAND_TYPE member procedure, 4.4Opens a new window
SET_ENQUEUE_DESTINATION procedure, 4.4Opens a new window
SET_OBJECT_NAME member procedure, 2.4.1Opens a new window, 4.4Opens a new window
SET_RULE_TRANSFORM_FUNCTION procedure, 2.4.1Opens a new window
SET_VALUES member procedure, 4.4Opens a new window
supplemental logging
example, 3.5Opens a new window

T

TROpens a new window 
transformations
rule-based
creating, 2.4.1Opens a new window
example, 2.4.1Opens a new window
Previous PageOpens a new window
Page 11 of 11
Next Page