Skip Headers
Oracle® Streams Replication Administrator's Guide
10g Release 2 (10.2)

Part Number B14228-02
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
View PDF

Index

A  B  C  D  E  F  G  H  I  J  L  M  O  P  Q  R  S  T  V 

A

ABORT_GLOBAL_INSTANTIATION procedure, 10.2
ABORT_SCHEMA_INSTANTIATION procedure, 10.2
ABORT_TABLE_INSTANTIATION procedure, 10.2
ADD SUPPLEMENTAL LOG, 9.1.2.1
ADD SUPPLEMENTAL LOG DATA, 9.1.2.2
ADD SUPPLEMENTAL LOG DATA clause of ALTER DATABASE, 9.1.2.4
ADD SUPPLEMENTAL LOG DATA clause of ALTER TABLE, 20.4
ADD SUPPLEMENTAL LOG GROUP clause of ALTER TABLE
conditional log groups, 9.1.2.2
unconditional log groups, 9.1.2.1
alert log
Streams best practices, 14.2.7
ALTER DATABASE statement
ADD SUPPLEMENTAL LOG DATA clause, 9.1.2.4
DROP SUPPLEMENTAL LOG DATA clause, 9.1.2.5
ALTER TABLE statement
ADD SUPPLEMENTAL LOG DATA clause, 20.4
conditional log groups, 9.1.2.2
unconditional log groups, 9.1.2.1
ADD SUPPLEMENTAL LOG GROUP clause
conditional log groups, 9.1.2.2
unconditional log groups, 9.1.2.1
DROP SUPPLEMENTAL LOG GROUP clause, 9.1.2.3
ALTER_APPLY procedure
removing the DDL handler, 9.3.4.3
removing the tag value, 9.4.2.2
setting the DDL handler, 9.3.4.2
setting the tag value, 4.1, 4.4, 9.4.2.1
applied SCN, 1.4.8
apply process, 1.4
applied SCN, 1.4.8
apply handlers, 1.4.4.6
apply servers
troubleshooting, 13.2.3
apply user
best practices, 17.1.1
best practices
configuration, 17.2
operation, 17.3
conflict handlers, 1.4.4.6
conflict resolution, 1.4.4.5, 3
constraints, 1.4.4.1
contention, 13.2.1, 13.2.2
creating, 9.3.1
datatypes applied
heterogeneous environments, 5.1.2.2
DDL changes, 1.4.5
CREATE TABLE AS SELECT, 1.4.5.5
current schema, 1.4.5.3
data structures, 1.4.5.2
ignored, 1.4.5.1
system-generated names, 1.4.5.4
DDL handlers, 1.4.2.2
creating, 9.3.4.1
monitoring, 12.2.2.2
removing, 9.3.4.3
setting, 9.3.4.2
dependencies, 1.4.3
barrier transactions, 1.4.3.6
troubleshooting, 13.2.2
virtual dependency definitions, 1.4.3.5, 9.3.5, 12.2.3
DML changes, 1.4.4
heterogeneous environments, 5.1.2.3
DML handlers, 1.4.2.2
creating, 9.3.3.1
heterogeneous environments, 5.1.2.1.4
monitoring, 12.2.2.1
setting, 9.3.3.2
error handlers, 1.4.2.2
heterogeneous, 5.1.2.1.6
errors
best practices, 17.2.2, 17.3.1
heterogeneous environments, 5.1.2, 5.2.3
database links, 5.1.2.1.1
example, 19.4.1
high-watermark, 1.4.8
ignore SCN, 1.4.6
index-organized tables, 1.4.4.4
instantiation SCN, 1.4.6
key columns, 1.4.4.1
LOBs, 11.4.1
low-watermark, 1.4.8
managing, 9.3
message handlers
heterogeneous environments, 5.1.2.1.5
monitoring, 12.2
apply handlers, 12.2.2
oldest SCN, 1.4.7
point-in-time recovery, 9.7.3
parallelism
best practices, 17.2.1
parameters
commit_serialization, 13.2.2
parallelism, 13.2.2
performance, 13.2.3
substitute key columns, 1.4.4.2
heterogeneous environments, 5.1.2.1.2, 5.1.2.1.3, 5.1.2.1.4, 5.1.2.1.5, 5.1.2.1.6
removing, 9.3.2.2
setting, 9.3.2.1
tables, 1.4.4
apply handlers, 1.4.4.6
column discrepancies, 1.4.4.3
tags, 4.4
monitoring, 12.3.2
removing, 9.4.2.2
setting, 9.4.2.1
triggers
firing property, 1.4.9
ON SCHEMA clause, 1.4.9
troubleshooting, 13
error queue, 13.2.4
update conflict handlers
monitoring, 12.2.5
ARCHIVELOG mode
capture process, 18.2, 19.2

B

backups
online
Streams, 4.3
Streams best practices, 14.2.4
batch processing
capture process best practices, 15.3.2
best practices
Streams replication, 13
alert log, 14.2.7
apply, 17
apply errors, 17.2.2, 17.3.1
apply process configuration, 17.2
apply process operation, 17.3
apply process parallelism, 17.2.1
apply user, 17.1.1
archive log threads, 14.3.1
automate configuration, 14.1.4
backups, 14.2.4
batch processing, 15.3.2
capture, 15
capture process configuration, 15.2
capture process operation, 15.3
capture process parallelism, 15.2.1
capture process queue, 14.2.3
checkpoint retention, 15.2.2
conflict resolution, 17.1.3
data dictionary build, 15.3.1
database configuration, 14.1
database operation, 14.2
DDL replication, 14.2.2
destination database, 17.1
global name, 14.2.1
heartbeat table, 15.1.3
instantiation SCN, 17.1.2
prepare for instantiation, 15.3.1
propagation, 16
propagation latency, 16.1.2
queue-to-queue propagation, 16.1.1
RAC databases, 14.3
removing, 14.2.8
restarting propagation, 16.2.1
SDU, 16.1.3
source database, 15.1
statistics collection, 14.2.5
storage, 14.1.2
Streams administrator, 14.1.3
STRMMON, 14.2.6
supplemental logging, 15.1.2
buffered queues, 1.3.1

C

capture process, 1.2.1
ARCHIVELOG mode, 18.2, 19.2
best practices
batch processing, 15.3.2
configuration, 15.2
data dictionary build, 15.3.1
operation, 15.3
prepare for instantiation, 15.3.1
creating, 9.1.1
DBID
changing, 9.5
global name
changing, 9.5
heterogeneous environments, 5.1.1
log sequence number
resetting, 9.7.1
parallelism
best practices, 15.2.1
supplemental logging, 1.2.1.2, 2.2.3
managing, 9.1.2
change cycling
avoidance
tags, 4.5
checkpoint retention
best practices, 15.2.2
column lists, 3.6.1.2
COMPARE_OLD_VALUES procedure, 3.4.1, 9.3.6.4
COMPATIBLE initialization parameter, 18.2, 19.2
conflict resolution, 3
best practices, 17.1.3
column lists, 3.6.1.2
conflict handlers, 3.3, 3.4, 3.5, 3.6
custom, 3.6.2
interaction with apply handlers, 1.4.4.6
modifying, 9.3.6.2
prebuilt, 3.6.1
removing, 9.3.6.3
setting, 9.3.6.1
data convergence, 3.6.1.4
DISCARD handler, 3.6.1.1.2
MAXIMUM handler, 3.6.1.1.3
example, 20.4
latest time, 3.6.1.1.3
MINIMUM handler, 3.6.1.1.4
OVERWRITE handler, 3.6.1.1.1
resolution columns, 3.6.1.3
time-based, 3.6.1.1.3
example, 20.4
preparing for, 20.3
conflicts
avoidance, 3.5
delete, 3.5.2.2
primary database ownership, 3.5.1
uniqueness, 3.5.2.1
update, 3.5.2.3
delete, 3.2.3
detection, 3.4
identifying rows, 3.4.2
monitoring, 12.2.4
stopping, 3.4.1, 9.3.6.4
DML conflicts, 3.1
foreign key, 3.2.4
transaction ordering, 3.3
types of, 3.2
uniqueness, 3.2.2
update, 3.2.1, 3.2.2, 3.2.3, 3.2.4
constructing
LCRs, 11.4.4
CREATE TABLE statement
AS SELECT
apply process, 1.4.5.5
CREATE_APPLY procedure
tags, 4.1, 4.4

D

datatypes
heterogeneous environments, 5.1.2.2
DBA_APPLY view, 12.2.2.2, 12.2.2.2, 12.3.2
DBA_APPLY_CONFLICT_COLUMNS view, 12.2.5
DBA_APPLY_DML_HANDLERS view, 12.2.2.1
DBA_APPLY_INSTANTIATED_OBJECTS view, 12.4.2
DBA_APPLY_KEY_COLUMNS view, 12.2.1
DBA_APPLY_TABLE_COLUMNS view, 12.2.4
DBA_CAPTURE_PREPARED_DATABASE view, 12.4.1
DBA_CAPTURE_PREPARED_SCHEMAS view, 12.4.1
DBA_CAPTURE_PREPARED_TABLES view, 12.4.1
DBA_LOG_GROUPS view, 12.1.1
DBA_RECOVERABLE_SCRIPT view, 13.1
DBA_RECOVERABLE_SCRIPT_BLOCKS view, 13.1
DBA_RECOVERABLE_SCRIPT_ERRORS view, 13.1
DBA_RECOVERABLE_SCRIPT_PARAMS view, 13.1
DBID (database identifier)
capture process
changing, 9.5
DBMS_STREAMS package, 9.4
DBMS_STREAMS_ADM package, 1.1.1
preparation for instantiation, 2.2.1
tags, 4.2
DDL handlers, 1.4.2.2
creating, 9.3.4.1
monitoring, 12.2.2.2
removing, 9.3.4.3
setting, 9.3.4.2
DDL replication
best practices, 14.2.2
dependencies
apply processes, 1.4.3
DISCARD conflict resolution handler, 3.6.1.1.2
DML handlers, 1.4.2.2, 1.4.4.6
creating, 9.3.3.1
LOB assembly, 11.4.2
monitoring, 12.2.2.1
setting, 9.3.3.2
unsetting, 9.3.3.3
DROP SUPPLEMENTAL LOG DATA clause of ALTER DATABASE, 9.1.2.5
DROP SUPPLEMENTAL LOG GROUP clause, 9.1.2.3

E

ENQUEUE procedure, 11.2
error handlers, 1.4.4.6
LOB assembly, 11.4.2
error queue
apply process, 13.2.4
heterogeneous environments, 5.1.5
EXECUTE member procedure, 9.3.3.1, 9.3.4.1
explicit capture, 1.2.2
Export
OBJECT_CONSISTENT parameter, 2.5.1, 10.3.3
Oracle Streams, 10.4.1

F

flashback queries
Streams replication, 12.5

G

GET_BASE_TABLE_NAME member function, 9.3.4.1
GET_COMMAND_TY, 9.3.4.1
GET_COMMIT_SCN member function, 9.3.3.1
GET_OBJECT_NAME member function, 9.3.3.1, 19.4.1
GET_OBJECT_OWNER member function, 9.3.3.1
GET_SCN member function, 9.3.3.1, 9.3.4.1
GET_SCN_MAPPING procedure, 9.7.2, 12.5
GET_SOURCE_DATABASE_NAME member function, 9.3.4.1
GET_TAG function, 9.4.1.2, 12.3.1
GET_TAG member function, 9.3.3.1, 9.3.4.1
GET_TRANSACTION_ID member function, 9.3.3.1, 9.3.4.1
GET_VALUES member function, 9.3.3.1
global name
best practices, 14.2.1
capture process
changing, 9.5
GLOBAL_NAMES initialization parameter, 18.2, 19.2

H

heartbeat table
Streams best practices, 15.1.3
heterogeneous information sharing, 5
non-Oracle to non-Oracle, 5.3
non-Oracle to Oracle, 5.2
apply process, 5.2.3
capturing changes, 5.2.1
instantiation, 5.2.4
user application, 5.2.1
Oracle to non-Oracle, 5.1
apply process, 5.1.2
capture process, 5.1.1
database links, 5.1.2.1.1
datatypes applied, 5.1.2.2
DML changes, 5.1.2.3
DML handlers, 5.1.2.1.4
error handlers, 5.1.2.1.6
errors, 5.1.5
instantiation, 5.1.2.4
message handlers, 5.1.2.1.5
staging, 5.1.1
substitute key columns, 5.1.2.1.2, 5.1.2.1.3, 5.1.2.1.4, 5.1.2.1.5, 5.1.2.1.6
transformations, 5.1.3
high-watermark, 1.4.8

I

ignore SCN, 1.4.6
Import
Oracle Streams, 10.4.1
STREAMS_CONFIGURATION parameter, 2.3.2.3, 2.5.2.2
STREAMS_INSTANTIATION parameter, 2.5.2.1, 10.3.3
index-organized tables
apply process, 1.4.4.4
instantiation, 2
aborting preparation, 10.2
Data Pump, 2.3
database, 10.3.4
example, 10.3, 19.4.1, 19.4.2, 20.4, 20.4
Data Pump export/import, 10.3.1
original export/import, 10.3.3
RMAN CONVERT DATABASE, 10.3.4.2
RMAN DUPLICATE, 10.3.4.1
RMAN TRANSPORT TABLESPACE, 10.3.2
transportable tablespace, 10.3.2
Export/Import, 2.5
heterogeneous environments
non-Oracle to Oracle, 5.2.4
Oracle to non-Oracle, 5.1.2.4
monitoring, 12.4
Oracle Streams, 10.4.1
preparation for, 2.2
preparing for, 2.1, 10.1
RMAN, 2.4
setting an SCN, 10.4
DDL LCRs, 10.4.2
export/import, 10.4.1
supplemental logging specifications, 2.1
instantiation SCN, 1.4.6
best practices, 17.1.2
IS_TRIGGER_FIRE_ONCE function, 1.4.9

J

JOB_QUEUE_PROCESSES initialization parameter, 18.2, 19.2

L

LCRs. See logical change records
LOB assembly, 11.4.2
LOBs
Oracle Streams, 11.4
apply process, 11.4.1
constructing, 11.4.4
log sequence number
Streams capture process, 9.7.1
logical change records (, 9.3.3.1
logical change records (LCRs)
constructing, 11.2
DDL LCRs
current_schema, 1.4.5.3
enqueuing, 11.2
executing, 11.3
DDL LCRs, 11.3.2
row LCRs, 11.3.1
getting information about, 9.3.4.1
LOB columns, 11.4, 11.4.4, 11.5
apply process, 11.4.1
requirements, 11.4.3
LONG columns, 11.5
requirements, 11.5
LONG RAW columns, 11.5
requirements, 11.5
managing, 11
requirements, 11.1
LONG datatype
Oracle Streams, 11.5
LONG RAW datatype
Oracle, 11.5
low-watermark, 1.4.8

M

MAINTAIN_GLOBAL procedure, 6.2, 6.2.2
MAINTAIN_SCHEMAS procedure, 6.2, 6.2.4
MAINTAIN_SIMPLE_TTS procedure, 6.2, 6.2.3, 6.2.3
MAINTAIN_TABLES procedure, 6.2, 6.2.5
MAINTAIN_TTS procedure, 6.2, 6.2.3, 6.2.3
MAXIMUM conflict resolution handler, 3.6.1.1.3
latest time, 3.6.1.1.3
MINIMUM conflict resolution handler, 3.6.1.1.4
monitoring
apply process, 12.2
apply handlers, 12.2.2
DDL handlers, 12.2.2.2
update conflict handlers, 12.2.5
conflict detection, 12.2.4
DML handlers, 12.2.2.1
instantiation, 12.4
Oracle Streams
replication, 12
STRMMON, 14.2.6
supplemental logging, 12.1
tags, 12.3
apply process value, 12.3.2
current session value, 12.3.1

O

OBJECT_CONSISTENT parameter
Export utility, 2.5.1, 10.3.3
oldest SCN, 1.4.7
point-in-time recovery, 9.7.3
ON SCHEMA clause
of CREATE TRIGGER
apply process, 1.4.9
optimizer
statistics collection
best practices, 14.2.5
ORA-01403 error, 13.2.4.2.2
ORA-23605 error, 13.2.4.2.3
ORA-23607 error, 13.2.4.2.4
ORA-24031 error, 13.2.4.2.5
ORA-26687 error, 13.2.4.2.6
ORA-26688 error, 13.2.4.2.7
ORA-26689 error, 13.2.4.2.8
Oracle Data Pump
Import utility
STREAMS_CONFIGURATION parameter, 2.3.2.3
instantiations, 10.3.1
Streams instantiation, 2.3
Oracle Real Application Clusters
Streams best practices, 14.3
archive log threads, 14.3.1
global name, 14.3.2
propagations, 14.3.3
queue ownership, 14.3.4
Oracle Streams
adding databases, 19.8
adding objects, 19.6
conflict resolution, 3
Export utility, 10.4.1
heterogeneous information sharing, 5
Import utility, 10.4.1
initialization parameters, 18.2, 19.2
instantiation, 2.1, 10.4.1
LOBs, 11.4
logical change records (LCRs)
managing, 11
LONG datatype, 11.5
migrating to from Advanced Replication, A
point-in-time recovery, 9.7
replication, 1, 8
adding databases, 8.2, 8.4
adding objects, 8.1, 8.3
best practices, 13
configuring, 6, 7
monitoring, 12
subsetting, 1.1.3
troubleshooting, 13
rules, 1.1.1
sample environments
replication, 18, 19, 20
supplemental logging, 1.2.1.2
managing, 9.1.2
tags, 4
OVERWRITE conflict resolution handler, 3.6.1.1.1

P

point-in-time recovery
Oracle Streams, 9.7
POST_INSTANTIATION_SETUP procedure, 6.2, 6.2.2, 6.2.3, 6.2.3
PRE_INSTANTIATION_SETUP procedure, 6.2, 6.2.2, 6.2.3, 6.2.3
PREPARE_GLOBAL_INSTANTIATION procedure, 2.2, 10.1
PREPARE_SCHEMA_INSTANTIATION procedure, 2.2, 10.1
PREPARE_TABLE_INSTANTIATION procedure, 2.2, 10.1
propagation
best practices, 16
broken propagations, 16.2.1
configuration, 16.1
propagation latency, 16.1.2
propagation operation, 16.2
queue-to-queue propagation, 16.1.1
restarting propagation, 16.2.1
SDU, 16.1.3
propagations, 1.3.2
creating, 9.2.2
database links
creating, 18.3, 19.3, 19.3, 19.8
queue-to-queue, 9.2.2

Q

queues
buffered queues, 1.3.1
commit-time, 5.2.2
growth
best practices, 14.2.3
transactional, 5.2.2
queue-to-queue propagation
best practices, 16.1.1

R

RECOVER_OPERATION procedure, 13.1
Recovery Manager
CONVERT DATABASE command
Streams instantiation, 10.3.4.2
DUPLICATE command
Streams instantiation, 10.3.4.1
Streams instantiation, 2.4
TRANSPORT TABLESPACE command
Streams instantiation, 10.3.2
replication, 8
adding databases, 8.2, 8.4, 19.8
adding objects, 8.1, 8.3, 19.6
configuration errors
recovering, 13.1
configuring, 6, 7
bi-directional, 6.2.1.1.3
database, 6.2.2
DBMS_STREAMS_ADM package, 6.2
DDL changes, 6.2.1.1.1
Enterprise Manager, 6.1
preparation, 6.2.1
schemas, 6.2.4
scripts, 6.2.1.1.4
tables, 6.2.5
tablespace, 6.2.3
heterogeneous single source example, 19
migrating to Streams, A
multiple source example, 20
Oracle Streams, 1
best practices, 13
simple single source example, 18
resolution columns, 3.6.1.3
rules, 1.1.1
system-created
subset, 1.1.3
tags, 4.2

S

SDU
Streams best practices, 16.1.3
SET_DML_HANDLER procedure, 3.6.2
setting a DML handler, 9.3.3.2
unsetting a DML handler, 9.3.3.3
SET_GLOBAL_INSTANTIATION_SCN procedure, 10.4, 10.4.2
SET_KEY_COLUMNS procedure, 1.4.4.2
removing substitute key columns, 9.3.2.2
setting substitute key columns, 9.3.2.1
SET_OBJECT_NAME member procedure, 19.4.1
SET_PARAMETER procedure
apply process, 13.2.2
SET_RULE_TRANSFORM_FUNCTION procedure, 19.4.1
SET_SCHEMA_INSTANTIATION_SCN procedure, 10.4, 10.4.2
SET_TABLE_INSTANTIATION_SCN procedure, 10.4
SET_TAG procedure, 4.1, 9.4.1.1
SET_TRIGGER_FIRING_PROPERTY procedure, 1.4.9
SET_UPDATE_CONFLICT_HANDLER procedure, 3.6.1
modifying an update conflict handler, 9.3.6.2
removing an update conflict handler, 9.3.6.3
setting an update conflict handler, 9.3.6.1
staging
buffered queues, 1.3.1
heterogeneous environments, 5.1.1
STREAMS_CONFIGURATION parameter
Data Pump Import utility, 2.3.2.3
Import utility, 2.3.2.3, 2.5.2.2
STREAMS_INSTANTIATION parameter
Import utility, 2.5.2.1, 10.3.3
STRMMON, 14.2.6
supplemental logging, 1.2.1.2
capture process
managing, 9.1.2
column lists, 3.6.1.2
conditional log groups, 1.2.1.2
DBA_LOG_GROUPS view, 12.1.1
example, 20.4
instantiation, 2.1
monitoring, 12.1
preparation for instantiation, 2.2.3, 10.1
Streams best practices, 15.1.2
unconditional log groups, 1.2.1.2
system change numbers (SCN)
applied SCN for an apply process, 1.4.8
oldest SCN for an apply process, 1.4.7
point-in-time recovery, 9.7.3
system-generated names
apply process, 1.4.5.4

T

tags, 4
ALTER_APPLY procedure, 4.1, 4.4
apply process, 4.4
change cycling
avoidance, 4.5
CREATE_APPLY procedure, 4.1, 4.4
examples, 4.5
getting value for current session, 9.4.1.2
managing, 9.4
monitoring, 12.3
apply process value, 12.3.2
current session value, 12.3.1
online backups, 4.3
removing value for apply process, 9.4.2.2
rules, 4.2
include_tagged_lcr parameter, 4.2
SET_TAG procedure, 4.1
setting value for apply process, 9.4.2.1
setting value for current session, 9.4.1.1
transformations
heterogeneous environments
Oracle to non-Oracle, 5.1.3
rule-based, 1.1.2
creating, 19.4.1
example, 19.4.1
transportable tablespace
Streams instantiation, 10.3.2
triggers
firing property, 1.4.9
system triggers
on SCHEMA, 1.4.9
troubleshooting
apply process, 13
error queue, 13.2.4
performance, 13.2.3
Oracle Streams
replication, 13

V

V$DATABASE view
supplemental logging, 12.1.2
V$STREAMS_APPLY_SERVER view, 13.2.3
V$STREAMS_TRANSACTION view, 10.1
virtual dependency definitions, 1.4.3.5
object dependencies, 1.4.3.5.2
managing, 9.3.5.2
monitoring, 12.2.3.2
value dependencies, 1.4.3.5.1
managing, 9.3.5.1
monitoring, 12.2.3.1