Skip Headers
Oracle® Streams Concepts and Administration
10
g
Release 2 (10.2)
Part Number B14229-04
Home
Book List
Contents
Master Index
Contact Us
Previous
View PDF
Index
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
X
A
action contexts,
5.1.3
name-value pairs
adding,
14.2.2.3
,
15.2.1
,
15.2.2
altering,
14.2.2.2
removing,
14.2.2.4
,
15.2.2
querying,
15.2.1
system-created rules,
6.6
ADD_COLUMN member procedure,
27.4
ADD_COLUMN procedure,
15.1.1.2
ADD_GLOBAL_RULES procedure,
6.3.1
ADD_MESSAGE_RULE procedure,
12.3.3
ADD_PAIR member procedure,
14.2.2.2
,
14.2.2.3
,
15.2.1
,
15.2.2
,
28.2
,
28.4
,
28.5
,
28.7
ADD_RULE procedure,
5.1.2.2
,
14.1.2
ADD_SCHEMA_PROPAGATION_RULES procedure,
6.3.2
ADD_SUBSCRIBER procedure,
12.1.2
ADD_SUBSET_PROPAGATION_RULES procedure
row migration,
6.3.4.2
ADD_SUBSET_RULES procedure,
6.3
,
6.3.4
row migration,
6.3.4.2
ADD_TABLE_RULES procedure,
6.3.3
alert log
Oracle Streams entries,
18.5
ALTER_APPLY procedure
removing a rule set,
13.4.4
removing the message handler,
13.7.2
removing the precommit handler,
13.8.3
setting an apply user,
13.6
setting the message handler,
13.7.1
setting the precommit handler,
13.8.2
specifying a rule set,
13.4.1
ALTER_CAPTURE procedure
removing a rule set,
11.4.4
setting a capture user,
11.6
setting the first SCN,
11.10
,
11.11
specifying a rule set,
11.4.1
specifying database link use,
11.12
ALTER_PROPAGATION procedure
removing the rule set,
12.2.10
specifying the rule set,
12.2.5
ALTER_PROPAGATION_SCHEDULE procedure,
12.2.4
ALTER_RULE procedure,
14.2.2
ANYDATA datatype
queues,
3.5
,
12.3.1
creating,
12.1.1
dequeuing,
12.3.2
enqueuing,
12.3.1
monitoring,
21.1
removing,
12.1.4
wrapper for messages,
3.5
,
12.3.1
applications
upgrading
using Streams,
C.3
applied SCN,
2.9.1
,
20.12
apply forwarding,
3.3.4.1
apply handlers,
4.3.2.1.2
apply process,
4
apply forwarding,
3.3.4.1
apply handlers,
4.3.2.1.2
Java stored procedures,
4.3.2.4
apply servers,
4.7.1
states,
4.7.1.3
apply user,
4.1
privileges,
18.3.7
secure queues,
3.9.4.2
setting,
13.6
architecture,
4.7
automatic restart,
4.7.4.3
coordinator process,
4.7.1
states,
4.7.1.2
creating,
4.7.2
,
13.1
datatypes applied,
4.4
DDL handlers,
4.3.2
dependencies,
4.7.1
DML handlers,
4.3.2
creating,
27.4
dropping,
13.13
enqueuing messages,
13.9
monitoring,
22.13
error handlers
creating,
13.11.1
monitoring,
22.4.1
setting,
13.11.2
error queue,
4.7.7
monitoring,
22.15
,
22.16
logical change records (LCRs),
4.3.2.1
managing,
13
message handlers,
4.3.2
monitoring,
22.4.2
removing,
13.7.2
setting,
13.7.1
messages,
4.3
captured,
4.3.1
user-enqueued,
4.3.1
monitoring,
22
apply handlers,
22.4
compatible tables,
26.3
latency,
22.7
,
22.10
transactions,
22.9
non-LCR messages,
4.3.2.2
options,
4.3.2
Oracle Real Application Clusters,
4.6
parallelism,
22.12
parameters,
4.7.4
commit_serialization,
4.7.4.2
disable_on_error,
4.7.4.4
disable_on_limit,
4.7.4.3
parallelism,
4.7.4.1
setting,
13.5
time_limit,
4.7.4.3
transaction_limit,
4.7.4.3
txn_lcr_spill_threshold,
22.6
persistent status,
4.7.6
precommit handlers,
4.3.2.3
creating,
13.8.1
monitoring,
22.4.3
removing,
13.8.3
setting,
13.8.2
reader server,
4.7.1
states,
4.7.1.1
reenqueue captured messages,
27.4
RESTRICTED SESSION,
4.5
row subsetting,
6.3
supplemental logging,
6.3.4.3
rule sets
removing,
13.4.4
specifying,
13.4.1
rules,
4.2
,
6.1
adding,
13.4.2
removing,
13.4.3
specifying execution,
13.10
monitoring,
22.14
spilled messages,
22.6
starting,
13.2
stopping,
13.3
trace files,
18.5.3
transformations
rule-based,
7.3.3
troubleshooting,
18.3
checking apply handlers,
18.3.5
checking message type,
18.3.3
checking status,
18.3.1
error queue,
18.3.8
approximate CSCN,
3.8.2
AQ_TM_PROCESSES initialization parameter
Streams apply process,
18.3.6
ARCHIVELOG mode
capture process,
2.12.8
,
11.1.1
,
27.2
Recovery Manager,
2.12.8.1
ATTACH_TABLESPACES procedure,
16.1
B
buffered messaging,
3.6
buffered queues,
3.9.2
monitoring,
21.2
apply processes,
21.2.8
capture processes,
21.2.2
propagations,
21.2.3
,
21.2.4
,
21.2.5
,
21.2.6
,
21.2.7
BUILD procedure,
2.9.2
,
2.12.5.1
C
capture process,
2
applied SCN,
2.9.1
,
20.12
architecture,
2.12
ARCHIVELOG mode,
2.12.8
,
11.1.1
,
27.2
automatic restart,
2.12.9.2
builder server,
2.12.1
capture user
secure queues,
3.9.4.2
setting,
11.6
captured messages,
3.2
captured SCN,
2.9.1
changes captured,
2.5
DDL changes,
2.5.2
DML changes,
2.5.1
NOLOGGING keyword,
2.5.4
UNRECOVERABLE clause for SQL*Loader,
2.5.5
UNRECOVERABLE SQL keyword,
2.5.4
checkpoints,
2.12.4
managing retention time,
11.7
maximum checkpoint SCN,
2.12.4.2
required checkpoint SCN,
2.12.4.1
,
2.12.8
retention time,
2.12.4.3
creating,
2.12.5
,
11.1
datatypes captured,
2.4
DBID,
2.12.5
,
11.1
downstream capture,
2.8
advantages,
2.8.2.4
creating,
11.1
database link,
2.8.2.5
,
11.12
monitoring,
20.5
monitoring remote access,
26.1.2
dropping,
11.14
first SCN,
2.9.2
setting,
11.10
,
11.11
global name,
2.12.5
,
11.1
index-organized tables,
2.5.1
local capture,
2.8
advantages,
2.8.1.2
LogMiner,
2.12.3
data dictionary,
2.12.5.1
multiple sessions,
2.12.3
managing,
11
maximum checkpoint SCN,
2.12.4.2
,
2.12.5.1.2
monitoring,
20
applied SCN,
20.12
compatible tables,
26.3
downstream capture,
20.5
elapsed time,
20.4
last redo entry,
20.9
latency,
20.13
,
20.14
,
20.14
message creation time,
20.3
old log files,
20.8
registered log files,
20.6
,
20.8
required log files,
20.7
rule evaluations,
20.15
state change time,
20.3
online redefinition,
2.5.3
Oracle Real Application Clusters,
2.11
parameters,
2.12.9
disable_on_limit,
2.12.9.2
message_limit,
2.12.9.2
parallelism,
2.12.9.1
setting,
11.5
time_limit,
2.12.9.2
PAUSED FOR FLOW CONTROL state,
2.12.2
persistent status,
2.12.11
preparer servers,
2.12.1
preparing for,
11.1.1
reader server,
2.12.1
Recovery Manager,
2.12.8.1
flash recovery area,
18.1.3
redo logs,
2.1
adding manually,
11.9
missing files,
18.1.3
redo transport services,
2.8
required checkpoint SCN,
2.12.4.1
RESTRICTED SESSION,
2.10
rule evaluation,
2.12.10
rule sets
removing,
11.4.4
specifying,
11.4.1
rules,
2.3
,
6.1
adding,
11.4.2
removing,
11.4.3
SGA_MAX_SIZE initialization parameter,
2.12.3
start SCN,
2.9.2
starting,
11.2
states,
2.12.2
stopping,
11.3
supplemental logging,
2.6
specifying,
11.8
SYS schema,
2.3
,
2.5
SYSTEM schema,
2.3
,
2.5
trace files,
18.5.1
transformations
rule-based,
7.3.1
troubleshooting,
18.1
checking progress,
18.1.2
checking status,
18.1.1
captured SCN,
2.9.1
character sets
migrating
using Streams,
C.3
checkpoints,
2.12.4
retention time,
2.12.4.3
managing,
11.7
CLONE_TABLESPACES procedure,
16.1
CLOSE_ITERATOR procedure,
28.3
COMPATIBLE initialization parameter,
10.2
,
27.2
,
27.2
COMPATIBLE_10_1 function,
6.7.1.2
COMPATIBLE_9_2 function,
6.7.1.2
conditions
rules,
5.1.1
CREATE_APPLY procedure,
4.7.2
,
13.1
CREATE_CAPTURE procedure,
2.12.5
,
11.1
,
11.1.2.2
CREATE_PROPAGATION procedure,
12.2.1
CREATE_RULE procedure,
14.2.1
CREATE_RULE_SET procedure,
14.1.1
D
database links
Oracle Streams,
10.3
database maintenance
using Streams,
C
assumptions,
C.1.2
capture database,
C.1.1
instantiation,
C.2.5
job queue processes,
C.1.3
logical dependencies,
C.2.3.2
PL/SQL package subprograms,
C.1.3
user-created applications,
C.2.3
user-defined types,
C.2.2
datatypes
applied,
4.4
captured,
2.4
DBA_APPLY view,
18.3.1
,
18.3.3
,
22.1
,
22.2
,
22.4.2
,
22.5
,
22.11
DBA_APPLY_DML_HANDLERS view,
22.4.1
DBA_APPLY_ENQUEUE view,
22.13
DBA_APPLY_ERROR view,
22.15
,
22.16
,
22.16
,
22.16
DBA_APPLY_EXECUTE view,
22.14
DBA_APPLY_PARAMETERS view,
22.3
DBA_APPLY_PROGRESS view,
22.10
DBA_APPLY_SPILL_TXN view,
22.6
DBA_CAPTURE view,
18.1.1
,
20.1
,
20.5
,
20.6
,
20.7
,
20.8
,
20.12
DBA_CAPTURE_EXTRA_ATTRIBUTES view,
20.11
DBA_CAPTURE_PARAMETERS view,
20.10
DBA_EVALUATION_CONTEXT_TABLES view,
23.6
DBA_EVALUATION_CONTEXT_VARS view,
23.7
DBA_FILE_GROUP_EXPORT_INFO view,
25.2.3
DBA_FILE_GROUP_FILES view,
25.1.3
DBA_FILE_GROUP_TABLES view,
25.2.2
DBA_FILE_GROUP_TABLESPACES view,
25.2.1
DBA_FILE_GROUP_VERSOINS view,
25.1.2
DBA_FILE_GROUPS view,
25.1.1
DBA_LOGMNR_PURGED_LOG view,
2.9.2.3
,
2.12.8
DBA_PROPAGATION view,
18.2.1
,
18.2.2
,
21.2.3
,
21.2.4
,
21.2.5
,
21.2.6
,
21.3.1
,
21.3.2
,
21.3.3
,
21.3.4
,
21.3.5
DBA_QUEUE_SCHEDULES view,
21.3.4
,
21.3.5
DBA_QUEUE_TABLES view,
21.1.1
DBA_QUEUES view,
21.1.1
DBA_REGISTERED_ARCHIVED_LOG view,
20.6
,
20.7
,
20.8
DBA_RULE_SET_RULES view,
23.8
,
23.9
DBA_RULE_SETS view,
23.5
DBA_RULES view,
23.8
,
23.9
,
23.10
DBA_STREAMS_ADD_COLUMN view,
24.2.1
DBA_STREAMS_NEWLY_SUPPORTED view,
26.3.2
DBA_STREAMS_RENAME_TABLE view,
24.2.2
DBA_STREAMS_RULES view,
18.4.1
,
23.3
DBA_STREAMS_TRANSFORM_FUNCTION view,
24.3
DBA_STREAMS_TRANSFORMATIONS view,
24.1
,
24.2
DBA_STREAMS_UNSUPPORTED view,
26.3.1
DBID (database identifier)
capture process,
2.12.5
,
11.1
DBMS_APPLY_ADM package,
13
DBMS_CAPTURE_ADM package,
11
DBMS_PROPAGATION_ADM package,
12
starting a propagation,
12.2.2
stopping a propagation,
12.2.3
DBMS_RULE package,
5.2
,
28
DBMS_RULE_ADM package,
14
,
14.1
,
28
DBMS_STREAMS_ADM package,
6.3
,
11
,
12
,
13
creating a capture process,
2.12.5
,
11.1
creating a propagation,
12.2.1
creating an apply process,
4.7.2
,
13.1
DBMS_STREAMS_TABLESPACE_ADM package,
16.1
information provisioning,
8.2.3
platform conversion,
8.2.3.4
DDL handlers,
4.3.2
DELETE_ALL_ERRORS procedure,
13.12.2.2
DELETE_ERROR procedure,
4.7.7
,
13.12.2.1
dependencies
apply process,
4.7.1
queues,
3.8.1
dequeue high-watermark,
3.8.2
DEQUEUE procedure,
12.3.2
,
12.3.3
example,
27.4
destination queue,
3.1
DETACH_TABLESPACES procedure,
16.1
direct path load
capture processes,
2.5.5
directed networks,
3.3.4
apply forwarding,
3.3.4.1
queue forwarding,
3.3.4.1
DISABLE_DB_ACCESS procedure,
12.1.3
DML handlers,
4.3.2
,
27.4
DROP_APPLY procedure,
13.13
DROP_CAPTURE procedure,
11.14
DROP_PROPAGATION procedure,
12.2.11
DROP_RULE procedure,
14.2.4
DROP_RULE_SET procedure,
14.1.4
E
ENABLE_DB_ACCESS procedure,
12.1.2
ENQUEUE procedure,
12.3.1
,
12.3.3
error handlers
creating,
13.11.1
monitoring,
22.4.1
setting,
13.11.2
unsetting,
13.11.3
error queue,
4.7.7
apply process,
18.3.8
deleting errors,
13.12.2
executing errors,
13.12.1
monitoring,
22.15
,
22.16
EVALUATE procedure,
5.2
,
28.2
,
28.3
,
28.4
,
28.5
,
28.6
,
28.7
,
28.8
evaluation contexts,
5.1.2
association with rule sets,
5.1.2.2
association with rules,
5.1.2.2
evaluation function,
5.1.2.3
object privileges
granting,
14.3.2
revoking,
14.3.4
system privileges
granting,
14.3.1
revoking,
14.3.3
user-created,
6.7
,
6.7.2
variables,
5.1.2.1
event contexts
example,
28.8
system-created rules,
6.5
EXECUTE member procedure,
13.11.1
,
27.4
EXECUTE_ALL_ERRORS procedure,
13.12.1.2
EXECUTE_ERROR procedure,
4.7.7
,
13.12.1.1
explicit capture,
1.2.1
Export
Oracle Streams,
17.1
F
file group repositories,
8.2.3.1
monitoring,
25
,
25.1
using,
16.2
first SCN,
2.9.2
flash recovery area
capture processes
archived redo log files,
18.1.3
flow control,
2.12.2
G
GET_ALL_NAMES member function,
28.2
,
28.3
,
28.4
,
28.5
,
28.6
,
28.7
,
28.8
GET_COMMA,
22.16
GET_COMMAND_TYPE member function,
13.11.1
,
13.12.1.1.2
,
27.4
GET_COMPATIBLE member function,
6.7.1.2
GET_DDL_TEXT member function,
22.16
GET_ERROR_MESSAGE function,
22.16
,
22.16
GET_INFORMATION function,
13.11.1
GET_NEXT_HIT function,
5.2
,
28.3
GET_OBJECT_NAME member function,
13.11.1
,
13.12.1.1.2
,
15.2.1
,
22.16
GET_OBJECT_OWNER member function,
13.12.1.1.2
,
15.2.1
,
22.16
GET_SOURCE_DATABASE_NAME member function,
22.16
GET_STREAMS_NAME function,
13.11.1
GET_VALUE member function,
13.12.1.1.2
LCRs,
15.2.1
rules,
28.2
,
28.3
,
28.4
,
28.5
,
28.6
,
28.7
,
28.8
GET_VALUES member function,
13.11.1
,
22.16
,
27.4
global name
capture process,
2.12.5
,
11.1
GLOBAL_NAME view,
18.2.1
,
20.5
GLOBAL_NAMES initialization parameter,
10.2
,
27.2
GRANT_ADMIN_PRIVILEGE procedure,
10.1
GRANT_OBJECT_PRIVILEGE procedure,
5.3
GRANT_REMOTE_ADMIN_ACCESS procedure,
11.1.3.2
,
11.1.3.3.1
GRANT_SYSTEM_PRIVILEGE procedure,
5.3
grids
information provisioning,
8
H
high availability
Streams,
9
advantages,
9.2.1
apply,
9.3.2.4
best practices,
9.3
capture,
9.3.2.1
database links,
9.3.2.2
propagation,
9.3.2.3
I
implicit capture,
1.2.1
Import
Oracle Streams,
17.1
INCLUDE_EXTRA_ATTRIBUTE procedure,
2.2.3
,
11.13
index-organized tables
capture process,
2.5.1
information provisioning,
8
bulk provisioning,
8.2
Data Pump,
8.2.1
DBMS_STREAMS_TABLESPACE_ADM package,
8.2.3
file group repositories,
8.2.3.1
incremental provisioning,
8.3
on-demand information access,
8.4
RMAN
transportable tablespace from backup,
8.2.2
tablespace repositories,
8.2.3.2
using,
16
initialization parameters
AQ_TM_PROCESSES
Streams apply process,
18.3.6
COMPATIBLE,
10.2
GLOBAL_NAMES,
10.2
JOB_QUEUE_PROCESSES,
10.2
LOG_ARCHIVE_CONFIG,
10.2
LOG_ARCHIVE_DEST_
n
,
10.2
LOG_ARCHIVE_DEST_STATE_
n
,
10.2
OPEN_LINKS,
10.2
Oracle Streams,
10.2
PARALLEL_MAX_SERVERS,
10.2
PROCESSES,
10.2
SESSIONS,
10.2
SGA_MAX_SIZE,
10.2
,
10.2
SGA_TARGET,
10.2
SHARED_POOL_SIZE,
10.2
STREAMS_POOL_SIZE,
3.9.1
,
10.2
TIMED_STATISTICS,
10.2
UNDO_RETENTION,
10.2
instantiation
example
RMAN CONVERT DATABASE,
C.3.3.3
RMAN DUPLICATE,
B.3.3.2
,
C.3.3.2
export/import,
B.2.2
,
C.2.5
Data Pump and original,
2.7
in Streams,
2.7
RMAN CONVERT DATABASE,
C.2.5
RMAN DUPLICATE,
B.2.2
,
C.2.5
interoperability
Streams,
26.3.2
IS_NULL_TAG member function,
22.16
J
job queue processes
propagation jobs,
3.9.3
JOB_QUEUE_PROCESSES initialization parameter,
10.2
,
27.2
propagation,
18.2.3
L
LCRs.
See
logical change records
LOG_ARCHIVE_CONFIG initialization parameter,
10.2
LOG_ARCHIVE_DEST_
n
initialization parameter,
10.2
LOG_ARCHIVE_DEST_STATE_
n
initialization parameter,
10.2
logical change records (LCRs),
2.2
,
13.11.1
apply process,
4.3.2.1
DDL LCRs,
2.2.2
rules,
6.3.3.1.2
,
6.3.6.1.2
extra attributes,
2.2.3
managing,
11.13
monitoring,
20.11
getting information about,
15.2.1
,
22.16
compatibility,
6.7.1.2
row LCRs,
2.2.1
rules,
6.3.1.1
XML schema,
A
LogMiner
capture process,
2.12.3
multiple sessions,
2.12.3
M
MAINTAIN_GLOBAL procedure,
8.3
MAINTAIN_SCHEMAS procedure,
8.3
MAINTAIN_SIMPLE_TTS procedure,
8.3
MAINTAIN_TABLES procedure,
8.3
MAINTAIN_TTS procedure,
8.3
maximum checkpoint SCN,
2.12.5.1.2
message handlers,
4.3.2
monitoring,
22.4.2
messages
apply process,
4.3
captured,
3.2
dequeue,
3.2
enqueue,
3.2
propagation,
3.3
user-enqueued,
3.2
messaging,
3.5
,
12.3
ANYDATA queues,
12.3.1
buffered messaging,
3.6
dequeue,
12.3.3
enqueue,
12.3.3
messaging clients
example,
27.4
managing,
12.3.3
notifications
managing,
12.3.3
messaging client,
3.4
messaging client user
secure queues,
3.9.4.2
transformations
rule-based,
7.3.4
migrating
to different character set
using Streams,
C.3
to different operating system
using Streams,
C.3
monitoring
ANYDATA datatype queues,
21.1
message consumers,
21.1.4
viewing event contents,
21.1.5
apply process,
22
apply handlers,
22.4
compatible tables,
26.3
error handlers,
22.4.1
error queue,
22.15
,
22.16
message handlers,
22.4.2
capture process,
20
applied SCN,
20.12
compatible tables,
26.3
elapsed time,
20.4
latency,
20.13
,
20.14
,
20.14
message creation time,
20.3
rule evaluations,
20.15
state change time,
20.3
file group repositories,
25
Oracle Streams,
19
performance,
26.4
propagation jobs,
21.3
propagations,
21
,
21.3
queues,
21
rule-based transformations,
24
rules,
23
tablespace repositories,
25
multi-version data dictionary
missing,
18.4.1.5
N
NOLOGGING mode
capture process,
2.5.4
O
online redefinition
Streams,
2.5.3
OPEN_LINKS initialization parameter,
10.2
operating systems
migrating
using Streams,
C.3
ORA-01291 error,
18.1.3
ORA-06550 error,
18.3.7
ORA-24093 error,
18.2.4.1
ORA-25224 error,
18.2.4.2
ORA-26666 error,
18.3.1
ORA-26678 error,
18.1.5
Oracle Data Pump
information provisioning,
8.2.1
Oracle Enterprise Manager
Streams tool,
1.14.3
Oracle Real Application Clusters
interoperation with Oracle Streams,
2.11
,
3.7
,
4.6
queues,
3.7
Oracle Streams
administrator
configuring,
10.1
monitoring,
26.1.1
alert log,
18.5
ANYDATA queues,
12.3.1
apply process,
4
capture process,
2
compatibility,
6.7.1.2
,
26.3
data dictionary,
3.9.6
,
4.7.3
,
19
Data Pump,
2.7
database links,
10.3
database maintenance,
C
directed networks,
3.3.4
Export utility,
2.7
,
17.1
high availability,
9
Import utility,
2.7
,
17.1
information provisioning,
8.3
initialization parameters,
10.2
,
27.2
,
27.2
instantiation,
2.7
interoperability,
26.3.2
logical change records (LCRs),
2.2
XML schema,
A
LogMiner data dictionary,
2.12.5.1
messaging,
3.5
,
12.3
messaging clients,
3.4
monitoring,
19
network connectivity,
10.3
overview,
1.1
packages,
1.14.1
preparing for,
10
propagation,
3
Oracle Real Application Clusters,
3.7
queues
Oracle Real Application Clusters,
3.7
rules,
6
action context,
6.6
evaluation context,
6.3
,
6.4
event context,
6.5
subset rules,
6.3
,
6.3.4
system-created,
6.3
sample environments
single database,
27
staging,
3
Oracle Real Application Clusters,
3.7
Streams data dictionary,
2.12.7
Streams pool,
3.9.1
monitoring,
26.2
Streams tool,
1.14.3
supplemental logging,
2.6
tags,
1.11
trace files,
18.5
transformations
rule-based,
7
troubleshooting,
18
upgrading online,
B
user messages,
3.1
P
PARALLEL_MAX_SERVERS initialization parameter,
10.2
patches
applying
using Streams,
C.3
POST_INSTANTIATION_SETUP procedure,
8.3
PRE_INSTANTIATION_SETUP procedure,
8.3
precommit handlers,
4.3.2.3
creating,
13.8.1
monitoring,
22.4.3
removing,
13.8.3
setting,
13.8.2
privileges
Oracle Streams administrator,
10.1
monitoring,
26.1.1
rules,
5.3
PROCESSES initialization parameter,
10.2
propagation jobs,
3.9.3
altering,
12.2.4
job queue processes,
3.9.3
managing,
12.2
monitoring,
21.3
RESTRICTED SESSION,
3.9.3.2
scheduling,
3.9.3.1
trace files,
18.5.2
troubleshooting,
18.2
job queue processes,
18.2.3
propagations,
3
,
3.3
architecture,
3.9
binary files,
3.3.5
buffered queues,
3.9.2
creating,
12.2.1
destination queue,
3.1
directed networks,
3.3.4
dropping,
12.2.11
ensured delivery,
3.3.3
managing,
12.2
monitoring,
21
,
21.3
queue-to-queue,
3.3.2
,
3.3.2
,
21.3.1
Oracle Real Application Clusters,
3.7
propagation job,
3.9.3
schedule,
12.2.4.1
rule sets
removing,
12.2.10
specifying,
12.2.5
rules,
3.3.1
,
6.1
adding,
12.2.8
removing,
12.2.9
source queue,
3.1
starting,
12.2.2
stopping,
12.2.3
transformations
rule-based,
7.3.2
troubleshooting,
18.2
checking queues,
18.2.1
checking status,
18.2.2
security,
18.2.4
Q
queue forwarding,
3.3.4.1
queues
ANYDATA,
3.5
,
12.3.1
creating,
12.1.1
dequeuing,
27.4
removing,
12.1.4
browsing,
3.8.1.2
buffered,
3.9.2
commit-time,
3.8
dependencies,
3.8.1
dequeue high-watermark,
3.8.2
monitoring,
21
nontransactional,
3.9.5
Oracle Real Application Clusters,
3.7
queue tables,
3.9.2
triggers,
3.9.2
secure,
3.9.4
disabling user access,
12.1.3
enabling user access,
12.1.2
users,
3.9.4.2
transactional,
3.9.5
typed,
3.5
queue-to-queue propagations,
3.3.2
,
3.3.2
,
21.3.1
schedule,
12.2.4.1
R
RE$NAME_ARRAY type,
28.5
,
28.6
,
28.7
,
28.8
RE$NV_LIST type,
5.2
,
28.2
,
28.4
,
28.5
,
28.5
,
28.6
,
28.7
,
28.7
,
28.8
ADD_PAIR member procedure,
14.2.2.2
,
14.2.2.3
,
15.2.1
,
15.2.2
REMOVE_PAIR member procedure,
14.2.2.2
,
14.2.2.4
,
15.2.2
,
15.2.3
RE$RULE_HIT_LIST type,
28.2
,
28.4
,
28.5
,
28.6
,
28.7
,
28.8
RE$TABLE_ALIAS_LIST type,
28.5
,
28.6
,
28.7
,
28.8
RE$TABLE_VALUE type,
28.5
,
28.6
,
28.7
,
28.8
RE$TABLE_VALUE_LIST type,
28.5
,
28.6
,
28.7
,
28.8
RE$VARIABLE_TYPE_LIST type,
28.2
,
28.4
,
28.6
,
28.7
,
28.8
RE$VARIABLE_VALUE type,
28.2
,
28.3
,
28.4
,
28.6
RE$VARIABLE_VALUE_LIST type,
28.2
,
28.3
,
28.4
,
28.6
Recovery Manager
capture processes
archived redo log files,
2.12.8.1
flash recovery area,
18.1.3
CONVERT DATABASE command
Streams instantiation,
C.2.5
,
C.3.3.3
DUPLICATE command
Streams instantiation,
B.2.2
,
B.3.3.2
,
C.2.5
,
C.3.3.2
information provisioning,
8.2.2
redo logs
capture process,
2.1
reenqueue
captured messages,
27
REMOVE_PAIR member procedure,
14.2.2.2
,
14.2.2.4
,
15.2.2
,
15.2.2
,
15.2.3
REMOVE_QUEUE procedure,
12.1.4
REMOVE_RULE procedure,
11.4.3
,
12.2.9
,
13.4.3
,
14.1.3
RENAME_COLUMN procedure,
15.1.2
RENAME_TABLE procedure,
15.1.1.1
,
15.1.3
required checkpoint SCN,
2.12.8
RESTRICTED SESSION system privilege
apply processes,
4.5
capture processes,
2.10
propagation jobs,
3.9.3.2
REVOKE_OBJECT_PRIVILEGE procedure,
5.3
REVOKE_SYSTEM_PRIVILEGE procedure,
5.3
row migration,
6.3.4.2
,
6.3.4.2
rule sets,
5.1
adding rules to,
14.1.2
creating,
14.1.1
dropping,
14.1.4
evaluation,
5.2
partial,
5.2.2
negative,
6.2
object privileges
granting,
14.3.2
revoking,
14.3.4
positive,
6.2
removing rules from,
14.1.3
system privileges
granting,
14.3.1
revoking,
14.3.3
rule-based transformations,
7
custom,
7.2
action contexts,
7.2.1
altering,
15.2.2
creating,
15.2.1
managing,
15.2
monitoring,
24.3
privileges,
7.2.2
removing,
15.2.3
declarative,
7.1
adding,
15.1.1
managing,
15.1
monitoring,
24.2
removing,
15.1.3
step number,
7.4.1
troubleshooting,
18.4.2
managing,
15
monitoring,
24
ordering,
7.4
rules,
5
action contexts,
5.1.3
adding name-value pairs,
14.2.2.2
,
14.2.2.3
,
15.2.1
,
15.2.2
altering,
14.2.2.2
removing name-value pairs,
14.2.2.4
,
15.2.2
,
15.2.3
transformations,
7.2.1
ADD_RULE procedure,
5.1.2.2
altering,
14.2.2
apply process,
4.2
,
6.1
capture process,
2.3
,
6.1
components,
5.1
creating,
14.2.1
DBMS_RULE package,
5.2
DBMS_RULE_ADM package,
14
dropping,
14.2.4
EVALUATE procedure,
5.2
evaluation,
5.2
capture process,
2.12.10
iterators,
5.2
partial,
5.2.2
evaluation contexts,
5.1.2
evaluation function,
5.1.2.3
user-created,
6.7.2
variables,
5.1.2.1
event context,
5.2
example,
28.8
example applications,
28
explicit variables,
5.1.2.1
example,
28.2
,
28.6
implicit variables,
5.1.2.1
example,
28.7
iterative results,
5.2
example,
28.3
managing,
14.1
MAYBE rules,
5.2
example,
28.4
monitoring,
23
object privileges
granting,
14.3.2
revoking,
14.3.4
partial evaluation,
5.2.2
example,
28.4
privileges,
5.3
managing,
14.3
propagations,
3.3.1
,
6.1
rule conditions,
5.1.1
,
6.3.3
,
6.3.4
complex,
6.7.1.3
explicit variables,
5.1.2.1
finding patterns in,
23.10
implicit variables,
5.1.2.1
Streams compatibility,
6.7.1.2
types of operations,
6.7.1.1
undefined variables,
6.7.1.4
using NOT,
6.7.1.3.1
variables,
6.3.1.1
rule_hits,
5.2
simple rules,
5.1.1.2
subset,
6.3.4
querying for action context of,
15.2.1
querying for names of,
15.2.1
system privileges
granting,
14.3.1
revoking,
14.3.3
system-created,
6
,
6.3
action context,
6.6
and_condition parameter,
6.3.7
DDL rules,
6.3.3.1.2
,
6.3.6.1.2
DML rules,
6.3.1.1
evaluation context,
6.3
,
6.4
event context,
6.5
global,
6.3.1
modifying,
14.2.3
row migration,
6.3.4.2
schema,
6.3.2
STREAMS$EVALUATION_CONTEXT,
6.3
,
6.4
subset,
6.3
,
6.3.4
table,
6.3.3
table data
example,
28.5
,
28.6
,
28.7
troubleshooting,
18.4
TRUE rules,
5.2
user-created,
6.7
variables,
5.1.2.1
S
secure queues,
3.9.4
disabling user access,
12.1.3
enabling user access,
12.1.2
propagation,
18.2.4
Streams clients
users,
3.9.4.2
SESSIONS initialization parameter,
10.2
SET_COMMAND_TYPE member procedure,
27.4
SET_DML_HANDLER procedure,
4.3.2.1.2
setting an error handler,
13.11.2
unsetting an error handler,
13.11.3
SET_ENQUEUE_DESTINATION procedure,
13.9
,
27.4
SET_EXECUTE procedure,
13.10
SET_MESSAGE_NOTIFICATION procedure,
12.3.3
SET_OBJECT_NAME member procedure,
27.4
SET_PARAMETER procedure
apply process,
13.5
capture process,
11.5
SET_RULE_TRANSFORM_FUNCTION procedure,
15.2
SET_UP_QUEUE procedure,
12.1.1
SET_VALUE member procedure,
13.12.1.1.2
,
15.2.1
SET_VALUES member procedure,
13.11.1
,
13.11.1
,
27.4
SGA_MAX_SIZE initialization parameter,
2.12.3
,
10.2
,
10.2
SGA_TARGET initialization parameter,
10.2
SHARED_POOL_SIZE initialization parameter,
10.2
source queue,
3.1
SQL*Loader
capture processes,
2.5.5
staging,
3
approximate CSCN,
3.8.2
architecture,
3.9
buffered queues,
3.9.2
monitoring,
21.2
management,
12
messages,
3.2
secure queues,
3.9.4
disabling user access,
12.1.3
enabling user access,
12.1.2
start SCN,
2.9.2
START_APPLY procedure,
13.2
START_CAPTURE procedure,
11.2
START_PROPAGATION procedure,
12.2.2
Statspack
Oracle Streams,
26.4
STOP_APPLY procedure,
13.3
STOP_CAPTURE procedure,
11.3
STOP_PROPAGATION procedure,
12.2.3
Streams data dictionary,
2.12.7
,
3.9.6
,
4.7.3
Streams pool,
3.9.1
monitoring,
26.2
Streams.
See
Oracle Streams
Streams tool,
1.14.3
STREAMS$_EVALUATION_CONTEXT,
6.3
,
6.4
STREAMS$_TRANSFORM_FUNCTION,
7.2.1
STREAMS_POOL_SIZE initialization parameter,
3.9.1
,
10.2
supplemental logging
capture process,
2.6
row subsetting,
6.3.4.3
specifying,
11.8
SYS.AnyData.
See
ANYDATA datatype
system change numbers (SCN)
applied SCN for a capture process,
2.9.1
,
20.12
captured SCN for a capture process,
2.9.1
first SCN for a capture process,
2.9.2
maximum checkpoint SCN for a capture process,
2.12.4.2
required checkpoint SCN for a capture process,
2.12.4.1
start SCN for a capture process,
2.9.2
T
tablespace repositories,
8.2.3.2
creating,
16.1.1
monitoring,
25
,
25.2
using,
16.1
with shared file system,
16.1.2
without shared file system,
16.1.3
tags,
1.11
TIMED_STATISTICS initialization parameter,
10.2
trace files
Oracle Streams,
18.5
transformations
custom rule-based,
7.2
action context,
7.2.1
altering,
15.2.2
creating,
15.2.1
monitoring,
24.3
removing,
15.2.3
STREAMS$_TRANSFORM_FUNCTION,
7.2.1
troubleshooting,
18.4.3
declarative rule-based,
7.1
monitoring,
24.2
troubleshooting,
18.4.2
Oracle Streams,
7
rule-based,
7
apply process,
7.3.3
capture process,
7.3.1
errors during apply,
7.3.3.1
errors during capture,
7.3.1.1
errors during dequeue,
7.3.4.1
errors during propagation,
7.3.2.1
managing,
15
messaging client,
7.3.4
monitoring,
24
multiple,
7.3.5
propagations,
7.3.2
triggers
queue tables,
3.9.2
troubleshooting
apply process,
18.3
checking apply handlers,
18.3.5
checking message type,
18.3.3
checking status,
18.3.1
error queue,
18.3.8
capture process,
18.1
checking progress,
18.1.2
checking status,
18.1.1
custom rule-based transformations,
18.4.3
missing multi-version data dictionary,
18.4.1.5
Oracle Streams,
18
propagation jobs,
18.2
job queue processes,
18.2.3
propagations,
18.2
checking queues,
18.2.1
checking status,
18.2.2
security,
18.2.4
rules,
18.4
U
UNDO_RETENTION initialization parameter,
10.2
UNRECOVERABLE clause
SQL*Loader
capture process,
2.5.5
UNRECOVERABLE SQL keyword
capture process,
2.5.4
upgrading
online using Streams,
B
assumptions,
B.1.2
capture database,
B.1.1
instantiation,
B.2.2
job queue processes,
B.1.3
PL/SQL package subprograms,
B.1.3
user-defined types,
B.2.1
user messages,
3.1
V
V$ARCHIVED_LOG view,
2.9.2
V$BUFFERED_PUBLISHERS view,
21.2.2
V$BUFFERED_QUEUES view,
21.2.1
,
21.2.6
,
21.2.8
V$BUFFERED_SUBSCRIBERS view,
21.2.6
,
21.2.8
V$PROPAGATION_RECEIVER view,
21.2.7
V$PROPAGATION_SENDER view,
21.2.3
,
21.2.4
,
21.2.5
V$RULE view,
23.14
V$RULE_SET view,
23.12
,
23.13
V$RULE_SET_AGGREGATE_STATS view,
23.11
V$SESSION view,
20.2
,
22.5
,
22.7
,
22.8
,
22.11
V$STREAMS_APPLY_COORDINATOR view,
4.7.1.2
,
22.8
,
22.9
,
22.10
V$STREAMS_APPLY_READER view,
4.7.1.1
,
22.5
,
22.6
,
22.7
V$STREAMS_APPLY_SERVER view,
4.7.1.3
,
22.11
,
22.12
V$STREAMS_CAPTURE view,
2.12.2
,
18.1.2
,
20.2
,
20.3
,
20.4
,
20.9
,
20.13
,
20.14
,
20.14
,
20.15
V$STREAMS_POOL_ADVICE view,
3.9.1.2
,
26.2
X
XML Schema
for LCRs,
A
Scripting on this page enhances content navigation, but does not change the content in any way.