Oracle8
i
Generic Documentation Master Index
Release 2 (8.1.6)
A76991-01
Library
Product
Contents
Oracle8
i
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
redo
thread_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
_redo
thread_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 Oracle8
i
, 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