Oracle8i Generic Documentation Master Index
Release 2 (8.1.6)

A76991-01

Library

Product

Contents

Prev Up Next

Oracle8i Generic Documentation Master Index


R

R0703040.SQL script
replication, MIG 4-33, MIG 5-20
R070304.SQL script, SRF 5-7
Radicati, Sara, OID 2-34
RADIUS, OAS 1-8, GTK 3-72, SCN 285
accounting, OAS 4-22
asynchronous (challenge-response) authentication mode, OAS 4-6
authentication modes, OAS 4-5
authentication parameters, OAS B-6
challenge-response (asynchronous) authentication, OAS 4-6
challenge-response (asynchronous) authentication, customizing challenge-response user interface, OAS C-1, OAS D-1
Challenge-Response user interface, OAS C-2
configuring, OAS 4-10
customizing the Challenge-Response user interface, OAS C-2
location of secret key, OAS 4-17
smartcards and, OAS 1-8, OAS 4-5, OAS 4-8, OAS 4-18, OAS C-2
synchronous authentication mode, OAS 4-5
system requirements, OAS 1-13
Radius
sample for sqlnet.ora file, OAS A-3
RADIUS authentication method
see Oracle Advanced Security
RAID, OID 13-9, DWG 4-9, DWG 18-52, PSC 9-8
RAISE statement, ADG 9-44, PLS 6-11
syntax, PLS 11-138
using in exception handler, PLS 6-15
RAISE_APPLICATION_ERROR procedure, ADG 9-43
remote procedures, ADG 9-46
raise_application_error procedure, PLS 6-9
raising an exception, PLS 6-11
raising exceptions
triggers, ADG 13-18
random access, PSC 8-6
random reads, STU 20-5
random writes, STU 20-5
randomizing requests among listeners, NET 2-20, NET C-40, PSC 8-10
range
distribution value, STU 5-8
range conditions, SQL 5-18
range operator, PLS 3-10
range partition
adding, SQL 7-158
creating, SQL 7-403
range partitioning, DWG 5-5, GTK 3-45, SAD 15-3, SCN 11-13
and primary key columns, SCN 11-41
equipartitioning, SCN 11-24
key comparison, SCN 11-19, SCN 11-22
partition bounds, SCN 11-19
performance considerations, DWG 5-6
range partitions, STU 5-14
examples of, STU 5-14
RANK function, DWG 17-24, SQL 4-67
ranking functions, DWG 17-24
RATIO_TO_REPORT function, DWG 17-45, SQL 4-68
RAW
external datatype, OCI 3-15
maximum size
change, MIG 9-16
RAW data
converting from CHAR data, SQL 2-23
RAW datatype, ADG 3-20, PC_ 4-9, PLS 2-16, SCN 12-15, SQL 2-22, SUT 5-59, SUT 5-64
converting, PCO 4-49, PLS 2-30
external, PCO 4-8
maximum length, PLS 2-16
SQL*Loader, SUT 5-67
raw device, STU 23-2
raw devices
control files, PSG 2-6
creating, PSG 2-7
on UNIX, PSG 2-7
on Windows NT, PSG 2-9
creating as root user, PSG 2-7
data files, PSG 2-6
DRSYS tablespace, PSG 2-6
identifying on UNIX
control1 database object, PSG 2-8
control2 database object, PSG 2-8
drysys1 database object, PSG 2-8
indx1 database object, PSG 2-8
rbs1 database object, PSG 2-8
redothread_number database object, PSG 2-8
system1 database object, PSG 2-8
temp1 database object, PSG 2-8
tools1 database object, PSG 2-8
users1 database object, PSG 2-8
identifying on Windows NT
db_name_control1 symbolic link, PSG 1-14, PSG 2-10
db_name_control2 symbolic link, PSG 1-14, PSG 2-10
db_name_drsys1 symbolic link, PSG 1-13, PSG 2-10
db_name_indx1 symbolic link, PSG 1-13, PSG 2-10
db_name_rbs1 symbolic link, PSG 1-13, PSG 2-10
db_name_redothread_number symbolic link, PSG 1-13, PSG 2-10
db_name_system1 symbolic link, PSG 1-13, PSG 2-10
db_name_temp1 symbolic link, PSG 1-13, PSG 2-10
db_name_tools1 symbolic link, PSG 1-13, PSG 2-10
db_name_users1 symbolic link, PSG 1-13, PSG 2-10
INDX tablespace, PSG 2-6
RBS tablespace, PSG 2-6
redo log files, PSG 2-6
setting DBCA_RAW_CONFIG environment variable, PSG 2-9
setting up, PSG 2-5 to PSG 2-10
SYSTEM tablespace, PSG 2-6
TEMP tablespace, PSG 2-6
TOOLS tablespace, PSG 2-6
USERS tablespace, PSG 2-6
verification, PSG 3-5, PSG 3-7, PSG 3-23
raw partition
LOG_ARCHIVE_DEST initialization parameter, SRF 1-55
RAWTOHEX function, ADG 3-25, PCO 4-49, SCN 12-24, SQL 2-37, SQL 4-69
RBS tablespace
description, PSG 1-12
raw device, PSG 2-6
RC_ views, SRF 2-160
RC_ARCHIVED_LOG view, RMN 11-2
RC_BACKUP_CONTROLFILE view, RMN 11-3
RC_BACKUP_CORRUPTION view, RMN 11-5
RC_BACKUP_DATAFILE view, RMN 11-6
RC_BACKUP_PIECE view, RMN 11-8
RC_BACKUP_REDOLOG view, RMN 11-9
RC_BACKUP_SET view, RMN 11-11
RC_CHECKPOINT_VIEW, RMN 11-12
RC_CONTROLFILE_COPY view, RMN 11-13
RC_COPY_CORRUPTION view, RMN 11-14
RC_DATABASE view, RMN 11-15
RC_DATABASE_INCARNATION view, RMN 11-15
RC_DATAFILE view, RMN 11-16
RC_DATAFILE_COPY view, RMN 11-17
RC_LOG_HISTORY view, RMN 11-18
RC_OFFLINE_RANGE view, RMN 11-19
RC_PROXY_CONTROLFILE view, RMN 11-20
RC_PROXY_DATAFILE view, RMN 11-22
RC_REDO_LOG view, RMN 11-24
RC_REDO_THREAD view, RMN 11-24
RC_RESYNC view, RMN 11-25
RC_STORED_SCRIPT view, RMN 11-25
RC_STORED_SCRIPT_LINE view, RMN 11-26
RC_TABLESPACE view, RMN 11-26
RC4 encryption algorithm, OAS 1-4, OAS 2-4
RC4_128 encryption algorithm, OAS 2-4
RC4_40 encryption, OID 2-26
rcpt()
function of UTL_SMTP, SPR 65-7
RDB Database field, NET 8-52
RDB_DATABASE parameter, NET 8-9, NET 8-52, NET C-46
RDBMS, SCN 1-21
object-relational DBMS, SCN 1-21, SCN 13-2
See also Oracle
RDBMS_SERVER_DN, SRF 1-100
RDNs. See Relative Distinguished Names (RDNs)
reactive tuning, STU 2-3
read committed isolation, SCN 217, SCN 218
read consistency, PCO 3-12, PLS 5-42, SCN 212, SCN 214, STU 18-10
Cache Fusion, SCN 217
defined, SCN 1-30
definition of, PC_ 3-16
dirty read, SCN 213, SCN 221
Export utility, SBR 4-19
LOBs, ADL 5-2
managing in distributed databases, DDS 5-28
multiversion, PSC 1-4
multiversion consistency model, SCN 1-30, SCN 214
nonrepeatable read, SCN 213, SCN 221
Oracle Parallel Server, SCN 217
phantom read, SCN 213, SCN 221
queries, SCN 21, SCN 214
rollback information, PSC 7-6, SRF 1-42
rollback segments and, SCN 4-22
snapshot too old message, SCN 215
statement level, SCN 216
subqueries in DML, SCN 224
transactions, SCN 1-30, SCN 214, SCN 216
triggers and, SCN 102, SCN 104
read consistent locators, ADL 5-2, ADL 5-3, ADL 5-10, ADL 5-13, ADL 5-25, ADL 5-28, ADL 5-29, ADL 5-30
read lock modes, PSC 4-12
READ object privilege, SQL 7-535
READ ONLY clause
ALTER TABLESPACE, SCN 3-11
of ALTER TABLESPACE, SQL 7-181
of SET TRANSACTION, SQL 7-602
READ ONLY parameter, PLS 5-47
in SET TRANSACTION statement, PC_ 3-23
using in SET TRANSACTION, PCO 3-20
read snapshot time, SCN 221
read uncommitted, SCN 213
READ WRITE clause
ALTER TABLESPACE, SCN 3-11
of ALTER TABLESPACE, SQL 7-181
of SET TRANSACTION, SQL 7-603
read_line()
as a function of UTL_TCP, SPR 66-9
READ_ONLY_OPEN_DELAYED initialization parameter, SRF 1-101
read_raw()
as a function of UTL_TCP, SPR 66-6
read_text()
as a function of UTL_TCP, SPR 66-8
readability, PLS 2-2, PLS 3-19
readBoolean() - oracle.jms.AQjmsBytesMessage.readBoolean(), JPR 2-31
readBoolean() - oracle.jms.AQjmsStreamMessage.readBoolean(), JPR 2-187
READBUFFERS keyword
SQL*Loader, SUT 5-24, SUT 8-15
readByte() - oracle.jms.AQjmsBytesMessage.readByte(), JPR 2-31
readByte() - oracle.jms.AQjmsStreamMessage.readByte(), JPR 2-187
readBytes(byte[]) - oracle.jms.AQjmsBytesMessage.readBytes(byte[]), JPR 2-32
readBytes(byte[]) - oracle.jms.AQjmsStreamMessage.readBytes(byte[]), JPR 2-188
readBytes(byte[], int) - oracle.jms.AQjmsBytesMessage.readBytes(byte[], int), JPR 2-32
readChar() - oracle.jms.AQjmsBytesMessage.readChar(), JPR 2-33
readChar() - oracle.jms.AQjmsStreamMessage.readChar(), JPR 2-188
read-consistent export, SUT 1-17
readDouble() - oracle.jms.AQjmsBytesMessage.readDouble(), JPR 2-33
readDouble() - oracle.jms.AQjmsStreamMessage.readDouble(), JPR 2-188
readers block writers, SCN 221
reader/writer conflicts
and Cache Fusion, PSA 12-1
readFloat() - oracle.jms.AQjmsBytesMessage.readFloat(), JPR 2-34
readFloat() - oracle.jms.AQjmsStreamMessage.readFloat(), JPR 2-189
read-focused, directories as, OID 1-2
reading
BFILES
specify 4 Gb-1 regardless of LOB, ADL 11-99
data fom temporary LOB, ADL 10-57
data from a LOB
internal persistent LOBs, ADL 9-101
large amounts of LOB data using streaming, ADL 9-65
portion of BFILE data using substr, ADL 11-108
portion of LOB using substr
internal persistent LOBs, ADL 9-112
portion of temporary LOB, ADL 10-68
small amounts of data,enable buffering, ADL 9-237
readInt() - oracle.jms.AQjmsBytesMessage.readInt(), JPR 2-34
readInt() - oracle.jms.AQjmsStreamMessage.readInt(), JPR 2-189
readLong() - oracle.jms.AQjmsBytesMessage.readLong(), JPR 2-35
readLong() - oracle.jms.AQjmsStreamMessage.readLong(), JPR 2-190
readObject() - oracle.jms.AQjmsStreamMessage.readObject(), JPR 2-190
read-only
databases
opening, SCN 5-9
tablespaces, SCN 3-11
backing up, SCN 367
restrictions on, SCN 3-12
transition read-only mode, SCN 3-11
transactions, SCN 1-31
read-only access, PSC 1-4, PSC 4-12
applications, PSC 8-6
index data, PSA 7-14
read PCM locks, PSC 4-12
read-only database
opening, SAD 3-9
read-only databases, GTK 3-51
read-only mode
standby databases, SBY 1-10, SBY 3-17
read-only response
two-phase commit, DDS 4-12
read-only snapshots, REP 1-7, REP 3-8, SCN 427
registration
manual, REP 3-17
unregistering, REP 3-17
read-only tables, PSA 5-3
read-only tablespaces
active transactions, MIG 9-24
backing up, RMN 5-16
compatibility, MIG 9-24
datafiles, SAD 10-8
effect on recovery, SBR 5-4
Import, SUT 2-51
migration, MIG 4-4
recovering, SBR 5-4
read-only tablespaces, see tablespaces, read-only
read-only transaction, PCO 3-20, PLS 5-47
ending, PCO 3-20
example, PCO 3-20
read-only transactions, ADG 7-8
description of, PC_ 3-23
example of, PC_ 3-23
how ended, PC_ 3-23
reads
data block
limits on, SCN 296
dirty, SCN 213
repeatable, SCN 216
readShort() - oracle.jms.AQjmsBytesMessage.readShort(), JPR 2-35
readShort() - oracle.jms.AQjmsStreamMessage.readShort(), JPR 2-191
READSIZE
SQL*Loader command-line parameter, SUT 6-7
readString() - oracle.jms.AQjmsStreamMessage.readString(), JPR 2-191
readUnsignedByte() - oracle.jms.AQjmsBytesMessage.readUnsignedByte(), JPR 2-35
readUnsignedShort() - oracle.jms.AQjmsBytesMessage.readUnsignedShort(), JPR 2-36
readUTF() - oracle.jms.AQjmsBytesMessage.readUTF(), JPR 2-36
read/write operations, STU 20-5
REAL datatype
ANSI, SQL 2-28
REAL keyword
behavior in Oracle7 and Oracle8i, MIG 9-23
real REF columns, SUT 5-97
REAL subtype, PLS 2-14
realm (CyberSafe), OAS 5-3
realm (Kerberos), OAS 6-3
reauthenticating clients, ADG 11-67, ADG 11-68, ADG 11-71
reblocking, DDS 9-11
REBUILD clause
of ALTER INDEX, SQL 7-32, SQL 7-37
of ALTER OUTLINE, SQL 7-63
REBUILD COMPRESS clause
of ALTER INDEX, SQL 7-39
REBUILD COMPUTE STATISTICS clause
of ALTER INDEX, SQL 7-39
REBUILD INDEX PARTITION statement, SCN 11-60
no-logging mode, SCN 151
rules of parallelism, SCN 181
REBUILD INDEX statement
no-logging mode, SCN 11-58, SCN 151
rules of parallelism, SCN 181
REBUILD LOGGING clause
of ALTER INDEX, SQL 7-39
REBUILD NOCOMPRESS clause
of ALTER INDEX, SQL 7-39
REBUILD NOLOGGING clause
of ALTER INDEX, SQL 7-39
REBUILD NOREVERSE clause
of ALTER INDEX, SQL 7-38
REBUILD ONLINE clause
of ALTER INDEX, SQL 7-39
REBUILD PARAMETERS clause
of ALTER INDEX, SQL 7-40
REBUILD PARTITION clause, SAD 15-26, SAD 15-27
of ALTER INDEX, SQL 7-38
REBUILD REVERSE clause
of ALTER INDEX, SQL 7-38
REBUILD statement, STU 12-9
REBUILD SUBPARTITION clause, SAD 15-27
of ALTER INDEX, SQL 7-38
REBUILD TABLESPACE clause
of ALTER INDEX, SQL 7-38
REBUILD UNUSABLE LOCAL INDEXES clause, SAD 15-28
of ALTER TABLE, SQL 7-157
REBUILD_FREELISTS procedure, SAD 20-3, SAD 20-6, SAD 20-8
example, SAD 20-13
rebuilding indexes
physical ROWIDs, MIG 12-8
RECALCULATE_STATISTICS parameter, SUT 2-25
receive() - oracle.jms.AQjmsConsumer.receive(), JPR 2-60
receive(long) - oracle.jms.AQjmsConsumer.receive(long), JPR 2-60
receiveNoData() - oracle.jms.AQjmsConsumer.receiveNoData(), JPR 2-61
receiveNoData() - oracle.jms.AQjmsQueueReceiver.receiveNoData(), JPR 2-154
receiveNoData() - oracle.jms.AQjmsTopicReceiver.receiveNoData(), JPR 2-208
receiveNoData() - oracle.jms.AQjmsTopicSubscriber.receiveNoData(), JPR 2-211
receiveNoData(long) - oracle.jms.AQjmsConsumer.receiveNoData(long), JPR 2-61
receiveNoData(long) - oracle.jms.AQjmsQueueReceiver.receiveNoData(long), JPR 2-154
receiveNoData(long) - oracle.jms.AQjmsTopicReceiver.receiveNoData(long), JPR 2-208
receiveNoData(long) - oracle.jms.AQjmsTopicSubscriber.receiveNoData(long), JPR 2-211
receiveNoWait() - oracle.jms.AQjmsConsumer.receiveNoWait(), JPR 2-62
receiver
registering, RAR 2-5
replication, REP 2-12
Receiving Messages, ADQ 12-71
Recipient list length limit, ADQ 6-3
Recipient Lists, ADQ 8-36, ADQ 12-53
Recipients, ADQ 1-18
recipients, SCN 71
subscription lists, SCN 71
Recipients, Local and Remote, ADQ 8-63
Recipients, Multiple, ADQ 8-61
RECNUM keyword
SQL*Loader, SUT 5-47
use with SQL*Loader keyword SKIP, SUT 5-55
RECOMMEND_MV function, DWG 15-5
RECOMMEND_MV_W function, DWG 15-5
recompiling
stored functions, procedures, and packages, SUT 2-58
record, PC_ 7-5
RECORD datatype, PLS 4-42
record keeping, STU 2-15
RECORD parameter, SUT 1-23
record, user-defined, PCO 6-6
recording statistics
for tuning, PSA 11-5
RECORDLENGTH
Export parameter, SUT 1-24
direct path export, SUT 1-44
Import parameter, SUT 2-26
records, PLS 4-42
%ROWTYPE, PLS 5-13
assigning, PLS 4-47
comparing, PLS 4-49
consolidating into a single logical record
SQL*Loader, SUT 5-36
declaring, PLS 4-43
defining, PLS 4-42
discarded by SQL*Loader, SUT 3-11, SUT 5-27
DISCARDFILE command-line parameter, SUT 6-5
DISCARDMAX command-line parameter, SUT 6-5
distinguishing different formats for SQL*Loader, SUT 5-52
extracting multiple logical records using SQL*Loader, SUT 5-51
fixed format, SUT 3-4
implicit declaration, PLS 5-13
initializing, PLS 4-44
manipulating, PLS 4-49
missing data columns during load, SUT 5-43
nesting, PLS 4-43
null columns at end, SUT 5-81
referencing, PLS 4-45
rejected by SQL*Loader, SUT 3-11, SUT 3-13, SUT 5-25
restrictions in SQL*Loader, SUT 3-17
setting column to record number with SQL*Loader, SUT 5-55
skipping during load, SUT 6-9
specifying how to load, SUT 6-6
specifying length for export, SUT 1-24, SUT 2-26
specifying length for import, SUT 2-26
stream format, SUT 3-17
stream record format, SUT 3-6
syntax, PLS 11-140
variable format, SUT 3-5, SUT 3-17
RECOVER ... FROM option
ALTER DATABASE statement, SBR 5-6, SBR 5-10
RECOVER AUTOMATIC clause
of ALTER DATABASE, SQL 7-13
RECOVER AUTOMATIC LOGFILE option
ALTER DATABASE statement, SBR 5-13
RECOVER CANCEL clause
of ALTER DATABASE, SQL 7-7, SQL 7-14
RECOVER clause
of ALTER DATABASE, SQL 7-7, SQL 7-12
RECOVER command, PSA 4-6, PSA 14-7, PSA 14-13, PSA 14-16
recover command (RMAN), RMN 1-61, RMN 6-18, RMN 10-96
RECOVER CONTINUE clause
of ALTER DATABASE, SQL 7-7, SQL 7-14
RECOVER DATABASE clause
of ALTER DATABASE, SQL 7-7, SQL 7-13
RECOVER DATABASE statement, PSA 14-7
RECOVER DATAFILE clause
of ALTER DATABASE, SQL 7-7, SQL 7-14
RECOVER DATAFILE statement, PSA 14-7
RECOVER LOGFILE clause
of ALTER DATABASE, SQL 7-7, SQL 7-14
RECOVER MANAGED STANDBY DATABASE clause
of ALTER DATABASE, SQL 7-8
RECOVER option
STARTUP statement, SAD 3-6
RECOVER STANDBY DATABASE clause
of ALTER DATABASE, SQL 7-13
RECOVER STANDBY DATAFILE clause
of ALTER DATABASE, SQL 7-14
RECOVER STANDBY TABLESPACE clause
of ALTER DATABASE, SQL 7-14
RECOVER statement
DATABASE option, SBR 5-8
DATAFILE option, SBR 5-8
FROM 'location' clause, SBY 4-15
PARALLEL clause, STU 24-15
specifying the TIMEOUT option, SBY 5-13
TABLESPACE option, SBR 5-8
unrecoverable objects and standby databases, SBR 5-3
UNTIL TIME option, SBR 5-30
RECOVER TABLESPACE clause
of ALTER DATABASE, SQL 7-7, SQL 7-14
RECOVER TABLESPACE statement, PSA 14-7
recoverability and availability enhancements
multiple ARCH processes, GTK 3-50
multiple, remote archive destinations, GTK 3-50
see also automated standby databases
RECOVERABLE, SQL 7-37, SQL 7-396
See also LOGGING clause
recoverable save set, LEG 2-8
recovered tablespaces
backing up, SBR 7-14
recoverer process, SAD 4-12
recoverer process (RECO), SCN 1-18, SCN 8-12
disabling, DDS 5-27, DDS 5-28
distributed transaction recovery, DDS 5-27
DISTRIBUTED_TRANSACTIONS initialization parameter, DDS 5-3
enabling, DDS 5-27, DDS 5-28
in-doubt transactions, SCN 1-35, SCN 5-9, SCN 38
pending transaction table, DDS 5-27
recovering
OS and NetWorker, UNIX, LEG 5-10, LEG 5-19
to new server, UNIX, LEG 5-16, LEG 5-25
recovery, PSA 14-1
access to files, PSA 14-4, PSC 7-2, PSC 7-3
ADD DATAFILE operation, SBR 6-3
after loss of control file, SBR 2-8
after SHUTDOWN ABORT, PSA 4-5
archive history, PSA 3-3
automatic, PSA 13-8
automatically applying archived logs, SBR 5-11
basic steps, SCN 1-49, SCN 350
block-level recovery, SCN 231, SCN 355
cache, PSC 9-16
cancel-based, SBR 5-22, SBR 5-25, SBR 5-28
change-based, SBR 5-30
compatibility, MIG 9-12, MIG 9-39
complete using RMAN, RMN 6-20
control files, SBR 2-8, SBR 6-12
crash recovery, SCN 1-45, SCN 344, SCN 354
instance failure, SCN 5-11
opening a database, SCN 5-9
read-only tablespaces, SCN 346
required after aborting instance, SCN 5-10
SMON process, SCN 1-17, SCN 8-11
creating new control files, SAD 5-5
database
in NOARCHIVELOG mode, RMN 6-43
database buffers and, SCN 348
database startup with automatic, SAD 3-6
datafiles, SBR 6-2
ARCHIVELOG mode, SBR 6-3
NOARCHIVELOG mode, SBR 6-2
datafiles needing, SBR 5-2
dead transactions, SCN 344
deferred transaction, PSC A-14
definition, PSA 14-2
diagrammed, SCN 353
direct path load
SQL*Loader, SUT 8-13
disaster, PSA 14-10, PSA 14-13
disaster recovery, SCN 368
disaster using RMAN, RMN 6-39
distributed databases
with snapshots, SBR 6-18
distributed processing in, SCN 8-12
distributed, enabling, SQL 7-106
dropped table, SBR 6-15
for replication, REP 6-10
from an offline backup, PSA 14-10
from an online backup, PSA 14-10
from multiple node failure, PSA 14-3
from network failure, SBY 5-40
from single-node failure, PSA 14-2
global checkpoint, PSA 13-14
Import utility, SBR 4-20
inaccessible datafiles
in open database, RMN 6-38
using disk and tape backups, RMN 6-39
incomplete, RMN 6-25
without a recovery catalog, RMN 6-31
without recovery catalog, RMN 6-29
incomplete media, PSA 14-8
instance, PSA 3-3, PSA 4-5, PSA 14-2
instance recovery, PSA 14-1, SCN 344
fast-start checkpointing, SCN 354
instance failure, SCN 1-45, SCN 344
parallel DML, SCN 198
read-only tablespaces, SCN 346
SMON process, SCN 1-17, SCN 8-11, SCN 198
instance startup with automatic, SAD 3-6
log history, PSA 13-8, PSA 14-8
media, SBR 5-1, SBR 6-1
complete, SBR 3-16
incomplete, SBR 3-16
media failure, PSA 13-8, PSA 13-15, PSA 14-6, PSA 14-7, PSC 7-2, PSC A-24
media recovery
dispatcher processes, SCN 8-21
enabled or disabled, SCN 358
media, with striping, DWG 4-8
methods, SBR 1-27
multi-threaded, SBR 5-12
number of required processes, SRF 1-100, SRF 1-101
of database, SQL 7-7
of distributed transactions, SCN 5-9
of instances, PSC 9-15
of lost or damaged recovery catalog, RMN 3-42
online, PSA 14-2
online redo logs, SBR 6-5
losing member, SBR 6-5
loss of group, SBR 6-7
open database using RMAN, RMN 6-24
overview of, SCN 1-44, SCN 348
parallel, PSA 14-14, PSA 14-16
intra transaction recovery, STU 24-17
parallel DML, SCN 197
parallel processes for, SBR 5-19, STU 24-15
parallel recovery, SCN 351
parallel restore, SCN 357
PARALLEL_MAX_SERVERS initialization parameter, STU 24-15
PARALLEL_MAX_SERVERS parameter, PSA 14-14, PSA 14-16
point-in-time
clone database, SCN 5-8
preparing for, RMN 6-19
process recovery, SCN 8-12, SCN 343
read-only tablespaces, SBR 5-4
recommendations for, SCN 353
Recovery Manager, SCN 1-50, SCN 356
recovery time, PSA 13-15
replacing rows, SUT 5-32
restrictions, PSC A-24
rolling back, PSC 7-6
rolling back transactions, SCN 349
rolling forward, SCN 349
See also media recovery
setting number of processes to use, SBR 5-19, STU 24-15
setting parallelism, PSA 14-14, PSA 14-15
skipping tablespaces during, RMN 6-20
standby database, SCN 368
starting another instance, PSA 3-3
statement failure, SCN 343
steps of, PSA 14-5
strategies
determining when media recovery is necessary, SBR 3-18
structures used in, SCN 1-46, SCN 346
tablespace, RMN 6-23
testing distributed transactions, DDS 5-26
time-based, SBR 3-16, SBR 5-28 to SBR 5-30
to log sequence number, RMN 6-28
to SCN, RMN 6-27
to time, RMN 6-26
transportable tablespaces, SBR 6-4
user errors, SBR 6-15
using backup control file (RMAN), RMN 6-22
using logs in non-default location, SBR 5-10
using Recovery Manager, SBR 1-28
using redo log, PSA 13-16
using RMAN, RMN 6-18
using SQL*Plus, SBR 1-27
whole database
using backup control file, RMN 6-22
when control file is intact, RMN 6-21
whole database backups, SCN 365
recovery catalog, RMN 1-14, RMN 2-6 to RMN 3-43
and incomplete recovery, RMN 6-26
backing up, RMN 1-16
using control file as repository, RMN 3-39
cataloging
O/S backups, RMN 3-34
changing availability of backup, RMN 3-13
changing status of backups to DELETED, RMN 3-18
compatibility, RMN 1-16
viewing, RMN 3-6
compatibility. See Oracle8i Migration
compatibility with Recovery Manager, MIG 9-39
connecting to Recovery Manager with, RMN 2-10, RMN 2-12
connecting to Recovery Manager without, RMN 2-9, RMN 2-11
consequences of using, RMN 2-6
creating, RMN 3-2
8.1.6 catalog usable with pre-8.1.6 RMAN, RMN 3-6
in separate database, RMN 2-6
crosschecking, RMN 3-14
db identifier problems, RMN 3-10
deleting records, RMN 3-20
dropping, RMN 3-44
log switch record, RMN 3-34
managing size of, RMN 3-33
operating with, RMN 1-14
operating without, RMN 1-17
overview, RMN 1-14
purging all records with DELETED status, RMN 3-19
querying, RMN 1-24, RMN 4-2
recovery of lost or damaged, RMN 3-42
refreshing, RMN 3-29
registering databases, RMN 3-9
registering target databases, RMN 3-9
in two catalogs, RMN 3-39
removing records, RMN 3-23
expired, RMN 3-21
obsolete, RMN 3-19, RMN 3-21
resynchronizing, RMN 1-15, RMN 3-29
schema, RMN 2-6
setting up, RMN 3-2
setting compatibility level, RMN 3-4
snapshot control file, RMN 1-15
stored scripts
creating, RMN 3-27
executing, RMN 3-28
UNKNOWN database name, RMN 9-35
unregistering databases, RMN 3-11
updating
after operating system deletions, RMN 3-20
after schema changes, RMN 3-32
upgrading, MIG 7-36, RMN 3-43
views, RMN 11-1
Recovery Catalog, Oracle8, LEG 1-9, LEG 1-10
recovery features, in Oracle8i, OID 1-5
Recovery Manager, PSA 14-6, SCN 1-50, SCN 356
advantages to using, RMN 1-4
allocate channel for maintenance, RMN 10-14
archive log backup, PSA 13-8
backup management, MIG 9-40
backup sets, RMN 1-39
backup types, RMN 1-32
duplexed backup sets, RMN 1-44
backups, RMN 5-2
archived redo logs, RMN 5-9, RMN 5-10
control file, RMN 5-7
datafile, RMN 5-5, RMN 5-6
fractured block detection, RMN 1-67
image copy, RMN 1-57
incremental, RMN 5-11
tablespace, RMN 5-5, RMN 5-6
using tags, RMN 1-58
whole database, RMN 5-3
backups and copies, SBR 1-21
channel control
overview, RMN 1-28
channels
managing, RMN 1-28
command line arguments, RMN 1-10
commands
allocate channel, RMN 10-10
allocate channel for delete, RMN 5-27
alter database, RMN 10-16
backup, RMN 1-22, RMN 1-33, RMN 5-2, RMN 5-28
catalog, RMN 3-9, RMN 3-34
change, RMN 3-15, RMN 3-36
compatibility, MIG 9-40
configure, RMN 10-47
connect, RMN 10-51
copy, RMN 10-55
create catalog, RMN 10-59
create script, RMN 10-61
crosscheck, RMN 10-64
debug, RMN 10-68
delete expired backup, RMN 10-69
delete script, RMN 10-71
drop catalog, RMN 10-74
duplicate, RMN 10-76
execute script, RMN 3-27
host, RMN 10-81
interactive use of, RMN 1-10
job, RMN 1-9
job commands, RMN 1-9
list, RMN 3-13
overview, RMN 1-5
print script, RMN 10-94
recover, RMN 1-61, RMN 6-18
register, RMN 3-10
release channel, RMN 10-103
replace script, RMN 10-105
replicate controlfile, RMN 6-12
report, RMN 4-5
reset database, RMN 3-12
restore, RMN 6-19
resync catalog, RMN 3-43
rman, RMN 10-130
run, RMN 10-133
send, RMN 2-22
set, RMN 5-24, RMN 6-10
shutdown, RMN 10-147
sql, RMN 10-150
stand-alone, RMN 1-9
stand-alone commands, RMN 1-8
startup, RMN 10-152
switch, RMN 10-154
upgrade catalog, RMN 10-158
using command files, RMN 1-10
validate, RMN 10-160
compatibility, MIG 9-39
compatibility. See Oracle8i Migration
compilation and execution of commands, RMN 1-6
configure archive logs, PSG 4-9 to PSG 4-16
connecting
duplicate database, RMN 2-12
with password files, RMN 2-10, RMN 2-11
with recovery catalog, RMN 2-10, RMN 2-12
without password files, RMN 2-11
without recovery catalog, RMN 2-9, RMN 2-11
connection options, RMN 2-9
auxiliary database, RMN 2-12
hiding passwords, RMN 2-13
with a catalog, RMN 2-10
without a catalog, RMN 2-9
constraints
backup, RMN 1-56
restore, RMN 1-60
corrupt datafile blocks, RMN 1-66, RMN 1-67
handling I/O errors and, RMN 1-47
creating duplicate databases, RMN 7-2
crosschecking recovery catalog, RMN 3-14
database character set, RMN 2-3
dates in commands, RMN 2-3
debugging, RMN 9-8
disaster recovery, PSA 14-10
disconnecting from, RMN 2-13
downgrading to 8.0.3
re-installing packages, MIG 13-63
error codes, RMN 9-3
error messages, RMN 9-2
error stacks
interpreting, RMN 9-6
errors, RMN 1-13
fractured block detection in, RMN 1-67
generating reports, SCN 358
hanging backups, RMN 9-23
image copy backups, RMN 1-57
incomplete media recovery, PSA 14-8
incomplete recovery
with a recovery catalog, RMN 6-26
without a recovery catalog, RMN 6-29
incremental backups
cumulative, RMN 1-53
differential, RMN 1-51
level 0, RMN 1-50
integrity checking, RMN 1-66
interactive use of commands, RMN 1-10
introduction, RMN 1-2
jobs
monitoring progress, RMN 9-14
lists, RMN 4-2
media management
backing up files, RMN 1-20
Backup Solutions Program (BSP), RMN 1-23
crosschecking, RMN 1-21
maximum file size, RMN 2-21
media manager, linking with a, RMN 2-20
proxy copy, RMN 1-22
requirements, RMN 2-20
restoring files, RMN 1-21
testing, RMN 1-23
unique filenames, RMN 2-21
metadata, RMN 1-13, RMN 3-1, RMN 7-1
storing in control file, RMN 1-17
monitoring, RMN 9-12, RMN 9-17
multiplexing
datafiles, RMN 1-42
name translation, RMN 1-7
normalize catalog, MIG 8-9
operating without a catalog, SCN 357
overview, RMN 1-4
parallel operations, SCN 357
parallel recovery, SCN 351
parallelization of backups, RMN 1-45
password files, RMN 2-2
PL/SQL job steps, RMN 1-7
recovery, RMN 6-18
after total media failure, RMN 6-39
complete, RMN 6-20
incomplete, RMN 6-25
open database, RMN 6-24
using backup control file, RMN 6-22
recovery catalog, RMN 1-14, SCN 356
backing up, RMN 3-37
changing availability of backups and copies, RMN 3-13
creating a separate database, RMN 2-6
crosschecking, RMN 3-14
deciding whether to use, RMN 2-6
losing control files when not using a, RMN 1-18
managing the size of, RMN 3-33
operating with, RMN 1-14
operating without, RMN 1-17
querying, RMN 1-24, RMN 4-2
recovering lost or damaged, RMN 3-42
registering databases, RMN 3-9
removing records, RMN 3-23
resynchronizing, RMN 3-29
schema, RMN 3-2
snapshot control file, RMN 1-15
updating after schema changes, RMN 3-32
upgrading, RMN 3-43
registering databases, RMN 3-10
reports, RMN 4-5
database schema, RMN 4-8
objects needing a backup, RMN 4-5
obsolete backups, RMN 4-6, RMN 4-8
resetting database information, RMN 3-12
restoring, RMN 6-2
archived redo logs, RMN 6-14
control files to default location using recovery catalog, RMN 6-12
control files to new location without recovery catalog, RMN 6-13
database to default location, RMN 6-3
datafiles, RMN 1-59
RPC calls and, RMN 9-25
sample scripts, RMN 2-22
sbttest program, RMN 1-23, RMN 2-22
security, RMN 2-13
See also Recovery Manager User's Guide and Reference
setting time parameters, RMN 2-2
snapshot control file location, RMN 2-3
starting a database, SAD 3-3
starting an instance, SAD 3-3
stored scripts, RMN 1-11
symbolic links for filenames, RMN 10-123
syntax conventions, RMN 10-2
tablespace point-in-time recovery, RMN 1-63
tags for backups, RMN 1-58
terminating commands, RMN 1-12
test disk API, RMN 9-19
tuning backups and restores. See Oracle8i Tuning
types of backups, RMN 1-57
using RMAN commands, RMN 1-5
Recovery Manager (RMAN), Oracle8, LEG 1-9, LEG 1-10
recovery sets
containing whole tables, RMN 8-6
copying to primary database, SBR 7-13
for RMAN TSPITR, RMN 8-4
importing into primary database, SBR 7-14
recovery strategy
overview, SBR 1-24
recovery with Recovery Manager, PSG 4-9
RECOVERY_CATALOG_OWNER role, SQL 7-530
RECOVERY_PARALLELISM initialization parameter, SBR 5-19, SRF 1-101, STU 24-15
RECOVERY_PARALLELISM parameter, PSA 1-12, PSA 14-14, PSA 14-15
rectifying
tables, SPR 34-6, RAR 7-41, RAR 8-56
recursion, PLS 7-39
infinite, PLS 7-39
mutual, PLS 7-42
terminating condition, PLS 7-39
versus iteration, PLS 7-43
recursive calls, STU 6-13, STU 20-27
recursive SQL, STU 13-1
cursors and, SCN 15
recyclable save set, LEG 2-8
recyclable volumes, LEG 2-7
RECYCLE cache, STU 19-33
REDEFINES clause
purpose, PCO 2-18
restrictions, PCO 2-18
REDEFINES support, PCO A-7
redefining mandatory attributes, OID 6-3
redirect connection, NET 2-9
redo allocation latch, STU 21-16, STU 21-19
redo buffer allocation retries, DWG 18-23
REDO BUFFER ALLOCATION RETRIES statistic, STU 19-7
redo copy latches, STU 21-16, STU 21-19
choosing how many, STU 21-16
redo log buffers, SBR 1-4
Redo Log Buffers parameter, OID 13-11
redo log file
adding, PSC A-20
archiving, PSC 1-5
dropping, PSC A-20
overwriting, PSC 1-5
renaming, PSC A-20
redo log files
active (current), SAD 6-4
archived
advantages of, SAD 7-2
contents of, SAD 7-2
log switches and, SAD 6-5
archived redo log files, SAD 7-6
archived redo logs, SAD 7-3
archiving, PSA 3-8, PSA 13-1, PSA 13-3, PSA 13-15
archiving mode, PSA 13-3
available for use, SAD 6-3
backup, PSA 13-16
circular use of, SAD 6-3
clearing, SAD 6-7, SAD 6-17
restrictions, SAD 6-17
contents of, SAD 6-2
creating
groups and members, SAD 6-11
creating members, SAD 6-11
described, PSG 1-13
distributed transaction information in, SAD 6-3
dropping, PSA 13-15
groups, SAD 6-6
creating, SAD 6-11
decreasing number, SAD 6-10
dropping, SAD 6-14
LOG_FILES initialization parameter, SAD 6-10
members, SAD 6-6
threads, SAD 6-2
how many in redo log, SAD 6-9
identified in control file, PSC 7-5
inactive, SAD 6-4
instance recovery, PSA 14-3
legal and illegal configurations, SAD 6-7
LGWR and the, SAD 6-3
log history, PSA 13-7
log sequence number, PSA 13-6
log sequence numbers of, SAD 6-5
log switches, SAD 6-5
members, SAD 6-6
creating, SAD 6-11
dropping, SAD 6-14
maximum number of, SAD 6-10
mirrored
log switches and, SAD 6-7
multiplexed, PSA 13-8
diagrammed, SAD 6-6
if all inaccessible, SAD 6-7
multiplexing, SAD 6-5
groups, SAD 6-6
if some members inaccessible, SAD 6-7
online, SAD 6-2
recovery use of, SAD 6-2
requirement of two, SAD 6-3
threads of, SAD 6-2
online redo log, SAD 6-1
overwriting, PSA 13-3
planning the, SAD 6-5, SAD 6-10
privileges
adding groups and members, SAD 6-11
raw devices, PSG 2-6
reconfiguring, PSA 3-8
redo entries, SAD 6-2
renaming, PSA 13-15
requirements, SAD 6-7
thread of redo, PSC 7-3
verifying blocks, SAD 6-17
viewing, SAD 2-16
redo logs, SBR 1-9, SCN 1-9, SCN 347, SCN 349
"fuzzy" data in backups and, SBR 3-6
See also online redo log
adding, SBY 4-12, SBY 5-25, SQL 7-18
archived, SBR 2-17, SCN 1-47, SCN 359
advantages of, SBR 2-14
automatically, SCN 360
contents of, SBR 2-15
errors in archiving, SCN 361
manually, SCN 361
archiver process (ARCn), SCN 1-18, SCN 8-12
archiving modes, SCN 358
automatic archiving of, SQL 7-103
automatic name generation, SQL 7-13
buffer management, SCN 8-9
buffer size, SRF 1-63
buffer tuning, STU 19-6
buffers, SCN 1-14, SCN 7-6
circular buffer, SCN 8-9
clearing, SBR 2-14, SBY 4-12, SBY 4-16
committed data, SCN 349
committing a transaction, SCN 8-10
direct path load, SUT 8-14
disabling specified threads in a parallel server, SQL 7-16
do not back up, SAD 7-2
dropping, SQL 7-19
enabling specified threads in a parallel server, SQL 7-15
entries, SCN 1-9, SCN 349
files named in control file, SBR 2-3, SCN 362
groups, SBR 2-13
members, SBR 2-13
inactive, SBR 1-9
instance and media recovery
SQL*Loader, SUT 8-14
listing files for backup, SBR 4-2
log sequence numbers, SCN 1-47
recorded in control file, SCN 363
log switch
ALTER SYSTEM SWITCH LOGFILE, SCN 8-12
archiver process, SCN 1-18, SCN 8-12
log writer process, SCN 7-6, SCN 8-9
members, SBR 2-13
adding to existing groups, SQL 7-18
dropping, SQL 7-19
renaming, SQL 7-15
mirrored
log switches and, SBR 2-14
mirroring, STU 20-21
mode of, SCN 1-47
multiplexed, SBR 2-12, SCN 1-47
diagrammed, SBR 2-13
groups, SBR 2-13
if all inaccessible, SBR 2-14
if some members inaccessible, SBR 2-14
purpose of, SBR 1-10, SCN 1-9
naming, SBR 5-9
online or offline, SCN 1-46, SCN 1-47, SCN 347
overview, SBR 1-9
overview of, SCN 1-9, SCN 1-46
parallel recovery, SCN 351
placement on disk, STU 20-19
recovery and, SCN 347
removing, SBY 4-12, SBY 5-25
resetting, SBY 4-12
reusing, SQL 7-517
rolling forward, SCN 349
instance failure, SCN 344
rolling forward and, SCN 349
saving space
direct path load, SUT 8-19
size of, SQL 7-517
size of buffers, SCN 7-6
specifying, SQL 7-516
for media recovery, SQL 7-14
storing separately from datafiles, SAD 10-4
switching groups, SQL 7-107
unavailable when database is opened, SAD 3-4
uncommitted data, SCN 349
when temporary segments in, SCN 4-20
writing buffers, SCN 8-9
written before transaction commit, SCN 8-10
redo logs, applying, LEG 5-26
redo records, SAD 6-2
change vectors, SBR 1-9
definition, SBR 1-9
redo thread, SRF 1-117
redo threads, PSA 13-1, PSA 13-5
REDUCE_ALARM initialization parameter: obsolete
reducing
buffer cache misses, STU 19-31
contention
dispatchers, STU 21-6
OS processes, STU 23-3
query servers, STU 21-15
redo log buffer latches, STU 21-16
shared servers, STU 21-9
data dictionary cache misses, STU 19-22
paging and swapping, STU 19-4
rollback segment contention, STU 21-4
unnecessary parse calls, STU 19-10
redundancy, OID 14-2
star schemas, DWG 2-4
redundancy planning, PSC 9-4
redundancy set
definition, SBR 1-20
redundant links, OID 14-8
REENABLE keyword
SQL*Loader, SUT 8-21
re-enabling
replication, REP 6-19
REF
binding, OCI 5-10, OCI 12-3
defining, OCI 5-21, OCI 12-4
external datatype, OCI 3-18
indicator variable for, OCI 2-32
retrieving from server, OCI 10-11
structure for, PC_ 17-33
REF (reference to object), PC_ 17-2
REF column
indexes on, ADG 5-7
REF columns, SUT 5-97
primary key, SUT 5-97
real, SUT 5-97
referential constraints on
downgrading, MIG 13-31
specifying, SQL 7-393
specifying from table or column level, SQL 7-393
REF CURSOR datatype, PLS 5-16
defining, PLS 5-17
ref cursor variables
binding, OCI 5-17
ref cursors
binding and defining, OCI 5-35
REF data
exporting, SUT 1-16
importing, SUT 2-57
REF fields
example, SUT 4-44
REF function, PLS 9-32, SQL 4-70
REF operator, DCI 1-8
REF type modifier, PLS 9-28
reference
for cman.ora, NET C-70 to NET C-76
for CMCTL commands, NET A-81 to NET A-97
for ldap.ora, NET C-78
for listener.ora, NET C-48 to NET C-58
for LSNRCTL commands, NET A-4 to NET A-25
for NAMESCTL commands, NET A-28 to NET A-79
for names.ora, NET C-59 to NET C-69
for protocol.ora, NET C-77
for sqlnet.ora, NET C-5 to NET C-30
for tnsnames.ora, NET C-31 to NET C-48
host variable, PCO 2-8
Reference - oracle.xml.parser.v2.XMLToken.Reference, JPR 4-138
REFERENCE clause
in TYPE statement, PC_ 5-14
reference cursor, PCO 6-30
reference datatypes, PLS 2-11
reference. See REF
reference semantics, ADL 2-3, ADL 9-27
BFILEs enables multiple BFILE columns per record, ADL 11-7
reference semantics (ANSI dynamic SQL), PC_ 14-7
reference tables, DWG 8-7
referenced
keys, SCN 1-58, SCN 263
objects
dependencies, SCN 108
external reference, SCN 50, SCN 62
partitions, SCN 11-18
REFERENCES clause
of constraint_clause, SQL 7-241
of CREATE TABLE, SQL 7-393
REFERENCES object privilege, SQL 7-535
REFERENCES privilege, ADG 11-22, ADG 11-32
CASCADE CONSTRAINTS option, SAD 23-15
revoking, SAD 23-14, SAD 23-15
when granted through a role, SCN 323
references to objects (REFs)
declaring, PC_ 17-33
using, PC_ 17-33
using in embedded SQL, PC_ 17-34
references to objects. See REFs
references, external, PLS 7-31
referencing
host tables, PCO 7-4
host variables, PCO 4-20
indicator variables, PCO 4-24
of host arrays, PC_ 8-2, PC_ 8-3
VARCHAR variables, PCO 4-28
REFERENCING clause
of CREATE TRIGGER, SQL 7-427, SQL 7-432
REFERENCING option, ADG 13-17
referential integrity, SCN 222, SCN 263
cascade rule, SCN 253
distributed database systems
application development, DDS 3-3
distributed databases and, ADG 4-14
examples of, SCN 271
one-to-many relationship, ADG 4-10
one-to-one relationship, ADG 4-10
partially null foreign keys, SCN 266
PRIMARY KEY constraints, SCN 261
privileges required to create foreign keys, ADG 4-25
restrict rule, SCN 253
self-referential constraints, ADG 13-44, REP 2-16, SCN 265, SCN 271
set to default rule, SCN 253
set to null rule, SCN 253
triggers and, ADG 13-41 to ??, ADG 13-41, ?? to ADG 13-45
referential integrity constraints, SQL 7-239, SQL 7-241
disabling for import, SUT 2-14
Import, SUT 2-45
SQL*Loader, SUT 8-20
referrals, OID 2-19, OID 2-20
referrals, in LDAP Version 3, OID 1-3
refresh, REP 3-28
automatic, REP 3-30
complete, REP 3-28
DBMS_REFRESH package
REFRESH_CHANGE procedure, REP 4-21
failures, REP B-8
fast, REP 3-28
fast and table reorganization, REP A-8
force, REP 3-29
group, REP 3-30
incremental, SCN 10-19
initiating, REP 3-30
interval, REP 3-30
intervals
parameter constraints, REP 3-30
job queue processes (SNPn), SCN 1-19, SCN 8-13
manual, REP 3-30
materialized views, SCN 10-19
monitoring, DWG 14-28
null optimization, REP 3-27
on-demand, REP 3-30
options, DWG 8-19
retries, REP B-8
snapshot sites, SPR 37-71, RAR 8-137
snapshots, SPR 48-8, SPR 48-11, SPR 48-12, RAR 7-40, RAR 8-239, RAR 8-242, RAR 8-243, REP 1-10, SCN 430
Refresh button, in Oracle Directory Manager, OID 4-12
REFRESH clause
of ALTER MATERIALIZED VIEW, SQL 7-48, SQL 7-52
of CREATE MATERIALIZED VIEW / SNAPSHOT, SQL 7-319
REFRESH COMPLETE clause
of ALTER MATERIALIZED VIEW, SQL 7-52
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-324
Refresh Entry button, in Oracle Directory Manager, OID 4-12
refresh error
snapshots
Import, SUT 2-48
REFRESH FAST clause
of ALTER MATERIALIZED VIEW, SQL 7-52
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-324
REFRESH FORCE clause
of ALTER MATERIALIZED VIEW, SQL 7-53
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-324
refresh groups, REP 3-25
adding members to, SPR 35-3, RAR 8-60
adding objects to, RAR 5-8
creating, SPR 35-7, RAR 5-6, RAR 8-64
data dictionary views, RAR 9-53
deleting, SPR 35-6, RAR 8-63
deployment templates, REP 4-21
optimization for large, REP A-2
refresh interval
changing, SPR 35-4, RAR 8-61
refreshing
manually, SPR 35-9, RAR 8-66
removing members from, SPR 35-10, RAR 8-67
size considerations, REP 3-27
troubleshooting, REP B-7
REFRESH ON COMMIT clause
of ALTER MATERIALIZED VIEW, SQL 7-53
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-324
REFRESH ON COMMIT mode
materialized views and downgrading, MIG 13-17
REFRESH ON DEMAND clause
of ALTER MATERIALIZED VIEW, SQL 7-53
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-324
Refresh Subentries button, in Oracle Directory Manager, OID 4-12
REFRESH_POLICY procedure, ADG 11-38, ADG 11-46
refresher
creating, RAR 2-16
refreshing, OCI 13-11
materialized views, DWG 14-16
nested materialized views, DWG 14-26
objects, OCI 13-11
partitioning, DWG 14-2
standby database control file, SBY 4-15, SBY 5-26
REFs, ADO 1-6, SQL 2-31, SQL 7-242
as containers for OIDs, SQL 2-31
compatibility, MIG 9-11
constraints on, ADO 6-9
constructing from object identifiers, ADO 7-2
dangling, ADO 1-7, SCN 13-10, SQL 7-206
declaring, PC_ 17-33
dereferencing of, ADO 1-7, ADO 9-22, SCN 13-10
for rows of object views, ADO 5-3, SCN 14-3
implicit dereferencing of, ADO 1-7, ADO 9-22, SCN 13-10
indexes on, ADO 2-4
indexing, ADO 6-10
indicator variables for, OCI 2-33
mutually dependent types, ADO 2-14
object identifiers, ADO 9-26
pinning, ADO 2-13, ADO 5-4, SCN 14-4
scoped, ADO 1-7, ADO 6-9, ADO 7-2, SCN 13-9
size of, ADO 7-2
storage, ADO 6-9
use of table aliases, ADO 2-7
using, PC_ 17-33
using in embedded SQL, PC_ 17-34
validating, SQL 7-206
WITH ROWID option, ADO 6-11
refs, PLS 9-27
dangling, PLS 9-33
declaring, PLS 9-28
dereferencing, PLS 9-33
REFTOHEX function, SCN 12-24, SQL 4-70
region database
configure database server, NET 6-50, NET 6-54
create Oracle Names server, NET 6-51
defined, NET 4-13
regions
delegated administrative, NET 4-19
delegated administrative below root, NET 4-21
delegated administrative, diagram, NET 4-20
in Oracle Names, NET 4-12, NET 4-18
organizing multiple administrative network, NET 4-18
root administrative, NET 4-19
register, NET 6-69
REGISTER command, NET 6-66, NET 6-69, NET A-44
register command (RMAN), RMN 3-9, RMN 3-10, RMN 10-101
REGISTER CONNECT SQL statement, PC_ F-97
Register Service with Oracle Names option, NET 6-64
register(int) - oracle.jms.AQjmsConsumer.register(int), JPR 2-62
registering
aliases with Oracle Names, NET 6-72
global database link qualifiers with Oracle Names, NET 6-68
global database links with Oracle Names, NET 6-68
net service names with Oracle Names, NET 6-65
objects with Oracle Names, NET 6-65
propagator for local database, SPR 11-16, RAR 8-31
user callbacks, OCI 9-10
registering a data cartridge name, DCI 2-10
registering an external procedure, DCI 4-3
registering applications with database, STU 11-8
Registration failed - error, ADQ D-8
Registration for notification failed - error, ADQ D-15
registration for notification vs. listener, ADQ 6-3
registry
DefinedNodes value, PSG 3-26
PM\db_name key, PSG 3-11, PSG 3-34, PSG C-3
REGR_AVGX function, DWG 17-49, SQL 4-71
REGR_AVGY function, DWG 17-49, SQL 4-71
REGR_COUNT function, DWG 17-49, SQL 4-71
REGR_INTERCEPT function, DWG 17-49, SQL 4-71
REGR_R2 function, DWG 17-50, SQL 4-71
REGR_SLOPE function, DWG 17-49, SQL 4-71
REGR_SXX function, DWG 17-50, SQL 4-71
REGR_SXY function, DWG 17-50, SQL 4-71
REGR_SYY function, DWG 17-50, SQL 4-71
regression
detecting, DWG 18-66
reject files
specifying for SQL*Loader, SUT 5-25
rejected PIN code
reasons for, OAS 7-13
rejected records
SQL*Loader, SUT 3-11, SUT 5-25
related documentation, LEG ix
relational database vs. directory, OID 1-2
relational DBMS (RDBMS)
object-relational DBMS, SCN 13-2
principles, SCN 1-20
SQL and, SCN 10
See also Oracle
relational design
planning, SAD 1-19
relational functions
server roundtrips, OCI C-2, OCI C-7
relational operators, PLS 2-46
COBOL vs SQL, PCO 2-19
relational tables
creating, SQL 7-381
relations, SCN 1-22
Relative Distinguished Name (RDN), defined, NET 2-40
Relative Distinguished Names (RDNs), OID 2-3
displaying for each entry, OID 7-3
modifying
using command line tools, OID 7-25
using ldapmodify, OID A-14
modifying, using ldapmoddn, OID 4-14
relative field positioning
where a field starts and SQL*Loader, SUT 5-84
with multiple SQL*Loader INTO TABLE clauses, SUT 5-51
relative file number, PSC 7-3
RELAY_STATISTICS parameter, NET C-74
releasable locking, PSA 7-12
releasable locks
comparing with fixed, PSC 5-5
creation, PSC 5-4
releasable PCM locks, PSA 9-3, PSA 9-5
release
defined, MIG 1-2
release channel command (RMAN), RMN 10-103
releasing a maintenance channel, RMN 10-104
release enhancements, OCI 1-12
release number format, SAD 1-21
RELEASE option, PC_ 3-23, PCO 3-15, PCO 3-20
COMMIT statement, PCO 3-15
if omitted, PC_ 3-23
in COMMIT statement, PC_ 3-18
in ROLLBACK statement, PC_ 3-21
omitting, PCO 3-20
purpose of, PC_ 3-18
restriction on, PC_ 3-21
restrictions, PCO 3-19
ROLLBACK statement, PCO 3-16
RELEASE_CURSOR
precompiler option
what it affects, PC_ C-7
RELEASE_CURSOR clause, STU 19-10
RELEASE_CURSOR option, PCO D-7
of ORACLE Precompilers, PC_ F-18, PCO F-15
using to improve performance, PC_ C-12
RELEASE_CURSOR precompiler option, PC_ 10-36, PCO 14-35
releases, SAD 1-21
checking the Oracle database release number, SAD 1-22
reliability, and replication, OID 2-12
relinking to the media management API, RMN 9-21
relinking with SQL*Net, MIG 10-2
RELOAD command
of LSNRCTL, NET A-8
of NAMESCTL, NET A-45
RELOADS column
V$LIBRARYCACHE table, STU 19-15
relocating control files, SAD 5-5
RELY clause
of constraint_clause, SQL 7-244
RELY constraints, DWG 7-5
REMARKS column
PLAN_TABLE table, STU 5-4
re-mastering
during failover, PSC 9-8
locks, PSC 9-15
remote access indicator, PLS 2-36
Remote Authentication Dial-In User Service. See RADIUS
remote clients
authenticating, SRF 1-103
remote connections, SAD 1-16
connecting as SYSOPER/SYSDBA, SAD 1-14
multithreaded shared servers, MIG 3-17
password files, SAD 1-9
remote connections to secondary instances, PSG 5-10
remote data
querying, DDS 2-33
updating, DDS 2-33
remote database
declaration of, PC_ F-37, PCO F-26
remote databases, SCN 1-34
remote dependencies, ADG 9-28, SCN 117
signatures, ADG 9-30
specifying timestamps or signatures, ADG 9-35
remote exception handling, ADG 9-46, ADG 13-18
remote instance, PSA 1-4, PSA 1-5
remote instances, PSA 4-4
remote I/O, PSC 8-11
remote join enhancements, GTK 3-67
remote logins, SRF 1-102
remote operation
Export/Import, SUT 1-53
remote procedure calls, DDS 1-46, SCN 416
distributed databases and, DDS 1-46
remote queries, DDS 3-4
distributed databases and, DDS 1-33
execution, DDS 3-4
post-processing, DDS 3-4
Remote Recipients, ADQ 8-63
remote SQL statement, STU 9-30
remote transactions, DDS 1-35, SCN 405
defined, DDS 1-35
parallel DML and DDL restrictions, SCN 184
REMOTE_ADMIN parameter, NET C-74, NET C-89
REMOTE_DEPENDENCIES_MODE initialization parameter, SRF 1-102
REMOTE_DEPENDENCIES_MODE parameter, ADG 9-35, SCN 117
of ALTER SESSION, SQL 7-94
of ALTER SYSTEM, SQL 7-117
REMOTE_LOGIN_PASSWORDFILE initialization parameter, SAD 1-11, SRF 1-102
migration, MIG A-17
REMOTE_LOGIN_PASSWORDFILE parameter, PSG 4-5
and control files, SQL 7-264
and databases, SQL 7-269
REMOTE_OS_AUTHENT initialization parameter, DDS 1-18, SRF 1-103
setting, SAD 22-10
REMOTE_OS_AUTHENT parameter, OAS 1-15
CyberSafe authentication, OAS 5-8
setting for DCE, OAS 14-5
REMOTE_OS_ROLES initialization parameter, SRF 1-103
setting, SAD 23-9, SAD 23-22
Remove a Subscriber, ADQ 9-62
Remove button, in Oracle Directory Manager, OID 4-12
removeAttribute(String) - oracle.xml.parser.v2.XMLElement.removeAttribute(java.lang.String), JPR 4-98
removeAttributeNode(Attr) - oracle.xml.parser.v2.XMLElement.removeAttributeNode(org.w3c.dom.Attr), JPR 4-99
removeCertChainCert(int) - oracle.security.ssl.OracleSSLCredential.removeCertChainCert(int), OAS F-22
removeChild(Node) - oracle.xml.parser.v2.XMLNode.removeChild(org.w3c.dom.Node), JPR 4-113
removeTrustedCert(int) - oracle.security.ssl.OracleSSLCredential.removeTrustedCert(int), OAS F-22
removeValue(String) - oracle.security.ssl.OracleSSLSession.removeValue(java.lang.String), OAS F-40
removeValue(String) - oracle.security.ssl.SSLSocketSession.removeValue(java.lang.String), OAS F-51
removing
attributes from an object class, OID 6-4
objects
using command line tools, OID A-11, OID A-16
using Oracle Directory Manager, OID 4-10, OID 4-12
redo logs, SBY 5-25
removing incompatibilities for downgrading, MIG 13-31
removing records from the recovery catalog, RMN 3-23
RENAME clause
of ALTER INDEX, SQL 7-40
of ALTER OUTLINE, SQL 7-63
of ALTER TABLE, SQL 7-153
RENAME command, ADG 2-39, ADG 2-40
RENAME DATABASE clause
ALTER DATABASE statement, RMN 6-10
RENAME DATAFILE clause
of ALTER TABLESPACE, SQL 7-179
RENAME FILE clause
of ALTER DATABASE, SQL 7-6, SQL 7-15
RENAME GLOBAL_NAME clause
of ALTER DATABASE, SQL 7-15
RENAME PARTITION clause, SAD 15-28
of ALTER INDEX, SQL 7-33, SQL 7-41
of ALTER TABLE, SQL 7-157
RENAME statement, SAD 19-3, SCN 12, SQL 7-554
RENAME SUBPARTITION clause, SAD 15-28
of ALTER INDEX, SQL 7-33, SQL 7-41
of ALTER TABLE, SQL 7-157
renaming
datafiles, SBY 4-11, SBY 5-24
automatically, SBY 2-21
manually, SBY 2-31
entries, OID 7-25
subtrees, OID 7-25
renaming a file
log switch, PSA 13-15
redo log file, PSC A-20
RENAME FILE option, PSC A-20
renaming configuration files
UNIX, LEG 5-15
Windows NT, LEG 5-22
renaming control files, SAD 5-5
REOPEN option
LOG_ARCHIVE_DEST_n initialization parameter, SAD 7-19, SBY 2-18, SBY 5-8
REORDER_NS command, NET 6-59, NET 6-61, NET 8-26, NET A-46
Reorganizing non-partitioned table with ALTER TABLE MOVE clause, GTK 3-42
REPAIR_TABLE view. See DBA_REPAIR_TABLE view.
repairing data block corruption
DBMS_REPAIR, SAD 20-2 to SAD 20-14
RepAPI. See Java RepAPI
Re-Parse Frequency data view, STU 14-10
REPARSE statement, ADG 11-46
reparsing, ADG 11-37, ADG 11-45, ADG 11-46, ADG 11-52
REPEAT command, NET A-47
REPEAT UNTIL structure
mimicking, PLS 3-10
repeatable reads, ADG 7-8, ADG 7-11, SCN 213
REPLACE AS OBJECT clause
of ALTER TYPE, SQL 7-188
REPLACE function, SQL 4-78
treatment of nulls, PLS 2-52
replace script command (RMAN), RMN 10-105
REPLACE table
example, SUT 4-15
replacing a table using SQL*Loader, SUT 5-33
replaceChild(Node, Node) - oracle.xml.parser.v2.XMLDocument.replaceChild(org.w3c.dom.Node, org.w3c.dom.Node), JPR 4-80
replaceChild(Node, Node) - oracle.xml.parser.v2.XMLNode.replaceChild(org.w3c.dom.Node, org.w3c.dom.Node), JPR 4-113
replacement characters, NLS 4-5
replacing attribute values, using ldapmodify, OID A-13
replay attack, OAS 2-5
replicas, OID 2-12
replicate command (RMAN), RMN 6-12, RMN 10-108
replicated data in Oracle Names, NET 4-13
replicated directories, conceptual discussion, OID 2-11
replicated object groups
offline instantiation of, SPR 24-3, SPR 24-4, SPR 24-5, SPR 24-7, SPR 24-8, RAR 8-40, RAR 8-41, RAR 8-42, RAR 8-44, RAR 8-45
replicated objects
dropping from master sites, SPR 37-52, RAR 8-118
replicated tables
and DML incompatibility, REP B-4
datatypes allowed, REP 7-2
replicated transactions
dependency ordering, REP 6-21
replication, OID 2-11, GTK 4-9
adding a new node for, OID 10-18, OID 10-24
administration, REP 1-12, REP 2-20, SCN 432
administration requests, REP 2-22
administrative queue, REP 2-24
administrative requests
states, REP 2-25
Advanced Symmetric Replication (ASR)
advanced techniques, REP 6-1
agreement parameters, OID 10-14
modifying, OID 10-15
modifying, using command line tools, OID 10-16
viewing, OID 10-15
agreements, OID 2-14, OID 5-17, OID 10-9, OID 10-15
adding nodes to, OID 10-16
configuring, OID 10-9
applications that use, REP 1-3, SCN 423
asynchronous propagation, REP 2-29
availability, REP 1-2, REP 6-7, SCN 422
backup and recovery for, REP 6-10
catalog views, RAR 9-1, RAR 9-2
change logs, OID 1-5, OID 2-17
checking imported data, REP 6-11
cold backup, OID B-1
column groups, RAR 6-4, RAR 6-6, RAR 6-9, RAR 6-11, RAR 6-13, RAR 6-17, REP 2-28
compared to Oracle Parallel Server, REP 2-5, REP 6-8
compatibility, MIG 9-12, MIG 9-45
configuration set entries
modifying, by using Oracle Directory Manager, OID 10-11
configuring, OID 10-9
Advanced Symmetric Replication (ASR), OID 10-6
sqlnet.ora, OID 10-4
tnsnames.ora, OID 10-4
conflict resolution, RAR 6-1, REP 1-15, REP 2-10, REP 2-42, REP 5-1, SCN 435
conflicts
detecting, REP 2-41
procedural replication, REP 1-17, SCN 437
connection qualifiers, REP 2-14
creating administrator, RAR 2-4
creating an environment, RAR 1-2, REP 8-28
data dictionary views, RAR 9-1
data requirements, REP 5-2
database copy procedure, OID B-1
database links, REP 2-12
CONNECT TO clause, REP 2-13
creating, RAR 2-12
USING clause, REP 2-13
debug logging level, OID 10-12
deferred transaction queue, REP 2-20
diagnosing problems with, REP B-6
managing, RAR 7-24
deferred transactions, REP 2-19
definition, REP 1-2, SCN 422
deployment templates, REP 1-11, REP 4-1, SCN 431
determining differences between tables, RAR 7-41
disabling, SPR 41-3, RAR 8-229, REP 6-4, REP 6-17, REP 6-18
disconnected computing, REP 1-2, SCN 422
distributed schema management, REP 1-14
downgrading, MIG 13-60
preparing environment for, MIG 13-47
regenerating after, MIG 13-62
enabling, SPR 41-3, RAR 8-229, REP 6-4, REP 6-17
error queue, REP 2-20
managing, RAR 7-26
failover, REP 6-9
filter columns, REP 3-37
flowchart for creating environment, REP 8-28
garbage collection, OID 10-10
modifying intervals, OID 10-12
generating support for, RAR 3-8
groups, REP 1-4, REP 2-26, SCN 424
how it works, OID 2-16
hybrid configurations, REP 1-11, SCN 431
initialization parameters, REP 7-3
installing, OID 10-2
internal procedures, REP 2-19
internal triggers, REP 2-19
introduction, REP 1-2, SCN 422
Java RepAPI, REP C-1
job queue, REP 2-20
log location, OID 5-17
login events, OID 5-27
managing an environment, RAR 7-1
mass deployment, REP 1-3, REP 4-2, SCN 423
master definition site, REP 1-5, SCN 425
master groups, REP 1-5, REP 2-26, SCN 425
creating, RAR 3-2
master sites, REP 1-5, REP 2-6, REP 2-11, SCN 425
adding, RAR 3-7
managing, RAR 7-2
materialized views (snapshots), SCN 10-18
migration, MIG 4-7
migration overview, MIG G-2
min communication, REP 2-38
modes, REP 2-20
multi-master, OID 1-4, OID 2-14
multimaster, REP 1-5, REP 2-1, SCN 425
naming contexts, OID 10-2
network load reduction, REP 1-2, SCN 422
new features, REP A-1
improved mass deployment support, REP A-2
improved Oracle8i Lite integration, REP A-5
improved security, REP A-4
Oracle Replication Manager enhancements, REP A-4
performance enhancements, REP A-2, REP A-5
nodes, adding, OID 10-18
objects, REP 2-15
adding to deployment template, RAR 4-5
adding to master group, RAR 3-5
altering, RAR 6-8, RAR 7-27
obsolete procedures, MIG G-14
off/on affects current session, REP 6-18
Oracle8i Lite support, REP C-1
performance, REP 1-2, REP 2-36, SCN 422
performance and, OID 2-12
planning for, REP 7-1
preparing Net8 environment, OID 10-4
procedural, REP 1-16, SCN 436
procedural replication, REP 6-2
propagation, REP 2-29
propagator, REP 2-12
registering, RAR 2-5
quiesce, REP 2-20
real-time replication. See synchronous replication
receiver, REP 2-12
registering, RAR 2-5
re-enabling, REP 6-19
reliability and, OID 2-12
REPADMIN user, REP 2-12
replication administrator, REP 2-12
replication management API, REP 1-14, SCN 434
Replication Manager, GTK 3-66
restrictions
direct-load INSERT, SCN 154
parallel DML, SCN 201
resuming, RAR 3-10, REP 2-22
scheduled links
creating, RAR 2-13
security, RAR A-1
See Also multimaster replication
See Also snapshots
server, OID 1-4, OID 2-30, OID 2-31
configuration set entries, OID 10-9, OID 10-10
starting, OID 3-6
stopping instances, OID 3-8
servers
starting, OID 3-6
setting up sites, RAR 2-2
single master, REP 2-6
sites, REP 1-4, SCN 424
setup, RAR 2-2
snapshot groups, REP 1-5, SCN 425
creating, RAR 5-4, RAR 5-5
snapshot logs
managing, RAR 7-17
snapshot sites
managing, RAR 7-5
snapshots, REP 1-7, REP 3-1, SCN 427
SNP background processes, REP 3-34
sponsor node, OID B-3
status location, OID 5-17
survivability, REP 6-7
suspending, REP 2-21
synchronous, REP 1-16, REP 2-31, SCN 436
tables
primary key, RAR 3-6
transaction propagation protection, REP 6-20
transport mechanism, OID 2-14
triggers, REP 6-19
troubleshooting, REP B-1
unsupported datatypes
BFILE, REP 3-22
LONG, REP 3-22
upgrading, MIG 7-24
uses of, REP 1-2, SCN 422
see also advanced replication
replication catalog, REP 1-14, SCN 434
comments
updating, RAR 7-45
DBA_REGISTERED_SNAPSHOTS, REP 3-16
DBA_REPCATLOG, REP 2-22
DBA_SNAPSHOT_LOGS, REP 3-16
incorrect views, REP B-6
USER_REFRESH, REP B-8
USER_REFRESH_CHILDREN, REP B-8
replication catalog views, RAR 9-1
comments
updating, RAR 7-45
replication functions, REP 2-17
replication management API, RAR 8-1, REP 1-14, REP 2-22, SCN 434
conflict resolution, RAR 6-1
deployment templates
creating, RAR 4-2
instantiating, RAR 4-17
packaging, RAR 4-11
examples, RAR 8-2
managing a replicated environment, RAR 7-1
master groups
creating, RAR 3-2
overview, RAR 1-1
packages, RAR 8-2
setting up replication sites, RAR 2-2
snapshot groups
creating, RAR 5-4
Replication Manager, GTK 3-66
Replication Manager. See Oracle Replication Manager
replication objects, REP 1-4, REP 2-19, SCN 424
at snapshot sites
problems creating, REP B-7
indexes, REP 2-16
packages, REP 2-16
procedures, REP 2-17
re-creating, REP B-4
sequences, REP 2-18
tables, REP 2-15, REP 7-2
modifying, REP 6-17
primary keys, REP 7-2
unable to generate support for, REP B-4
triggers, REP 2-17
replication of data in Oracle Names, NET 6-55
replication servers, starting, OID 10-17
replication triggers, REP A-6
REPLICATION_DEPENDENCY_TRACKING initialization parameter, REP 7-7, SRF 1-104
reply, replies
functions of UTL_SMTP, SPR 65-3
report command (RMAN), RMN 1-26, RMN 10-110
need backup option, RMN 4-5
reporting functions, DWG 17-43
reports (RMAN)
database incarnations, RMN 4-13
database schema, RMN 4-13
datafiles needing backups, RMN 4-10
deleted backups and copies, RMN 4-13
obsolete backups and copies, RMN 4-11, RMN 4-12
unrecoverable datafiles, RMN 4-11
reports, generating, RMN 4-2, RMN 4-5
database schema, RMN 4-8
objects needing a backup, RMN 4-5
obsolete backups, RMN 4-6, RMN 4-8
scenarios, RMN 4-10, RMN 4-11, RMN 4-13
unrecoverable backups, RMN 4-6, RMN 4-8
repository database
defined, PSG 2-3, PSG 6-3
installing, PSG 6-9
REQUIRED - oracle.xml.parser.v2.AttrDecl.REQUIRED, JPR 4-8
required SSL version, setting on server, OAS 10-27
requirements
export, MIG 6-2
requiring client authentication in SSL, OAS 10-28
reraising an exception, PLS 6-14
reserved namespaces, OCI 2-35, PC_ B-4
reserved words, OCI xxii, OCI 2-35, PLS F-1, SCN 11, SQL 2-73, SQL C -1, SUT A-2
misuse of, PLS 2-6
SQL*Loader, SUT A-2
using as quoted identifier, PLS 2-7
reserved words and keywords, PC_ B-2
RESET COMPATIBILITY clause
of ALTER DATABASE, SQL 7-15
reset database command (RMAN), RMN 3-12, RMN 10-118
incarnation option, RMN 3-13
reset() - oracle.jms.AQjmsBytesMessage.reset(), JPR 2-37
reset() - oracle.jms.AQjmsStreamMessage.reset(), JPR 2-192
RESET_STATS command, NET A-48
RESETLOGS option
ALTER DATABASE statement, SBR 5-16, SBR 5-17, SBR 5-34
backing up control file, SBR 4-16
database backups after using, SBR 3-8
multiple timelines for redo logs, SBR 3-11
recovery of database after using, SBR 5-36
RESETLOGS parameter
ALTER DATABASE statement, SBY 3-7
of CREATE CONTROLFILE, SQL 7-265
resolution, name, PLS 2-37, PLS D-1
RESOLVE clause
of ALTER JAVA CLASS, SQL 7-46
of CREATE JAVA, SQL 7-312
resolveNamespacePrefix(String) - oracle.xml.parser.v2.NSResolver.resolveNamespacePrefix(java.lang.String), JPR 4-41
resolveNamespacePrefix(String) - oracle.xml.parser.v2.XMLElement.resolveNamespacePrefix(java.lang.String), JPR 4-99
RESOLVER clause
of ALTER JAVA CLASS, SQL 7-46
of ALTER JAVA SOURCE, SQL 7-46
of CREATE JAVA, SQL 7-314
resolving
errors, see also troubleshooting
resource
adding, STU 1-4
persistent, PSC 3-6
tuning contention, STU 2-13
resource allocation methods, SAD 25-3
CPU resource, SAD 25-10
EMPHASIS, SAD 25-8, SAD 25-10
limiting degree of parallelism, SAD 25-10
PARALLEL_DEGREE_LIMIT_ABSOLUTE, SAD 25-10
ROUND-ROBIN, SAD 25-11
resource consumer groups, SAD 25-2
creating, SAD 25-11 to SAD 25-12
DEFAULT_CONSUMER_GROUP, SAD 25-11, SAD 25-12, SAD 25-15, SAD 25-17
deleting, SAD 25-12
LOW_GROUP, SAD 25-12, SAD 25-20
managing, SAD 25-14 to SAD 25-17
OTHER_GROUPS, SAD 25-7, SAD 25-9, SAD 25-11, SAD 25-14, SAD 25-20
parameters, SAD 25-11
SYS_GROUP, SAD 25-12, SAD 25-20
updating, SAD 25-12
resource errors
Import, SUT 2-46
resource limits
altering in profiles, SAD 22-23
assigning with profiles, SAD 22-23
call level, SCN 296
connect time per session, SCN 297
costs and, SAD 22-24
CPU time limit, SCN 296
creating profiles and, SAD 22-22
determining values for, SCN 298
disabling, SAD 22-21
enabling, SAD 22-21
idle time per session, SCN 297
logical reads limit, SCN 296
overview of, SCN 1-42
private SGA space per session, SCN 297
privileges to enable and disable, SAD 22-21
privileges to set costs, SAD 22-24
profiles, SAD 22-21
PUBLIC_DEFAULT profile and, SAD 22-22
session level, SCN 295
sessions per user, SCN 297
setting to null, SAD 22-23
resource limits for profiles, SRF 1-104, SRF 1-105
resource manager, ADG 16-2, PC_ 5-54
resource manager events, ADG 14-6
resource manager. See database resource manager
resource mastering, PSC 3-5
resource parameters
of CREATE PROFILE, SQL 7-359
resource plan directives, SAD 25-3, SAD 25-8
CPU_Pn, SAD 25-12
deleting, SAD 25-14
PARALLEL_DEGREE_LIMIT_P1, SAD 25-8, SAD 25-13
parameters, SAD 25-12
specifying, SAD 25-12 to SAD 25-14
updating, SAD 25-14
resource plans, SAD 25-3
creating, SAD 25-6 to SAD 25-11
DELETE_PLAN_CASCADE, SAD 25-11
deleting, SAD 25-11
examples, SAD 25-6, SAD 25-18
parameters, SAD 25-10
plan schemas, SAD 25-7, SAD 25-11, SAD 25-13, SAD 25-18, SAD 25-22
subplans, SAD 25-6, SAD 25-7, SAD 25-11
SYSTEM_PLAN, SAD 25-10, SAD 25-12, SAD 25-20
top plan, SAD 25-7, SAD 25-8, SAD 25-18
updating, SAD 25-10
validating, SAD 25-8
RESOURCE privilege, ADG 11-19
RESOURCE role, SAD 23-5, SCN 324, SQL 7-530, SUT 2-11
user-defined types, ADO 2-11
resource types
client, LEG 2-3, LEG 2-5
browse policy, LEG 2-6
retention policy, LEG 2-6
device, LEG 2-3, LEG 3-2
label template, LEG 2-3
policy, LEG 2-3
pool, LEG 2-3
server, LEG 2-3, LEG 2-5
RESOURCE_COST view, SRF 2-160
RESOURCE_LIMIT initialization parameter, SRF 1-104
enabling and disabling limits, SAD 22-21
RESOURCE_LIMIT parameter
of ALTER SYSTEM, SQL 7-117
RESOURCE_MANAGER_PLAN initialization parameter, SAD 25-18, SRF 1-105
RESOURCE_MANAGER_PLAN parameter
of ALTER SYSTEM, SQL 7-117
RESOURCE_MAP view, SRF 2-160
resources
and locks, avoiding dynamic allocation, PSA 10-2
consumption, parameters affecting, DWG 18-17
consumption, parameters affecting parallel DML/DDL, DWG 18-22
database, PSC 4-9
limiting for users, DWG 18-9
limits, DWG 18-8
operating system, PSA 1-9
oversubscribing, DWG 18-37
oversubscription, DWG 18-41
parallel query usage, DWG 18-17
profiles, SAD 22-21
releasing, PSA 14-3
response queues, SCN 8-17
response time, SCN 131, STU 1-2, STU 1-3, STU 4-8
cost-based approach, STU 4-10
optimizing, STU 4-9, STU 7-7
responsibilities
of a database administrator, SAD 1-2
of database users, SAD 1-3
RESTART command, NET A-48
restarting
a directory server, OID 3-9
a directory servers, OID 5-4
listener for directory database, OID 10-6
restore command (RMAN), RMN 6-19, RMN 10-120
restore constraints, RMN 1-60
restore validation, RMN 3-24
restoring
archived redo logs, SBR 5-6
backup control file
using dbid, RMN 6-36
backup set without using RMAN, RMN 6-37
backups, SBR 5-4
of online redo logs, SBR 3-10
control files, RMN 6-12
to default location, SBR 6-13
to non-default location, SBR 6-13
database
to default location, SBR 5-15
to new location, SBR 5-16
database to default location, RMN 6-3
database to new host with same file system, RMN 6-4
using recovery catalog, RMN 6-5
without recovery catalog, RMN 6-6
datafiles, RMN 1-59, RMN 6-2, RMN 6-10
to default location, SBR 5-5
files
how RMAN chooses, RMN 1-60
in an OPS configuration using RMAN, RMN 6-16
tablespaces, RMN 6-10
testing, RMN 3-24
whole database backups, SBR 5-15
RESTRICT OPTION
STARTUP statement, SAD 3-6
RESTRICT_REFERENCES pragma, DCI 5-6, PLS 7-9
of ALTER TYPE, SQL 7-189
syntax, PLS 11-144
syntax for, ADG 9-66
using to control side effects, ADG 9-66
using with autonomous functions, PLS 5-60
using with dynamic SQL, PLS 10-15
restricted mode
starting instances in, SCN 5-6
restricted multilingual support, NLS 3-26
restricted rowid format, SCN 12-18
restricted rowids, PLS 2-17, SQL 2-26
compatibility and migration of, SQL 2-27
RESTRICTED SESSION privilege, SCN 300
RESTRICTED SESSION system privilege, SQL 7-525
connecting to database, SAD 3-6
connecting to database., SAD 3-6
restricted mode and, SAD 3-6
session limits and, SAD 22-3
restrictions
AT clause, PCO 3-7
binding of data, removed for INSERTS and UPDATES, ADL 4-17
binds of more than 4000 bytes, ADL 7-18
cached sequence, PSC 8-15
changing the redo log, PSA 3-8
CURRENT OF clause, PCO 5-17
cursor declaration, PCO 5-13
cursor variables, PCO 6-35
DB2 load utility, SUT B-3
deferred rollback segments, PSC A-21
direct-load INSERT, SCN 154, SCN 200
dynamic SQL, PCO 14-32
Export, SUT 1-4
FAST REFRESH, DWG 8-20
file operations, PSC A-19, PSC A-21, PSC B-3
FOR clause, PCO 7-17
host tables, PCO 7-3, PCO 7-9, PCO 7-13, PCO 7-15
host variables, PCO 4-23
naming, PCO 2-16
referencing, PCO 4-23
importing grants, SUT 2-12
importing into another user's schema, SUT 2-12
importing into own schema, SUT 2-11
input host variable, PCO 5-2
nested materialized views, DWG 8-24
nested tables, SCN 186
offline tablespace, PSC 7-6, PSC A-20
on AT clause, PC_ 3-11
on Comments, PC_ 13-31
on CURRENT OF clause, PC_ 6-18
on declaring cursors, PC_ 6-13
on FOR clause, PC_ 8-15
on host arrays, PC_ 8-4, PC_ 8-10, PC_ 8-12, PC_ 8-13, PC_ 8-14
on host tables, PCO 7-6
on input host variables, PC_ 6-2
on NULLs, PC_ 6-5
on separate precompilation, PC_ 2-16
on SET TRANSACTION statement, PC_ 3-23
parallel DDL, SCN 188
remote transactions, SCN 184
parallel DML, SCN 200
remote transactions, SCN 184, SCN 203
parallel execution of functions, SCN 203
partitions
bitmap indexes, SCN 11-13
datatypes, SCN 11-12, SCN 11-21
partition-extended table names, SCN 11-64
procedural replication, REP 2-16
query rewrite, DWG 8-19
recovery, PSC A-24
REDEFINES clause, PCO 2-18
RELEASE option, PCO 3-19
separate precompilation, PCO 2-27
SET TRANSACTION statement, PCO 3-20
SQLCHECK option, PCO E-2
SQLGLM subroutine, PCO 8-14
SQLIEM subroutine, PCO 8-14
system triggers, ADG 13-25
table names in Export parameter file, SUT 1-26
table names in Import parameter file, SUT 2-27
TO SAVEPOINT clause, PCO 3-19
use of CURRENT OF clause, PC_ 8-4, PCO 7-6
Restrictions on Callbacks, DCI 4-11
result set, PLS 1-5, PLS 5-8
RESUME
DB2 keyword, SUT 5-32
RESUME clause
of ALTER SYSTEM, SQL 7-108
RESUME option
ALTER SYSTEM statement, SBR 4-11
resuming a database, SAD 3-13
resuming branches, OCI 8-7
resuming recovery after interruption, SBR 5-14
resuming replication activity, SPR 37-78, RAR 8-144
resync catalog command (RMAN), RMN 1-15, RMN 3-29, RMN 10-127
from controlfilecopy option, RMN 3-43
resynchronizing the recovery catalog, RMN 1-15, RMN 3-29
retention, ADQ 2-5
Retention and Message History, ADQ 8-24, ADQ 12-16
retention and message history, ADQ 1-8
retention policy, LEG 2-6
save set, LEG 2-9
RETRIES parameter, NET 8-13, NET C-44, PSG 5-3
retrieving rows from a table
embedded SQL, PC_ F-103, PCO F-80
RETRY option
STARTUP PARALLEL command, PSA 4-3
Retry with Delay Interval, ADQ 8-84
RETURN clause
cursor, PLS 5-12
function, PLS 7-7
of CREATE FUNCTION, SQL 7-288
of CREATE OPERATOR, SQL 7-340
of CREATE TYPE BODY, SQL 7-449
return codes
user exits, PC_ 20-8
RETURN statement, PLS 7-8
syntax, PLS 11-147
return type, PLS 5-17, PLS 7-26
return value, function, PLS 7-7
return values
navigational functions, OCI 16-5
RETURN-CODE special register is unpredictable, PCO B-3
RETURNING clause, PLS 5-64, PLS 9-36
binding with, OCI 5-27
error handling, OCI 5-28
initializing variables, OCI 5-27
of DELETE, SQL 7-467
of INSERT, SQL 7-540, SQL 7-544
of UPDATE, SQL 7-616, SQL 7-620
using with OCI
with REFs, OCI 5-28
returning clause, PCO 5-9
DELETE, PC_ 6-10
in INSERT, PC_ 6-11, PCO 5-9
in UPDATE, PC_ 6-10
returning clauses, PC_ 6-11
returning nested tables as, ADO 9-30
reusability, PLS 7-3
reusable packages, ADG 9-70, PLS 5-65
REUSE clause
of CREATE CONTROLFILE, SQL 7-264
of filespec clause, SQL 7-517
REUSE STORAGE clause
of TRUNCATE, SQL 7-613
REVERSE clause
of CREATE INDEX, SQL 7-300
REVERSE clause for indexes, SCN 10-33
reverse indexes, SQL 7-300
reverse key indexes, GTK 4-14, SCN 10-33
reverse migration
not supported, MIG 14-2
REVERSE reserved word, PLS 3-11
reverse-key indexes
creating, PSA 5-5
for minimizing contention, PSA 6-11
Revert button, in Oracle Directory Manager, OID 4-10
REVOKE command, ADG 11-29, ADG 11-34
object types and dependencies, ADO 2-15
REVOKE CONNECT THROUGH clause
of ALTER USER, SQL 7-194, SQL 7-195
revoking multi-tier authorization, SAD 22-14
Revoke Queue Privilege, ADQ 9-50
REVOKE schema_object_privileges statement, SQL 7-559
REVOKE statement, SAD 23-13, SCN 13
FORCE option, ADO 2-15
locks, SCN 240
when takes effect, SAD 23-17
Revoke System Privilege, ADQ 9-45
REVOKE system_privileges_and_roles statement, SQL 7-556
revokee event attribute, ADG 14-4
revokeQueuePrivilege(Session, String, String) - oracle.jms.AQjmsDestination.revokeQueuePrivilege(javax.jms.Session, java.lang.String, java.lang.String), JPR 2-69
revokeSystemPrivilege(String, String) - oracle.jms.AQjmsSession.revokeSystemPrivilege(java.lang.String, java.lang.String), JPR 2-181
revokeTopicPrivilege(Session, String, String) - oracle.jms.AQjmsDestination.revokeTopicPrivilege(javax.jms.Session, java.lang.String, java.lang.String), JPR 2-70
revoking
privileges on selected columns, ADG 11-31
roles and privileges, ADG 11-29
revoking privileges and roles
on selected columns, SAD 23-14
REVOKE statement, SAD 23-13
when using operating-system roles, SAD 23-21
revoking roles and privelieges (AQ), ADQ A-68
rewrite
predicates in security policies, SCN 326
using materialized views, SCN 10-18
REWRITE hint, DWG 19-5, DWG 19-28, SQL 2-65, STU 7-17
REWRITE_INTEGRITY initialization parameter, SRF 1-100
rewrites
hints, DWG 19-28
parameters, DWG 19-5
privileges, DWG 19-6
query optimizations
hints, DWG 19-5, DWG 19-28
matching join graphs, DWG 8-18
RFCs enforced by Oracle Internet Directory, OID F-2
.rhosts file, PSG 2-11
RM (resource manager), ADG 16-2
RM date format element, SQL 2-46
RM format element, NLS 2-14
RM804813.SQL script, SRF 5-7
RMAN, SMS 23-1
AUTOLOCATE option, PSA 13-11
restoring archive logs with, PSA 13-11
See Recovery Manager
tuning for backups, STU 20-61
using to back up archive logs, PSA 13-8
rman command (RMAN), RMN 10-130
RMAN. See Recovery Manager
RMAN. See Recovery Manager.
RMAN1.SH script, RMN 3-19, RMN 3-21
RMJVM.SQL script, SRF 5-8
RN number format element, SQL 2-41
RNDS argument, ADG 9-66
RNDS parameter
of PRAGMA RESTRICT_REFERENCES, SQL 7-189
RNPS argument, ADG 9-66
RNPS parameter
of PRAGMA RESTRICT_REFERENCES, SQL 7-189
ROLAP enhancements, GTK 3-24
Role, Administrator, ADQ 4-6
Role, User, ADQ 4-7
ROLE_ROLE_PRIVS view, SRF 2-161
ROLE_SYS_PRIVS view, ADG 11-9, SRF 2-161
ROLE_TAB_PRIVS view, ADG 11-9, SRF 2-161
roles, SCN 1-40, SCN 319, SRF 1-91
ADMIN OPTION, ADG 11-29
ADMIN OPTION and, SAD 23-11
advantages, ADG 11-8
application, ADG 11-9, ADG 11-12, ADG 11-21, SCN 320
application developers and, SAD 21-11
authorization, SAD 23-8
by a password, SQL 7-366
by an external service, SQL 7-366
by the database, SQL 7-366
by the enterprise directory service, SQL 7-366
changing, SQL 7-76
authorized by enterprise directory service, SAD 23-9
backward compatibility, SAD 23-5
central management, ADG 11-23
changing authorization for, SAD 23-7
changing passwords, SAD 23-7
CONNECT role, ADO 2-11, SAD 23-5, SCN 324
creating, ADG 11-23, SQL 7-365
database authorization, SAD 23-8
DBA role, ADO 2-11, SAD 1-6, SAD 23-5, SCN 324
DDL statements and, SCN 323
default, ADG 11-24, SAD 22-20, SAD 23-18
definer-rights procedures disable, SCN 322
dependency management in, SCN 323
disabling, SAD 23-17
for the current session, SQL 7-600, SQL 7-601
dropping, ADG 11-27, SAD 23-10
enabled or disabled, SCN 321
enabling, ADG 11-9, SAD 23-17
for the current session, SQL 7-600, SQL 7-601
enabling and disabling, ADG 11-16
enterprise, SAD 22-11, SAD 23-9
EXP_FULL_DATABASE, SAD 23-5, SUT 1-4, SUT 1-9
EXP_FULL_DATABASE role, SCN 324
functionality, SCN 304
global, SAD 22-11, SAD 23-9
global authorization, SAD 23-9
GRANT and REVOKE commands, ADG 11-27
GRANT OPTION and, SAD 23-12
GRANT statement, SAD 23-21
granting, ADG 11-28, SCN 305, SCN 321, SQL 7-519
about, SAD 23-10
system privileges on, SQL 7-525
to a user, SQL 7-520
to all users, SQL 7-520
to another role, SQL 7-520
to PUBLIC, SQL 7-520
granting to PUBLIC, ADG 11-34
grouping with roles, SAD 23-4
IMP_FULL_DATABASE, SAD 23-5, SUT 2-6, SUT 2-22, SUT 2-29
IMP_FULL_DATABASE role, SCN 324
in applications, SCN 1-41
invoker-rights procedures use, SCN 323
listing, SAD 23-25
listing grants, SAD 23-24
listing privileges and roles in, SAD 23-26
management, ADG 11-8
management using the operating system, SAD 23-18
managing, ADG 11-21, SAD 23-4
managing via operating system, SCN 325
managing with RADIUS server, OAS 4-24
maximum, SAD 23-18
multi-byte characters
in names, SAD 23-7
multi-byte characters in passwords, SAD 23-8
multi-threaded server and, SAD 23-9
naming, SCN 322
network authorization, SAD 23-9
obtained through database links, DDS 1-23, SCN 393
operating system, ADG 11-27
operating system granting of, SAD 23-20, SAD 23-21
operating-system authorization, SAD 23-8
OS management and the multi-threaded server, SAD 23-22
overview of, SCN 1-40
passwords, ADG 11-18, ADG 11-25
passwords for enabling, SAD 23-8
predefined, SAD 1-6, SAD 23-5, SCN 324
privileges
changing authorization method, SAD 23-7
changing passwords, SAD 23-7
for creating, SAD 23-6
for dropping, SAD 23-10
granting system privileges or roles, SAD 23-10
protecting, ADG 11-23
queue administrator, SCN 73
recommended practices, ADG 11-16
remote clients, SRF 1-103
removing from the database, SQL 7-495
RESOURCE, SUT 2-11
RESOURCE role, ADO 2-11, SAD 23-5, SCN 324
restricting from tool users, ADG 11-12
restrictions on privileges of, SCN 323
REVOKE statement, SAD 23-21
revoking, ADG 11-29, SAD 23-13, SCN 321, SQL 7-556
from another role, SQL 7-495, SQL 7-557
from PUBLIC, SQL 7-557
from users, SQL 7-495, SQL 7-557
revoking ADMIN OPTION, SAD 23-14
schemas do not contain, SCN 322
security and, SAD 21-6
security domains of, SCN 322
SET ROLE statement, ADG 11-27, SAD 23-21
setting in PL/SQL blocks, SCN 323
system privileges, ADG 11-28
unique names for, SAD 23-7
use of passwords with, SCN 1-41
usefulness compromised, ADG 11-6
user, ADG 11-9, ADG 11-21, SCN 321
users capable of granting, SCN 322
uses of, SCN 320
WITH GRANT OPTION, ADG 11-31
without authorization, SAD 23-7
roles in tuning, STU 1-7
roles, external, mapping to DCE groups, OAS 14-7
roll back
to a savepoint, PC_ F-102, PCO F-79
to the same savepoint multiple times, PC_ F-100, PCO F-77
rollback, OCI 2-26, SCN 4-21, SCN 36
automatic, PCO 3-17
defined, SCN 1-53
described, SCN 36
during recovery, SCN 1-50, SCN 349
ending a transaction, SCN 32, SCN 35, SCN 36
in object applications, OCI 13-14
purpose, PCO 3-13
statement-level, PCO 3-17, SCN 34
to a savepoint, SCN 38
ROLLBACK command, ADG 7-6
rollback entries, SCN 4-21
rollback segment, PSA 3-4
deferred, PSC A-21
onlining, PSC A-15
tablespace, PSA 3-4
rollback segments, OID 10-5, PCO 3-12, DWG 18-22, PLS 5-42, PSG 1-16, SBR 1-8, SCN 1-7, SCN 4-21, STU 18-10
access to, SCN 4-21
acquired during startup, SCN 5-9
acquiring, SRF 1-105, SRF 1-120
acquiring automatically, SAD 11-3, SAD 11-11
acquiring on startup, SAD 2-23
allocating, SAD 2-25
allocation of extents for, SCN 4-23
new extents, SCN 4-25
altering storage parameters, SAD 11-9
and RMAN TSPITR, RMN 8-6
assigning to transactions, STU 20-30
AVAILABLE, SAD 11-10
bringing
online, SAD 11-10
online automatically, SAD 11-11
PARTLY AVAILABLE segment online, SAD 11-10
bringing online, SQL 7-78, SQL 7-368
bringing online when new, SAD 11-7
changing storage characteristics, SQL 7-78
checking if offline, SAD 11-11
choosing how many, SAD 2-25, STU 21-4
choosing size for, SAD 2-25
clashes when acquiring, SCN 4-28
committing transactions and, SCN 4-23
CONSISTENT Export parameter, SUT 1-17
contention, PSA 3-4, PSC 7-6, PSC 7-7, STU 21-3
contention for, SCN 4-23
controlling size during import, SUT 2-19
creating, OID 10-5, SAD 11-6 to SAD 11-8, SQL 7-367, STU 21-4
creating public and private, SAD 11-3
deallocating extents from, SCN 4-26
deferred, PSC 7-7, SCN 4-31
defined, SCN 1-7
described, PSG 1-14
description, PSC 7-6
detecting dynamic extension, STU 20-27
displaying
information on, SAD 11-14
PENDING OFFLINE segments, SAD 11-16
displaying names of all, SAD 11-15
distributed locks, PSC 7-7, SRF 1-42
dropping, SAD 11-10, SAD 11-12, SCN 4-26
restrictions on, SCN 4-31
during SQL*Loader loads, SUT 5-26
dynamic extension, STU 20-30
equally sized extents, SAD 11-5
explicitly assigning transactions to, SAD 11-12
Export, SUT 1-50
function of, PC_ 3-16
global constant parameters, PSC 7-7, SRF 1-42
granting
system privileges on, SQL 7-525
guidelines for managing, SAD 11-2 to SAD 11-6
how transactions write to, SCN 4-23
ID number, PSA 3-4, PSA 3-6
in-doubt distributed transactions, DDS 5-12, SCN 4-25
INITIAL, SAD 11-5, SAD 11-8
initial, SAD 11-2
initialization parameters, SRF 1-42
invalid, SCN 4-29
invalid status, SAD 11-13
listing extents in, SAD 19-32
location of, SAD 11-6
locks on, SCN 241
making available for use, SAD 11-9
MAXEXTENTS UNLIMITED, SCN 197
maximum size, SRF 1-68
migration, MIG 4-4
MINEXTENTS, SAD 11-5, SAD 11-8
moving to the next extent of, SCN 4-24
multiple, PSA 3-4, PSC 7-6, SQL 7-368
name, PSA 3-4, PSA 3-6
NEXT, SAD 11-5, SAD 11-8
number of concurrent transactions, SRF 1-120
number of transactions per, SCN 4-23
OFFLINE, SAD 11-10
offline, SAD 11-10, SCN 4-29, SCN 4-31
offline status, SAD 11-11
offline tablespaces and, SCN 4-31
online, PSA 3-6, PSC 7-6, SCN 4-29, SCN 4-31
online status, SAD 11-11
OPTIMAL, SAD 11-5, SAD 11-6, SAD 11-8, SCN 197
overview of, SCN 4-21, SCN 348
parallel DML, SCN 197
parallel recovery, SCN 350
PARTLY AVAILABLE, SAD 11-10
partly available, SCN 4-29, SCN 344
PCTINCREASE, SAD 11-5, SAD 11-8
PENDING OFFLINE, SAD 11-12
private, SAD 11-3, SAD 11-7, SCN 4-27
private rollback segments, SRF 1-105
privileges
for dropping, SAD 11-13
required to create, SAD 11-6
public, PSA 3-5, SAD 11-3, SAD 11-7, SCN 4-27, SQL 7-367
public rollback segments, SRF 1-105
public vs. private, PSA 3-5, PSC 7-7
read consistency and, SCN 1-30, SCN 4-22, SCN 214
recovery needed for, SCN 4-29
reducing size, SQL 7-78
removing from the database, SQL 7-496
setting parameters for, PSA 1-8
setting size of, SAD 11-4
shrinking size of, SAD 11-9
snapshot sites, REP 7-16
specifying, PSA 3-4, SRF 1-105
specifying optimal size of, SQL 7-608
specifying tablespaces for, SQL 7-367
SQL examples, SQL 7-368
states of, SCN 4-29
status for dropping, SAD 11-13
status or state, SAD 11-10
storage characteristics, SQL 7-368, SQL 7-605
storage parameters, SAD 11-7
SYSTEM, PSC 7-6, SRF 1-105
SYSTEM rollback segment, SCN 4-27
tablespace, PSA 3-4, PSA 3-6, PSC 7-6
taking offline, SAD 11-11, SQL 7-78
taking tablespaces offline and, SAD 9-17
transactions and, SCN 4-22
use of in recovery, SCN 1-48, SCN 349
using multiple, SAD 11-2
when acquired, SCN 4-27
when used, SCN 4-22
written circularly, SCN 4-23
ROLLBACK SQL statement, PC_ F-98
ROLLBACK statement, PC_ 3-22, PCO 3-16, PCO F-76, PLS 5-44, SCN 13, SQL 7-564
effect of, PC_ 3-20
effect on savepoints, PLS 5-45
effects, PCO 3-16
ending a transaction, PC_ F-100, PCO F-77
example, PCO 3-16
example of, PC_ 3-21
examples, PC_ F-101, PCO F-78
FORCE clause, DDS 5-13, DDS 5-14, DDS 5-15
forcing, DDS 5-12
in error handling routines, PC_ 3-21
purpose of, PC_ 3-20
RELEASE option, PCO 3-16
RELEASE option in, PC_ 3-21
syntax, PLS 11-149
TO SAVEPOINT clause, PCO 3-16
TO SAVEPOINT clause in, PC_ 3-20
using in a PL/SQL block, PC_ 3-28, PCO 3-25
using in error-handling routines, PCO 3-16
where to place, PC_ 3-21, PCO 3-16
rollback() - oracle.jms.AQjmsSession.rollback(), JPR 2-181
ROLLBACK_SEGMENTS initialization parameter, SRF 1-105
adding rollback segments to, SAD 11-7, SAD 11-11
dropping rollback segments, SAD 11-13
online at instance startup, SAD 11-3, SAD 11-4
setting before database creation, SAD 2-23
unique values, SRF 1-105
ROLLBACK_SEGMENTS parameter, DWG 18-22, PSA 1-9, PSA 1-13, PSG 1-16, PSG 4-5, PSC 7-7, PSC 7-8
private and public segments, PSA 3-4, PSA 3-5
rollbacks
automatic, PC_ 3-22
fast-start on-demand, STU 24-16
fast-start parallel, STU 24-16
function of, PC_ 3-16
implicit, PLS 5-46
of FORALL statement, PLS 4-33
ORA-02067 error, DDS 3-3
statement-level, PC_ 3-22, PLS 5-44
rolling back
instance recovery, PSA 14-3
rollback segments, PSC 7-6
row locks, PSC 4-12
transactions, PCO F-76
rolling back transactions, SCN 1-54, SCN 32, SCN 36, SCN 344
to savepoints, ADG 7-6
rolling forward during recovery, SCN 1-50, SCN 349
rolling up hierarchies, DWG 9-3
ROLLUP, DWG 17-6
partial, DWG 17-8
when to use, DWG 17-10
ROLLUP operation
of queries and subqueries, SQL 7-578
ROLLUP operation, GROUP BY clause, GTK 3-24
Roman numerals
format mask for, NLS 2-14
root, PSG 2-11
root administrative regions
described, NET 4-19
domain requirements, NET 4-19
requirements, NET 4-19
root administrative regions, described, NET 4-19
root blocks, SCN 10-59
root domains, described, NET 4-19
root level, DWG 2-7
root of search
entering, OID 7-4
selecting, OID 7-5
rosbild.sql script, MIG F-22
ROSFILES
nmcbild.sql script, MIG F-22
nmcgrnt.sql script, MIG F-22
rosbild.sql script, MIG F-22
rosgrnt.sql script, MIG F-22
rosgrnt.sql script, MIG F-22
ROUND function
date function, SQL 4-79
format models, SQL 4-117
number function, SQL 4-79
round-robin
distribution value, STU 5-8
ROUND-ROBIN resource allocation method, SAD 25-11
roundtrips
See server roundtrips
roundtrips to the server, avoiding, ADL 5-21, ADL 5-28
routers, verifying, LEG B-5
routine
service, DCI 4-12
routines
autonomous, ADG 7-32
calling, SQL 7-226
executing, SQL 7-226
external, ADG 10-2
service, ADG 10-35
routines, external, PLS 7-44
routing connections, NET 1-3, NET 8-21
routing, data-dependent, PSA 5-16
row cache, PSC 4-2, SCN 7-10
row data (section of data block), SCN 4-5
row directories, SCN 4-4
row errors
Import, SUT 2-45
ROW EXCLUSIVE lock mode, SQL 7-548
row level locking
DML locks, PSA 7-17, PSC 4-7
independent of PCM locks, PSC 4-12
resource sharing system, PSC 1-4
row lock
acquiring with FOR UPDATE OF, PCO 3-21
using to improve performance, PCO D-6
when acquired, PCO 3-22
when released, PCO 3-22
row locking, SCN 221, SCN 231
block-level recovery, SCN 231, SCN 355
manually locking, ADG 7-18
serializable transactions and, SCN 219
row locks, PLS 5-48
acquiring with FOR UPDATE OF, PC_ 3-24
advantage of, PC_ C-6
using to improve performance, PC_ C-6
when acquired, PC_ 3-25
when released, PC_ 3-25
row movement clause for partitioned tables, SAD 15-8
row objects, ADO 1-6, SCN 13-8
storage, ADO 6-7
row operators, PLS 5-6
row pieces, SCN 10-5
headers, SCN 10-6
how identified, SCN 10-8
row sampling, SCN 138, STU 8-3
ROW SHARE lock mode, SQL 7-548
row sources, SCN 126, STU 4-6
Row Statistics for Execute/Fetch drilldown data views, STU 14-20
row triggers, SCN 89
defining, ADG 13-12
REFERENCING option, ADG 13-17
timing, ADG 13-7
UPDATE statements and, ADG 13-6, ADG 13-18
when fired, SCN 102
See also triggers
ROW_CACHE_CURSORS initialization parameter: obsolete
ROW_CACHE_MULTI_INSTANCE parameter (Oracle Version 6), PSC A-23
ROW_LOCKING initialization parameter, SRF 1-106
ROW_LOCKING parameter, ADG 7-11, PSA 1-8
ROW_NUMBER function, DWG 17-35, SQL 4-80
%ROWCOUNT cursor attribute, PLS 5-36, PLS 5-40
ROWID
external datatype, OCI 3-13
Import, SUT 2-48
logical, OCI 3-6, PC_ 4-7, PC_ 4-38
pseudocolumn, PC_ 3-26
using to mimic CURRENT OF, PC_ 3-26, PC_ 8-28
pseudocolumns, PC_ 4-38
universal, PC_ 4-7, PC_ 4-8, PC_ 4-38, PC_ A-5
Universal ROWID, OCI 3-6
used for positioned updates and deletes, OCI 2-34
ROWID datatype, ADG 3-21, PC_ 4-7, PLS 2-17, SCN 12-15, SCN 12-16, SQL 2-26
DBMS_ROWID package, SPR 45-1
extended format, SPR 45-12
extended ROWID format, ADG 3-21
extended rowid format, SCN 12-17
heap tables vs index-organized tables, PCO 4-32
migration, ADG 3-23
restricted rowid format, SCN 12-18
ROWID snapshots, REP 3-5
Universal, PCO 4-32
use of, PCO 4-32
use of ALLOCATE, PCO 4-33
ROWID descriptor, OCI 2-16
ROWID hint, SQL 2-65, STU 7-11
ROWID pseudocolumn, PLS 5-4, SQL 2-26, SQL 2-27, SQL 2-59
ROWID pseudocolumns
retrieving with SQLROWIDGET, PCO 4-33
universal ROWID, PCO 4-32
using to mimic CURRENT OF, PCO 3-22, PCO 7-19
ROWIDs
logical, GTK 3-29
universal, GTK 3-29
rowids, PLS 2-17, SCN 10-8
accessing, SCN 12-16
block portion of, SQL 2-26
changes in, SCN 12-17
compatibility, MIG 9-27
client access, MIG 12-7
conversion to Oracle8i format, MIG 12-3
examples, MIG 12-5
DBMS_ROWID compatibility package, MIG 12-3
description of, SQL 2-26
extended, PLS 2-17, SQL 2-27
not directly available, SQL 2-27
file portion of, SQL 2-26
guess, PLS 2-18
in non-Oracle databases, SCN 12-23
indexes, MIG 12-8
internal use of, SCN 12-16, SCN 12-20
logical, PLS 2-17, SCN 12-15
logical rowids, SCN 12-20
index on index-organized table, SCN 10-42
physical guesses, SCN 10-42, SCN 12-21
staleness of guesses, SCN 12-22
statistics for guesses, SCN 12-22
mapping to bitmaps, STU 12-18
migration, MIG 12-1
FAQ, MIG 12-7
questions and answers, MIG 12-7
nonphysical, SQL 2-27
of clustered rows, SCN 10-8
of foreign tables, SQL 2-27
of index-organized tables, SQL 2-27
physical, PLS 2-17, SCN 12-15
restricted, PLS 2-17, SQL 2-26
compatibility and migration of, SQL 2-27
row migration, SCN 4-11
row portion of, SQL 2-26
snapshot refresh, MIG 12-6
sorting indexes by, SCN 10-30
table access by, STU 4-21
universal, PLS 2-17, SCN 12-16
uses for, SQL 2-60
ROWIDTOCHAR function, ADG 3-25, PLS 5-4, SCN 12-24, SQL 2-37, SQL 4-81
row-level locking, SCN 221, SCN 231
ROWNUM pseudocolumn, PLS 5-5, SQL 2-60
cannot use indexes, STU 4-46
optimizing view queries, STU 4-77, STU 4-88
uses for, SQL 2-61
ROWNUM pseudocolumns, PCO 4-12
ROWS
command-line parameter
SQL*Loader, SUT 8-13
Export parameter, SUT 1-24
Import parameter, SUT 2-26
performance issues
SQL*Loader, SUT 8-18
SQL*Loader command-line parameter, SUT 6-7
rows, SCN 1-22, SCN 10-3
adding to a table, SQL 7-540
addresses of, SCN 10-8
allowing movement of between partitions, SQL 7-383
buffering multiple, DDS 9-8
chaining across blocks, ADG 2-5, SAD 12-4, SAD 19-9, SCN 4-10, SCN 10-5
choosing which to load using SQL*Loader, SUT 5-41
clustered, SCN 10-7
rowids of, SCN 10-8
defined, SCN 1-22
described, SCN 10-3
exporting, SUT 1-24
fetched, SCN 21
fetching from cursors, PC_ F-58, PC_ F-61, PCO F-46, PCO F-49
format, ADG 2-2
format of in data blocks, SCN 4-4
header, ADG 2-2
headers, SCN 10-5
identifying during conflict detection, REP 2-42
inserting
into partitions, SQL 7-542
into remote databases, SQL 7-542
into subpartitions, SQL 7-542
inserting into tables and views, PC_ F-67, PCO F-55
locking, SCN 221, SCN 231
locks on, SCN 11-45, SCN 231, SCN 234
logical rowids, SCN 12-20
index-organized tables, SCN 10-42
migrating to new block, SCN 4-11
movement between partitions, SQL 7-404
order of storage, SQL 7-396
pieces of, SCN 10-5
removing
from a cluster, SQL 7-611
from a table, SQL 7-611
from partitions and subpartitions, SQL 7-466
from tables and views, SQL 7-465
row objects, ADO 1-6, SCN 13-8
row overflow in index-organized tables, SCN 10-41
row sources, SCN 126, STU 4-6
rowids used to locate, STU 4-21, STU 4-35
row-level security, SCN 325
selecting in hierarchical order, SQL 5-20
shown in ROWIDs, ADG 3-22
shown in rowids, SCN 12-17, SCN 12-18
size, ADG 2-2
size of, SCN 10-5
specifying constraints on, SQL 7-241
specifying for import, SUT 2-26
specifying number to insert before save
SQL*Loader, SUT 8-13
storage format of, SCN 10-5
stored in ascending order, SQL 7-244
storing if in violation of constraints, SQL 7-163, SQL 7-245, SQL 7-407
triggers on, SCN 89
updates to existing rows with SQL*Loader, SUT 5-33
updating, PC_ F-111, PCO F-86
violating integrity constraints, ADG 4-20
when rowid changes, SCN 12-17
rows column, SQL trace, STU 6-13
Rows Fetched/Fetch Count Ratio data view, STU 14-12
Rows Sorted data view, STU 14-12
RowSource event, STU 14-5
rows-processed count, PCO 8-9
in the SQLCA, PC_ 9-21
use in error reporting, PC_ 9-15
%ROWTYPE attribute, PLS 2-33
syntax, PLS 11-151
ROWTYPE_MISMATCH exception, ADG 9-41, PLS 6-6
RPAD function, SQL 4-82
RPC (remote procedure call), PLS 6-12
RPC time out, DCI 4-14, DCI 5-10
rpcinfo, use of to test portmapper, LEG B-4
RR date format, ADG 3-11
RR date format element, SQL 2-46, SQL 2-49
interpreting, SQL 2-49
RR diagrams
see syntax diagrams, PCO F-7
RRRR date format element, SQL 2-46
RS locks
LOCK TABLE command, ADG 7-13
RSA encryption, OAS 1-4
rset()
function of UTL_SMTP, SPR 65-11
RTRIM function, SQL 4-82
using to insert data, PLS B-4
RULE, SRF 1-86
Rule, ADQ 1-12
RULE hint, DWG 18-64, SQL 2-64, STU 7-8
OPTIMIZER_MODE and, STU 4-11
rule-based optimization, SCN 142, SRF 1-86, STU 4-34
Rule-based Subscription, ADQ 8-94
rule-based subscriptions, SCN 72
Rules, ADQ 1-19
rules
LDIF, OID A-3
rules, purity, PLS 7-9
Rules, Selecting Subscriber, ADQ 10-37
rules, syntax for configuration files, NET C-2
run command (RMAN), RMN 10-130, RMN 10-133
run() - oracle.jms.AQjmsSession.run(), JPR 2-181
running
a directory, with SSL enabled, OID 8-2
directory servers, OID 3-3
ldapmodify, OID 5-14
on non-default port, OID 4-3
Oracle Directory Manager, OID 4-2
replication server, OID 3-6
run-server command, using OID Control Utility, OID 4-15
runtime areas, SCN 7-9
run-time compilation
avoiding, SQL 7-67, SQL 7-198
runtime context
establishing, PC_ 5-46
terminating, PC_ 5-46
run-time error handling, ADG 9-43
run-time errors, PLS 6-1
runtime type checking, PC_ 17-22
RX locks
LOCK TABLE command, ADG 7-13

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents