Oracle8i Generic Documentation Master Index

A, PSC 5-29

abbreviations

AM/PM, NLS 2-14

BC/AD, NLS 2-14

Languages, NLS A-2

abbreviations permitted, PCO 2-11

abnormal termination

automatic rollback, PC_ F-26, PCO F-17

abort

shutting down an instance, SAD 3-12

abort message, DDS 3-4

abort mode, warning notice, PSC 6-22

ABORT option

SHUTDOWN command, SBR 3-3, SBR 14-17, SBR 14-18, SBR 14-26, SBR 15-12

aborted save set, LEG 2-8

ABORTED_REQUEST_THRESHOLD procedure, STU 19-24

aborting an instance, SCN 5-10, SCN 32-4

aborting OCI calls, OCI 2-33

ABS function, SQL 4-5

ABSI

standards, SQL B - 1

absolute file number, SPS 6-3

abstract data type

representing in C applications, OCI 10-8

abstraction, PLS 7-3, PLS 9-2

access

data

managing, SAD 24-1

system privileges, SAD 24-2

database

controlling, SAD 23-1

database administrator account, SAD 1-4

granting privileges, ADG 12 - 16, SAD 24-9

restricting, SAD 3-4

revoking privileges, ADG 12 - 18, SAD 24-12

object

granting privileges, SAD 24-10

privilege types, SAD 24-3

revoking privileges, SAD 24-13

objects

sequences, ADG 3 - 37

remote integrity constraints and objects, DDS 4-3

schema objects

granting privileges, ADG 12 - 17

remote integrity constraints, ADG 5 - 14

revoking privileges, ADG 12 - 19

triggers, ADG 13 - 3, ADG 13 - 48

access control, SCN 30-2

discretionary, SCN 1-39

fine-grained access control, SCN 30-22

password encryption, SCN 29-7

privileges, SCN 30-2

roles, SCN 30-16

access methods, SCN 23-34

cluster scans, SCN 23-34

execution plans, SCN 22-2

hash scans, SCN 23-35

index scans, SCN 23-35

table scans, SCN 23-34

access path, STU 2-10

access paths

cluster join, SCN 23-40

composite index, SCN 23-42

defined, SCN 22-4

hash cluster key, SCN 23-41

indexed cluster key, SCN 23-41

list of, SCN 23-36

optimization, SCN 23-33

single row by cluster join, SCN 23-38

single row by hash cluster key (with unique key), SCN 23-39

single row by rowid, SCN 23-38

single row by unique or primary key, SCN 23-40

access privileges, SUT 2-11

Export, SUT 1-4

ACCESS_INTO_NULL exception, PLS 6-5

ACCOUNT LOCK clause

of ALTER USER. See CREATE USER

of CREATE USER, SQL 7-427

ACCOUNT UNLOCK clause

of ALTER USER. See CREATE USER.

of CREATE USER, SQL 7-427

accounting, RADIUS, OAS 3-26

accounts

creating for snapshots, REP 3-25

operating-system

database administrator, SAD 1-4

role identification, SAD 24-17

user

SYS and SYSTEM, SAD 1-5

ACOS function, SQL 4-6

acquiring rollback segments, SPS 14-5

distributed locks, SRF 1-46

initialization parameters, SPS 6-9

acquisition AST, SPS 8-2, SPS 8-4

ACT parameter, NET 7-39, NET C-80

ACTIVATE STANDBY DATABASE clause

of ALTER DATABASE, SQL 7-11

activating checksumming and encryption, OAS 2-6

active destination state

for archived redo logs, SAD 7-14

active online redo log

loss of group, SBR 15-9, SBR 15-10

active set, PCO 5-12

changing, PC_ 6-13, PC_ 6-14, PCO 5-14, PCO 5-15

cursor movement through, PC_ 6-14

definition, PCO 5-12

definition of, PC_ 2-8

how identified, PC_ 6-12

if empty, PC_ 6-14

when empty, PCO 5-15

when fetched from, PC_ 6-14

when no longer defined, PC_ 6-12

active transactions

read-only tablespaces, MIG 8-23

ACTIVE_DELAYS, NET A-91

actual parameter, PLS 5-8

AD (A.D.) date format element, SQL 2-41, SQL 2-43

Ada. See SQL*Module for Ada

adapters, authentication, OAS 1-10

adaptive multi-user

algorithm for, STU 26-7

definition, STU 26-7

ADD clause

of ALTER DIMENSION, SQL 7-26

of ALTER TABLE, SQL 7-131

ADD DATAFILE clause

of ALTER TABLESPACE, SQL 7-167

ADD LOGFILE clause

of ALTER DATABASE, SQL 7-9

THREAD clause, SPS 6-3

thread required, SPS 14-8

ADD LOGFILE GROUP clause

of ALTER DATABASE, SQL 7-18

ADD LOGFILE MEMBER clause

of ALTER DATABASE, SQL 7-9, SQL 7-18

ADD LOGFILE MEMBER option

ALTER DATABASE command, SAD 6-12

ADD LOGFILE option

ALTER DATABASE command, SAD 6-11

ADD LOGFILE THREAD clause

of ALTER DATABASE, SQL 7-18

add master site, RAR 3-7, RAR 7-3

add object to refresh group, RAR 5-6

ADD OVERFLOW clause

of ALTER TABLE, SQL 7-144

ADD PARTITION, SQL 7-149

ADD PARTITION clause

ALTER TABLE command, SAD 13-11

of ALTER TABLE, SQL 7-148, SQL 7-149

ADD PRIMARY KEY clause

of ALTER MATERIALIZED VIEW LOG, SQL 7-56

ADD ROWID clause

of ALTER MATERIALIZED VIEW, SQL 7-56

of ALTER MATERIALIZED VIEW LOG, SQL 7-56

ADD TEMPFILE clause

of ALTER TABLESPACE, SQL 7-167

add template object, RAR 4-5

ADD_MASTER_DATABASE procedure

DBMS_REPCAT package, REP 2-33

ADD_MONTHS function, SQL 4-6

ADDED_EXTENTS, SPS A-10

adding

columns in column groups, REP 6-14

priority group members, REP 6-25

site priority group members, REP 6-30

sites

to an advanced replication environment, REP 8-8

adding a file, SPS 14-9, SPS 15-10, SPS A-18

additive prebuilt conflict resolution method, RAR 6-10, REP 6-18

address, PLS 5-16

ADDRESS (ADD or ADDR) attribute, NET 7-63, NET 9-4

ADDRESS parameter, NET 6-12, NET 6-76, NET 7-55, NET C-5, NET C-39, NET C-52

ADDRESS_LIST parameter, NET 4-11, NET 6-77, NET C-6, NET C-39, NET C-53

addresses, configuring, NET 6-64

ADMIN OPTION

about, SAD 24-10

revoking, SAD 24-13

roles, SCN 30-19

system privileges, SCN 30-3

with EXECUTE ANY TYPE, SCN 14-14

admin_tables procedure, SAD 19-3, SAD 19-12

ADMINISTER ANY TRIGGER system privilege, SQL 7-501

administering instances, PSC 6-1 to PSC 6-39

with initialization files, PSC 6-2

with Oracle Parallel Server Management, PSC 6-13

administration

distributed databases, DDS 2-1

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

applying, REP 7-5

deleting, REP 7-6

diagnosing problems with, REP 7-8

displaying, REP 7-5

administrative procedures

new after migration, MIG 6-7

administrative regions

defined, NET 6-23

delegated, NET 2-40

delegated, below root, NET 2-42

delegating domains, NET 6-50

described, NET 2-33

in Oracle Names, NET 2-33

root, NET 2-40

administrator accounts

master sites, REP 2-8

Administrator GUI, LSM

administrator privileges, SCN 5-3

connections audited, SCN 31-5

OUTLN schema, SCN 22-6

statement execution not audited, SCN 31-5

administrators, LSM

acceptable names, LEG 2-27

administrator server attribute, LEG 2-25, LEG 2-26

modifying on UNIX, LEG 2-28

modifying on Windows NT, LEG 2-28

server resource attributes, LEG 2-25, LEG 2-26

specifying, LEG 2-26

using wildcard to grant privileges, LEG 2-27

ADO. See attribute descriptor object

ADT, See object type

ADT. See abstract data type

Advanced Networking Option, GTK 2-70

Advanced Program-to-Program Communication (APPC), NET 4-26

advanced queue (AQ) tables

exporting, SUT 1-57

importing, SUT 2-61

advanced queueing

dequeue function, OCI 15-5

description, OCI 9-25

enqueue function, OCI 15-7

examples, OCI 15-8

OCI and, OCI 9-25

OCI descriptors for, OCI 9-25

OCI functions for, OCI 9-25

OCI vs. PL/SQL, OCI 9-26

Advanced Queuing, GTK 2-37 to GTK 2-40, GTK 3-6

administrative interface, SPR 4 - 11

privileges and access control, ADQ 3-10

compatibility, MIG 8-14, MIG 8-32

message streaming, MIG 8-32

privileges, MIG 8-32

rule based subscriptions, MIG 8-32

creation of queue tables and queues, ADQ 8-4

database event publication, GTK 2-39

DBMS_AQADM package, ADQ 3-9, SPR 5 - 1

downgrading queue tables, MIG 12-31

extended address field, MIG 7-26

features

interoperability, MIG 8-32

sender's ID column, MIG 8-32

message properties, ADQ 3-5

multiple consumer queues, GTK 2-39

nonpersistent queues, GTK 2-40

object level and system level privileges, GTK 2-40

parallel server mode, GTK 2-40

propagation, enhanced, GTK 2-39

addition of a sender's ID column, GTK 2-39

history management information, GTK 2-39

single view, GTK 2-39

statistics, GTK 2-39

removing propagation, MIG 12-32

revoking object and system level privileges, MIG 12-30

revoking roles and privelieges, ADQ 8-53

rules engine, GTK 2-38

scripts

CATNOQUEUE.SQL, MIG 7-28

CATQUEUE.SQL, MIG 7-28

upgrading, MIG 7-26

directory

exporting, SUT 1-56

importing, SUT 2-60

for columns, SQL 5-18

for expressions in view query, SQL 7-432

qualifying column names, SCN 14-8, SCN 14-9

qualifying subqueries (inline views), SCN 10-16

specifying in queries and subqueries, SQL 7-547

aliasing, PLS 7-21

ALL, SCN 23-6

data dictionary view, DDS 2-20

ALL clause

of SELECT, SQL 7-545

of SET CONSTRAINTS, SQL 7-568

of SET ROLE, SQL 7-571

ALL comparison operator, PLS 5-5

ALL EXCEPT clause

of SET ROLE, SQL 7-571

ALL operator, SQL 3-6

ALL option, PLS 5-3, SPS 21-4

ALL PRIVILEGES clause

of GRANT object_privileges, SQL 7-506

of REVOKE schema_object_privileges, SQL 7-533

of REVOKE schema_objects_privileges, SQL 7-533

ALL PRIVILEGES shortcut

of AUDIT sql_statements, SQL 7-199

ALL row operator, PLS 5-6

ALL shortcut

of AUDIT sql_statements, SQL 7-199

ALL_ views, SCN 2-6

ALL_ALL_TABLES view, SRF 2-2

ALL_ARGUMENTS view, SRF 2-4

ALL_ASSOCIATIONS view, SRF 2-5

ALL_CATALOG view, SRF 2-5

ALL_CLUSTER_HASH_EXPRESSIONS view, SRF 2-7

ALL_CLUSTERS view, SRF 2-6

ALL_COL_COMMENTS view, SQL 7-212, SRF 2-7

ALL_COL_PRIVS view, SRF 2-7

ALL_COL_PRIVS_MADE view, SRF 2-8

ALL_COL_PRIVS_RECD view, SRF 2-8

ALL_COLL_TYPES view, SRF 2-8

ALL_CONS_COLUMNS view, SRF 2-9

ALL_CONSTRAINTS view, SRF 2-10

ALL_CONTEXT view, SRF 2-11

ALL_DB_LINKS view, SRF 2-11

ALL_DEF_AUDIT_OPTS view, SRF 2-11

ALL_DEPENDENCIES view, SRF 2-12

ALL_DIM_ATTRIBUTES view, SRF 2-13

ALL_DIM_CHILD_OF view, SRF 2-13

ALL_DIM_HIERARCHIES view, SRF 2-14

ALL_DIM_JOIN_KEY view, SRF 2-14

ALL_DIM_LEVEL_KEY view, SRF 2-15

ALL_DIM_LEVELS view, SRF 2-14

ALL_DIMENSIONS view, SRF 2-12

ALL_DIRECTORIES view, SRF 2-15

ALL_ERRORS view, SRF 2-15

debugging stored procedures, ADG 10 - 43

ALL_HISTOGRAMS view, STU 7-6

ALL_IND_COLUMNS view, SRF 2-16

ALL_IND_PARTITIONS view, SRF 2-16

ALL_IND_SUBPARTITIONS view, SRF 2-18

ALL_INDEXES view, SRF 2-19, STU 6-16

filling with data, SAD 20-5

ALL_INDEXTYPE_OPERATORS view, SRF 2-22

ALL_INDEXTYPES view, SRF 2-22

ALL_JOBS view, SRF 2-22

ALL_LABELS view, SRF 2-23

ALL_LIBRARIES view, SRF 2-23

ALL_LOB_PARTITIONS view, SRF 2-24

ALL_LOB_SUBPARTITIONS view, SRF 2-25

ALL_LOBS view, SRF 2-24

ALL_METHOD_PARAMS view, SRF 2-26

ALL_METHOD_RESULTS view, SRF 2-27

ALL_MVIEW_AGGREGATES view, SRF 2-27

ALL_MVIEW_ANALYSIS view, SRF 2-28

ALL_MVIEW_DETAIL_RELATIONS view, SRF 2-29

ALL_MVIEW_JOINS view, SRF 2-29

ALL_MVIEW_KEYS view, SRF 2-30

ALL_NESTED_TABLES view, SRF 2-30

ALL_OBJECT_TABLES view, SRF 2-31

ALL_OBJECTS view, SRF 2-33, STU 19-32

ALL_OPANCILLARY view, SRF 2-34

ALL_OPARGUMENTS view, SRF 2-34

ALL_OPBINDINGS view, SRF 2-34

ALL_OPERATORS view, SRF 2-35

ALL_OUTLINE_HINTS view, SRF 2-35

ALL_OUTLINES view, SRF 2-35

ALL_PART_COL_STATISTICS view, SRF 2-36

ALL_PART_HISTOGRAMS view, SRF 2-37

ALL_PART_INDEXES view, SRF 2-37

ALL_PART_KEY_COLUMNS view, SRF 2-38

ALL_PART_LOBS view, SRF 2-39

ALL_PART_TABLES view, SRF 2-40

ALL_PARTIAL_DROP_TABS view, SRF 2-41

ALL_POLICIES view, SRF 2-41

ALL_QUEUES view, SRF 2-42

ALL_REFRESH_CHILDREN view, SRF 2-43

ALL_REFRESH_DEPENDENCIES view, SRF 2-44

ALL_REFRESHS view, SRF 2-42

ALL_REGISTERED_SNAPSHOTS view, SRF 2-45

ALL_REPCATLOG view, SRF 2-46

ALL_REPCOLUMN view, SRF 2-46

ALL_REPCOLUMN_GROUP view, SRF 2-46

ALL_REPCONFLICT view, SRF 2-46

ALL_REPDDL view, SRF 2-46

ALL_REPGENERATED view, SRF 2-46

ALL_REPGENOBJECTS view, SRF 2-46

ALL_REPGROUP view, SRF 2-46

ALL_REPGROUPED_COLUMN view, SRF 2-47

ALL_REPKEY_COLUMNS view, SRF 2-47

ALL_REPOBJECT view, SRF 2-47

ALL_REPPARAMETER_COLUMN view, SRF 2-47

ALL_REPPRIORITY view, SRF 2-47

ALL_REPPRIORITY_GROUP view, SRF 2-47

ALL_REPPROP view, SRF 2-47

ALL_REPRESOL_STATS_CONTROL view, SRF 2-48

ALL_REPRESOLUTION view, SRF 2-47

ALL_REPRESOLUTION_METHOD view, SRF 2-48

ALL_REPRESOLUTION_STATISTICS view, SRF 2-48

ALL_REPSITES view, SRF 2-48

ALL_ROWS hint, SCN 23-33, SQL 2-59, STU 7-38

ALL_SEQUENCES view, SRF 2-48

ALL_SNAPSHOT_LOGS view, SRF 2-49

ALL_SNAPSHOT_REFRESH_TIMES view, SRF 2-49

ALL_SNAPSHOTS view, SRF 2-49

ALL_SOURCE view, ADG 10 - 43, SRF 2-51

ALL_SUBPART_COL_STATISTICS view, SRF 2-51

ALL_SUBPART_HISTOGRAMS view, SRF 2-52

ALL_SUBPART_KEY_COLUMNS view, SRF 2-52

ALL_SUMDELTA view, SRF 2-53

ALL_SUMMARIES view, SRF 2-53

ALL_SYNONYMS view, SRF 2-54

ALL_TAB_COL_STATISTICS view, SRF 2-54

ALL_TAB_COLUMNS view, SRF 2-55, STU 7-5, STU 7-6

filling with data, SAD 20-5

ALL_TAB_COMMENTS view, SQL 7-212, SRF 2-56

ALL_TAB_HISTOGRAMS view, SRF 2-56

ALL_TAB_PARTITIONS view, SRF 2-57

ALL_TAB_PRIVS view, SRF 2-58

ALL_TAB_PRIVS_MADE view, SRF 2-58

ALL_TAB_PRIVS_RECD view, SRF 2-59

ALL_TAB_SUBPARTITIONS view, SRF 2-59

ALL_TABLES table, SPS 16-7

ALL_TABLES view, SRF 2-60

filling with data, SAD 20-5

ALL_TRIGGER_COLS view, SRF 2-64

ALL_TRIGGERS view, SRF 2-63

ALL_TYPE_ATTRS view, SRF 2-64

ALL_TYPE_METHODS view, SRF 2-65

ALL_TYPES view, SRF 2-65

ALL_UPDATABLE_COLUMNS view, SCN 10-15, SRF 2-65, SRF 2-66, SRF 2-156, SRF 2-260

ALL_USERS view, SRF 2-66

ALL_USTATS view, SRF 2-66

ALL_VARRAYS view, SRF 2-67

ALL_VIEWS view, SRF 2-67

ALLOCATE

allocating a cursor variable, PC_ 4-27

allocate channel command (RMAN), SBR 11-9

for delete option, SBR 8-26, SBR 11-13

for maintenance option, SBR 11-13

ALLOCATE DESCRIPTOR statement, PC_ 14-13, PC_ F-14, PCO F-12

ALLOCATE EXTENT clause

of ALTER CLUSTER, SQL 7-3, SQL 7-4

of ALTER INDEX, SQL 7-30, SQL 7-34

of ALTER TABLE, SQL 7-140

ALLOCATE EXTENT option

DATAFILE option, SPS 11-11, SPS 17-12

in exclusive mode, SPS 17-11

instance number, SPS 11-15, SPS 17-13, SRF 1-52

INSTANCE option, SPS 11-11, SPS 17-12

not available, SPS A-20

pre-allocating extents, SPS 17-14

SIZE option, SPS 11-11, SPS 17-11

ALLOCATE SQL statement, PC_ 17-5

ALLOCATE SQL statements, PC_ F-12

ALLOCATE statement, PCO F-10

use with ROWID, PCO 4-37

allocating

cursor variables, PC_ 4-27

cursors, PC_ F-12, PCO F-10

thread context, PC_ 11-8, PC_ F-28, PCO F-19

allocating cursor variables, PCO 6-33

allocation

allocation duration

example, OCI 13-14

of objects, OCI 13-14

ALLOW_PARTIAL_SN_RESULTS parameter, SRF 1-13

obsolete for 8.1, SPS A-5

alphanumeric datatypes, SAD 12-17

ALTER ANY CLUSTER system privilege, SQL 7-495

ALTER ANY DIMENSION system privilege, SQL 7-496

ALTER ANY INDEX system privilege, SQL 7-496

ALTER ANY MATERIALIZED VIEW system privilege, SQL 7-497

ALTER ANY OUTLINE system privilege, SQL 7-498

ALTER ANY PROCEDURE system privilege, SQL 7-498

ALTER ANY ROLE system privilege, SQL 7-498

ALTER ANY SEQUENCE system privilege, SQL 7-499

ALTER ANY SNAPSHOT system privilege, SQL 7-499

ALTER ANY TABLE system privilege, SQL 7-500

ALTER ANY TRIGGER system privilege, SQL 7-501

ALTER ANY TYPE privilege, SCN 14-13

See also privileges

ALTER ANY TYPE system privilege, SQL 7-501

ALTER AUTHORIZATION

changing password, PCO 3-11

ALTER CLUSTER command, ADG 3 - 6

ALLOCATE EXTENT option, ADG 6 - 17, SAD 17-9

MAXTRANS option, SAD 12-9

using for hash clusters, SAD 18-8

using for index clusters, SAD 17-9

ALTER CLUSTER statement, SPS A-20, SQL 7-2

ALLOCATE EXTENT option, SPS 17-11

allocating extents, SPS 17-14

ALTER command, SCN 16-4

auditing partitions, SCN 11-63

ALTER DATABASE

statement, SQL 7-6

system privilege, SQL 7-495

ALTER DATABASE ADD LOGFILE, PSC 8-2

ALTER DATABASE command

ADD LOGFILE, SRF 1-123

ADD LOGFILE MEMBER option, SAD 6-12

ADD LOGFILE option, SAD 6-11

ARCHIVELOG option, SAD 7-7

BACKUP CONTROLFILE option, SBR 3-6

BACKUP CONTROLFILE TO TRACE option, SBR 13-12

CLEAR LOGFILE GROUP option, SBR 16-17

CLEAR LOGFILE option, SAD 6-17

CLEAR UNARCHIVED LOGFILE option, SAD 6-7, SBR 2-14, SBR 16-25

CREATE DATAFILE option, SBR 14-6

database name, SRF 1-33

database partially available to users, SAD 3-7

DATAFILE OFFLINE DROP clause, SBR 16-27

DATAFILE ONLINE option, SBR 14-31

DATAFILE...OFFLINE DROP option, SAD 10-8

DROP LOGFILE MEMBER option, SAD 6-15

DROP LOGFILE option, SAD 6-14

ENABLE THREAD, SRF 1-123

ENABLE THREAD option, SBR 16-24

MOUNT option, SAD 3-7

MOUNT STANDBY DATABASE option, SBR 16-6, SBR 16-29

NOARCHIVELOG option, SAD 7-7

NORESETLOGS option, SBR 13-14, SBR 14-33

OPEN option, SAD 3-7

OPEN READ ONLY option, SBR 16-19, SBR 16-20, SBR 16-21

OPEN RESETLOGS option, SBR 6-7

RECOVER ... FROM option, SBR 14-8, SBR 14-12

RECOVER AUTOMATIC LOGFILE option, SBR 14-15

RECOVER LOGFILE option, SBR 14-14

RENAME DATABASE clause, SBR 9-9

RENAME FILE option

datafiles for multiple tablespaces, SAD 10-10

RESETLOGS option, SBR 13-14, SBR 14-17, SBR 14-18, SBR 14-33

standby database, SCN 5-7

THREAD, SRF 1-123

UNRECOVERABLE DATAFILE option, SAD 6-17

alter database command (RMAN), SBR 11-15

ALTER DATABASE CONVERT command, MIG 3-4, MIG 3-26

re-running, MIG A-19

ALTER DATABASE OPEN RESETLOGS command, MIG 3-4, MIG 3-26

ALTER DATABASE OPEN RESETLOGS statement, SPS 22-14

ALTER DATABASE RESET COMPATIBILITY, MIG 8-7

ALTER DATABASE statement

ADD LOGFILE, SPS 6-3

adding or dropping log file, SPS A-18

CLOSE option, SPS 18-18

DATAFILE OFFLINE and ONLINE options, SPS A-18

DATFILE RESIZE, SPS 15-9

DISABLE, SPS 14-9

ENABLE THREAD, SPS 14-8

MOUNT option, SPS 18-13

OPEN option, SPS 18-14

RECOVER, SPS 22-7

RECOVER option, SPS 22-7

renaming a file, SPS A-18

setting the log mode, SPS 14-2, SPS 14-9, SPS B-2

THREAD, SPS 14-9

thread of redo, SPS 14-9

ALTER DIMENSION statement, SQL 7-24

ALTER FUNCTION command

COMPILE option, SAD 20-25

ALTER FUNCTION statement, SQL 7-27

ALTER INDEX COALESCE, SAD 16-7

ALTER INDEX command, ADG 3 - 6, SAD 13-18

about, SAD 16-13

MAXTRANS option, SAD 12-9

MOVE PARTITION clause, SAD 13-11

no-logging mode for SPLIT PARTITION, SCN 11-58, SCN 25-7

partition attributes, SCN 11-37

REBUILD PARTITION, SCN 11-60

REBUILD PARTITION clause, SAD 13-11, SAD 13-20

ALTER INDEX REBUILD statement, STU 6-9

ALTER INDEX statement, SQL 7-29

COMPUTE STATISTICS clause, GTK 2-27

DEALLOCATE UNUSED option, SPS 17-16

online rebuild, GTK 2-42

ALTER JAVA CLASS statement, SQL 7-43

ALTER JAVA SOURCE statement, SQL 7-43

ALTER MATERIALIZED VIEW LOG statement, SQL 7-54

ALTER MATERIALIZED VIEW statement, SQL 7-45, STU 29-4

enabling query rewrite, STU 31-4

ALTER object privilege, SQL 7-508

ALTER OUTLINE statement, SQL 7-58

ALTER PACKAGE command

COMPILE option, SAD 20-25

ALTER PACKAGE statement, SQL 7-59

ALTER PROCEDURE command

COMPILE option, SAD 20-25

ALTER PROCEDURE statement, SQL 7-62

ALTER PROFILE

statement, SQL 7-64

system privilege, SQL 7-498

ALTER PROFILE command

altering resource limits, SAD 23-19

COMPOSITE_LIMIT option, SAD 23-19

alter replicated object, RAR 7-16

alter replication object, RAR 6-8

ALTER RESOURCE COST

statement, SQL 7-68

system privilege, SQL 7-499

ALTER RESOURCE COST command, SAD 23-20

ALTER ROLE command

changing authorization method, SAD 24-8

ALTER ROLE statement, SQL 7-71

ALTER ROLLBACK SEGMENT

statement, SQL 7-73

system privilege, SQL 7-498

ALTER ROLLBACK SEGMENT command, SPS 6-10

changing storage parameters, SAD 21-9

OFFLINE option, SAD 21-12

ONLINE option, SAD 21-11, SAD 21-12

PUBLIC option, SAD 21-9

STORAGE clause, SAD 21-9

ALTER SEQUENCE command, ADG 3 - 37, SAD 15-11

ALTER SEQUENCE statement, SQL 7-76

ALTER SESSION

FORCE PARALLEL DDL, SCN 26-24, SCN 26-27

create or rebuild index, SCN 26-25, SCN 26-27

create table as select, SCN 26-26, SCN 26-27

move or split partition, SCN 26-25, SCN 26-28

FORCE PARALLEL DML

insert, SCN 26-23, SCN 26-24, SCN 26-27

update and delete, SCN 26-22, SCN 26-27

statement, SQL 7-78

system privilege, DDS 4-2, SQL 7-499

ALTER SESSION command, SCN 16-5

ALTER SESSION statement

examples, STU 14-5

SET INSTANCE option, SPS 11-11, SPS 17-10

SET SESSION_CACHED_CURSORS, STU 19-18

ALTER SNAPSHOT LOG command, REP 7-23

ALTER SNAPSHOT LOG. See ALTER MATERIALIZED VIEW LOG.

ALTER SNAPSHOT. See ALTER MATERIALIZED VIEW.

ALTER statement

triggers on, SQL 7-405

ALTER SYSTEM

command, limiting instances for parallel execution, SPS 18-27

statement, SQL 7-95

system privilege, SQL 7-495

ALTER SYSTEM ARCHIVE LOG statement, SPS 18-18, SPS 21-16

CURRENT option, SPS 21-10, SPS A-19

global log switch, SPS 21-10, SPS 21-16

THREAD option, SPS 18-18, SPS 21-4

ALTER SYSTEM CHECK DATAFILES statement, SPS 6-2

instance recovery, SPS 22-4

ALTER SYSTEM CHECKPOINT statement, SPS 21-9

global versus local, SPS 18-18

specifying an instance, SPS 18-18

ALTER SYSTEM command, SCN 16-5

ALTER SYSTEM DISCONNECT SESSION, STU 25-22

ALTER SYSTEM privilege, SPS 21-10

ALTER SYSTEM RESUME, SAD 3-13

alter system set mts_dispatchers wait event, SRF A-20

ALTER SYSTEM statement

CHECKPOINT option, STU 25-6

MTS_DISPATCHERS parameter, STU 21-8

ALTER SYSTEM SUSPEND, SAD 3-8

ALTER SYSTEM SWITCH LOGFILE statement, SPS 18-18, SPS 21-10, SPS A-19

DBA privilege, SPS 21-10, SPS A-19

ALTER TABLE command, ADG 3 - 6, ADG 3 - 9

add or coalesce hash partition, SCN 11-17

ADD PARTITION clause, SAD 13-11

ALLOCATE EXTENT option, SAD 14-11

auditing, SCN 31-7

bitmap index invalidation, MIG 8-25

CACHE clause, SCN 7-4

DEALLOCATE UNUSED, SCN 4-14

defining integrity constraints, ADG 5 - 18

DISABLE ALL TRIGGERS option, ADG 13 - 31, SAD 20-13

DISABLE integrity constraint option, ADG 5 - 23, SAD 20-20

disable or enable constraints, SCN 28-22

DROP COLUMN, SCN 10-6

DROP integrity constraint option, ADG 5 - 29, SAD 20-21

DROP PARTITION clause, SAD 13-12

ENABLE ALL TRIGGERS option, ADG 13 - 30, SAD 20-12

ENABLE integrity constraint option, ADG 5 - 23, SAD 20-20

example, SAD 14-11

EXCHANGE PARTITION, SCN 11-11

INITRANS parameter, ADG 8 - 26

MAXTRANS option, SAD 12-9

MERGE PARTITIONS, SCN 11-16

MODIFY CONSTRAINT, SCN 28-23

MODIFY PARTITION clause, SAD 13-10

no-logging mode for SPLIT PARTITION, SCN 11-58, SCN 25-7

partition attributes, SCN 11-27

SPLIT PARTITION clause, SAD 13-11, SAD 13-17

triggers and, SCN 20-6

TRUNCATE PARTITION clause, SAD 13-15

UNUSED column, SCN 10-6

validate or novalidate constraints, SCN 28-22

ALTER TABLE statement, SQL 7-114

ALLOCATE EXTENT option, SPS 17-11

allocating extents, SPS 17-14, SPS 17-15, SRF 1-52

DISABLE TABLE LOCK option, SPS 7-6, SPS 10-3, SPS 16-7

drop column support, GTK 2-41

ENABLE ROW MOVEMENT, GTK 2-46

ENABLE TABLE LOCK option, SPS 7-6, SPS 10-3, SPS 16-7

MAXEXTENTS option, SPS 17-15

merging partitions, GTK 2-46

MODIFY CONSTRAINT clause, GTK 2-28

MOVE option for IOT or non-partitioned table, GTK 2-29

no longer invalidates bitmap indexes, GTK 2-25

NOLOGGING option, STU 27-23

ALTER TABLESPACE

statement, SQL 7-164

system privilege, SQL 7-500

ALTER TABLESPACE command

ADD DATAFILE parameter, SAD 10-5

BEGIN BACKUP option, SBR 13-6, SBR 13-9

BEGIN/END BACKUP option, SBR 6-28

END BACKUP option, SBR 13-9

ONLINE option

example, SAD 9-10

READ ONLY, SCN 3-10

READ ONLY option, SAD 9-12

READ WRITE, SCN 3-11

READ WRITE option, SAD 9-14

RENAME DATA FILE option, SAD 10-10

TEMPORARY or PERMANENT, SCN 3-13

ALTER TABLESPACE statement

ADD DATAFILE, SPS 15-10

ADD DATAFILE option, SPS A-18

BACKUP option, SPS 21-15

OFFLINE and ONLINE options, SPS A-18

READ ONLY option, SPS 12-2

renaming a data file, SPS A-18

ALTER TRIGGER command

DISABLE option, ADG 13 - 30, SAD 20-13

ENABLE option, ADG 13 - 30, SAD 20-12

ALTER TRIGGER statement, SQL 7-171

ALTER TYPE statement, SQL 7-173

ALTER USER

statement, SQL 7-179

system privilege, SQL 7-501

ALTER USER command

temporary segments and, SCN 4-18

ALTER USER privilege, SAD 23-15

ALTER VIEW command

COMPILE option, SAD 20-25

ALTER VIEW statement, SQL 7-183

ALTER_MASTER_REPOBJECT procedure

DBMS_REPCAT package, REP 2-29

altering

alternate character mappings, NLS 4-9

alternate keys

in replicated tables, REP 2-25

Always Use Dedicated Server option, NET 7-26

ALWAYS_ANTI_JOIN parameter, SCN 24-13, SRF 1-14, STU 7-22, STU 7-56

ALWAYS_SEMI_JOIN parameter, SCN 24-13, SRF 1-14

AM (A.M.) date format element, SQL 2-41, SQL 2-43

American National Standards Institute (ANSI)

ANSI-compatible locking, ADG 8 - 19

American National Standards Institute. See ANSI.

AM/PM abbreviation

language of, NLS 2-14

analysis dictionary, STU 12-4

ANALYZE

Import parameter, SUT 2-19

ANALYZE ANY system privilege, SQL 7-502

ANALYZE CLUSTER statement, SQL 7-185

ANALYZE command, SCN 16-4, SRF 2-19, SRF 2-55, SRF 2-60, SRF 2-94, SRF 2-145, SRF 2-150, SRF 2-206, SRF 2-249, SRF 2-254

CASCADE option, SAD 20-8

COMPUTE STATISTICS option, SAD 20-7

creating histograms, SCN 22-11

dangling REFs, GTK 2-36

distributed transactions, DDS 2-26

ESTIMATE STATISTICS SAMPLE option, SAD 20-7

estimated statistics, SCN 22-14

LIST CHAINED ROWS option, SAD 20-9

partition statistics, SCN 11-14

shared pool and, SCN 7-11

shared SQL and, SAD 20-8

STATISTICS option, SAD 20-4

VALIDATE STRUCTURE option, SAD 20-8

ANALYZE command,parallel, GTK 3-2

ANALYZE INDEX statement, SQL 7-185

ANALYZE statement, STU 11-4, STU 20-31, STU 27-20, STU 27-27, STU 32-16

ANALYZE TABLE statement, SQL 7-185

ANALYZE TABLE VALIDATE STRUCTURE, SAD 19-3

ANALYZE TABLE VALIDATE STRUCTURE command

change in release 8.1, MIG 8-17

analyze tables, DDS 4-6

analyzer statistics, SUT 2-63

analyzing archived redo logs, SAD 7-25

analyzing data

for parallel processing, STU 26-78

analyzing objects

about, SAD 20-3

privileges, SAD 20-3

ANCILLARY TO clause

of CREATE OPERATOR, SQL 7-320

AND expression

for simple subquery snapshots, REP 3-13

AND operator, SQL 3-11

AND_EQUAL hint, SQL 2-59, STU 6-7, STU 7-49

ANO. See Advanced Networking Option.

anonymous PL/SQL block, PLS 7-2

anonymous PL/SQL blocks, SCN 16-15, SCN 18-9

about, ADG 10 - 2

applications, SCN 16-17

calling a stored procedure, SCN 16-19

compared to triggers, ADG 10 - 26

contrasted with stored procedures, SCN 18-9

dynamic SQL, SCN 16-19

dynamic SQL and, SPR 48 - 2

performance, SCN 18-9

ANSI, SQL B - 1

datatypes, SQL 2-23

conversion to Oracle datatypes, SQL 2-23

standards, SQL 1-2

supported datatypes, SQL 2-8

ANSI C Support, PC_ E-2

ANSI dynamic SQL, PC_ A-4, PCO A-2

reference semantics, PC_ 14-7

ANSI format

COBOL statements, PCO 2-12

ANSI SQL standard

datatypes of, SCN 12-22

Oracle certification, SCN 1-3

ANSI SQL92

FIPS flagger, ADG 8 - 2

ANSI/ISO SQL

extensions, PCO 14-22

ANSI/ISO SQL standard, SCN 1-3

composite foreign keys, SCN 28-16

data concurrency, SCN 27-2

isolation levels, SCN 27-10

ANSWER_TIMEOUT parameter, NET C-78

anti-joins, SCN 24-13

ANY, SCN 23-6

ANY comparison operator, PLS 5-5

ANY operator, SQL 3-6

API

MM, LEG 1-11

apostrophe, PLS 2-8

APPC architecture, NET 4-26

APPEND hint, SQL 2-61, STU 7-61, STU 27-22

APPEND keyword

SQL*Loader, SUT 5-43

append sequences

conflict resolution methods, REP 6-36

append site names

conflict resolution methods, REP 6-36

APPEND to table

example, SUT 4-11

SQL*Loader, SUT 5-32

application administrator, SAD 1-3

database administrator versus, SAD 22-11

application context, ADG 12 - 22, GTK 2-69, SCN 30-24

compatibility, MIG 8-13

CREATE CONTEXT statement, GTK 2-70

downgrading, MIG 12-36

application design, STU 2-9

application designer, STU 1-8

application developer, STU 1-8

role during migration, MIG 1-10

application developers

privileges for, SAD 22-9

roles for, SAD 22-10

application development

in a distributed database environment, DDS 4-1

security for, SAD 22-10

using Heterogeneous Services, DDS 7-1

application development process, PC_ 2-9, PCO 2-2

Application development with Heterogeneous Services, DDS 7-1

application error

definition, SBR 1-12

application failover, STU 25-17, STU 25-19

callback example, OCI 9-20

callback registration, OCI 9-20

OCI callbacks, OCI 9-18

Application Generator for Microsoft Visual Studio, GTK 2-85

application level firewalls, OAS 9-11

application program interface (API), for non-Oracle data sources, NET 9-2

application roles, ADG 12 - 3

application servers

allowing to connect as a user, SQL 7-181

applications

allowing to connect as a user, SQL 7-181

analysis of, SPS 12-1

application vs. database triggers, SCN 20-3

availability, SPS 22-2

building with Net8 OPEN, NET 9-8

business functions, SPS 12-2

calling stored procedures and packages, ADG 10 - 52

can find constraint violations, SCN 28-6

client/server, STU 3-9

compatibility, MIG 8-16

compute-intensive, SPS 1-21

configuring system to use custom, NET 9-9

converting to multi-instance, SPS 23-3

data dictionary references, SCN 2-4

data warehousing, SCN 10-32

star queries, SCN 24-14

database access through, SCN 8-2

decision support, STU 3-3, STU 26-3

decision support systems (DSS), SCN 10-33

parallel SQL, SCN 26-2, SCN 26-31

departmentalized, SPS 2-8

dependencies of, SCN 21-11

designing, SPS 13-1

development

constraints, DDS 4-3

database links, controlling connections, DDS 4-2

distributing data, DDS 4-2

referential integrity, DDS 4-3

remote connections, terminating, DDS 4-2

direct-load INSERT, SCN 26-38

discrete transactions, SCN 17-8

disjoint data, SPS 1-17, SPS 2-7

distributed databases, STU 3-7

DSS, SPS 1-5, SPS 1-12, SPS 1-21, SPS 2-7

enhancing security with, SCN 1-42, SCN 28-5

errors

RAISE_APPLICATION_ERROR() procedure, DDS 4-11

failover of, SPS 4-11

index-organized tables, SCN 10-40

compatibility, MIG 8-16

information retrieval (IR), SCN 10-40

insert-intensive, SPS 11-12

interoperability, MIG 8-16

linking, OCI 2-36

network communication and, SCN 6-5

node, SPS 5-4

object dependencies and, SCN 21-13

OCI

compatibility, MIG 8-17

interoperability, MIG 8-17

OLTP, SPS 1-5, SPS 1-12, SPS 2-7, STU 3-1

online analytical processing (OLAP), SCN 10-42

online transaction processing (OLTP)

reverse key indexes, SCN 10-31

parallel DML, SCN 26-37

parallel query, STU 3-4

parallel server, STU 3-8

performance, SPS 11-12

physical ROWIDs and UROWIDs, MIG 8-16

physical ROWIDs in Oracle8i, MIG 11-2

PL/SQL

compatibility, MIG 8-20

interoperability, MIG 8-20

portability, SPS 1-5

precompiler

compatibility, MIG 8-18

interoperability, MIG 8-18

processes, SCN 8-4

profile, SPS 12-2

profiles, SPS 3-2

program interface and, SCN 8-25

query-intensive, SPS 1-17, SPS 2-7

quiescing during maintenance operations, SAD 13-21

random access, SPS 2-8

redesigning for parallel processing, SPS 1-16

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

roles, ADG 12 - 4

roles and, SCN 30-18

samples provided with Net8 OPEN, NET 9-11

scalability, SPS 2-2, SPS 2-6

securing, SQL 7-243

security, ADG 12 - 7

application context, SCN 30-24

sharing code, SCN 7-17

spatial applications, SCN 10-42

transaction termination and, SCN 17-5

tuning, SPS 12-1

tuning performance, SPS 1-15, SPS 11-12

Tuxedo applications

compatibility, MIG 8-17

unhandled exceptions in, ADG 10 - 46

upgrading, MIG 9-1

validating, SQL 7-243

applying log files

SQL*Plus, SBR 14-12

AQ

exporting queue tables, SCN 19-12

message queuing, SCN 19-2

publish/subscribe support, SCN 19-10

event publication, SCN 20-18

queue monitor process, SCN 1-20, SCN 8-13, SCN 19-6

interval statistics, SCN 19-11

window of execution, SCN 19-7

queue tables, SCN 19-4

recipients, SCN 19-5

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

subscription lists, SCN 19-5

remote databases, SCN 19-9

AQ (advanced queue) tables

exporting, SUT 1-57

importing, SUT 2-61

AQ. See advanced queueing.

AQ. See Advanced Queuing

AQ_ADMINISTRATOR role, SCN 19-7

AQ_ADMINISTRATOR_ROLE role, SQL 7-503

AQ_TM_PROCESS parameter, SCN 19-6, SCN 19-7

AQ_TM_PROCESSES parameter, SRF 1-15

of ALTER SYSTEM, SQL 7-100

AQ_USER_ROLE role, SQL 7-503

ARCH process, SPS 5-5, SPS 21-4, STU 21-16

multiple, STU 26-75

specifying multiple processes, SAD 7-20

ARCH_IO_SLAVES parameter, SRF 1-15

architecture, PLS 1-17

client/server, SCN 1-33

hardware, SPS 3-1

MPP, SCN 26-49

multi-instance, SPS 5-4

Net8, NET 2-5

of Oracle, SCN 1-14

OPSCTL utility on UNIX, PSC 5-4

OPSCTL utility on Windows NT, PSC 5-6

Optimal Flexible Architecture (OFA), PSC 1-2

Oracle Connection Manager, NET 2-46

Oracle database, SPS 6-1

Oracle Enterprise Manager, PSC 5-8

Oracle instance, SPS 5-1

Oracle Names, NET 2-31

Oracle Parallel Server, PSC 1-2

Oracle Parallel Server Management, PSC 5-2

SMP, SCN 26-49

architecture and CPU, STU 18-10

architecture of SSL

in an Oracle environment, OAS 9-3

with other authentication methods, OAS 9-8

architecture, LSM, LEG 2-2, LEG 2-3

archive buffer parameters, SAD 7-22

archive log

backup, SPS 21-7

ARCHIVE LOG clause

CURRENT option, SPS 21-10, SPS 21-16, SPS A-19

global log switch, SPS 21-10, SPS 21-16

manual archiving, SPS 21-4

of ALTER SYSTEM, SQL 7-96

specifying an instance, SPS 18-21

THREAD option, SPS 21-4

ARCHIVE LOG command, SPS 21-3

destination file, SRF 1-60

LIST option, SAD 6-14

START and STOP, SRF 1-66

ARCHIVE LOG CURRENT option

ALTER SYSTEM command, SBR 16-4, SBR 16-21

archive log destination parameters

new in release 8.1, MIG B-13

ARCHIVE LOG option

ALTER SYSTEM command, SAD 7-10

archived redo log, SCN 1-48

automatic archiving, SCN 32-19

automatic versus manual, SRF 1-66

enabling, SCN 32-18

manual archiving, SCN 32-20

storage device, SRF 1-60, SRF 1-64

archived redo log files

location of, SQL 7-13

storage locations, SQL 7-83

archived redo logs, SAD 7-2, SBR 2-14, SBR 2-18, SBR 2-21

ALTER SYSTEM ARCHIVE ALL command, SBR 3-5

analyzing, SAD 7-25

applying during media recovery, SBR 14-10, SBR 14-14

archiving modes, SAD 7-7

automatic archiving, SAD 7-8

backing up, SBR 8-19

copies, listing, SBR 7-2

deleting after recovery, SBR 14-8

destination states, SAD 7-13, SBR 16-11

active/inactive, SAD 7-14

bad param, SAD 7-14

deferred, SAD 7-14

enabled/disabled, SAD 7-13

valid/invalid, SAD 7-13

destinations

re-archiving to failed, SAD 7-19, SBR 16-11

sample scenarios, SAD 7-18

enabling automatic archiving, SAD 7-8

errors during recovery, SBR 14-16

failed destinations and, SAD 7-16

location during recovery, SBR 14-10

loss of, SBR 15-10

multiplexing, SAD 7-11, SBR 2-19, SBR 16-10

normal transmission of, SAD 7-14, SBR 2-21

registering, SBR 6-5

restoring to disk, SBR 14-7

restoring using RMAN, SBR 9-13

specifying destinations for, SAD 7-11, SBR 2-19

standby transmission of, SAD 7-14, SBR 2-21

status information, SAD 7-24, SBR 2-4, SBR 2-18

transmitting, SAD 7-14, SBR 2-21, SBR 16-7

tuning, SAD 7-20

archivelog backups

using RMAN, SBR 8-8

ARCHIVELOG clause

of ALTER DATABASE, SQL 7-9, SQL 7-17

of CREATE CONTROLFILE, SQL 7-248

ARCHIVELOG mode, SAD 7-4, SAD 7-6, SBR 2-16, SPS 14-9

advantages, SAD 7-5, SBR 2-17

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

archiving, SAD 7-4, SBR 2-15

archiving destination, SRF 1-60, SRF 1-64

automatic archiving, SPS 4-6, SPS 21-3, SRF 1-66

automatic archiving in, SAD 7-5

backup options, SBR 3-20

backup strategies when using, SBR 3-16

changing mode, SPS 14-2, SPS 14-9, SPS B-2

creating a database, SPS 14-2

datafile loss in, SBR 15-3

defined, SCN 32-18

definition of, SAD 7-4, SBR 2-16

distributed databases, SAD 7-6, SBR 3-22

enabling, SAD 7-7

manual archiving in, SAD 7-5

online and offline backups, SPS 4-6, SPS 21-3

overview, SBR 1-10, SCN 1-48

partial database backups, SCN 1-50, SCN 32-24

running in, SAD 7-4, SBR 2-16

strategies for backups in, SBR 3-16

switching to, SAD 7-7

taking datafiles offline and online in, SAD 10-8

whole database backups, SCN 32-24

archivelogRecoverSpecifier clause (RMAN), SBR 11-17

archiver process (ARCn)

automatic archiving, SCN 32-19

described, SCN 1-19, SCN 8-12

example, SCN 32-18

multiple processes, SCN 1-19, SCN 8-12

not used for manual archiving, SCN 32-21

trace file, SCN 32-20

archiving

advantages, SAD 7-4, SBR 2-15

after inconsistent closed backups, SBR 3-5

after open backups, SBR 3-5

ALTER SYSTEM ARCHIVE ALL, SBR 3-5

automatic

disabling, SAD 7-9

disabling at instance startup, SAD 7-9

enabling, SAD 7-8

enabling after instance startup, SAD 7-9

enabling at instance startup, SAD 7-9

changing archiving mode, SAD 7-7

destination states, SAD 7-13, SBR 16-11

active/inactive, SAD 7-14

enabled/disabled, SAD 7-13

valid/invalid, SAD 7-13

destinations

failure, SAD 7-16

disabling, SAD 7-7

disadvantages, SAD 7-4, SBR 2-15

enabling, SAD 7-7, SAD 7-9

error detection behavior, MIG 8-43

increasing speed of, SAD 7-23

manual, SAD 7-10

minimizing impact on system performance, SAD 7-23

multiple ARCH processes, SAD 7-20

privileges

disabling, SAD 7-9

enabling, SAD 7-8

for manual archiving, SAD 7-10

setting archive buffer parameters, SAD 7-22

setting initial mode, SAD 7-7

to failed destinations, SAD 7-19, SBR 16-11

tuning, SAD 7-20

viewing information on, SAD 7-24, SBR 2-4, SBR 2-18

archiving redo log files, SPS 21-1

automatic versus manual, SPS 21-3

conversion to multi-instance, SPS 23-3

creating a database, SPS 14-2

forcing a log switch, SPS 21-10

history, SPS 21-6

identified in control file, SPS 6-5

log sequence number, SPS 21-5

online archiving, SPS 4-6, SPS 21-3

ARCHVIELOG clause

OF CREATE DATABASE, SQL 7-252

ARCn background process, SCN 1-19, SCN 8-12

See also archiver process

ARGS parameter, NET 6-78

arguments

attributes, OCI 6-16

arguments of operators, SQL 3-1

ARGV0 parameter, NET 6-78

arithmetic operators, SQL 3-3

array interface, STU 22-2

array of structs, PC_ 8-17, PC_ A-2

array processing, SCN 16-13

ARRAYLEN statement, PC_ 7-17, PCO 6-17

arrays, ADG 16 - 28

batch fetch, PC_ 8-5

BIND_ARRAY procedure, SPR 48 - 6

binds, OCI 12-3

bulk DML using DBMS_SQL, SPR 48 - 15

bulk operations (ANSI dynamic SQL), PC_ 14-8

chapter discusses how to use, PC_ 8-1

committing after insert

Import, SUT 2-20

defines, OCI 12-6

definition of, PC_ 4-41

host arrays, PC_ 2-7

operations, PC_ 2-7

size of VARRAYs, SCN 13-11

skip parameter for, OCI 5-20

variable (VARRAYs), SCN 13-11

varying length, PC_ 18-3

arrays of structures, OCI 5-17

indicator variables, OCI 5-20

OCI calls used, OCI 5-20

skip parameters, OCI 5-18

AS 'filespec' clause

of CREATE LIBRARY, SQL 7-298

AS clause

of CREATE JAVA, SQL 7-295

AS EXTERNAL clause

of CREATE FUNCTION, SQL 7-271, SQL 7-336

of CREATE TYPE BODY, SQL 7-424

AS OBJECT clause

of CREATE TYPE, SQL 7-414

AS SELECT option

CREATE TABLE command, SBR 14-4

AS subquery

of CREATE MATERIALIZED VIEW / SNAPSHOT, SQL 7-300, SQL 7-307

of CREATE TABLE, SQL 7-384

of CREATE VIEW, SQL 7-433

AS TABLE clause

of CREATE TYPE, SQL 7-418

AS VARRAY clause

of CREATE TYPE, SQL 7-417

ASACC precompiler option, PCO 14-12

ASC clause

of CREATE INDEX, SQL 7-281

ascending indexes, SQL 7-281

ASCII

character set, SQL 2-29

fixed-format files

exporting, SUT 1-4

function, SQL 4-6

ASCII character set

Import, SUT 2-56

sorting order, NLS 2-25

ASIN function, SQL 4-7

A.SMD record, NET 6-68, NET 8-17, NET A-45

assigning

update conflict resolution methods, REP 6-17

assigning new pincode to SecurID card, OAS 6-15

assignment

aggregate, PLS 2-33

character string, PLS B-2

collection, PLS 4-11

cursor variable, PLS 5-31

field, PLS 4-42

record, PLS 4-42

semantics, PLS B-2

assignment operator, PLS 1-4

assignment statement

syntax, PLS 11-3

ASSOCIATE STATISTICS statement, SQL 7-194

association operator, PLS 7-13

associations

downgrading, MIG 12-35

associative interface, PC_ 17-4

when to use, PC_ 17-4

ASSUME_SQLCODE precompiler option, PCO 14-13

AST, SPS 8-2

asterisk (*) option, PLS 5-3

asymmetrical multiprocessing, SPS 2-5

Asynchronous, ADQ 1-10

asynchronous

DDL, SPR 34 - 57, RAR 8-138

replication, REP 2-3

RPCs, REP 9-2

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

asynchronous data operations, NET 2-4

asynchronous I/O, STU 26-29

parallel recovery and, SCN 32-11

asynchronous operation, PLS 8-16

asynchronous processing, SCN 19-2

asynchronous trap, SPS 8-2, SPS 8-3, SPS 8-4

AT clause

CONNECT statement, PCO 3-6

DECLARE CURSOR statement, PCO 3-7

DECLARE STATEMENT statement, PCO 3-8

EXECUTE IMMEDIATE statement, PCO 3-8

in CONNECT statement, PC_ 3-9

in DECLARE CURSOR statement, PC_ 3-10

in DECLARE STATEMENT statement, PC_ 3-12

in EXECUTE IMMEDIATE statement, PC_ 3-11

of COMMIT statement, PC_ F-25, PCO F-16

of CONNECT statement, PCO F-18

of DECLARE CURSOR directive, PC_ F-36, PCO F-24

of DECLARE STATEMENT directive, PC_ F-39, PCO F-28

of EXECUTE IMMEDIATE statement, PC_ F-57, PCO F-44

of EXECUTE statement, PC_ F-52, PCO F-39

of INSERT statement, PC_ F-70

of INSERT statements, PCO F-55

of SAVEPOINT statement, PC_ F-103, PCO F-78

of SELECT statement, PC_ F-106, PCO F-81

of UPDATE statement, PC_ F-114, PCO F-86

restriction on, PC_ 3-11

restrictions, PCO 3-7

use of, PC_ 3-10

ATAN function, SQL 4-7

ATAN2 function, SQL 4-8

atomic nullness, OCI 10-29

atomic nulls, SCN 14-3, SUT 5-94

atomically null, PLS 9-23

attack

data modification, OAS 2-5

replay, OAS 2-5

Attempts Per Names Server option, NET 6-39

ATTRIBUTE clause

of ALTER DIMENSION, SQL 7-25

of CREATE DIMENSION, SQL 7-262

attribute descriptor object, OCI 11-23

attribute indicator, PLS 1-7

attribute nulls, SUT 5-93

attributes, PLS 1-7, STU 30-4

%ROWTYPE, PLS 2-32

%TYPE, PLS 2-31

adding to a dimension, SQL 7-26

cursor, PLS 5-34

dropping from a dimension, SQL 7-26

leaf-level, SCN 14-18

leaf-level scalar, SCN 14-18

maximum number of in object type, SQL 7-368

object, PLS 9-3, PLS 9-7

of dimensions, defining, SQL 7-262

of handles, OCI 2-12

of objects, OCI 10-17

of parameter descriptors, OCI 6-5

of parameters, OCI 6-5

attributes for resources

client resource, LEG 2-20, LEG 2-21, LEG 2-22

server resource, LEG 2-25, LEG 2-26

storage device resource, LEG 3-5

volume pool resource, LEG 3-12

attributes of a collection

descriptions, PC_ 18-15

attributes of object type, DCI 1-15, DCI 11-2

referencing in method, DCI 5-5

attributes of object types, SCN 13-2, SCN 13-4

AUD, SMS 47-1

AUDIT (Schema Objects) statement, SQL 7-205

AUDIT ANY system privilege, SQL 7-502

AUDIT command, SAD 25-9, SCN 16-4

locks, SCN 27-29

schema objects, SAD 25-11

statement auditing, SAD 25-10

system privileges, SAD 25-10

AUDIT sql_statements statement, SQL 7-197

AUDIT SYSTEM system privilege, SQL 7-495

audit trail, SAD 25-14, STU 12-4

archiving, SAD 25-15

auditing changes to, SAD 25-16

controlling size of, SAD 25-14

creating and deleting, SAD 25-4

deleting data in dictionary, SCN 2-5

deleting views, SAD 25-5

described, NET 11-25

interpreting, SAD 25-17

maximum size of, SAD 25-14

protecting integrity of, SAD 25-16

purging records from, SAD 25-15

recording changes to, SAD 25-16

records in, SAD 25-7

reducing size of, SAD 25-16

script for using information, NET 11-26

table that holds, SAD 25-2

views on, SAD 25-4

AUDIT_ACTIONS table, SRF 2-68

AUDIT_FILE_DEST parameter, SRF 1-15

AUDIT_TRAIL initialization parameter

migration, MIG A-3

AUDIT_TRAIL parameter, SRF 1-15

setting, SAD 25-13

auditing, REP 7-18, SAD 25-2, SCN 1-44, SCN 31-1

AUDIT command, SAD 25-9

audit option levels, SAD 25-8

audit options, SCN 31-3

audit records, SCN 31-3

audit trail records, SAD 25-5

audit trails, SCN 31-3

database, SCN 31-3

operating system, SCN 31-5, SCN 31-6

by access, SCN 31-11

mandated for, SCN 31-12

by session, SCN 31-10

prohibited with, SCN 31-12

conflict resolution, REP 7-18

connect with administrator privileges, SCN 31-5

data dictionary used for, SCN 2-5

database and OS usernames, SCN 29-4

DDL statements, SCN 31-7

default options, SAD 25-11

described, SCN 1-44, SCN 31-2

disabling default options, SAD 25-13

disabling options, SAD 25-11, SAD 25-12, SAD 25-13

disabling options versus auditing, SAD 25-12

distributed databases and, SCN 31-6

DML statements, SCN 31-7

enabling options, SAD 25-9, SAD 25-13

enabling options versus auditing, SAD 25-10

guidelines, SAD 25-2

historical information, SAD 25-4

keeping information manageable, SAD 25-2

managing the audit trail, SAD 25-4

operating-system audit trails, SAD 25-7

partitioned tables and indexes, SCN 11-63

policies for, SAD 22-18

privilege audit options, SAD 25-9

privilege use, SCN 31-2, SCN 31-7

privileges required for object, SAD 25-11

privileges required for system, SAD 25-10

range of focus, SCN 31-3, SCN 31-9

schema object, SCN 31-2, SCN 31-8

schema objects, SAD 25-11

stopping, SQL 7-525

security and, SCN 31-6

session level, SAD 25-8

shortcuts for object, SAD 25-9

shortcuts for system, SAD 25-8

SQL statements, SQL 7-200

SQL statements, stopping, SQL 7-523

startup and shutdown, SCN 31-5

statement, SAD 25-10, SCN 31-2, SCN 31-7

statement level, SAD 25-8

successful executions, SCN 31-9

suspicious activity, SAD 25-3

system privileges, SAD 25-10

transaction independence, SCN 31-4

triggers and, ADG 13 - 34, SAD 25-20

types of, SCN 31-2

unsuccessful executions, SCN 31-9

user, SCN 31-12

using the database, SAD 25-2

viewing

active object options, SAD 25-19

active privilege options, SAD 25-18

active statement options, SAD 25-18

default object options, SAD 25-19

views, SAD 25-4

when options take effect, SCN 31-6

auditing options

for database objects, SQL 7-200

for SQL statements, SQL 7-202

AUTHENTICATED BY, DDS 2-8

AUTHENTICATED BY clause

of CREATE DATABASE LINK, SQL 7-257

authenticated RPC, protocol adapter includes, OAS 11-3

authenticating remote clients, SRF 1-107

authenticating users, SRF 1-92

authentication, OAS 1-5

biometric, OAS 7-1

centralized, OAS 1-5

database administrators, SCN 29-12

database managed, SAD 23-8

described, SCN 29-3

multi-tier, SCN 29-9

network, SCN 29-4

operating system, SAD 1-7, SCN 29-4

Oracle, SCN 29-7

password file, SAD 1-9, SPS 18-26

password policy, SAD 22-4

public key infrastructure, SCN 29-5

remote, SCN 29-6

specifying when creating a user, SAD 23-12

users, SAD 22-2, SAD 23-7, SAD 23-9

authentication adapters, OAS 1-10

authentication management, OCI 8-10

authentication modes in RADIUS, OAS 3-4

authentication, using Oracle Advanced Security, NET 7-28

AUTHENTICATION_LEVEL parameter, NET C-78

AUTHID clause, PLS 7-32

AUTHID CURRENT_USER clause

of ALTER JAVA, SQL 7-44

of CREATE FUNCTION, SQL 7-270

of CREATE JAVA, SQL 7-294

of CREATE PACKAGE, SQL 7-325

of CREATE PROCEDURE, SQL 7-335

of CREATE TYPE, SQL 7-415

AUTHID DEFINER clause

of ALTER JAVA, SQL 7-44

of CREATE FUNCTION, SQL 7-270

of CREATE JAVA, SQL 7-294

of CREATE PACKAGE, SQL 7-325

of CREATE PROCEDURE, SQL 7-335

of CREATE TYPE, SQL 7-415

authorization, OAS 1-9, OAS 9-11, OAS Glossary-1

changing for roles, SAD 24-8

omitting for roles, SAD 24-8

operating-system role management and, SAD 24-7

roles

about, SAD 24-6

multi-threaded server and, SAD 24-7

authorize functions, OCI 15-87

authorize template users, RAR 4-10

auto media management

enabled behavior, LEG 3-19

for tape devices, LEG 3-19

not enabled, LEG 3-19, LEG 3-23

AUTO_CONNECT, PC_ 10-11

precompiler option, PC_ 3-5

AUTO_CONNECT option

instead of CONNECT statement, PCO 3-11

AUTO_CONNECT precompiler option, PC_ 10-11, PCO 14-14

auto-discovery

DB_NAME.CONF file, PSC C-4

errors, PSC C-3

LISTENER.ORA file, PSC C-6

NMICONF.LOG file, PSC C-9

NMICONF.LST file, PSC C-10

on UNIX, PSC C-4

on Windows NT, PSC C-5

performing, PSC 5-18

PM\DB_NAME registry key, PSC C-5

SERVICES.ORA file, PSC C-9

SID_LIST_listener_name parameter, PSC C-6

TNSNAMES.ORA file, PSC C-7

troubleshooting, PSC C-10

understanding, PSC C-3

AUTOEXTEND, SPS 15-9, STU 20-28

AUTOEXTEND clause

for datafiles, SQL 7-17

of ALTER DATABASE, SQL 7-10

of ALTER TABLESPACE, SQL 7-165, SQL 7-167

of CREATE DATABASE, SQL 7-250

of CREATE TABLESPACE, SQL 7-393, SQL 7-395

of CREATE TEMPORARY TABLESPACE, SQL 7-398, SQL 7-399

Automated, ADQ 1-13

automated parallel query tuning, GTK 2-27

Automated Standby Database, SCN 32-26

automated standby databases, GTK 2-50

automatic archival, GTK 2-50

read-only databases, GTK 2-51

automatic archiving, SPS 21-3

archive log destination, SAD 7-8

automatic bootstrap backup, LEG 2-5, LEG 4-5

automatic conflict resolution

versus manual, REP 6-7

automatic connections, PC_ 3-4, PC_ 3-8

automatic instance registration, Net8, GTK 2-76

automatic logons, PCO 3-5, PCO 3-10

automatic recovery, SPS 21-7

automatic refreshes

refresh interval, REP 3-24

AUTOMATIC_IPC parameter, NET 4-20, NET 5-19, NET 7-26

autonomous PL/SQL blocks, GTK 2-78

autonomous routine, ADG 8 - 33

autonomous scope

versus autonomous transaction, ADG 8 - 33

autonomous transaction, PLS 5-52

advantages, PLS 5-52

controlling, PLS 5-56

autonomous transactions, ADG 8 - 33

compatibility, MIG 8-14

defining, ADG 8 - 41

AUTONOMOUS_TRANSACTION, ADG 8 - 33

AUTONOMOUS_TRANSACTION pragma, PLS 5-53

AUTORECOVERY option

SET command, SBR 14-12

auxiliary databases

for RMAN TSPITR

converted filenames, SBR A-15

using datafile copies, SBR A-14

auxiliary sets

for RMAN TSPTIR, SBR A-4

naming datafiles in tablespaces, SBR A-13

availability, SPS 12-1

and interconnect, SPS 3-3

benefit of parallel databases, SPS 1-14

data files, SPS 6-2, SPS 22-4

multiple databases, SPS 1-19

phases of recovery, SPS 22-5

shared disk systems, SPS 3-6

single-node failure, SPS 2-12, SPS 22-2

available option (RMAN)

change command, SBR 6-8

average

conflict resolution method

use of, REP 6-39

Average Elapsed Time data view, STU 15-10

average prebuilt conflict resolution method, RAR 6-10, REP 6-18

AVG aggregate function, PLS 5-3

AVG function, SQL 4-8

avoiding dangerous backup techniques, SBR 3-23

avoiding delete conflicts, RAR 6-24

AY date format element, SQL 2-41