---

R

R0703040.SQL script

replication, MIG 3-28, MIG 4-17

R070304.SQL script, SRF 5-7

RADIUS, OAS 1-7, GTK 2-72, SCN 29-6

accounting, OAS 3-26

asynchronous (challenge-response) authentication mode, OAS 3-5

authentication modes, OAS 3-4

authentication parameters, OAS B-4

challenge-response (asynchronous) authentication, OAS 3-5

challenge-response (asynchronous) authentication, customizing challenge-response user interface, OAS C-1

configuring, OAS 3-9

location of secret key, OAS 3-20

smartcards and, OAS 1-7, OAS 3-4, OAS 3-7, OAS 3-22, OAS C-2

synchronous authentication mode, OAS 3-4

system requirements, OAS 1-12

RADIUS authentication method

see Oracle Advanced Security

RAID, STU 20-25, STU 26-45, STU 26-70

RAISE statement, ADG 10 - 45, PLS 6-11

syntax, PLS 11-132

using in exception handler, PLS 6-15

RAISE_APPLICATION_ERROR procedure, ADG 10 - 44

remote procedures, ADG 10 - 47, DDS 4-11

raise_application_error procedure, PLS 6-9

raising an exception, PLS 6-11

raising exceptions

triggers, ADG 13 - 18

random access, SPS 2-8

random reads, STU 20-5

random writes, STU 20-5

randomizing requests among listeners, NET 2-30, NET C-41

range

distribution value, STU 13-8

range conditions, SQL 5-16

range operator, PLS 3-10

range partition

adding, SQL 7-148

creating, SQL 7-378

range partitioning, GTK 2-46, SCN 11-15, STU 13-13, STU 26-46

and primary key columns, SCN 11-42

equipartitioning, SCN 11-24

examples of, STU 13-15

key comparison, SCN 11-20, SCN 11-22

partition bounds, SCN 11-20

performance considerations, STU 26-47

RAW

external datatype, OCI 3-14

Raw, PSC 3-6

RAW column

maximum width, PCO 4-4

RAW data

converting from CHAR data, SQL 2-19

RAW datatype, ADG 4 - 18, PC_ 4-9, PLS 2-15, SCN 12-14, SQL 2-18, SUT 5-59, SUT 5-64

compared with CHAR, PCO 4-4

converting, PCO 4-53, PLS 2-29

external, PCO 4-12

internal, PCO 4-4

maximum length, PLS 2-15

restrictions, PCO 4-4

SQL*Loader, SUT 5-68

raw device, SPS 23-4, STU 24-2

raw devices

control files, PSC 2-7

creating, PSC 2-7, PSC 8-3

creating as root user, PSC 2-7

creating on UNIX, PSC 2-7

creating on Windows NT, PSC 2-9

DB_NAME.TBL file, PSC 2-9

DR tablespace, PSC 2-6

identifying, PSC 2-10

identifying on UNIX, PSC 2-10

CTL1 database object, PSC 2-10

CTL2 database object, PSC 2-10

DR database object, PSC 2-10

INDX1 database object, PSC 2-10

LOGthread_id_number database object, PSC 2-10

OEMREP1 database object, PSC 2-10

RBS1 database object, PSC 2-10

SYS1 database object, PSC 2-10

TMP1 database object, PSC 2-10

USR1 database object, PSC 2-10

identifying on Windows NT, PSC 2-11

db_name_ctl1 symbolic link, PSC 2-12

db_name_ctl2 symbolic link, PSC 2-12

db_name_dr symbolic link, PSC 2-11

db_name_indx1 symbolic link, PSC 2-12

db_name_logthread_id_number
symbolic link, PSC 2-12

db_name_oemrep1 symbolic link, PSC 2-12

db_name_rbs1 symbolic link, PSC 2-11

db_name_sys1 symbolic link, PSC 2-11

db_name_tmp1 symbolic link, PSC 2-11

db_name_usr1 symbolic link, PSC 2-12

INDX1 tablespace, PSC 2-6

minimum size for Oracle Database Configuration Assistant, PSC 2-6

number required, PSC 2-6

OEM_REPOSITORY tablespace, PSC 2-6

RBS tablespace, PSC 2-6

redo log files, PSC 2-7

setting DBCA_RAW_CONFIG environment variable, PSC 2-8, PSC 2-13, PSC 4-3

setting up, PSC 2-6 to PSC 2-12

suggested file names on UNIX, PSC 2-7

SYSTEM tablespace, PSC 2-6

TEMP tablespace, PSC 2-6

USERS tablespace, PSC 2-6

verification, PSC 3-5, PSC 3-6

raw partition

LOG_ARCHIVE_DEST parameter, SRF 1-60

RAW session layer, NET 4-13, NET 7-55

RAWTOHEX function, ADG 4 - 25, PCO 4-53, SCN 12-23, SQL 2-32, SQL 4-31

RBS tablespace raw device, PSC 2-6

RC4, NET 4-31

RC4 encryption algorithm, OAS 1-4

RDB Database option, NET 7-71

RDB_DATABASE parameter, NET 7-8, NET 7-71, NET C-47

RDBMS, SCN 1-22

object-relational DBMS, SCN 1-22, SCN 13-2

See also Oracle

rdbms ipc message block wait event, SRF A-46

rdbms ipc message wait event, SRF A-45

rdbms ipc reply wait event, SRF A-46

RDBMS_SERVER_DN, SRF 1-104

reactive tuning, STU 2-3

read committed isolation, SCN 27-6, SCN 27-8

read consistency, PCO 3-19, PLS 5-41, SCN 27-2, SCN 27-4, STU 18-7

Cache Fusion, SCN 27-6

defined, SCN 1-31

definition of, PC_ 3-16

dirty read, SCN 27-2, SCN 27-10

Export utility, SBR 13-16

LOBs, ADL 2-2

multiversion, SPS 4-6

multiversion consistency model, SCN 1-31, SCN 27-4

nonrepeatable read, SCN 27-3, SCN 27-10

Oracle Parallel Server, SCN 27-6

phantom read, SCN 27-3, SCN 27-10

queries, SCN 16-12, SCN 27-4

rollback information, SPS 6-8, SRF 1-46

rollback segments and, SCN 4-20

snapshot too old message, SCN 27-5

statement level, SCN 27-5

subqueries in DML, SCN 27-14

transactions, SCN 1-31, SCN 27-4, SCN 27-6

triggers and, SCN 20-21, SCN 20-23

read consistent locators, ADL 2-2, ADL 2-3, ADL 2-9, ADL 2-12, ADL 2-19, ADL 2-21, ADL 2-22, ADL 2-24

read lock mode, SPS 4-15

READ object privilege, SQL 7-508

READ ONLY clause

of ALTER TABLESPACE, SQL 7-169

of SET TRANSACTION, SQL 7-572

READ ONLY option

ALTER TABLESPACE, SCN 3-10

READ ONLY parameter, PLS 5-46

in SET TRANSACTION statement, PC_ 3-23

using in SET TRANSACTION, PCO 3-27

read snapshot time, SCN 27-10

read uncommitted, SCN 27-3

READ WRITE clause

of ALTER TABLESPACE, SQL 7-169

of SET TRANSACTION, SQL 7-573

READ WRITE option

ALTER TABLESPACE, SCN 3-11

READ_CLIENT_INFO

procedure in DBMS_APPLICATION_INFO, STU 5-2

READ_MODULE

procedure in DBMS_APPLICATION_INFO, STU 5-2

READ_ONLY_OPEN_DELAYED parameter, SRF 1-105

readability, PLS 2-2, PLS 3-19

READBUFFERS keyword

SQL*Loader, SUT 5-24, SUT 8-15

read-consistent export, SUT 1-17

readers block writers, SCN 27-10

reader/writer conflicts

and Cache Fusion, SPS 20-1

read-only access, SPS 4-6, SPS 4-15

applications, SPS 2-7

index data, SPS 15-5

read PCM lock, SPS 4-15

read-only database open, SAD 3-8

read-only databases, GTK 2-51

opening, SCN 5-9

read-only mode

standby databases, SBR 16-5, SBR 16-19

read-only replication

uses of, REP 1-10, SCN 34-11

read-only snapshot, REP 1-7, SCN 34-8

read-only snapshots, REP 3-7

registration, REP 7-37

manual, REP 7-37

unregistering, REP 7-37

read-only tables, SPS 12-2

read-only tablespaces

active transactions, MIG 8-23

altering to writable, SAD 9-14

backing up, SBR 8-15, SCN 32-26

compatibility, MIG 8-23

creating, SAD 9-12

datafiles, SAD 10-8

described, SCN 3-10

effect on recovery, SBR 14-5

Import, SUT 2-54

migration, MIG 3-4

on a WORM device, SAD 9-14

recovering, SBR 14-5

restrictions on, SCN 3-12

transition read-only mode, SCN 3-11

read-only transaction, PCO 3-26, PLS 5-46

ending, PCO 3-27

example, PCO 3-27

read-only transactions, ADG 8 - 8, SCN 1-32

description of, PC_ 3-23

distributed, DDS 3-17

example of, PC_ 3-23

how ended, PC_ 3-23

reads

data block

limits on, SCN 29-17

dirty, SCN 27-2

repeatable, SCN 27-6

read/write operations, STU 20-5

REAL datatype

ANSI, SQL 2-24

REAL keyword

behavior in Oracle7 and Oracle8i, MIG 8-22

Real REF Columns, SUT 5-97

REAL subtype, PLS 2-13

realm (CyberSafe), OAS 4-3

realm (Kerberos), OAS 5-3, OAS Glossary-6

real-time

data replication, REP 1-15, SCN 34-16

replication, REP 1-15, REP 8-6, SCN 34-16

REBUILD, STU 6-9

REBUILD clause

of ALTER INDEX, SQL 7-31, SQL 7-36

of ALTER OUTLINE, SQL 7-58

REBUILD COMPRESS clause

of ALTER INDEX, SQL 7-37

REBUILD COMPUTE STATISTICS clause

of ALTER INDEX, SQL 7-38

REBUILD INDEX command

no-logging mode, SCN 11-58, SCN 25-7

rules of parallelism, SCN 26-25

REBUILD INDEX PARTITION command, SCN 11-60

no-logging mode, SCN 25-7

rules of parallelism, SCN 26-25

REBUILD LOGGING clause

of ALTER INDEX, SQL 7-38

REBUILD NOCOMPRESS clause

of ALTER INDEX, SQL 7-38

REBUILD NOLOGGING clause

of ALTER INDEX, SQL 7-38

REBUILD NOREVERSE clause

of ALTER INDEX, SQL 7-37

REBUILD ONLINE clause

of ALTER INDEX, SQL 7-38

REBUILD PARAMETERS clause

of ALTER INDEX, SQL 7-38

REBUILD PARTITION clause

ALTER INDEX command, SAD 13-11, SAD 13-20

of ALTER INDEX, SQL 7-37

REBUILD REVERSE clause

of ALTER INDEX, SQL 7-37

REBUILD SUBPARTITION clause

of ALTER INDEX, SQL 7-37

REBUILD TABLESPACE clause

of ALTER INDEX, SQL 7-37

REBUILD UNUSABLE LOCAL INDEXES clause

of ALTER TABLE, SQL 7-146

rebuild_freelists procedure, SAD 19-6, SAD 19-10

rebuilding indexes

physical ROWIDs, MIG 11-8

RECALCULATE_STATISTICS parameter, SUT 2-27

receiver, REP 2-5

accounts

master sites, REP 2-8

receiving data

asynchronously, NET 2-4

synchronously, NET 2-4

recipients, SCN 19-5

subscription lists, SCN 19-5

RECNUM keyword

SQL*Loader, SUT 5-46

use with SQL*Loader keyword SKIP, SUT 5-55

RECO process, SPS 1-18, SPS 5-5

RECOMMEND_MV function, STU 32-17

RECOMMEND_MV_W function, STU 32-17

recompiling

automatically, SAD 20-24

functions, SAD 20-25

packages, SAD 20-25

procedures, SAD 20-25

stored functions, procedures, and packages, SUT 2-61

views, SAD 20-25

RECORD

Export parameter, SUT 1-23

record, PC_ 7-5, PLS 4-37

%ROWTYPE, PLS 5-13

assigning, PLS 4-42

comparing, PLS 4-44

declaring, PLS 4-39

defining, PLS 4-38

implicit declaration, PLS 5-13

initializing, PLS 4-40

manipulating, PLS 4-44

nesting, PLS 4-38

referencing, PLS 4-40

syntax, PLS 11-134

RECORD datatype, PLS 4-37

record keeping, STU 2-13

record, user-defined, PCO 6-6

RECORDLENGTH

Export parameter, SUT 1-23

direct path export, SUT 1-43

Import parameter, SUT 2-27

records

consolidating into a single logical record

SQL*Loader, SUT 5-36

DISCARD command-line parameter, SUT 6-5

discarded by SQL*Loader, SUT 3-12, SUT 5-27

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-5

missing data columns during load, SUT 5-42

null columns at end, SUT 5-82

rejected, SUT 3-14

rejected by SQL*Loader, SUT 3-12

rejected SQL*Loader records, SUT 5-25

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-23, SUT 2-27

specifying length for import, SUT 2-27

stream record format, SUT 3-6

variable format, SUT 3-6

RECOVER ... FROM option

ALTER DATABASE command, SBR 14-8, SBR 14-12

RECOVER AUTOMATIC clause

of ALTER DATABASE, SQL 7-13

RECOVER AUTOMATIC LOGFILE option

ALTER DATABASE command, SBR 14-15

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, SBR 14-9, SPS 18-19, SPS 22-7, SPS 22-13, SPS 22-15

FROM 'location' option, SBR 16-29

MANAGED STANDBY DATABASE option, SBR 16-8, SBR 16-18

PARALLEL clause, SBR 14-20

unrecoverable objects and standby databases, SBR 14-5

UNTIL TIME option, SBR 14-31

recover command (RMAN), SBR 4-49, SBR 9-15, SBR 11-88

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, SPS 22-7, SPS 22-8

RECOVER DATAFILE clause

of ALTER DATABASE, SQL 7-7, SQL 7-13

RECOVER DATAFILE command, SBR 14-10

RECOVER DATAFILE statement, SPS 22-7, SPS 22-8

recover in-doubt transaction dialog, DDS 3-30

RECOVER LOGFILE clause

of ALTER DATABASE, SQL 7-7, SQL 7-14

RECOVER MANAGED STANDBY DATABASE clause

of ALTER DATABASE, SQL 7-8

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

PARALLEL clause, STU 25-14

RECOVER TABLESPACE clause

of ALTER DATABASE, SQL 7-7, SQL 7-13

RECOVER TABLESPACE command, SBR 14-9

RECOVER TABLESPACE statement, SPS 22-7, SPS 22-8

recoverability and availability enhancements

multiple ARCH processes, GTK 2-50

multiple, remote archive destinations, GTK 2-50

see also automated standby databases

RECOVERABLE, SQL 7-36, SQL 7-371

See also LOGGING clause.

recoverable save set, LEG 2-8

recovered tablespaces

backing up, SBR B-14

recoverer process (RECO), SCN 1-20, SCN 8-12

disabling, DDS 3-34

distributed transaction recovery, DDS 3-34

DISTRIBUTED_TRANSACTIONS parameter, DDS 3-18

enabling, DDS 3-34

in-doubt transactions, SCN 1-36, SCN 5-8, SCN 17-8

pending transaction table, DDS 3-34

recovering

OS and NetWorker, UNIX, LEG 5-10, LEG 5-19

to new server, UNIX, LEG 5-16, LEG 5-25

recovery, REP 7-17, SPS 22-1

access to files, SPS 6-2, SPS 22-4

after SHUTDOWN ABORT, SPS 18-27

archive history, SPS 14-4

automatic, SPS 21-7

basic steps, SCN 1-50, SCN 32-9

block-level recovery, SCN 27-21, SCN 32-14

cancel-based, SBR 14-20, SBR 14-23, SBR 14-26, SBR 14-29

change-based, SBR 14-32 to SBR 14-35

commands, SBR 14-2 to SBR 14-10

compatibility, MIG 8-13, MIG 8-39

complete using RMAN, SBR 9-18

conversion to multi-instance, SPS 23-9

crash, SBR 1-19

crash recovery, SCN 1-46, SCN 32-4, SCN 32-13

instance failure, SCN 5-10

opening a database, SCN 5-8

read-only tablespaces, SCN 32-6

required after aborting instance, SCN 5-10

SMON process, SCN 1-19, SCN 8-11

creating new control files, SAD 5-5

data warehouse, STU 11-9

database buffers and, SCN 32-8

dead transactions, SCN 32-4

deferred transaction, SPS A-12

definition, SPS 22-1

detection of error, SPS 19-8

diagrammed, SCN 32-13

direct path load

SQL*Loader, SUT 8-13

disaster, SPS 22-10, SPS 22-13

disaster recovery, SCN 32-26

disaster using RMAN, SBR 9-35

distributed databases

with snapshots, SBR 15-17

distributed processing in, SCN 8-12

distributed, enabling, SQL 7-99

effect of checkpoints, STU 20-39

for replication, REP 7-17

FREEZE_DB_FOR_INSTANCE_RECOVERY, SPS 22-4

from an offline backup, SPS 22-10

from an online backup, SPS 22-10

from multiple node failure, SPS 22-3

from single-node failure, SPS 22-2

global checkpoint, SPS 21-9

Import utility, SBR 13-18

incomplete media, SPS 22-8

incomplete using RMAN, SBR 9-23

instance, SBR 1-19, SPS 14-4, SPS 18-27, SPS 22-2

instance failure, SPS 22-1

instance recovery, SCN 32-4, SPS 22-1

Fast-Start Checkpointing, SCN 32-13

instance failure, SCN 1-46, SCN 32-4

parallel DML, SCN 26-41

read-only tablespaces, SCN 32-6

SMON process, SCN 1-19, SCN 8-11, SCN 26-41

log history, SPS 21-7, SPS 22-9

media, SBR 14-1, SBR 15-1

complete, SBR 3-28

incomplete, SBR 3-28

media failure, SPS 6-2, SPS 21-7, SPS 21-10, SPS 22-6, SPS 22-7, SPS A-22

media recovery

dispatcher processes, SCN 8-20

enabled or disabled, SCN 32-18

media, with striping, STU 26-44

multi-threaded, SBR 14-13

number of required processes, SRF 1-104, SRF 1-106

of database, SQL 7-7

of distributed transactions, SCN 5-8

of lost or damaged recovery catalog, SBR 6-33

online, SPS 22-2

open database using RMAN, SBR 9-22

overview of, SCN 1-45, SCN 32-8

parallel, SPS 22-14, SPS 22-15

intra transaction recovery, STU 25-16

parallel DML, SCN 26-40

parallel processes for, SBR 14-19, STU 25-14

parallel recovery, SCN 32-10

parallel restore, SCN 32-16

PARALLEL_MAX_SERVERS initialization parameter, SBR 14-20, STU 25-14

PARALLEL_MAX_SERVERS parameter, SPS 22-15

phases, SPS 22-5

point-in-time

clone database, SCN 5-7

process recovery, SCN 8-11, SCN 32-3

read-only tablespaces, SBR 14-5

recommendations for, SCN 32-13

Recovery Manager, SCN 1-51, SCN 32-15, SPS 22-8

recovery time, SPS 21-10

replacing rows, SUT 5-32

restrictions, SPS A-22

rolling back, SPS 6-8

rolling back transactions, SCN 32-9

rolling forward, SCN 32-9

See Also media recovery

setting number of processes to use, SBR 14-19, STU 25-14

setting parallelism, SPS 22-14, SPS 22-15

standby database, SCN 32-26

starting another instance, SPS 14-4

startup with automatic, SAD 3-5

statement failure, SCN 32-3

strategies

deciding what to recovery, SBR 3-28

determining when media recovery is necessary, SBR 3-30

structures used in, SCN 1-47, SCN 32-6

testing distributed transactions, DDS 3-33

time-based, SBR 3-28, SBR 14-29 to SBR 14-31

using backup control file (RMAN), SBR 9-20

using redo log, SPS 21-12

using RMAN, SBR 9-15

whole database backups, SCN 32-24

recovery array read time statistic, SRF C-14

recovery array reads statistic, SRF C-14

recovery blocks read statistic, SRF C-14

recovery catalog, SBR 4-13, SBR 5-4 to SBR 6-33

and incomplete recovery, SBR 9-24

backing up, SBR 4-14

cataloging

O/S backups, SBR 6-27

changing availability of backup, SBR 6-8

changing status of backups to deleted, SBR 6-13

connecting to Recovery Manager with, SBR 5-10, SBR 5-11

connecting to Recovery Manager without, SBR 5-9, SBR 5-10

consequences of using, SBR 5-4

creating, SBR 6-2

in separate database, SBR 5-5

crosschecking, SBR 6-9

dropping, SBR 6-35

log switch record, SBR 6-27

managing size of, SBR 6-26

operating with, SBR 4-13

operating without, SBR 4-15

overview, SBR 4-13

PL/SQL packages requirement, MIG 8-39

querying, SBR 4-20, SBR 7-2

recovery of lost or damaged, SBR 6-33

refreshing, SBR 6-23

registering databases, SBR 6-4, SBR 6-5

removing records, SBR 6-16

resynchronizing, SBR 4-14, SBR 6-23

schema, SBR 5-5

setting up, SBR 6-2

snapshot control file, SBR 4-14

unregistering databases, SBR 6-6

updating

after schema changes, SBR 6-25

upgrading, MIG 7-30, SBR 6-34

views, SBR 12-1

Recovery Catalog, Oracle8, LEG 1-9, LEG 1-10

Recovery Manager, SCN 1-51, SCN 32-15, SPS 22-6

advantages to using, SBR 4-4

allocate channel for maintenance, SBR 11-13

archive log backup, SPS 21-7

backup management, MIG 8-40

backup method, SBR 3-9

backup pieces, SBR 4-31

backup sets, SBR 4-31

backup types, SBR 4-28

duplexed backup sets, SBR 4-33

backups, SBR 8-2

archived redo logs, SBR 8-8

control file, SBR 8-6, SBR 8-7

datafile, SBR 8-4, SBR 8-5, SBR 8-6

fractured block detection, SBR 4-55

image copy, SBR 4-45

incremental, SBR 8-9

tablespace, SBR 8-4, SBR 8-5, SBR 8-6

using tags, SBR 4-46

whole database, SBR 8-3

channel control

overview, SBR 4-24

command line arguments, SBR 4-9

commands

allocate channel, SBR 11-9

allocate channel for delete, SBR 8-26

alter database, SBR 11-15

backup, SBR 4-19, SBR 4-29, SBR 8-2, SBR 8-26

catalog, SBR 6-5, SBR 6-27

change, SBR 6-10, SBR 6-28

connect, SBR 11-44

copy, SBR 11-48

create catalog, SBR 11-52

create script, SBR 11-54

crosscheck, SBR 11-57

debug, SBR 11-62

delete expired backup, SBR 11-63

delete script, SBR 11-65

drop catalog, SBR 11-68

duplicate, SBR 11-69

execute script, SBR 6-20

host, SBR 11-74

interactive use of, SBR 4-10

job, SBR 4-9

job commands, SBR 4-8

list, SBR 6-7

overview, SBR 4-5

print script, SBR 11-86

recover, SBR 4-49, SBR 9-15

register, SBR 6-6

release channel, SBR 11-95

replace script, SBR 11-97

replicate controlfile, SBR 9-11

report, SBR 7-5

reset database, SBR 6-7

restore, SBR 9-17

resync catalog, SBR 6-33

rman, SBR 11-121

run, SBR 11-124

send, SBR 5-20

set, SBR 8-22, SBR 9-9

shutdown, SBR 11-137

sql, SBR 11-140

stand-alone, SBR 4-9

stand-alone commands, SBR 4-8

startup, SBR 11-142

switch, SBR 11-144

upgrade catalog, SBR 11-148

using command files, SBR 4-10

validate, SBR 11-150

compatibility, MIG 8-39

compilation and execution of commands, SBR 4-6

connecting

duplicate database, SBR 5-11

with password files, SBR 5-9, SBR 5-11

with recovery catalog, SBR 5-10, SBR 5-11

without password files, SBR 5-10

without recovery catalog, SBR 5-9, SBR 5-10

connection options, SBR 5-8

constraints

backup, SBR 4-44

restore, SBR 4-48

corrupt datafile blocks, SBR 4-54, SBR 4-55

handling I/O errors and, SBR 4-36

creating duplicate databases, SBR 10-2

crosschecking recovery catalog, SBR 6-9

database character set, SBR 5-3

dates in commands, SBR 5-2

disaster recovery, SPS 22-10

disconnecting from, SBR 5-12

downgrading to 8.0.3

re-installing packages, MIG 12-52

errors, SBR 4-12

fractured block detection in, SBR 4-55

generating reports, SCN 32-17

image copy backups, SBR 4-45

incomplete media recovery, SPS 22-8

incomplete recovery

with a recovery catalog, SBR 9-24

without a recovery catalog, SBR 9-27

incremental backups

cumulative, SBR 4-42

differential, SBR 4-40

level 0, SBR 4-39

integrity checking, SBR 4-54

interactive use of commands, SBR 4-10

introduction, SBR 4-2

lists, SBR 7-2

media management

backing up files, SBR 4-17

Backup Solutions Program (BSP), SBR 4-20

crosschecking, SBR 4-18

maximum file size, SBR 5-20

media manager, linking with a, SBR 5-19

proxy copy, SBR 4-19

requirements, SBR 5-19

restoring files, SBR 4-18

testing, SBR 4-19

unique filenames, SBR 5-19

media recovery, SPS 22-8

metadata, SBR 4-13, SBR 6-1

storing in control file, SBR 4-15

multiplexing

datafiles, SBR 4-32

name translation, SBR 4-6

operating without a catalog, SCN 32-16

overview, SBR 4-4

parallel operations, SCN 32-16

parallel recovery, SCN 32-11

parallelization of backups, SBR 4-34

password files, SBR 5-2

PL/SQL job steps, SBR 4-6

recovery, SBR 9-15

after total media failure, SBR 9-35

complete, SBR 9-18

incomplete, SBR 9-23

open database, SBR 9-22

using backup control file, SBR 9-20

recovery catalog, SBR 4-13, SCN 32-15

backing up, SBR 6-30

changing availability of backups and copies, SBR 6-8

creating a separate database, SBR 5-5

crosschecking, SBR 6-9

deciding whether to use, SBR 5-4

losing control files when not using a, SBR 4-16

managing the size of, SBR 6-26

operating with, SBR 4-13

operating without, SBR 4-15

querying, SBR 4-20, SBR 7-2

recovering lost or damaged, SBR 6-33

registering databases, SBR 6-5

removing records, SBR 6-16

resynchronizing, SBR 6-23

schema, SBR 6-2

snapshot control file, SBR 4-14

updating after schema changes, SBR 6-25

upgrading, SBR 6-34

registering databases, SBR 6-6

reports, SBR 7-5

database schema, SBR 7-8

objects needing a backup, SBR 7-5

obsolete backups, SBR 7-6, SBR 7-8

resetting database information, SBR 6-7

restoring, SBR 9-2

archived redo logs, SBR 9-13

control files to new location, SBR 9-11, SBR 9-12

database to default location, SBR 9-3

restoring datafiles using, SBR 4-47

sample scripts, SBR 5-21

sbttest program, SBR 4-19, SBR 5-21

setting time parameters, SBR 5-2

snapshot control file location, SBR 5-3

stored scripts, SBR 4-10

syntax conventions, SBR 11-2

tablespace point-in-time recovery, SBR 4-51

types of backups, SBR 4-45

user tags for backups, SBR 4-46

using RMAN commands, SBR 4-5

Recovery Manager (RMAN), Oracle8, LEG 1-9, LEG 1-10

recovery sets

containing whole tables, SBR A-6

copying to primary database, SBR B-13

for RMAN TSPITR, SBR A-4

importing into primary database, SBR B-13

recovery strategy

overview, SBR 1-17 to SBR 1-25

RECOVERY_CATALOG_OWNER role, SQL 7-503

RECOVERY_PARALLELISM initialization parameter, SBR 14-19, STU 25-14

RECOVERY_PARALLELISM parameter, PSC 6-10, SPS 18-10, SPS 22-1, SPS 22-14, SPS 22-15, SRF 1-106

RECTIFY

procedure, REP 7-19

rectifying

tables, SPR 31 - 5, RAR 8-63, REP 7-19

recursion, PLS 7-37

infinite, PLS 7-38

mutual, PLS 7-40

terminating condition, PLS 7-38

versus iteration, PLS 7-41

recursive calls, STU 14-14, STU 20-26

recursive calls statistic, SRF C-14

recursive cpu usage statistic, SRF C-14

recursive SQL, STU 10-1

cursors and, SCN 16-7

recyclable save set, LEG 2-8

recyclable volumes, LEG 2-7

RECYCLE cache, STU 19-31

REDEFINES clause

purpose, PCO 2-18

restrictions, PCO 2-18

REDEFINES support, PCO A-7

redo allocation latch, STU 21-16, STU 21-19

REDO BUFFER ALLOCATION RETRIES, STU 21-15

redo copy latches, STU 21-17, STU 21-19

choosing how many, STU 21-17

redo entries, SCN 1-12, SCN 32-9

content of, SAD 6-2

See redo records

redo entries statistic, SRF C-14

redo log, SCN 1-12, SCN 32-9

archiving mode, SPS 21-3

archiving modes, SCN 32-18

instance recovery, SPS 22-2

log history, SPS 21-6

reconfiguring, SPS 14-9

redo log buffer, SPS 5-5

rolling forward, SCN 32-8, SCN 32-9

instance failure, SCN 32-4

redo log "kick" enqueue, SRF B-2

redo log buffer tuning, STU 19-6

redo log buffers, SCN 1-16, SCN 7-6

circularity, SCN 8-9

committing a transaction, SCN 8-10

log writer process and, SCN 7-6

size, SRF 1-67

size of, SCN 7-6

writing, SCN 8-9

writing of, SAD 6-2

redo log entries

committed data, SCN 32-8, SCN 32-9

uncommitted data, SCN 32-9

redo log file

accessibility, SPS 5-9

adding, SPS A-18

archiving, SPS 4-6, SPS 14-9, SPS 21-1, SPS 21-3, SPS 21-10

backup, SPS 21-12

dropping, SPS 21-10, SPS A-18

identified in control file, SPS 6-5

log history, SPS 21-6

log sequence number, SPS 21-5

multiplexed, SPS 21-7

overwriting, SPS 4-6, SPS 21-3

renaming, SPS 21-10, SPS A-18

thread of redo, SPS 6-3

redo log file groups

switching, SQL 7-100

redo log file members

adding to existing groups, SQL 7-18

dropping, SQL 7-18

renaming, SQL 7-15

redo log files, SBR 1-8, SCN 1-12, SCN 32-7

"fuzzy" data in backups and, SBR 3-17

active (current), SAD 6-4

adding, SQL 7-18

archived, SBR 2-15, SCN 1-48, SCN 32-18

advantages of, SAD 7-2, SBR 2-14

automatically, SCN 32-19

contents of, SAD 7-2, SBR 2-15

errors in archiving, SCN 32-20

log switches and, SAD 6-5

manually, SCN 32-20

archived redo log files, SAD 7-7

archived redo logs, SAD 7-4

archiver process (ARCn), SCN 1-19, SCN 8-12

automatic archiving of, SQL 7-96

automatic name generation, SQL 7-13

available for use, SAD 6-3

buffer management, SCN 8-9

circular use of, SAD 6-3

clearing, SAD 6-7, SAD 6-17, SBR 2-14

restrictions, SAD 6-17

contents of, SAD 6-2

creating

groups and members, SAD 6-11

creating members, SAD 6-11

direct path load, SUT 8-14

disabling specified threads in a parallel server, SQL 7-15

distributed transaction information in, SAD 6-3

dropping, SQL 7-18

enabling specified threads in a parallel server, SQL 7-15

files named in control file, SBR 2-3, SCN 32-21

groups, SAD 6-6, SBR 2-13

creating, SAD 6-11

decreasing number, SAD 6-10

dropping, SAD 6-14

LOG_FILES initialization parameter, SAD 6-10

members, SAD 6-6, SBR 2-13

threads, SAD 6-2

how many in redo log, SAD 6-9

inactive, SAD 6-4

instance and media recovery

SQL*Loader, SUT 8-14

legal and illegal configurations, SAD 6-7

LGWR and the, SAD 6-3

listing files for backup, SBR 13-2

log sequence numbers, SCN 1-48

recorded in control file, SCN 32-22

log sequence numbers of, SAD 6-5

log switch

ALTER SYSTEM SWITCH LOGFILE, SCN 8-12

archiver process, SCN 1-19, SCN 8-12

log switches, SAD 6-5

log writer process, SCN 8-9

members, SAD 6-6, SBR 2-13

creating, SAD 6-11

dropping, SAD 6-14

maximum number of, SAD 6-10

mirrored

log switches and, SAD 6-7, SBR 2-14

mirroring, STU 20-21

mode of, SCN 1-48

multiplexed, SBR 2-12, SCN 1-48

diagrammed, SAD 6-6, SBR 2-13

groups, SBR 2-13

if all inaccessible, SAD 6-7, SBR 2-14

if some members inaccessible, SBR 2-14

purpose of, SBR 1-9, SCN 1-12

multiplexing, SAD 6-5

groups, SAD 6-6

if some members inaccessible, SAD 6-7

naming, SBR 14-10

online, SAD 6-2

recovery use of, SAD 6-2

requirement of two, SAD 6-3

threads of, SAD 6-2

online or offline, SCN 1-47, SCN 1-48, SCN 32-7

online redo log, SAD 6-1

overview, SBR 1-8

overview of, SCN 1-12, SCN 1-47

parallel recovery, SCN 32-10

physical database structure, SCN 1-5

placement on disk, STU 20-21

planning the, SAD 6-5, SAD 6-10

privileges

adding groups and members, SAD 6-11

re-archiving, MIG 8-43

recovery and, SCN 32-7

redo entries, SAD 6-2, SCN 1-12, SCN 32-9

requirements, SAD 6-7

reusing, SQL 7-491

rolling forward and, SCN 32-9

saving space

direct path load, SUT 8-19

size of, SQL 7-491

specifying, SQL 7-490

for media recovery, SQL 7-14

verifying blocks, SAD 6-16

viewing, SAD 2-8

when temporary segments in, SCN 4-19

written before transaction commit, SCN 8-10

redo log files raw devices, PSC 2-7

redo log files, described, PSC 1-12

redo log space requests statistic, SRF C-15

redo log space wait time statistic, SRF C-15

redo log switch interrupts statistic, SRF C-15

redo logs, applying, LEG 5-26

redo ordering marks statistic, SRF C-15

redo records, SAD 6-2, SCN 1-12

redo size statistic, SRF C-15

redo sync writes statistic, SRF C-15

redo synch time statistic, SRF C-15

redo thread, SPS 21-4, SRF 1-122

redo thread enqueue, SRF B-2

redo wait event, SRF A-46

redo wastage statistic, SRF C-16

redo write time statistic, SRF C-16

redo writer latching time statistic, SRF C-16

redo writes statistic, SRF C-16

REDUCE_ALARM parameter, SRF 1-106

reducing

buffer cache misses, STU 19-29

contention

dispatchers, STU 21-6

OS processes, STU 24-2

query servers, STU 21-15

redo log buffer latches, STU 21-15

shared servers, STU 21-10

data dictionary cache misses, STU 19-20

library cache misses, STU 19-15

paging and swapping, STU 19-4

rollback segment contention, STU 21-4

unnecessary parse calls, STU 19-9

REENABLE keyword

SQL*Loader, SUT 8-22

re-enabling

advanced replication, REP 8-36

REF

binding, OCI 5-10, OCI 12-3

defining, OCI 5-16, OCI 12-4

external datatype, OCI 3-18

indicator variable for, OCI 2-31

retrieving from server, OCI 10-11

structure for, PC_ 17-33

ref, PLS 9-27

dangling, PLS 9-33

declaring, PLS 9-28

dereferencing, PLS 9-33

REF (reference to object), PC_ 17-2

REF Columns, SUT 5-97

REF columns

primary key, SUT 5-98

real, SUT 5-97

specifying, SQL 7-368

specifying from table or column level, SQL 7-368

REF columns, indexes on, ADG 6 - 7

REF CURSOR datatype, PLS 5-16

defining, PLS 5-17

ref cursor variables

binding, OCI 5-12

ref cursors

binding and defining, OCI 5-30

REF data

exporting, SUT 1-16

importing, SUT 2-60

REF Fields

example, SUT 4-44

REF function, SQL 4-32

REF operator, DCI 1-8, PLS 9-32

REF type modifier, PLS 9-28

reference

for CMCTL commands, NET A-90 to NET A-93

for listener configuration, NET C-50 to NET C-64

for local naming configuration, NET C-31 to NET C-49

for LSNRCTL commands, NET A-4 to NET A-30

for NAMESCTL commands, NET A-34 to NET A-88

for Oracle Connection Manager configuration, NET C-76 to NET C-80

for Oracle Names servers configuration, NET C-65 to NET C-75

for profile configuration, NET C-7 to NET C-30

for protocol configuration, NET C-81

host variable, PCO 2-8

REFERENCE clause

in TYPE statement, PC_ 5-14

reference cursor, PCO 6-32

reference. See REF

reference semantics (ANSI dynamic SQL), PC_ 14-7

reference semantics for BFILEs, ADL 5-6

reference tables, STU 28-5

reference type, PLS 2-10

reference, external, PLS 7-32

referenced

keys, SCN 1-59, SCN 28-13

objects

dependencies, SCN 21-2

external reference, SCN 18-10, SCN 18-19

partitions, SCN 11-19

REFERENCES clause

of constraint_clause, SQL 7-223

of CREATE TABLE, SQL 7-369

REFERENCES object privilege, SQL 7-508

REFERENCES privilege

CASCADE CONSTRAINTS option, SAD 24-14

revoking, SAD 24-13, SAD 24-14

when granted through a role, SCN 30-21

references to objects (REFs)

declaring, PC_ 17-33

using, PC_ 17-33

using in embedded SQL, PC_ 17-33

references to objects. See REFs.

referencing

host tables, PCO 7-3

host variables, PCO 4-23

indicator variables, PCO 4-27

of host arrays, PC_ 8-2, PC_ 8-3

VARCHAR variables, PCO 4-31

REFERENCING clause

of CREATE TRIGGER, SQL 7-402, SQL 7-406

REFERENCING option, ADG 13 - 17

referential integrity, SCN 27-11, SCN 28-13

cascade rule, SCN 28-3

distributed database systems

application development, DDS 4-3

distributed databases and, ADG 5 - 14

examples of, SCN 28-18

one-to-many relationship, ADG 5 - 9

one-to-one relationship, ADG 5 - 9

partially null foreign keys, SCN 28-16

PRIMARY KEY constraints, SCN 28-11

privileges required to create foreign keys, ADG 5 - 30

restrict rule, SCN 28-3

self-referential constraints, ADG 13 - 44, SCN 28-15, SCN 28-18

set to default rule, SCN 28-3

set to null rule, SCN 28-3

triggers and, ADG 13 - 41, ADG 13 - 43, ADG 13 - 44, ADG 13 - 45

using triggers to enforce, DDS 4-3

referential integrity constraints, SQL 7-222, SQL 7-223

disabling for import, SUT 2-14

dropping table partition with, SAD 13-13

Import, SUT 2-48

SQL*Loader, SUT 8-21

truncating table partition with, SAD 13-16

refresh

failures, REP 7-34

fast and table reorg, REP A-4

incremental, SCN 10-18

job queue processes (SNPn), SCN 1-20, SCN 8-13

materialized views, SCN 10-18

retries, REP 7-34

snapshot sites

syntax, SPR 34 - 64, RAR 8-148

snapshots, SPR 45 - 7, SPR 45 - 9, SPR 45 - 10, RAR 8-259, RAR 8-261, RAR 8-263

REFRESH clause

of ALTER MATERIALIZED VIEW, SQL 7-46, SQL 7-49

of CREATE MATERIALIZED VIEW / SNAPSHOT, SQL 7-300

REFRESH COMPLETE clause

of ALTER MATERIALIZED VIEW, SQL 7-49

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-304

refresh error

snapshots

Import, SUT 2-51

REFRESH FAST clause

of ALTER MATERIALIZED VIEW, SQL 7-49

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-304

REFRESH FORCE clause

of ALTER MATERIALIZED VIEW, SQL 7-49

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-304

refresh groups

adding members to, SPR 32 - 2, RAR 8-66

creating

for snapshot sites, REP 5-29

creating new, SPR 32 - 5, RAR 8-70

data dictionary views, RAR 9-32

deleting, SPR 32 - 5, RAR 8-69

listing group members, RAR 9-37

managing, REP 7-35

manual refresh, REP 3-24

refresh interval

changing, SPR 32 - 3, RAR 8-67

REFRESH view, RAR 9-36

REFRESH_CHILDREN view, RAR 9-37

refreshing

manually, SPR 32 - 8, RAR 8-73

removing members from, SPR 32 - 8, RAR 8-74

snapshots, REP 5-28

troubleshooting refresh, REP 7-34

refresh intervals

listing, RAR 9-36

parameter constraints, REP 3-24

REFRESH view, RAR 9-36

snapshot refresh groups, REP 3-24

REFRESH ON COMMIT clause

of ALTER MATERIALIZED VIEW, SQL 7-49

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-304

REFRESH ON COMMIT mode

materialized views and downgrading, MIG 12-9

REFRESH ON DEMAND clause

of ALTER MATERIALIZED VIEW, SQL 7-50

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-304

refresh options, STU 29-7

refresh types

manual, REP 3-24

REFRESH view, RAR 9-36

REFRESH_CHILDREN view, RAR 9-37

refreshing, OCI 13-11

objects, OCI 13-11

REFs, ADG 18 - 9, SQL 2-26, SQL 7-224

as containers for OIDs, SQL 2-26

constraints on, ADG 18 - 10

constructing from object identifiers, SCN 14-18, SCN 14-19

dangling, SCN 13-9, SCN 13-10, SQL 7-190

declaring, PC_ 17-33

dereferencing of, ADG 16 - 24, SCN 13-10

for rows of object views, SCN 15-3

implicit dereferencing of, ADG 16 - 24, SCN 13-10

indexes on, SCN 14-6

indexing, ADG 18 - 12

indicator variables for, OCI 2-33

mutually dependent types, SCN 14-16

object identifiers, ADG 16 - 28

pinning, SCN 14-16, SCN 15-4

scoped, ADG 18 - 10, SCN 13-9, SCN 14-19

size of, SCN 14-19

storage, ADG 18 - 10

use of table aliases, SCN 14-8

using, PC_ 17-33

using in embedded SQL, PC_ 17-33

validating, SQL 7-190

WITH ROWID option, ADG 18 - 11

REFTOHEX function, SCN 12-23, SQL 4-32

REG_MULTI_SZ, PSC C-5

region database

configure database server, NET 6-26, NET 6-31

create Oracle Names server, NET 6-27

defined, NET 2-34

storing Oracle Names information, NET 6-26

regions

delegated administrative, NET 2-40

delegated administrative below root, NET 2-42

delegated administrative, diagram, NET 2-41

in Oracle Names, NET 2-33, NET 2-40

organizing multiple administrative network, NET 2-40

root administrative, NET 2-40

register, NET 6-45

REGISTER command, NET 6-42, NET 6-45, NET 6-49, NET A-47

register command (RMAN), SBR 6-5, SBR 6-6, SBR 11-93

REGISTER CONNECT SQL statement, PC_ F-98

register propagator, RAR 2-5

register receiver, RAR 2-5

Register Service with Oracle Names option, NET 6-40

REGISTER_SNAPSHOT procedure

DBMS_SNAPSHOT package, REP 7-37

REGISTERED_SNAPSHOTS, RAR 9-34

registering

archived redo logs, SBR 6-5

datafiles, SBR 6-5

global database link qualifiers with Oracle Names, NET 6-44

global database links with Oracle Names, NET 6-44

net service names with Oracle Names, NET 6-41

propagator for local database, RAR 8-34

snapshots, REP A-4

user callbacks, OCI 9-11

registering a data cartridge name, DCI 2-10

registering an external procedure, DCI 4-3

registering applications with database, STU 5-1, STU 12-7

registering global database link qualifiers with Oracle Names, NET 6-46

registering objects with Oracle Names, NET 6-41

registration

of instances, SPS 18-28

registry

DefinedNodes value, PSC 4-6

PM\DB_NAME key, PSC C-2, PSC C-5

regression, STU 27-29, STU 27-31

regular IIOP connections, NET 7-52

reject file

specifying for SQL*Loader, SUT 5-25

rejected PIN code, reasons for, OAS 6-16

rejected records

SQL*Loader, SUT 3-12, SUT 5-25

related Oracle products

Oracle Advanced Security, NET 7-28

Relational Access Manager, STU 28-9

relational DBMS (RDBMS)

object-relational DBMS, SCN 13-2

principles, SCN 1-22

SQL and, SCN 16-2

See also Oracle

relational design

planning, SAD 1-19

relational functions

server roundtrips, OCI C-2, OCI C-6

relational operator, PLS 2-45

relational operators

COBOL vs SQL, PCO 2-19

relational tables

creating, SQL 7-358

relations, SCN 1-23

relative field positioning

where a field starts and SQL*Loader, SUT 5-84

with multiple SQL*Loader INTO TABLE clauses, SUT 5-52

relative file number, SPS 6-3

RELAY_STATISTICS parameter, NET C-79

releasable freelist waits, SPS 15-13

releasable hashed PCM lock, SPS 9-4, SPS 15-7, SPS 15-9

release 8.1 CMAN.ORA parameters, NET 4-19

release 8.1 features, NET 4-2

changes in CMAN.ORA file, NET 4-14

changes in LISTENER.ORA file, NET 4-13

changes in TNSNAMES.ORA file, NET 4-9 to NET 4-12

connection load balancing, NET 4-2

database instance registration, NET 4-2

DB_DOMAIN parameter default, NET 4-5

Java Option support, NET 4-5

Net8 Configuration Assistant, NET 4-5

new parameters in CMAN.ORA file, NET 4-19

new parameters in LISTENER.ORA file, NET 4-18

new parameters in TNSNAMES.ORA file, NET 4-15 to NET 4-17

RADIUS authentication method

service naming, NET 4-3

SSL authentication method

TCP/IP with SSL protocol, NET 4-6

release 8.1 LISTENER.ORA parameters, NET 4-18

release 8.1 TNSNAMES.ORA parameters, NET 4-15 to NET 4-17

release channel command (RMAN), SBR 11-95

releasing a maintenance channel, SBR 11-96

release enhancements, OCI 1-12

RELEASE option, PC_ 3-22, PCO 3-21, PCO 3-26

COMMIT statement, PCO 3-21

if omitted, PC_ 3-23

in COMMIT statement, PC_ 3-18

in ROLLBACK statement, PC_ 3-21

omitting, PCO 3-26

purpose of, PC_ 3-18

restriction on, PC_ 3-21

restrictions, PCO 3-26

ROLLBACK statement, PCO 3-22

RELEASE_CURSOR, STU 19-10

precompiler option

what it affects, PC_ C-7

RELEASE_CURSOR option, PCO D-7

of ORACLE Precompilers, PC_ F-18, PCO F-15

using to improve performance, PC_ C-12, PCO D-12

RELEASE_CURSOR precompiler option, PC_ 10-36, PCO 14-36

releases

checking the release number, SAD 1-22

identifying for Oracle8i, SAD 1-21

maintenance release number, SAD 1-21

patch release number, SAD 1-22

port-specific release number, SAD 1-22

versions of other Oracle software, SAD 1-22

relinking with SQL*Net, MIG 9-2

RELOAD command

of LSNRCTL, reference, NET A-8

of NAMESCTL, reference, NET A-48, NET A-49

RELOADS column

V$LIBRARYCACHE table, STU 19-14

RELOCATE_MASTERDEF procedure

DBMS_REPCAT package, REP 7-3

relocating

control files, SAD 5-5

datafiles, SAD 10-9, SAD 10-10

RELY clause

of constraint_clause, SQL 7-226

REMARKS column

PLAN_TABLE table, STU 13-3

REMOTE, PSC 6-4

remote access indicator, PLS 2-35

Remote Authentication Dial-In User Service. See RADIUS

remote clients

authenticating, SRF 1-107

remote connections, SAD 1-16

connecting as SYSOPER/SYSDBA, SAD 1-14

multithreaded shared servers, MIG 2-16

password files, SAD 1-9

remote data

querying, DDS 2-26

updating, DDS 2-26

remote database

declaration of, PC_ F-37, PCO F-26

remote databases, SCN 1-35, SPS 1-18

database links, SCN 33-6

remote dependencies, ADG 10 - 28, SCN 21-11

signatures, ADG 10 - 29

specifying timestamps or signatures, ADG 10 - 35

remote exception handling, ADG 10 - 47, ADG 13 - 18

remote file server (RFS) process, SBR 16-9

remote instance, SPS 18-6, SPS 18-8, SPS 18-20

remote instance undo block writes statistic, SRF C-16

remote instance undo header writes statistic, SRF C-16

remote I/O, SPS 2-3

remote join enhancements, GTK 2-68

remote logins, SRF 1-107

remote operation

Export/Import, SUT 1-52

remote procedure calls, DDS 1-12, DDS 5-3, REP 2-4, SCN 33-12

deferring, REP 9-5

remote procedure calls (RPCs), DDS 1-12, SCN 33-12

remote procedures

error handling

application development, DDS 4-11

remote queries, DDS 4-3

execution, DDS 4-3

post-processing, DDS 4-3

remote SQL statement, STU 8-1

remote transactions, DDS 1-12, SCN 33-12

parallel DML and DDL restrictions, SCN 26-28

REMOTE_DEPENDENCIES_MODE parameter, ADG 10 - 35, SCN 21-11, SRF 1-106

of ALTER SESSION, SQL 7-87

of ALTER SYSTEM, SQL 7-107

REMOTE_LOGIN_PASSWORDFILE initialization parameter

migration, MIG A-18

REMOTE_LOGIN_PASSWORDFILE parameter, PSC 6-4, SAD 1-11, SPS 18-26, SRF 1-107

and control files, SQL 7-246

and databases, SQL 7-251

REMOTE_OS_AUTHENT parameter, OAS 1-13, SRF 1-107

setting, OAS 13-4, SAD 23-10

REMOTE_OS_ROLES parameter, SRF 1-108

setting, SAD 24-8, SAD 24-19

REMOVE_MASTER_DATABASES procedure

DBMS_REPCAT package, REP 2-34

removing

columns in column groups, REP 6-14

conflict resolution methods, REP 6-17

removing incompatibilities for downgrading, MIG 12-23

removing records from the recovery catalog, SBR 6-16

RENAME clause

of ALTER INDEX, SQL 7-39

of ALTER OUTLINE, SQL 7-58

of ALTER TABLE, SQL 7-143

RENAME command, ADG 3 - 48, SAD 20-2, SCN 16-4

RENAME DATABASE clause

ALTER DATABASE command, SBR 9-9

RENAME DATAFILE clause

of ALTER TABLESPACE, SQL 7-167

RENAME FILE clause

of ALTER DATABASE, SQL 7-15

RENAME GLOBAL_NAME clause

of ALTER DATABASE, SQL 7-15

RENAME PARTITION clause

of ALTER INDEX, SQL 7-32, SQL 7-40

of ALTER TABLE, SQL 7-147

RENAME statement, SQL 7-527

RENAME SUBPARTITION clause

of ALTER INDEX, SQL 7-32, SQL 7-40

of ALTER TABLE, SQL 7-147

renaming

control files, SAD 5-5

datafiles, SAD 10-9, SAD 10-10

datafiles with a single table, SAD 10-9

online redo log members, SAD 6-12

schema objects, SAD 20-2

renaming a file

log switch, SPS 21-10

redo log file, SPS A-18

RENAME FILE option, SPS A-18

renaming configuration files

UNIX, LEG 5-15

Windows NT, LEG 5-22

renaming objects, ADG 3 - 48

REOPEN option

LOG_ARCHIVE_DEST_n initialization parameter, SAD 7-19, SBR 16-11

REORDER_NS command, NET 5-25, NET 6-36, NET 6-37, NET 7-20

Reorganizing non-partitioned table with ALTER TABLE MOVE option, GTK 2-42

Re-Parse Frequency data view, STU 15-10

reparsing, STU 18-6

RepCat table

updating, REP 7-38

REPCAT_REFRESH_TEMPLATES view, RAR 9-6

REPCAT_TEMPLATE_OBJECTS view, RAR 9-6

REPCAT_TEMPLATE_PARMS view, RAR 9-8

REPCAT_TEMPLATE_SITES view, RAR 9-11

REPCAT_USER_AUTHORIZATIONS view, RAR 9-12

REPCAT_USER_PARM_VALUES view, RAR 9-13

REPCATLOG view, RAR 9-5, REP 2-40, REP 7-6 to REP 7-8

RepCatLog view

purging, SPR 34 - 63, RAR 8-146

REPCOLUMN view, RAR 9-15

RepColumn_Group table

updating, SPR 34 - 24, RAR 8-100, REP 7-38

REPCOLUMN_GROUP view, RAR 9-15, RAR 9-16

REPCONFLICT view, RAR 9-16

REPDDL view, RAR 9-17

REPEAT command, NET A-50

REPEAT UNTIL structure

mimicking, PLS 3-10

repeatable reads, ADG 8 - 8, ADG 8 - 11, SCN 27-3

REPGENOBJECTS view, RAR 9-26

REPGROUP view, RAR 9-3, REP 2-40

RepGroup view

updating, SPR 34 - 26, RAR 8-102

REPGROUP_PRIVILEGES view, RAR 9-17

REPGROUPED_COLUMN view, RAR 9-18

REPKEY_COLUMNS view, RAR 9-18

REPLACE AS OBJECT clause

of ALTER TYPE, SQL 7-174

REPLACE function, SQL 4-33

treatment of nulls, PLS 2-51

replace script command (RMAN), SBR 11-97

REPLACE table

example, SUT 4-15

replacing a table using SQL*Loader, SUT 5-33

replacement characters, NLS 4-4

replacing

views, SAD 15-8

replay attack, OAS 2-5

replicate command (RMAN), SBR 9-11, SBR 11-100

replicated environment

determining differences in tables, REP 7-19

replicated object groups

dropping, SPR 34 - 46, RAR 8-125

offline instantiation of, SPR 21 - 2, SPR 21 - 3, SPR 21 - 4, SPR 21 - 5, SPR 21 - 6, RAR 8-44, RAR 8-46, RAR 8-48, RAR 8-50, RAR 8-52

replicated objects

altering, SPR 34 - 16, RAR 8-91

at snapshot sites

problems creating, REP 7-34

creating

master sites, SPR 34 - 34, RAR 8-110

snapshot sites, SPR 34 - 38, RAR 8-116

creating master group, SPR 34 - 33, RAR 8-109

DROP_MASTER_REPOBJECT and, SPR 34 - 48, RAR 8-127

dropping

snapshot site, SPR 34 - 54, RAR 8-135

generating support for, SPR 34 - 58, RAR 8-140

re-creating, REP 7-32

replicated procedures

generating support for, REP 8-3

replicated systems, SPS 23-1

replicated tables

alternate keys for, REP 2-25

and DML incompatibility, REP 7-31

datatypes allowed, REP 2-26

differences between, REP 7-19

populating manually, REP 2-27

replicated transactions

dependency ordering, REP 2-43

replication, GTK 3-9

administrator, REP 2-5

advanced

introduction to conflicts, REP 6-2

re-enabling, REP 8-36

advanced techniques, REP 8-1 to REP 8-37

advanced, uses for, REP 1-5, SCN 34-6

backup and recovery for, REP 7-17

basic, REP 3-1

catalog, REP 1-13, SCN 34-14

catalog views, RAR 9-2

compatibility, MIG 8-44

conflicts

procedural replication, REP 1-15, SCN 34-16

definition, REP 1-2, SCN 34-2

distributed databases vs., SCN 33-7

disabling, REP 8-34, REP 8-35

enabling, REP 8-34

environment

advanced

adding new sites to, REP 8-8

group, REP 1-2, SCN 34-2

materialized views (snapshots), SCN 10-17

multimaster, REP 2-1 to REP 2-44

advanced options, REP 2-40 to REP 2-44

building environment

example, REP 2-6

monitoring, REP 2-38 to REP 2-40, REP 7-4 to REP 7-16

objects, SCN 34-2

generated, REP 2-2

of object definitions to master sites, REP 2-26

manual, REP 2-27

off/on affects current session, REP 8-35

procedural, REP 1-14, SCN 34-15

propagator, REP 2-5

real-time, REP 1-15, REP 8-6, SCN 34-16

receiver, REP 2-5

Replication Manager, GTK 2-66

restrictions

direct-load INSERT, SCN 25-12

parallel DML, SCN 26-44

resuming for master groups, REP 2-23

sites, REP 1-4, SCN 34-5

suspending for master groups, REP 2-22

triggers, REP 8-36

uses of read-only, REP 1-10, SCN 34-11

see also advanced replication

replication catalog view

incorrect, REP 7-33

replication groups

master sites

managing, REP 2-19

replication management API, RAR 8-1, REP 1-13, SCN 34-14

administration requests, SCN 34-14

Replication Manager, GTK 2-66, REP 1-13, SCN 34-15

administration requests, REP 7-4 to REP 7-8

Create New Master Group property sheet, REP 2-19

Create New Scheduled Link property sheet, REP 2-12

Edit Database Destination property sheet, REP 2-39

Finish page, REP 2-10

Scheduled Links folder, REP 2-15

Scheduling folder, REP 2-15

Set Alternate Key Columns dialog, REP 2-20, REP 2-25

Set Date dialog, REP 2-12, REP 2-16

Set Interval dialog, REP 2-13, REP 2-16

Set Scheduled Link dialog, REP 2-12

setup wizard, REP 2-7

replication objects, REP 1-2

adding to master groups, REP 2-19, REP 2-24

altering definition, REP 2-28

deleting from master groups, REP 2-30

replication of data in Oracle Names, NET 2-34, NET 6-32

replication support

for tables

unable to generate, REP 7-32

generating for all master group tables, REP 2-37

generating for master groups, REP 2-35

generation for objects, REP 2-36

replication tables

updating Comments, REP 7-38

replication triggers, REP A-2

REPLICATION_DEPENDENCY_TRACKING parameter, SRF 1-108

RepObject table

updating, SPR 34 - 28, RAR 8-104, REP 7-38

REPOBJECT view, RAR 9-19, REP 2-40

report command (RMAN), SBR 4-22, SBR 11-102

need backup option, SBR 7-5

reports, generating, SBR 7-2, SBR 7-5

database schema, SBR 7-8

objects needing a backup, SBR 7-5

obsolete backups, SBR 7-6, SBR 7-8

scenarios, SBR 7-10, SBR 7-11, SBR 7-12

unrecoverable backups, SBR 7-6, SBR 7-8

repository database

defined, PSC 2-4, PSC 5-3

installing, PSC 5-10

Repository Login dialog box, PSC 5-31, PSC 5-36

REPPARAMETER_COLUMN view, RAR 9-20

REPPRIORITY view, RAR 9-21

RepPriority_Group table

updating, SPR 34 - 25, RAR 8-101, REP 7-38

REPPRIORITY_GROUP view, RAR 9-22

REPPROP view, RAR 9-22

REPRESOL_STATS_CONTROL view, RAR 9-24

RepResolution table

updating, SPR 34 - 29, RAR 8-105, REP 7-38

REPRESOLUTION view, RAR 9-23

REPRESOLUTION_METHOD view, RAR 9-24

RepResolution_Statistics table

purging, SPR 34 - 63, RAR 8-147, REP 7-19

REPRESOLUTION_STATISTICS view, RAR 9-25

RepResolution_Statistics view

gathering statistics, REP 7-18

RepSchema table

updating, REP 7-38

RepSite view

updating, SPR 34 - 27, RAR 8-103

REPSITES view, RAR 9-26, REP 2-40

required SSL version, setting on server, OAS 9-28

requirements

export, MIG 5-2

requiring client authentication in SSL, OAS 9-28

reraising an exception, PLS 6-14

reserved namespaces, OCI 2-35, PC_ B-4

reserved words, OCI 2-35, PLS E-1, SCN 16-3, SQL 2-67, SQL C -1, SUT A-2

misuse of, PLS 2-5

SQL*Loader, SUT A-2

using as quoted identifier, PLS 2-6

reserved words and keywords, PC_ B-2

RESET COMPATIBILITY clause

of ALTER DATABASE, SQL 7-15

reset database command (RMAN), SBR 6-7, SBR 11-110

incarnation option, SBR 6-7

RESET_STATS command, NET A-51

RESETLOGS option

ALTER DATABASE command, SBR 14-17, SBR 14-18, SBR 14-33

backing up control file, SBR 13-14

database backups after using, SBR 3-19

multiple timelines for redo logs, SBR 3-23

recovery of database after using, SBR 14-35

RESETLOGS parameter

of CREATE CONTROLFILE, SQL 7-247

resolution methods

additive prebuilt, RAR 6-10, REP 6-18

average prebuilt, RAR 6-10, REP 6-18

discard, RAR 6-3, REP 6-21

earliest timestamp, RAR 6-7, REP 6-20

for column groups

ordering, REP 6-17

for conflicts

removing, REP 6-17

latest timestamp, RAR 6-7, REP 6-20

managing, REP 6-16

maximum value method, RAR 6-5, REP 6-19

minimum value method, RAR 6-5, REP 6-19

overwrite, RAR 6-3, REP 6-21

resolution statistics

gathering, REP 7-18

viewing, REP 7-18

resolution, name, PLS 2-36, PLS D-1

RESOLVE clause

of ALTER JAVA CLASS, SQL 7-44

of CREATE JAVA, SQL 7-293

RESOLVER clause

of ALTER JAVA CLASS, SQL 7-44

of ALTER JAVA SOURCE, SQL 7-44

of CREATE JAVA, SQL 7-295

resolving

errors, see also troubleshooting

net service name addresses, NET 3-3

resource

adding, STU 1-4

consumption, parameters affecting, STU 26-20

consumption, parameters affecting parallel DML/DDL, STU 26-25

database, SPS 4-12

limiting for users, STU 26-10

limits, STU 26-9

operating system, SPS 18-9

oversubscribing, STU 27-5

oversubscription, STU 27-9

parallel query usage, STU 26-20

persistent, SPS 8-10

releasing, SPS 22-3

tuning contention, STU 2-11

resource allocation methods, SAD 11-2

resource consumer groups, SAD 11-2

resource errors

Import, SUT 2-49

resource limits

altering in profiles, SAD 23-19

assigning with profiles, SAD 23-18

call level, SCN 29-16

composite limits and, SAD 23-19

connect time per session, SCN 29-18

costs and, SAD 23-20

CPU time limit, SCN 29-17

creating profiles and, SAD 23-18

determining values for, SCN 29-19

disabling, SAD 23-21

enabling, SAD 23-21

idle time per session, SCN 29-17

logical reads limit, SCN 29-17

overview of, SCN 1-43

private SGA space per session, SCN 29-18

privileges to enable and disable, SAD 23-21

privileges to set costs, SAD 23-20

profiles, SAD 23-17

PUBLIC_DEFAULT profile and, SAD 23-18

service units, SAD 23-19

session level, SCN 29-16

sessions per user, SCN 29-17

setting to null, SAD 23-19

resource limits for profiles, SRF 1-108, SRF 1-109

resource manager, PC_ 5-54, PCO 3-32

resource manager events, ADG 14 - 4

resource manager. See database resource manager

resource parameters

of CREATE PROFILE, SQL 7-337

resource plan directives, SAD 11-2

resource plans, SAD 11-2

RESOURCE role, SAD 24-5, SCN 30-22, SQL 7-503, SUT 2-11

user-defined types, SCN 14-13, SCN 14-14

RESOURCE shortcut

of AUDIT sql_statements, SQL 7-198

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-180

RESOURCE_LIMIT parameter, SRF 1-108, SRF 1-109

enabling and disabling limits, SAD 23-21

of ALTER SYSTEM, SQL 7-107

RESOURCE_MANAGER_PLAN parameter, SRF 1-109

of ALTER SYSTEM, SQL 7-108

RESOURCE_MAP view, SRF 2-180

resources, PSC 1-15

profiles, SAD 23-17

response queues, SCN 8-17

response time, SCN 22-7, SPS 1-10, STU 1-2, STU 1-3

cost-based approach, SCN 23-31

optimizing, STU 7-4, STU 7-39

responsibilities

of a database administrator, SAD 1-2

of database users, SAD 1-3

RESTART command, NET A-52

restore command (RMAN), SBR 9-17, SBR 11-112

restore constraints, SBR 4-48

RESTORE DATABASE statement, SPS 22-8

RESTORE DATAFILE statement, SPS 22-8

RESTORE TABLESPACE statement, SPS 22-8

restore validation, SBR 6-18

restoring

archived redo logs using RMAN, SBR 9-13

backup file selection, SBR 4-48

backups of online redo logs, SBR 3-23

database using RMAN, SBR 9-3

datafiles, SBR 4-47

datafiles using RMAN, SBR 9-2

testing, SBR 6-18

whole database backups, SBR 14-17

RESTRICT_REFERENCES pragma, DCI 5-6, PLS 5-59, PLS 7-7, PLS 10-13

of ALTER TYPE, SQL 7-175

syntax for, ADG 10 - 66

using to control side effects, ADG 10 - 66

restricted mode

starting instances in, SCN 5-6

restricted multilingual support, NLS 3-23

restricted rowid, PLS 2-16

restricted rowid format, SCN 12-18

restricted rowids, SQL 2-22

compatibility and migration of, SQL 2-23

RESTRICTED SESSION privilege, SCN 29-20

instances in restricted mode, SAD 3-8

restricted mode and, SAD 3-4

session limits and, SAD 23-3

RESTRICTED SESSION system privilege, SQL 7-499

restricting access to database

starting an instance, SAD 3-4

restriction

distributed transactions, DDS 2-26

restrictions

AT clause, PCO 3-7

cached sequence, SPS 6-7

changing the redo log, SPS 14-9

COBOL-74, PCO 2-20

CURRENT OF clause, PCO 5-17

cursor declaration, PCO 5-13

cursor variables, PCO 6-37

DB2 load utility, SUT B-3

deferred rollback segments, SPS A-19

direct-load INSERT, SCN 25-11, SCN 26-43

dynamic SQL, PCO 2-17

Export, SUT 1-4

file operations, SPS A-17, SPS A-19, SPS B-2

FOR clause, PCO 7-17

host tables, PCO 7-3, PCO 7-9, PCO 7-13, PCO 7-14, PCO 7-15

host variables, PCO 4-25

naming, PCO 2-16

referencing, PCO 4-25

importing grants, SUT 2-13

importing into another user's schema, SUT 2-13

importing into own schema, SUT 2-11

input host variable, PCO 5-2

LONG datatype, PCO 4-3

LONG RAW datatype, PCO 4-4

nested tables, SCN 26-30

offline tablespace, SPS 6-8, SPS A-18

on AT clause, PC_ 3-11

on Comments, PC_ 13-31

on CURRENT OF clause, PC_ 6-17

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-5

on input host variables, PC_ 6-2

on NULLs, PC_ 6-5

on separate precompilation, PC_ 2-17

on SET TRANSACTION statement, PC_ 3-23

parallel DDL, SCN 26-31

remote transactions, SCN 26-28

parallel DML, SCN 26-43

remote transactions, SCN 26-28, SCN 26-46

parallel execution of functions, SCN 26-46

partition views, SCN 11-12

partitions

bitmap indexes, SCN 11-14

datatypes, SCN 11-14, SCN 11-21

partition-extended table names, SCN 11-64

procedural replication, REP 8-2

RAW datatype, PCO 4-4

recovery, SPS A-22

REDEFINES clause, PCO 2-18

RELEASE option, PCO 3-26

separate precompilation, PCO 2-28

SET TRANSACTION statement, PCO 3-27

SQLCHECK option, PCO E-2

SQLGLM subroutine, PCO 8-27

SQLIEM subroutine, PCO 8-27

system triggers, ADG 13 - 24

table names in Export parameter file, SUT 1-25

table names in Import parameter file, SUT 2-29

TO SAVEPOINT clause, PCO 3-26

use of CURRENT OF clause, PC_ 8-4, PCO 7-5

result set, PLS 1-5, PLS 5-8

result value, function, PLS 7-6

Results, PSC 6-24

RESUME

DB2 keyword, SUT 5-32

RESUME clause

of ALTER SYSTEM, SQL 7-100

RESUME option

ALTER SYSTEM command, SBR 13-10

resume replication, RAR 3-9

RESUME_MASTER_ACTIVITY procedure

DBMS_REPCAT package, REP 2-24

RESUME_SUBSET_OF_MASTERS procedure

DBMS_OFFLINE_OG package, REP 8-16

resuming branches, OCI 8-7

resuming recovery after interruption, SBR 14-16

resuming replication activity, SPR 34 - 71, RAR 8-155

resync catalog command (RMAN), SBR 4-14, SBR 6-23, SBR 11-118

from controlfilecopy option, SBR 6-33

resynchronizing the recovery catalog, SBR 4-14, SBR 6-23

retention and message history, ADQ 1-6

retention policy, LEG 2-6

save set, LEG 2-9

retrieving rows from a table

embedded SQL, PC_ F-104, PCO F-79

RETRY option, SPS 18-15

STARTUP PARALLEL command, SPS 18-15

RETURN clause

cursor, PLS 5-12

function, PLS 7-6

of CREATE FUNCTION, SQL 7-270

of CREATE OPERATOR, SQL 7-320

of CREATE TYPE BODY, SQL 7-423

return codes

user exits, PC_ 20-8

RETURN statement, PLS 7-8

syntax, PLS 11-138

return type, PLS 5-17, PLS 7-25

return values

navigational functions, OCI 16-5

RETURN-CODE special register is unpredictable, PCO B-3

RETURNING clause, PLS 5-63, PLS 9-36

binding with, OCI 5-22

error handling, OCI 5-23

initializing variables, OCI 5-23

of DELETE, SQL 7-441

of INSERT, SQL 7-513, SQL 7-516

of UPDATE, SQL 7-585, SQL 7-588

using with OCI

with REFs, OCI 5-23

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, ADG 16 - 33, ADG 18 - 20

reusability, PLS 7-3

reusable packages, ADG 10 - 70, PLS 5-64

REUSE clause

of CREATE CONTROLFILE, SQL 7-246

of filespec clause, SQL 7-491

REUSE STORAGE clause

of TRUNCATE, SQL 7-583

REVERSE clause

of CREATE INDEX, SQL 7-282

reverse indexes, SQL 7-282

reverse key indexes, GTK 3-14, SCN 10-31

reverse migration

not supported, MIG 13-2

REVERSE option for indexes, SCN 10-31

REVERSE reserved word, PLS 3-11

REVOKE command, ADG 12 - 18, SAD 24-12, SCN 16-4

FORCE option, SCN 14-17

locks, SCN 27-29

object types and dependencies, SCN 14-17

when in effect, ADG 12 - 22

when takes effect, SAD 24-16

REVOKE CONNECT THROUGH clause

of ALTER USER, SQL 7-180, SQL 7-181

REVOKE schema_object_privileges statement, SQL 7-532

REVOKE system_privileges_and_roles statement, SQL 7-529

revoking

privileges and roles

SYSOPER/DBA privileges, SAD 1-13

revoking privileges and roles

on selected columns, ADG 12 - 19, SAD 24-13

REVOKE command, ADG 12 - 18, SAD 24-12

shortcuts for object privileges, SAD 24-3

when using operating-system roles, SAD 24-19

revoking roles and privelieges (AQ), ADQ 8-53

rewrite

predicates in security policies, SCN 30-23

using materialized views, SCN 10-17

REWRITE hint, SQL 2-59, STU 7-50, STU 31-4, STU 31-21

REWRITE_INTEGRITY parameter, SRF 1-104

rewrites

hints, STU 31-21

initialization parameters, STU 31-4

privileges, STU 31-4

query optimization

hints, STU 31-4, STU 31-21

matching join graphs, STU 29-6

RFS

See remote file server

.RHOSTS file, PSC 2-14

RM date format element, SQL 2-41

RM format element, NLS 2-12

RMAN, SMS 23-1

ALLOCATE CHANNEL command, SPS 21-8

See Recovery Manager

tuning for backups, STU 20-52

rman command (RMAN), SBR 11-121

RN number format element, SQL 2-36

RNDS argument, ADG 10 - 67

RNDS parameter

of PRAGMA RESTRICT_REFERENCES, SQL 7-175

RNPS argument, ADG 10 - 67

RNPS parameter

of PRAGMA RESTRICT_REFERENCES, SQL 7-175

ROLAP enhancements, GTK 2-24

ROLE_ROLE_PRIVS view, SRF 2-181

ROLE_SYS_PRIVS view, ADG 12 - 4, SRF 2-181

ROLE_TAB_PRIVS view, ADG 12 - 4, SRF 2-181

roles, OAS 9-11, SCN 1-41, SCN 30-16, SRF 1-92

ADMIN OPTION and, ADG 12 - 17, SAD 24-10

advantages, ADG 12 - 4

application, ADG 12 - 3, ADG 12 - 4, ADG 12 - 7, ADG 12 - 10, SCN 30-18

application developers and, SAD 22-10

application security policy, ADG 12 - 3, ADG 12 - 7

assigning to a user, SQL 7-427

authorization, SAD 24-6

authorized by a password, SQL 7-344

authorized by an external service, SQL 7-344

authorized by the database, SQL 7-344

authorizes by the enterprise directory service, SQL 7-344

backward compatibility, SAD 24-5

changing authorization for, SAD 24-8, SQL 7-71

changing passwords, SAD 24-8

CONNECT role, SAD 24-5, SCN 14-13, SCN 14-14, SCN 30-22

creating, ADG 12 - 11, SQL 7-343

database authorization, SAD 24-7

DBA role, SAD 1-6, SAD 24-5, SCN 14-13, SCN 30-22

DDL statements and, SCN 30-20

default, ADG 12 - 13, SAD 23-16

definer-rights procedures disable, SCN 30-20

dependency management in, SCN 30-20

disabling for the current session, SQL 7-571

disabling for the session, SQL 7-570

distributed database applications, SCN 33-17

dropping, ADG 12 - 16, SAD 24-8

enabled or disabled, SCN 30-18

enabling, ADG 12 - 4, ADG 12 - 14

enabling for the current session, SQL 7-571

enabling for the session, SQL 7-570

EXP_FULL_DATABASE, SAD 24-5, SUT 1-4, SUT 1-9

EXP_FULL_DATABASE role, SCN 30-22

functionality, SCN 30-2

global authentication service, SCN 33-17

GRANT and REVOKE commands, ADG 12 - 15

GRANT command, SAD 24-19

GRANT OPTION and, SAD 24-11

granting, ADG 12 - 16, SCN 30-3, SCN 30-18, SQL 7-493

about, SAD 24-9

system privileges on, SQL 7-498

to a user, SQL 7-494

to all users, SQL 7-494

to another role, SQL 7-494

to PUBLIC, SQL 7-494

grouping with roles, SAD 24-4

IMP_FULL_DATABASE, SAD 24-5, SUT 2-7, SUT 2-23, SUT 2-31

IMP_FULL_DATABASE role, SCN 30-22

in applications, SCN 1-42

invoker-rights procedures use, SCN 30-20

listing, SAD 24-23

listing grants, SAD 24-21

listing privileges and roles in, SAD 24-24

management using the operating system, SAD 24-16

managing, ADG 12 - 10, SAD 24-4

managing via operating system, SCN 30-22

managing with RADIUS server, OAS 3-28

multi-byte characters

in names, SAD 24-5

multi-byte characters in passwords, SAD 24-7

multi-threaded server and, SAD 24-7

naming, SCN 30-19

operating system granting of, ADG 12 - 15, SAD 24-17, SAD 24-19

operating-system authorization, SAD 24-7

OS management and the multi-threaded server, SAD 24-19

overview of, SCN 1-41

passwords for enabling, SAD 24-7

predefined, SAD 1-6, SAD 24-5, SCN 30-22

privileges

changing authorization method, SAD 24-6

changing passwords, SAD 24-6

for creating, SAD 24-4

for dropping, SAD 24-9

granting system privileges or roles, SAD 24-9

privileges for creating, ADG 12 - 12

queue administrator, SCN 19-7

remote clients, SRF 1-108

removing from the database, SQL 7-469

RESOURCE, SUT 2-11

RESOURCE role, SAD 24-5, SCN 14-13, SCN 14-14, SCN 30-22

restrictions on privileges of, SCN 30-20

REVOKE command, SAD 24-19

revoking, SAD 24-12, SCN 30-18, SQL 7-529

from a user, SQL 7-530

from all users, SQL 7-530

from another role, SQL 7-469, SQL 7-530

from PUBLIC, SQL 7-530

from users, SQL 7-469

revoking ADMIN OPTION, SAD 24-13

schemas do not contain, SCN 30-19

security and, SAD 22-6

security domains of, SCN 30-19

SET ROLE command, ADG 12 - 15, SAD 24-19

setting in PL/SQL blocks, SCN 30-20

unique names for, SAD 24-4

use of passwords with, SCN 1-42

user, ADG 12 - 4, ADG 12 - 7, ADG 12 - 10, SCN 30-18

user privileges and enabling, ADG 12 - 13

users capable of granting, SCN 30-19

uses of, SCN 30-17

when to enable, ADG 12 - 12

WITH GRANT OPTION and, ADG 12 - 18

without authorization, SAD 24-8

roles in tuning, STU 1-7

roles, external, mapping to DCE groups, OAS 13-6

roll back

to a savepoint, PC_ F-103, PCO F-78

to the same savepoint multiple times, PC_ F-101, PCO F-76

rollback, OCI 2-26, SCN 4-20, SCN 17-6

automatic, PCO 3-23

defined, SCN 1-53

described, SCN 17-6

during recovery, SCN 1-51, SCN 32-9

ending a transaction, SCN 17-2, SCN 17-4, SCN 17-6

forcing, DDS 3-31

implicit, PLS 5-45

in object applications, OCI 13-14

of FORALL statement, PLS 4-33

purpose, PCO 3-19

statement-level, PCO 3-23, PLS 5-43, SCN 17-4

to a savepoint, SCN 17-6

rollback changes - undo records applied statistic, SRF C-16

ROLLBACK command, ADG 8 - 6, SCN 16-5

FORCE option, DDS 3-31

forcing, DDS 3-21

rollback entries, SCN 4-20

rollback segment, PCO 3-19, PLS 5-41, SPS 14-5

contention, SPS 6-8, SPS 6-9, SPS 14-5

deferred, SPS 6-9, SPS A-19

description, SPS 6-8

distributed locks, SPS 6-9

function of, PC_ 3-16

global constant parameters, SPS 6-9

ID number, SPS 14-5, SPS 14-7

multiple, SPS 6-8, SPS 14-5, SPS 18-15

name, SPS 14-5, SPS 14-7

online, SPS 6-8, SPS 14-7

onlining, SPS A-13

private, SPS 23-9

public, SPS 14-6

public vs. private, SPS 6-9, SPS 14-6, SPS 18-5

specifying, SPS 14-5

SYSTEM, SPS 6-8

tablespace, SPS 6-8, SPS 14-5, SPS 14-7, SPS 23-9

rollback segments, PSC 1-12, SBR 1-8, SCN 1-11, SCN 4-19, STU 18-8, STU 26-25

access to, SCN 4-20

acquired during startup, SCN 5-8

acquiring, SRF 1-110, SRF 1-125

acquiring automatically, SAD 21-3, SAD 21-11

acquiring on startup, SAD 2-12

allocating, SAD 2-14

allocation of extents for, SCN 4-22

new extents, SCN 4-24

altering public, SAD 21-9

altering storage parameters, SAD 21-9

and RMAN TSPITR, SBR A-6

assigning to transactions, STU 20-29

AVAILABLE, SAD 21-11

bringing

online, SAD 21-11

online automatically, SAD 21-11

online when new, SAD 21-8

PARTLY AVAILABLE segment online, SAD 21-11

bringing online, SQL 7-73, SQL 7-346

changing storage characteristics, SQL 7-73

checking if offline, SAD 21-12

choosing how many, SAD 2-14, STU 21-4

choosing size for, SAD 2-14

clashes when acquiring, SCN 4-27

committing transactions and, SCN 4-21

CONSISTENT Export parameter, SUT 1-17

contention, STU 21-3

contention for, SCN 4-21

controlling size during import, SUT 2-20

creating, SAD 21-8, SQL 7-345, STU 21-4

creating after database creation, SAD 21-3

creating public and private, SAD 21-3

deallocating extents from, SCN 4-25

decreasing size of, SAD 21-10

deferred, SAD 21-16, SCN 4-30

defined, SCN 1-11

detecting dynamic extension, STU 20-26

displaying

all deferred rollback segments, SAD 21-16

deferred rollback segments, SAD 21-16

information on, SAD 21-14

PENDING OFFLINE segments, SAD 21-15

displaying names of all, SAD 21-15

distributed locks, SRF 1-46

dropping, SAD 21-13, SCN 4-25

restrictions on, SCN 4-30

during SQL*Loader loads, SUT 5-26

dynamic extension, STU 20-29

equally sized extents, SAD 21-5

explicitly assigning transactions to, SAD 21-13

Export, SUT 1-49

global constant parameters, SRF 1-46

granting

system privileges on, SQL 7-498

guidelines for managing, SAD 21-2

how transactions write to, SCN 4-22

in-doubt distributed transactions, DDS 3-21, SCN 4-24

initial, SAD 21-2

initialization parameters, SRF 1-46

invalid, SCN 4-28

invalid status, SAD 21-14

listing extents in, SAD 20-32

location of, SAD 21-7

locks on, SCN 27-30

making available for use, SAD 21-10

managing, SAD 21-1

MAXEXTENTS UNLIMITED, SCN 26-40

maximum size, SRF 1-72

migration, MIG 3-4

monitoring, SAD 21-6

moving to the next extent of, SCN 4-22

multiple, SQL 7-346

number of concurrent transactions, SRF 1-125

number of transactions per, SCN 4-21

OFFLINE, SAD 21-11

offline, SCN 4-28, SCN 4-30

offline rollback segments, SAD 21-10

offline status, SAD 21-12

offline tablespaces and, SCN 4-30

online, SCN 4-28, SCN 4-30

online rollback segments, SAD 21-10

online status, SAD 21-12

OPTIMAL, SCN 26-40

overview of, SCN 4-19, SCN 32-8

parallel DML, SCN 26-40

parallel recovery, SCN 32-10

PARTLY AVAILABLE, SAD 21-11

partly available, SCN 4-28, SCN 32-4

PENDING OFFLINE, SAD 21-12

private, SCN 4-26

private rollback segments, SRF 1-110

privileges

for dropping, SAD 21-14

required to alter, SAD 21-9

required to create, SAD 21-7

public, SCN 4-26, SQL 7-345

public rollback segments, SRF 1-110

read consistency and, SCN 1-31, SCN 4-20, SCN 27-4

recovery needed for, SCN 4-28

reducing size, SQL 7-73

removing from the database, SQL 7-470

setting size of, SAD 21-4

setup wizard, REP 2-16

specifying, SRF 1-110

specifying optimal size of, SQL 7-578

specifying tablespaces for, SQL 7-345

SQL examples, SQL 7-346

states of, SCN 4-28

status for dropping, SAD 21-13

status or state, SAD 21-11

storage characteristics, SQL 7-575

storage characteristics of, SQL 7-346

storage parameters, SAD 21-8

storage parameters and, SAD 21-8

SYSTEM, SRF 1-110

SYSTEM rollback segment, SCN 4-26

taking offline, SAD 21-12, SQL 7-73

taking tablespaces offline and, SAD 9-12

transactions and, SAD 21-13, SCN 4-20

use of in recovery, SCN 1-49, SCN 32-9

using multiple, SAD 21-2

when acquired, SCN 4-26

when used, SCN 4-20

written circularly, SCN 4-21

ROLLBACK SQL statement, PC_ F-99

ROLLBACK statement, PC_ 3-22, PCO 3-22, PCO F-74, PLS 5-43, SQL 7-537

effect of, PC_ 3-20

effect on savepoints, PLS 5-44

effects, PCO 3-22

ending a transaction, PC_ F-101, PCO F-76

example, PCO 3-22

example of, PC_ 3-21

examples, PC_ F-102, PCO F-77

in error handling routines, PC_ 3-21

purpose of, PC_ 3-20

RELEASE option, PCO 3-22

RELEASE option in, PC_ 3-21

syntax, PLS 11-140

TO SAVEPOINT clause, PCO 3-22

TO SAVEPOINT clause in, PC_ 3-20

using in a PL/SQL block, PC_ 3-28, PCO 3-31

using in error-handling routines, PCO 3-23

where to place, PC_ 3-21, PCO 3-22

ROLLBACK_SEGMENTS parameter, PSC 1-12, PSC 6-4, PSC 6-10, PSC 6-11, SPS 6-9, SPS 6-10, SPS 18-10, SPS 18-11, SRF 1-110, STU 26-25

adding rollback segments to, SAD 21-8

conversion to multi-instance, SPS 23-7

private and public segments, SPS 14-5, SPS 14-6

setting before database creation, SAD 2-12

unique values, SRF 1-110

rollbacks

automatic, PC_ 3-22

fast-start on-demand, STU 25-15

fast-start parallel, STU 25-15

function of, PC_ 3-16

ORA-02067 error, DDS 4-3

statement-level, PC_ 3-22

rollbacks only - consistent read gets statistic, SRF C-16

rolling back, SBR 14-2

instance recovery, SPS 22-3

rollback segments, SPS 6-8

row locks, SPS 4-15

transactions, PCO F-74

rolling back during recovery, SCN 32-9

rolling back transactions, SCN 1-54, SCN 17-2, SCN 17-6, SCN 32-4

to savepoints, ADG 8 - 6

rolling forward, SBR 14-2

rolling forward during recovery, SCN 1-50, SCN 32-9

rolling up a hierarchy, STU 30-2

rolling upgrades, PSC 3-8

ROLLUP operation

example, SQL 4-17

of queries and subqueries, SQL 7-549

ROLLUP operation, GROUP BY clause, GTK 2-24

Roman numerals

format mask for, NLS 2-12

root, PSC 2-14

administrative region domain requirements, NET 2-40

administrative region in Oracle Names, NET 2-40

administrative region Oracle Names servers requirements, NET 2-40

regions, data definition requirements, NET 2-40

root administrative regions, described, NET 2-40

root blocks, SCN 10-55

root domains, described, NET 2-40

ROSBILD.SQL script, NET 5-27

ROSFILES

NMCBILD.SQL script, NET 5-27

NMCGRNT.SQL script, NET 5-27

ROSBILD.SQL script, NET 5-27

ROSGRNT.SQL script, NET 5-27

ROSFILES, migrating to Oracle Names, NET 5-26

ROSGRNT.SQL script, NET 5-27

ROUND

date function, SQL 4-34

number function, SQL 4-33

ROUND function

format models, SQL 4-55

round-robin

distribution value, STU 13-8

roundtrips

See server roundtrips

roundtrips to the server, avoiding, ADL 2-15, ADL 2-21

routers, verifying, LEG B-5

routine

service, DCI 4-12

routine, external, PLS 7-28

routines

autonomous, ADG 8 - 33

calling, SQL 7-210

executing, SQL 7-210

external, ADG 11 - 3

service, ADG 11 - 35

routing connections, NET 1-6, NET 7-26

routing, data-dependent, SPS 12-7, SPS 19-6

row cache, SCN 7-10, SPS 6-6

row cache enqueue, SRF B-2

row cache lock wait event, SRF A-46

row data (section of data block), SCN 4-5

row directories, SCN 4-4

row errors

Import, SUT 2-48

ROW EXCLUSIVE lock mode, SQL 7-521

row level locking, SPS 7-2

DML locks, SPS 10-3

independent of PCM locks, SPS 4-15

resource sharing system, SPS 4-6, SPS 5-4

row lock, PLS 5-47

acquiring with FOR UPDATE OF, PCO 3-28

using to improve performance, PCO D-6

when acquired, PCO 3-28

when released, PCO 3-28

row locking, SCN 27-11, SCN 27-20

block-level recovery, SCN 27-21, SCN 32-14

manually locking, ADG 8 - 17

serializable transactions and, SCN 27-8

row locks

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 objects, SCN 13-8

storage, ADG 18 - 8

row operator, PLS 5-6

row pieces, SCN 10-5

headers, SCN 10-5

how identified, SCN 10-7

row sampling, SCN 22-14

ROW SHARE lock mode, SQL 7-521

row sources, SCN 22-4

Row Statistics for Execute/Fetch drilldown data views, STU 15-19

row triggers, SCN 20-8

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 20-21

See also triggers

ROW_CACHE_CURSORS parameter, SRF 1-110

ROW_CACHE_MULTI_INSTANCE parameter (Oracle Version 6), SPS A-21

ROW_LOCKING parameter, ADG 8 - 11, ADG 8 - 19, PSC 6-11, SPS 18-11, SRF 1-111

%ROWCOUNT cursor attribute, PLS 5-35, PLS 5-39

ROWID

datatype, SQL 2-21

external datatype, OCI 3-13

hint, SQL 2-59

Import, SUT 2-51

logical, OCI 3-6, PC_ 4-7, PC_ 4-38

pseudocolumn, PC_ 3-26, SQL 2-21, SQL 2-23, SQL 2-54

using to mimic CURRENT OF, PC_ 3-26, PC_ 8-28

pseudocolumns, PC_ 4-38

universal, PC_ 4-7, PC_ 4-38

Universal ROWID, OCI 3-6

used for positioned updates and deletes, OCI 2-34

rowid, PLS 2-16

extended, PLS 2-16

guess, PLS 2-17

logical, PLS 2-16

physical, PLS 2-16

restricted, PLS 2-16

universal, PLS 2-16

ROWID datatype, ADG 4 - 18, PC_ 4-7, PLS 2-16, SCN 12-15, SCN 12-16

DBMS_ROWID package, SPR 42 - 1

extended format, SPR 42 - 12

extended ROWID format, ADG 4 - 19

extended rowid format, SCN 12-17

heap tables vs index-organized tables, PCO 4-36

internal, PCO 4-5

migration, ADG 4 - 21

restricted rowid format, SCN 12-18

Universal, PCO 4-36

use of, PCO 4-36

use of ALLOCATE, PCO 4-37

ROWID descriptor, OCI 2-16

ROWID hint, STU 7-43

ROWID pseudocolumn, PLS 5-4

ROWID pseudocolumns, PCO 4-5

retrieving with SQLROWIDGET, PCO 4-38

universal ROWID, PCO 4-37

using to mimic CURRENT OF, PCO 3-29, PCO 7-19

ROWID snapshots, REP 3-5

ROWIDs

compatibility, client access, MIG 11-7

conversion to Oracle8i format, MIG 11-3

examples, MIG 11-5

DBMS_ROWID compatibility package, MIG 11-3

indexes, MIG 11-8

logical, GTK 2-29

mapping to bitmaps, STU 6-17

migration

questions and answers, MIG 11-7

snapshot refresh, MIG 11-6

universal, GTK 2-30

rowids, SCN 10-7

accessing, SCN 12-15

block portion of, SQL 2-22

changes in, SCN 12-16

description of, SQL 2-21

extended, SQL 2-22

not directly available, SQL 2-22

file portion of, SQL 2-22

in non-Oracle databases, SCN 12-22

internal use of, SCN 12-16, SCN 12-19

logical, SCN 12-15

logical rowids, SCN 12-20

index on index-organized table, SCN 10-39

physical guesses, SCN 10-39, SCN 12-20

staleness of guesses, SCN 12-21

statistics for guesses, SCN 12-21

nonphysical, SQL 2-23

of clustered rows, SCN 10-7

of foreign tables, SQL 2-23

of index-organized tables, SQL 2-23

physical, SCN 12-15

restricted, SQL 2-22

compatibility and migration of, SQL 2-23

row migration, SCN 4-10

row portion of, SQL 2-22

sorting indexes by, SCN 10-28

table access by, SCN 23-34

universal, SCN 12-15

uses for, SQL 2-54

ROWIDTOCHAR function, ADG 4 - 25, PLS 5-4, SCN 12-23, SQL 2-32, SQL 4-34

ROWLABEL column, ADG 4 - 23

row-level locking, SCN 27-10, SCN 27-20

row-level replication, REP 2-2

detecting conflicts, REP 6-5

ROWNUM pseudocolumn, PLS 5-5, SQL 2-55

cannot use indexes, SCN 23-49

optimizing view queries, SCN 23-16, SCN 23-25

uses for, SQL 2-56

ROWNUM pseudocolumns, PCO 4-7

ROWS

command line parameter

SQL*Loader, SUT 8-13

Export parameter, SUT 1-23

Import parameter, SUT 2-27

performance issues

SQL*Loader, SUT 8-18

SQL*Loader command-line parameter, SUT 6-7

rows, SCN 1-23, SCN 10-3

adding to a table, SQL 7-513

addresses of, SCN 10-7

allowing movement of between partitions, SQL 7-360

buffering multiple, DDS 7-8

chaining across blocks, ADG 3 - 5, SAD 12-4, SAD 20-8, SCN 4-10, SCN 10-5

choosing which to load using SQL*Loader, SUT 5-40

clustered, SCN 10-6

rowids of, SCN 10-7

defined, SCN 1-23

described, SCN 10-3

exporting, SUT 1-23

fetched, SCN 16-12

fetching, DDS 7-8

fetching from cursors, PC_ F-58, PC_ F-61, PCO F-45, PCO F-48

format, ADG 3 - 2

format of in data blocks, SCN 4-4

header, ADG 3 - 2

headers, SCN 10-5

identifying during conflict detection, REP 6-6

insert

into remote databases, SQL 7-515

inserting

into partitions, SQL 7-515

into subpartitions, SQL 7-515

inserting into tables and views, PC_ F-68, PCO F-54

locking, SCN 27-11, SCN 27-20

locks on, SCN 11-45, SCN 27-20, SCN 27-23

logical rowids, SCN 12-20

index-organized tables, SCN 10-39

migrating to new block, SCN 4-10

movement between partitions, SQL 7-380

order of storage, SQL 7-372

pieces of, SCN 10-5

removing

from a cluster, SQL 7-581

from a table, SQL 7-581

removing from partitions and subpartitions, SQL 7-441

removing from tables and views, SQL 7-439

row objects, SCN 13-8

row overflow in index-organized tables, SCN 10-38

row sources, SCN 22-4

rowids used to locate, SCN 23-34, SCN 23-38

row-level security, SCN 30-22

selecting in hierarchical order, SQL 5-19

shown in ROWIDs, ADG 4 - 20

shown in rowids, SCN 12-17, SCN 12-18

size, ADG 3 - 2

size of, SCN 10-5

specifying constraints on, SQL 7-224

specifying for import, SUT 2-27

specifying number to insert before save

SQL*Loader, SUT 8-13

storage format of, SCN 10-5

stored in ascending order, SQL 7-227

storing if in violation of constraints, SQL 7-228

triggers on, SCN 20-8

updates to existing rows with SQL*Loader, SUT 5-33

updating, PC_ F-112, PCO F-85

violating integrity constraints, ADG 5 - 21, SAD 20-15

when rowid changes, SCN 12-16

rows column, SQL trace, STU 14-13

Rows Fetched/Fetch Count Ratio data view, STU 15-11

Rows Sorted data view, STU 15-11

RowSource event, STU 15-5

rows-processed count, PCO 8-22

in the SQLCA, PC_ 9-21

use in error reporting, PC_ 9-15

%ROWTYPE attribute, PLS 2-32

syntax, PLS 11-142

ROWTYPE_MISMATCH exception, ADG 10 - 41, PLS 6-6

RPAD function, SQL 4-35

RPC, DDS 1-12, REP 2-4, SCN 33-12

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

RPCs, DDS 5-3

RR date format, ADG 4 - 11

RR date format element, SQL 2-41, SQL 2-44

interpreting, SQL 2-44

RR diagrams

see syntax diagrams, PCO F-7

RRRR date format element, SQL 2-41

RS locks

LOCK TABLE command, ADG 8 - 13

RSA Data Security

see Oracle Advanced Security

RSA encryption, OAS 1-4

RTRIM function, SQL 4-35

using to insert data, PLS B-4

RULE, SRF 1-88, SRF 1-89

Rule, ADQ 1-10

RULE hint, SQL 2-59, STU 7-41, STU 27-27

OPTIMIZER_MODE and, SCN 23-33

rule-based optimization, SCN 22-18, STU 7-24

rule-based optimizer, SRF 1-88

rule-based subscriptions, SCN 19-5, SCN 19-6

rules, purity, PLS 7-7

rules, syntax for configuration files, NET C-2

run command (RMAN), SBR 11-121, SBR 11-124

runtime areas, SCN 7-8

run-time compilation

avoiding, SQL 7-62, SQL 7-183

runtime context, PCO 4-36

establishing, PC_ 5-46

terminating, PC_ 5-46

runtime contexts, PCO A-3

runtime error, PLS 6-1

run-time error handling, ADG 10 - 44

runtime type checking, PC_ 17-22

RX locks

LOCK TABLE command, ADG 8 - 13

---