Oracle8i Generic Documentation Master Index

I date format element, SQL 2-41

I variable in SQLDA

how value is set, PC_ 15-10

purpose of, PC_ 15-10

IAF GET statement

example, PCO 12-6

example of using, PC_ 20-5

in user exits, PC_ 20-4

purpose of, PC_ 20-4

specifying block and field names, PCO 12-6

specifying block and field names in, PC_ 20-5

syntax for, PC_ 20-4

using in user exit, PCO 12-5

IAF PUT statement

example, PCO 12-7

example of using, PC_ 20-6

in user exits, PC_ 20-5

purpose of, PC_ 20-5

specifying block and field names, PCO 12-7

specifying block and field names in, PC_ 20-6

syntax for, PC_ 20-5

using in user exit, PCO 12-6

IAP, PCO 12-12

IAP in SQL*Forms

purpose of, PC_ 20-13

IBM's NetView/6000, SCN 33-20

IBMsNetView/6000', DDS 1-20

ID column

PLAN_TABLE table, STU 13-4

identification

users, SAD 23-7

IDENTIFIED BY clause

of ALTER ROLE. See CREATE ROLE.

of CREATE ROLE, SQL 7-344

IDENTIFIED BY password clause

of CREATE DATABASE LINK, SQL 7-257

of CREATE USER, SQL 7-426

of SET ROLE, SQL 7-571

IDENTIFIED EXTERNALLY clause

of ALTER ROLE. See CREATE ROLE.

of ALTER USER. See CREATE USER.

of CREATE ROLE, SQL 7-344

of CREATE USER, SQL 7-426

IDENTIFIED GLOBALLY clause

of ALTER ROLE. See CREATE ROLE.

of ALTER USER, SQL 7-181

of CREATE ROLE, SQL 7-344

of CREATE USER, SQL 7-427

of CREATE USERIDENTIFIED BY clause

of ALTER USER. See CREATE USER.

identifier

forming, PLS 2-4

maximum length, PLS 2-5

quoted, PLS 2-6

scope rules, PLS 2-37

identifier, lock, SPS 7-8

identifiers, ORACLE

how to form, PC_ F-11, PCO F-10

identity, definition, OAS Glossary-3

Identix authentication method

see Oracle Advanced Security

Identix Biometric, system requirements, OAS 1-12

Identix TouchNet II Desktop Sensor, OAS 7-15

Identix TouchNet II Hardware Interface, OAS 7-4

IDEPTREE view, SRF 2-171

IDLE_TIME parameter

of ALTER PROFILE, SQL 7-64

of CREATE PROFILE, SQL 7-339

IDLM, SPS 8-1

block access synchronization, PSC 1-16

deadlock detection, PSC 1-16

defined, PSC 1-15

described, PSC 1-15

interacting with CM, PSC 1-6, PSC 1-16

LMDN process, PSC 1-15

LMON process, PSC 1-15

modification synchronization, PSC 1-16

IDLM parameters, SPS 18-12

IF statement, PLS 3-2

ELSE clause, PLS 3-3

ELSIF clause, PLS 3-4

syntax, PLS 11-86

THEN clause, PLS 3-3

IFILE, SRF 1-4

IFILE keyword

nested files, SRF 1-50

IFILE parameter, PSC 6-4, PSC 6-5, SPS 18-5, SRF 1-50

multiple files, SPS 18-7

overriding values, SPS 18-7

specifying identical parameters, SPS 18-6

iFS. See Internet File System

IGNORE

Import parameter, SUT 2-24, SUT 2-57

existing objects, SUT 2-48

IIOP, GTK 2-71, NET 4-13

configuring for SSL, NET 7-64

configuring the MTS_DISPATCHER parameter, NET 7-54

described, NET 7-50, NET 7-51

GIOP presentation layer, NET 2-14, NET 4-13

no session layer, NET 2-14

IIOP (Internet Inter-ORB Protocol), OAS Glossary-4

secured by SSL, OAS 9-7

IIOP clients

IIOP clients connections through listeners, NET 7-54

IIOP stack communications

described

ILMS, SCN 16-20

image copies, SBR 4-45

crosschecking, SBR 6-12

testing restore of, SBR 6-18

IMG, SMS 48-1

immediate (CR) block cleanout applications statistic, SRF C-11

immediate (CURRENT) block cleanout applications statistic, SRF C-11

IMMEDIATE clause

of SET CONSTRAINTS, SQL 7-568

immediate constraints, SCN 28-20

IMP, PSC 8-5, SMS 17-1

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

Import, SUT 2-31

Implementing, NET 6-71, NET 7-12

implementing database design, SAD 1-20

implicit connections, PC_ 3-14

multiple, PC_ 3-15

single, PC_ 3-14

implicit cursor, PLS 5-11

attribute, PLS 5-38

implicit data conversion, SQL 2-31, SQL 2-33

implicit datatype conversion, PLS 2-27

effect on performance, PLS 5-67

implicit declaration

cursor FOR loop record, PLS 5-13

FOR loop counter, PLS 3-13

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

implicit logons, PCO 3-15

multiple, PCO 3-16

single, PCO 3-15

implicit VARCHAR, PCO 4-30

Import, SUT 2-1

ANALYZE parameter, SUT 2-19

backup files, SUT 2-51

BUFFER parameter, SUT 2-19

CATEXP.SQL

preparing the database, SUT 2-7

character set conversion, SUT 1-53, SUT 2-56

character sets, SUT 2-55

COMMIT parameter, SUT 2-20

committing after array insert, SUT 2-20

compatibility, SUT 2-5

complete export file, SUT 2-43

consolidated extents, SUT 2-53

controlling size of rollback segments, SUT 2-20

conversion of Version 6 CHAR columns to VARCHAR2, SUT 2-65

creating an index-creation SQL script, SUT 2-26

cumulative, SUT 2-43

data files

reusing, SUT 2-21

database

reusing existing data files, SUT 2-21

DESTROY parameter, SUT 2-21

disabling referential constraints, SUT 2-14

displaying online help, SUT 2-24

dropping a tablespace, SUT 2-54

error handling, SUT 2-47

errors importing database objects, SUT 2-48

example session, SUT 2-34

export COMPRESS parameter, SUT 2-53

export file

importing the entire file, SUT 2-23

listing contents before import, SUT 2-28

failed integrity constraints, SUT 2-48

fatal errors, SUT 2-48, SUT 2-49

FEEDBACK parameter, SUT 2-22

FILE parameter, SUT 2-22

FROMUSER parameter, SUT 2-23

grants

specifying for import, SUT 2-23

GRANTS parameter, SUT 2-23

HELP parameter, SUT 2-9, SUT 2-24

IGNORE parameter, SUT 2-24, SUT 2-48

importing grants, SUT 2-13, SUT 2-23

importing objects into other schemas, SUT 2-13

importing rows, SUT 2-27

importing tables, SUT 2-28

incremental, SUT 2-43

specifying, SUT 2-25

INCTYPE parameter, SUT 2-25

INDEXES parameter, SUT 2-25

INDEXFILE parameter, SUT 2-26

INSERT errors, SUT 2-48

interactive method, SUT 2-41

invalid data, SUT 2-48

invoking, SUT 2-7

length of Oracle Version 6 export file DEFAULT columns, SUT 2-65

log files

LOG parameter, SUT 2-26

LONG columns, SUT 2-61

manually ordering tables, SUT 2-15

modes, SUT 2-5

NLS considerations, SUT 2-55

NLS_LANG environment variable, SUT 2-56

object creation errors, SUT 2-24

objects imported, SUT 1-5

OPTIMAL storage parameter, SUT 2-53

Oracle objects, ADG 18 - 41

Oracle Version 6 integrity constraints, SUT 2-65

parameter file, SUT 2-10, SUT 2-27

parameters, SUT 2-16

preparing the database, SUT 2-7

read-only tablespaces, SUT 2-54

recompiling stored procedures, SUT 2-61

RECORDLENGTH parameter, SUT 2-27

records

specifying length, SUT 2-27

reducing database fragmentation, SUT 2-46

refresh error, SUT 2-51

reorganizing tablespace during, SUT 2-54

resource errors, SUT 2-49

rows

specifying for import, SUT 2-27

ROWS parameter, SUT 2-27

schema objects, SUT 2-11, SUT 2-13

sequences, SUT 2-49

SHOW parameter, SUT 1-4, SUT 2-28

single-byte character sets, SUT 2-56

snapshot log, SUT 2-50

snapshot master table, SUT 2-51

snapshots, SUT 2-50

restoring dropped, SUT 2-51

specifying by user, SUT 2-23

specifying index creation commands, SUT 2-26

specifying the export file, SUT 2-22

storage parameters

overriding, SUT 2-53

stored functions, SUT 2-61

stored packages, SUT 2-61

stored procedures, SUT 2-61

system objects, SUT 2-13

table objects

import order, SUT 2-4

tables created before import, SUT 2-14

TABLES parameter, SUT 2-28

TOUSER parameter, SUT 2-31

transferring files across networks, SUT 2-50

unique indexes, SUT 2-25

uniqueness constraints

preventing import errors, SUT 2-20

user definitions, SUT 2-14

USERID parameter, SUT 2-32

using Oracle Version 6 files, SUT 2-65

import data, PSC 8-5

Import utility, PSC 8-5, SBR 13-16, SCN 1-6

about, SAD 1-17

Compatibility, SPS B-1

copying statistics, SCN 22-8

data definition conversion, MIG 2-13

database recovery, SBR 13-18

free lists, SPS A-20

migration, MIG 2-10, MIG 5-1

offline instantiation of master site, REP 8-17

partition maintenance operations, SCN 11-48

procedure for using, SBR 13-18

requirements for migration, MIG 5-2

restoring data, SPS B-1

restricted mode and, SAD 3-4

use in recovery, SCN 32-25

user-defined types, SCN 14-20

import_check, REP 7-17

importing

jobs, SAD 8-7

object groups

offline instantiation and, SPR 21 - 3, SPR 21 - 5, RAR 8-46, RAR 8-50

snapshots

offline instantiation and, SPR 22 - 2, SPR 22 - 3, RAR 8-55, RAR 8-57

status check, SPR 34 - 70, RAR 8-154

improving network performance

by adjusting SDU size, NET 3-13

by client load balancing, NET 3-12

by connection pooling, NET 2-50, NET 3-11

by randomizing client requests, NET 2-30, NET C-41

by using connection concentration, NET 3-11

with listener queuesize, NET 3-14

in avoiding dynamic extension, STU 20-28

in basic replication, REP 1-11, SCN 34-12

IN bind variables, DDS 7-5

IN comparison operator, PLS 2-46, PLS 5-5

IN operator, SCN 23-5

merging views, SCN 23-18

IN OUT bind variables, DDS 7-6

IN OUT parameter

of CREATE FUNCTION, SQL 7-269

of CREATE PROCEDURE, SQL 7-334

IN OUT parameter mode, ADG 10 - 6, PC_ 7-3, PCO 6-5, PLS 7-16

IN parameter

of CREATE function, SQL 7-269

of CREATE PROCEDURE, SQL 7-334

IN parameter mode, ADG 10 - 6, PC_ 7-3, PCO 6-5, PLS 7-14

in progress save set, LEG 2-8

IN subquery, SCN 23-17

inactive destination state

for archived redo logs, SAD 7-14

inactive online redo log

loss of, SBR 15-7

inactive session wait event, SRF A-33

inactive transaction branch wait event, SRF A-34

INAME option

when a file extension is required, PCO 14-2

INAME precompiler option, PCO 14-25, PC_ 10-25

incarnation of database option (RMAN)

list command, SBR 6-7

incarnation option (RMAN)

reset database command, SBR 6-7

INCLUDE

precompiler option, use of, PC_ 5-34

using to include the SQLCA, PC_ 9-16

INCLUDE precompiler option, PC_ E-3, PCO 14-25

INCLUDE statement

case-sensitive operating systems, PCO 2-23

declaring the ORACA, PCO 8-37

declaring the SQLCA, PCO 8-21

declaring the SQLDA, PCO 11-7

effect of, PCO 2-22

INCLUDE statements, PCO B-2

INCLUDING clause

of ALTER TABLE, SQL 7-144

INCLUDING CONTENTS clause

of DROP TABLESPACE, SQL 7-477

INCLUDING NEW VALUES clause

of ALTER MATERIALIZED VIEW LOG, SQL 7-57

of CREATE MATERIALIZED VIEW LOG / SNAPSHOT LOG, SQL 7-316

INCLUDING TABLES clause

of DROP CLUSTER, SQL 7-447

incompatibilities

removing, MIG 12-2

system-defined, MIG 12-4

incompatibilities, system-defined, MIG 8-6

incomplete media recovery

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

definition, SBR 1-20, SBR 3-28

in OPS configuration, SBR 14-13

procedures for, SBR 14-26 to SBR 14-35

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

using backup control file, SBR 14-13

incomplete object type, PLS 9-29

incomplete object types, ADG 16 - 16, SCN 14-17

creating, SQL 7-413

incomplete recovery

change-based (RMAN), SBR 9-25

log sequence-based (RMAN), SBR 9-26

time-based (RMAN), SBR 9-24

using RMAN, SBR 9-23

with a recovery catalog, SBR 9-24

without a recovery catalog, SBR 9-27

incomplete types, SQL 7-413

creating, SQL 7-411

inconsistent backups

definition, SBR 1-16

inconsistent whole database backups

definition, SBR 3-4

INCREMENT BY clause

of ALTER SEQUENCE. See CREATE SEQUENCE.

of CREATE SEQUENCE, SQL 7-351

incremental backups, SBR 8-21

differential, SBR 4-40

using RMAN, SBR 8-9

incremental checkpoint, SCN 8-8

incremental export, SBR 13-17, SUT 1-44

backing up data, SUT 1-49

command syntax, SUT 1-20

data selected, SUT 1-48

recording, SUT 1-23

restrictions, SUT 1-44

session example, SUT 1-49

specifying, SUT 1-20

SYS.INCFIL table, SUT 1-51

SYS.INCVID table, SUT 1-52

incremental growth, SPS 17-13

incremental import

parameter, SUT 2-25

specifying, SUT 2-25

incremental migration, REP B-4

incremental refresh, SCN 10-18

INCTYPE

Export parameter, SUT 1-20

Import parameter, SUT 2-25

IND synonym for USER_INDEXES, SRF 2-172

index

client, LEG 2-5

contention, SPS 19-6

creating, SPS 17-8

data partitioning, SPS 11-12, SPS 15-5

domain

creating, DCI 11-15

FREELISTS option, SPS 17-8

key compression, MIG 8-10

media, LEG 2-5

metadata for, DCI 11-37

PCM locks, SPS 15-5

save set status value in client index, LEG 2-9

using to improve performance, PCO D-6

index block split wait event, SRF A-34

INDEX clause

of CREATE CLUSTER, SQL 7-239

INDEX hint, SQL 2-59, STU 6-7, STU 6-16, STU 7-44

index join, STU 27-7

index joins, SCN 23-36, SCN 23-49

INDEX object privilege, SQL 7-508

index on physical ROWID, MIG 11-8

index options

SORTED INDEXES with SQL*Loader, SUT 5-43

SQL*Loader SINGLEROW keyword, SUT 5-43

index partition

dropping, SAD 13-14

moving, SAD 13-11

rebuilding, SAD 13-20

splitting, SAD 13-18

index partitions

changing physical attributes of, SQL 7-35

deallocating unused space from, SQL 7-34

dropping, SQL 7-40

marking UNUSABLE, SQL 7-146

modifying the real characteristics of, SQL 7-39

rebuilding, SQL 7-36

unusable, SQL 7-146

renaming, SQL 7-40

specifying tablespace for, SQL 7-37

splitting, SQL 7-40

index rebuilding

physical ROWIDs, MIG 11-8

index segments, SCN 1-11, SCN 4-17

index subpartitions

allocating extents for, SQL 7-40

changing physical attributes of, SQL 7-35

deallocating unused space from, SQL 7-34, SQL 7-40

marking UNUSABLE, SQL 7-40

rebuilding, SQL 7-36

renaming, SQL 7-40

specifying tablespace for, SQL 7-37

Index Unusable state

indexes left in Index Unusable state, SUT 8-11

index, cursor FOR loop, PLS 5-13

INDEX_ASC hint, SQL 2-59, STU 7-46

INDEX_COMBINE hint, SQL 2-59, STU 6-7, STU 6-16

INDEX_DESC hint, SQL 2-59, STU 7-46, STU 7-47

INDEX_FFS hint, SCN 23-36, SQL 2-59, STU 6-9, STU 7-48, STU 11-3

INDEX_HISTOGRAM view, SRF 2-172

INDEX_JOIN hint, SCN 23-36

INDEX_STATS view, SRF 2-172

index-by table

versus nested table, PLS 4-3

indexed clusters

creating, SQL 7-239

INDEXES

Export parameter, SUT 1-21

Import parameter, SUT 2-25

indexes, SCN 1-26, SCN 10-21

adding partition, SAD 13-12

allocating new extents for, SQL 7-34

altering, SAD 16-13

analyzing statistics, SAD 20-3

application-specific, SQL 7-290

ascending, SQL 7-281

auditing partitions, SCN 11-63

avoiding the use of, STU 6-7

B*-tree structure of, SCN 10-27

based on indextypes, SQL 7-285

bitmap, MIG 6-3, STU 6-13, STU 6-16, STU 6-18, STU 11-7

bitmap indexes, SCN 10-32, SCN 10-36

nulls and, SCN 10-8

parallel query and DML, SCN 10-33

bitmapped, SQL 7-279

branch blocks, SCN 10-28

building

using an existing index, SCN 10-22

building online, GTK 2-41

cardinality, SCN 10-33

changing attributes of, SQL 7-35

choosing columns for, STU 6-4

cluster, SCN 10-50, SQL 7-279

altering, SAD 17-9

cannot be partitioned, SCN 11-2

contrasted with table, SCN 10-50

creating, SAD 17-6

dropping, SAD 17-10, SCN 10-50

managing, SAD 17-1

scans of, SCN 23-41

collecting statistics on, SQL 7-38, SQL 7-186

compatibility, MIG 8-10

composite, SCN 10-22, STU 6-5

scans of, SCN 23-42

on composite-partitioned tables, SQL 7-285

concatenated, SCN 10-22

correct tables and columns, SAD 16-8

creating, ADG 6 - 5, SQL 7-277

after inserting table data, SAD 16-3

explicitly, SAD 16-8

unrecoverably, SAD 16-5

creating in parallel, STU 27-20

creating manually, SUT 2-26

deallocating unused space from, SQL 7-34

defragment using COALESCE, GTK 2-42

descending, GTK 2-25, SQL 7-281

and query rewrite, SQL 7-281

as function-based indexes, SQL 7-281

described, SCN 1-26, SCN 10-21

design, STU 2-9

direct path load

left in direct load state, SUT 8-11

disabling and dropping constraints and, SAD 16-7

disassociating statistics types from, SQL 7-454

domain, SCN 10-42, SQL 7-277, SQL 7-285, SQL 7-290

dropping, MIG 12-13

domain indexes

extensible optimization, SCN 22-16

user-defined statistics, SCN 22-17

domain, using, STU 6-23

dropped tables and, ADG 3 - 10, SAD 14-12

dropping, ADG 6 - 6, SAD 16-15

SQL*Loader, SUT 8-20

dropping before continuing a direct path load, SUT 5-34

dropping index partitions of, SQL 7-454

enforcing integrity constraints, SCN 28-10, SCN 28-12

enforcing uniqueness, STU 6-10

ensuring the use of, STU 6-6

estimating size, SAD 16-5

example, STU 4-8

examples, SQL 7-286

exporting, SUT 1-21

extensible, SCN 10-42

extensible indexing, GTK 2-31

extent allocation for, SAD 16-6

fast full scan, STU 6-8, STU 11-3

fast full scans of, SCN 23-36

FREELISTS option, SRF 1-28

function-based, ADG 6 - 6, GTK 2-24, SCN 10-24, SQL 7-277, STU 6-12

creating, SQL 7-280

dependencies, SCN 10-26, SCN 21-7, SCN 21-9

DETERMINISTIC functions, SCN 21-8

DISABLED, SCN 21-8

dropping, MIG 12-13

optimization with, SCN 10-25

privileges, SCN 10-26, SCN 21-8

global, STU 26-74

global partitioned indexes, SCN 11-32

managing partitions, SCN 11-33, SCN 11-60

globally partitioned, SQL 7-283, SQL 7-284

granting

system privileges on, SQL 7-496

guidelines, ADG 6 - 3

guidelines for managing, SAD 16-2

on hash-partitioned tables, SQL 7-284

importing, SUT 2-25

index joins, SCN 23-36, SCN 23-49

index unusable (IU), SCN 11-61

index-creation commands

Import, SUT 2-26

index-organized tables, SCN 10-36

logical rowids, SCN 10-39, SCN 12-20

secondary indexes, SCN 10-39

INITRANS for, SAD 16-4

internal structure of, SCN 10-27

key compression, SCN 10-29

key compression of, SQL 7-37, SQL 7-282

keys and, SCN 10-23

primary key constraints, SCN 28-12

unique key constraints, SCN 28-10

leaf blocks, SCN 10-28

left direct load state

SQL*Loader, SUT 8-17

limiting per table, SAD 16-3

local, STU 26-74

local indexes, SCN 11-29, SCN 11-59

building partitions in parallel, SCN 11-30

locally partitioned, SQL 7-284

location of, SCN 10-26

logging attributes of, SQL 7-282

logging rebuild operations on, SQL 7-38

LONG RAW datatypes prohibit, SCN 12-15

managing, SAD 16-1, SAD 16-15

managing partitions, SCN 11-59

marking as UNUSABLE, SQL 7-39

MAXTRANS for, SAD 16-4

merging contents of index blocks, SQL 7-39

modifying values of, STU 6-5

monitoring space use of, SAD 16-14

multiple column

SQL*Loader, SUT 8-17

no-logging mode, SCN 25-7

non-unique, STU 6-10

nonunique, SCN 10-22

nulls and, SCN 10-8, SCN 10-24, SCN 10-35

on attribute of object column, SCN 14-6

on complex data types, SCN 10-42

on REFs, SCN 14-6

online, SQL 7-283

optimization and, SCN 23-10

order of columns, ADG 6 - 4

overview of, SAD 16-2, SCN 1-26, SCN 10-21

parallel, STU 11-3

parallel creation, STU 27-20, STU 27-21

parallel DDL storage, SCN 26-33

parallel index scans, SCN 26-5

parallel local, STU 27-20

parallel queries and DML on, SQL 7-35

parallelizing creation of, SQL 7-286

parallelizing index creation, SAD 16-5

partition pruning, SCN 11-4

partitioned, NLS 4-8, SQL 2-64, SQL 7-277

user-defined, SQL 7-283

partitioned tables, SCN 10-36

partitioned tables and, REP A-4

partitioning, STU 26-46

partitioning guidelines, SCN 11-36

partitions, SCN 11-2, SCN 11-29

adding new, SQL 7-40

PCTFREE for, SAD 16-4

PCTUSED for, SAD 16-4

performance and, SCN 10-22

physical attributes of, SQL 7-281

placement on disk, STU 20-22

presorting data, SUT 4-25

SQL*Loader, SUT 8-16

privileges, ADG 6 - 5

for altering, SAD 16-13

for dropping, SAD 16-15

privileges for partitions, SCN 11-62

range scans, SCN 23-35

on range-partitioned tables, SQL 7-284

rebuild partition, SCN 11-60

rebuilding, SQL 7-36, STU 6-9

rebuilding while online, SQL 7-38

rebuilt after direct-load INSERT, SCN 25-8

recreating, STU 6-9

removing from the database, SQL 7-454

renaming, SQL 7-39

reverse, SQL 7-37, SQL 7-282

reverse key indexes, SCN 10-31

rowids and, SCN 10-28

scans of, SCN 23-35

bounded range, SCN 23-44

cluster key, SCN 23-41

composite, SCN 23-42

MAX or MIN, SCN 23-46

ORDER BY, SCN 23-47

restrictions, SCN 23-48

single-column, SCN 23-42

unbounded range, SCN 23-45

secondary for index-organized tables, GTK 2-29

selectivity of, STU 6-4

separating from a table, SAD 14-6

setting storage parameters for, SAD 16-5

skipping unusable, SUT 2-28

specifying PCTFREE for, ADG 3 - 6

specifying tablespace for, SQL 7-37

SQL*Loader, SUT 5-43

SQL*Loader and, ADG 6 - 2, SAD 16-3

state after discontinued load, SUT 5-34

statement conversion and, SCN 23-10

statistics on, SQL 7-283

statistics, gathering, STU 7-9

storage characteristics of, SQL 7-281, SQL 7-575

STORAGE clause, STU 27-21

storage format of, SCN 10-26

storage parameters, SAD 12-10

tablespace containing, SQL 7-282

tablespace for, SAD 16-4

temporary segments and, ADG 6 - 2, SAD 16-3

unique, SCN 10-22, SQL 7-278, SUT 2-25

unique scans, SCN 23-35

unsorted, SQL 7-282

user-defined types, SCN 14-6

using to improve performance, PC_ C-6

validating structure, SAD 20-8

validating structure of, SQL 7-191

when to create, ADG 6 - 2, STU 6-2

when used with views, SCN 10-14

see also bitmap indexes

INDEXES clause

of ASSOCIATE STATISTICS, SQL 7-194, SQL 7-196

indexes partitions

marking UNUSABLE, SQL 7-40

INDEXFILE

Import parameter, SUT 2-26

indexing

extensible

queries benefitting, DCI 11-14

queries not benefitting, DCI 11-14

index-organized table, PCO 4-37, SAD 14-14

not used in power demand example, DCI 11-48

index-organized table clause

of CREATE TABLE, SQL 7-361, SQL 7-372

index-organized tables, GTK 3-14, SCN 10-36

applications, SCN 10-40

benefits, SCN 10-38

compatibility, MIG 8-10

creating, SQL 7-365, SQL 7-372

full table functionality, GTK 2-29

key compression, GTK 2-29

key compression in, SCN 10-30, SCN 10-38

LOB column support, GTK 2-29

logical ROWIDs, GTK 2-29

logical rowids, SCN 10-39, SCN 12-20

modifying, SQL 7-143

nested table data, GTK 2-34

parallel CREATE, SCN 26-31

parallel loading of, GTK 2-29

parallel queries, SCN 26-29

partition of, SCN 11-42

partitioned secondary indexes on, SCN 11-45

partitioning, GTK 2-47

queue tables, SCN 19-12

rebuild of, SCN 10-39

rebuilding, SQL 7-134

rebuilding with ALTER TABLE MOVE, GTK 2-29

removing LOBs from, MIG 12-7

removing partitions from, MIG 12-14

reserving space in the index block, SQL 7-144

row overflow area, SCN 10-38

rowids of, SQL 2-23

secondary indexes, GTK 2-29

secondary indexes on, SCN 10-39

storing nested tables as, ADG 18 - 17

indextype, SCN 10-43

INDEXTYPE clause

of CREATE INDEX, SQL 7-285

indextype implementation methods, DCI 11-22

indextypes

associating statistics with, SQL 7-196

creating, SQL 7-290

disassociating from statistics types, SQL 7-456

drop routines, invoking, SQL 7-454

dropping, MIG 12-13

granting

system privileges on, SQL 7-496

indexes based on, SQL 7-285

instances of, SQL 7-277

removing from the database, SQL 7-456

INDEXTYPES clause

of ASSOCIATE STATISTICS, SQL 7-194, SQL 7-196

indicator arrays, PC_ 8-4

example of using, PC_ 8-4

uses for, PC_ 8-4

INDICATOR keyword, PC_ 4-16

INDICATOR property, ADG 11 - 23

indicator table, PCO 7-2

indicator tables

example, PCO 7-4

purpose, PCO 7-4

indicator variable, OCI 2-31

arrays of structures, OCI 5-20

for named datatypes, OCI 2-31, OCI 2-33

for REF, OCI 2-31

for REFs, OCI 2-33

named datatype defines, OCI 12-5

PL/SQL OUT binds, OCI 12-5

REF defines, OCI 12-5

using to handle NULLs, PCO 5-4, PCO 5-5

with named datatype bind, OCI 12-3

with REF bind, OCI 12-3

indicator variables, PCO 5-3

assigning values to, PC_ 6-3, PCO 4-26

association with host variables, PC_ 6-3, PCO 4-26

declarations, PC_ 18-4

declaring, PC_ 4-16, PC_ 18-4, PCO 2-11, PCO 4-26

definition of, PC_ 2-6

function, PCO 4-26

function of, PC_ 6-3, PCO 4-26

guidelines, PC_ 4-18

interpreting value, PCO 5-3

interpreting values of, PC_ 6-3, PCO 4-26

naming of, PC_ 4-43

NULLs, PCO 6-2

referencing, PC_ 4-16, PCO 4-27

required size, PCO 4-26

requirements for, PC_ 6-4

truncated values, PCO 6-2

used with multi-byte character strings, PCO 4-43

used with multibyte character strings, PC_ 4-52

using in PL/SQL, PC_ 7-12, PCO 6-12

using to detect NULLs, PC_ 6-4, PCO 4-26

using to detect truncated values, PC_ 6-4, PCO 4-26, PCO 5-4

using to handle NULLs, PCO 5-4

using to insert NULLs, PC_ 6-4

using to return NULLs, PC_ 6-5

using to test for NULLs, PC_ 6-5, PCO 5-6

with PL/SQL, PCO 6-2

with structures, PC_ 4-42

in-doubt transaction, PC_ 3-26, PCO 3-30

in-doubt transactions, DDS 3-4, SCN 4-24, SCN 5-8

after a system failure, DDS 3-19

forcing, SQL 7-215

forcing a commit, DDS 3-31

forcing a rollback, DDS 3-31

forcing commit of, SQL 7-215

forcing rollback, SQL 7-538

forcing rollback of, SQL 7-538

intentionally creating, DDS 3-33

overriding manually, DDS 3-21

pending transactions table, DDS 3-29

recoverer process, DDS 3-34

rollback segments, DDS 3-21

rollback segments and, SAD 21-11

rolling back, DDS 3-31, SQL 7-537

INDX1 tablespace raw device, PSC 2-6

inequality test, SQL 3-5

INFILE keyword

SQL*Loader, SUT 5-22

infinite loop, PLS 3-6

information

distribution

in basic replication, REP 1-10, SCN 34-11

off-loading

in basic replication, REP 1-10, SCN 34-11

transport, REP 1-11, SCN 34-12

information distribution

basic replication for, REP 1-10, SCN 34-11

information hiding, PLS 1-15, PLS 8-4

information retrieval (IR) applications

index-organized tables, SCN 10-40

inheritance, ADG 18 - 33

dual subtype/super-type reference, ADG 18 - 38

subtype contains super-type, ADG 18 - 35

super-type contains all subtypes, ADG 18 - 37

INITCAP function, SQL 4-18

INITDB_NAME.ORA file, PSC 1-11, PSC 6-2

BACKGROUND_DUMP_DEST parameter, PSC C-11, PSC C-12

CHECKPOINT_PROCESS parameter, PSC 6-10

CONTROL_FILES parameter, PSC 6-11

CPU_COUNT parameter, PSC 6-11

DB_BLOCK_SIZE parameter, PSC 6-11

DB_DOMAIN parameter, PSC 6-7, PSC 6-11

DB_FILES parameter, PSC 6-11

DB_NAME parameter, PSC 1-11, PSC 6-3, PSC 6-7, PSC 6-11

DELAYED_LOGGING_BLOCK_
CLEANOUTS parameter, PSC 6-10

DML_LOCKS parameter, PSC 6-10, PSC 6-11

GC_FILES_TO_LOCKS parameter, PSC 1-17, PSC 6-9, PSC 6-11

GC_RELEASABLE_LOCKS parameter, PSC 1-18, PSC 6-9

GC_ROLLBACK_LOCKS parameter, PSC 6-9, PSC 6-11

Global Constant (GC) parameters, PSC 6-8

identical parameters, PSC 6-11

INSTANCE_NUMBER parameter, PSC 6-10

LM_LOCKS parameter, PSC 6-11, PSC 6-12

LM_PROCS parameter, PSC 6-11, PSC 6-12

LM_RESS parameter, PSC 6-11, PSC 6-12

LOCAL_LISTENER parameter, NET 6-67, PSC 3-6, PSC 4-17, PSC 4-37

LOG_ARCHIVE_FORMAT parameter, PSC 6-10

MAX_COMMIT_PROPAGATION_DELAY parameter, PSC 6-10, PSC 6-11

NLS_* parameters, PSC 6-10

PARALLEL_DEFAULT_MAX_INSTANCES parameter, PSC 6-11

PARALLEL_DEFAULT_MAX_SCANS parameter, PSC 6-11

PARALLEL_SERVER parameter, PSC 6-10

parameter notes, PSC 6-10

PROCESSES parameter, PSC 6-10

RECOVERY_PARALLELISM parameter, PSC 6-10

ROLLBACK_SEGMENTS parameter, PSC 6-10, PSC 6-11

ROW_LOCKING parameter, PSC 6-11

SERVICE_NAMES parameter, PSC 6-7

THREAD parameter, PSC 6-10

USER_DUMP_DEST parameter, PSC C-12

INITDW.ORA file, SRF 1-2

INITFILE OTT parameter, OCI 14-26, PC_ 19-29

INITFUNC OTT parameter, OCI 14-26, PC_ 19-29

initial

passwords for SYS and SYSTEM, SAD 1-5

INITIAL extent size, STU 26-66, STU 27-13

INITIAL parameter

of STORAGE clause, SQL 7-577

Initial Preallocated Requests option, NET 6-39

INITIAL storage parameter, SAD 12-7

altering, SAD 14-11

minimum value, SPS 17-13

rollback segments, SPS 6-8

initial ticket, OAS Glossary-3

initialization

using DEFAULT, PLS 2-30

variable, PLS 2-40

when required, PLS 2-31

initialization files, PSC 6-1 to PSC 6-39

definition, PSC 6-2

editing, PSC 6-12

for instances, PSC 6-2

identical parameters, PSC 6-11

INITDB_NAME.ORA, PSC 6-2

INITSID.ORA, PSC 6-2

location, PSC 6-12

initialization function

calling, PC_ 19-20

tasks of, PC_ 19-22

initialization parameter

archiving, SPS 21-3

control of blocks, SPS 9-13

control of PCM locks, SPS 9-13

displaying values, SPS 18-16, SPS 18-21

duplicate values, SPS 18-7

global constant, SPS 6-1, SPS 18-9

guidelines, SPS 5-9

identical for all instances, SPS 18-11

Integrated Distributed Lock Manager, SPS 18-12

MAX_DEFAULT_PROPAGATION_DELAY, SPS 18-11

obsolete, SPS A-21

PARALLEL_DEFAULT_MAXSCANS, SPS 18-11

planning LM capacity, SPS 16-3, SPS 16-6

using default value, SPS 18-7

Initialization parameters

specifying, DDS 6-13

initialization parameters

added in Oracle8i, MIG B-2

adjusting for release 8.1, MIG 3-24, MIG 4-10, MIG 7-15

affecting sequences, SAD 15-11

ALLOW_PARTIAL_SN_RESULTS, SRF 1-13

altering, SRF 1-6

ALWAYS_ANTI_JOIN, SCN 24-13, SRF 1-14

ALWAYS_SEMI_JOIN, SCN 24-13, SRF 1-14

AQ_TM_PROCESS, SCN 19-6, SCN 19-7

AQ_TM_PROCESSES, SRF 1-15

ARCH_IO_SLAVES, SRF 1-15

archive log destination

switching to new, MIG B-13

AUDIT_FILE_DEST, SRF 1-15

AUDIT_TRAIL, SRF 1-15

B_TREE_BITMAP_PLANS, SRF 1-16

BACKGROUND_CORE_DUMP, SRF 1-16

BACKGROUND_DUMP_DEST, SRF 1-16

BACKUP_DISK_IO_SLAVES, SRF 1-17

BACKUP_TAPE_IO_SLAVES, SBR 8-23, SRF 1-17

BITMAP_MERGE_AREA_SIZE, SRF 1-18

BLANK_TRIMMING, SRF 1-18

BUFFER_POOL_KEEP, SCN 7-5, SRF 1-19

BUFFER_POOL_RECYCLE, SCN 7-5, SRF 1-19

CACHE_SIZE_THRESHOLD, SRF 1-19

case significance in filenames, SRF 1-3

changes in Oracle8i, MIG B-1

CLEANUP_ROLLBACK_ENTRIES, SRF 1-19

CLOSE_CACHED_OPEN_CURSORS, SRF 1-20

COMMIT_POINT_STRENGTH, SRF 1-20

compatibility, MIG B-8

DB_DOMAIN, MIG B-9

DML_LOCKS, MIG B-8

O7_DICTIONARY_ACCESSIBILITY, MIG B-8

COMPATIBLE, MIG 8-2, SBR 16-26, SCN 3-11, SRF 1-20, STU 28-10, STU 31-4

COMPATIBLE_NO_RECOVERY, SRF 1-21

COMPLEX_VIEW_MERGING, SRF 1-21

CONTROL_FILE_RECORD_KEEP_TIME, SRF 1-21

CONTROL_FILES, SBR 9-11, SBR 15-13, SBR 16-25, SRF 1-22

for primary and standby databases, SBR 16-25

CORE_DUMP_DEST, SRF 1-23

CPU_COUNT, SRF 1-23, STU 25-16

CREATE_BITMAP_AREA_SIZE, SRF 1-24

CURSOR_SPACE_FOR_TIME, SRF 1-24

database creation, SRF 1-33

DB_BLOCK_BUFFERS, SCN 7-5, SCN 7-13, SRF 1-25

DB_BLOCK_CHECKING, SRF 1-26

DB_BLOCK_CHECKPOINT_BATCH, SRF 1-25

DB_BLOCK_CHECKSUM, SRF 1-26

DB_BLOCK_LRU_EXTENDED_STATISTICS, SRF 1-27

DB_BLOCK_LRU_LATCHES, SCN 8-8, SRF 1-27

DB_BLOCK_LRU_STATISTICS, SRF 1-27

DB_BLOCK_MAX_DIRTY_TARGET, SRF 1-27

DB_BLOCK_SIZE, SCN 7-5, SCN 7-13, SRF 1-28

DB_DOMAIN, SRF 1-29

DB_FILE_DIRECT_IO_COUNT, SRF 1-30

DB_FILE_MULTIBLOCK_READ_COUNT, SCN 23-51, SCN 24-9, SRF 1-30

DB_FILE_NAME_CONVERT, SRF 1-31

DB_FILE_SIMULTANEOUS_WRITES, SRF 1-31

DB_FILE_STANDBY_NAME_CONVERT, SBR 16-26

for primary and standby databases, SBR 16-25

DB_FILES, SBR 16-26, SCN 7-15, SRF 1-32

DB_NAME, SCN 32-22, SRF 1-32

DB_WRITER_PROCESSES, SCN 1-18, SCN 8-8, SRF 1-33

DBLINK_ENCRYPT_LOGIN, SRF 1-34

DBWR_IO_SLAVES, SRF 1-34

DELAYED_LOGGING_BLOCK_CLEANOUTS, SRF 1-35

derived parameters, SRF 1-10

descriptions, PSC 6-12

DISCRETE_TRANSACTIONS_ENABLED, SRF 1-36

DISK_ASYNCH_IO, SRF 1-36

display current settings, SRF 1-9

DISTRIBUTED_LOCK_TIMEOUT, SRF 1-36

DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME, SRF 1-36

DISTRIBUTED_TRANSACTIONS, SCN 8-12, SRF 1-37

DML_LOCKS, ADG 8 - 11, SRF 1-37

dynamic, SRF 1-6

editing, PSC 6-12

ENQUEUE_RESOURCES, SRF 1-39

EVENT, SRF 1-40

FAST_FULL_SCAN_ENABLED, SRF 1-40

FAST_START_IO_TARGET, SCN 32-13

FAST_START_PARALLEL_ROLLBACK, SRF 1-42, STU 25-16

FIXED_DATE, SRF 1-42

for primary and standby databases, SBR 16-25

FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY, SRF 1-43

GC parameters, SRF 1-10

GC_DEFER_TIME, SRF 1-44

GC_FILES_TO_LOCKS, SRF 1-44

GC_LATCHES, SRF 1-45

GC_LCK_PROCS, SRF 1-45

GC_RELEASABLE_LOCKS, SRF 1-46

GC_ROLLBACK_LOCKS, SRF 1-46

global cache, SRF 1-10

Global Constant (GC) parameters, PSC 6-8

global constant parameters, SRF 1-10

GLOBAL_NAMES, SRF 1-47

HASH_AREA_SIZE, SCN 24-8, SRF 1-47

HASH_JOIN_ENABLED, SCN 24-7, SRF 1-47

HASH_MULTIBLOCK_IO_COUNT, SCN 24-8, SRF 1-48

HI_SHARED_MEMORY_ADDRESS, SCN 7-13, SRF 1-49

HS_AUTOREGISTER, SRF 1-49

identical, PSC 6-11

IFILE, SRF 1-50

INSTANCE_GROUPS, SRF 1-50

INSTANCE_NAME, SRF 1-51

INSTANCE_NUMBER, SRF 1-51

JAVA_POOL_SIZE, SRF 1-52

JOB_QUEUE_INTERVAL, REP 7-7, SRF 1-52, STU 28-10, STU 32-6

JOB_QUEUE_PROCESSES, REP 7-7, SCN 19-10, SRF 1-53, STU 28-10, STU 32-6

LARGE_POOL_MIN_ALLOC, SRF 1-53

LARGE_POOL_SIZE, SRF 1-53

parallel execution allocation, MIG B-9

LICENSE_MAX_SESSIONS, SCN 29-20, SRF 1-54

LICENSE_MAX_USERS, SRF 1-55

LICENSE_SESSIONS_WARNING, SCN 29-20, SRF 1-55

LM_LOCKS, SRF 1-56

LM_PROCS, SRF 1-57

LM_RESS, SRF 1-57

LOCAL_LISTENER, SRF 1-58

LOCK_NAME_SPACE, SRF 1-59

LOCK_SGA, SCN 7-13, SCN 7-17, SRF 1-59

LOCK_SGA_AREAS, SRF 1-59

LOG_ARCHIVE_BUFFER_SIZE, SAD 7-22, SAD 7-23, SRF 1-59

LOG_ARCHIVE_BUFFERS, SAD 7-22, SAD 7-23, SRF 1-59

LOG_ARCHIVE_DEST, SBR 2-19, SBR 14-8, SBR 14-10, SBR 14-28, SBR 14-31, SBR 16-7, SRF 1-60

LOG_ARCHIVE_DEST_n, SRF 1-61

LOG_ARCHIVE_DEST_n, SAD 7-11, SBR 2-19, SBR 14-8, SBR 14-10, SBR 16-6, SBR 16-10

LOG_ARCHIVE_DEST_STATE_n, SRF 1-62

LOG_ARCHIVE_DEST_STATE_n, SAD 7-13, SBR 16-11

LOG_ARCHIVE_DUPLEX_DEST, SBR 2-19, SRF 1-63

LOG_ARCHIVE_FORMAT, SBR 14-7, SBR 14-10, SRF 1-64

LOG_ARCHIVE_MAX_PROCESSES, SAD 7-20, SCN 1-19, SCN 8-12, SCN 32-19, SRF 1-64

LOG_ARCHIVE_MIN_SUCCEED_DEST, SAD 7-17, SRF 1-65

LOG_ARCHIVE_START, SAD 7-9, SAD 7-14, SCN 32-19, SRF 1-66

LOG_BLOCK_CHECKSUM, SAD 6-16, SRF 1-66

LOG_BUFFER, SCN 7-6, SCN 7-13, SRF 1-67

LOG_CHECKPOINT_INTERVAL, SCN 32-13, SRF 1-67, STU 25-4

LOG_CHECKPOINT_TIMEOUT, SCN 32-13, SRF 1-68, STU 25-3

LOG_CHECKPOINTS_TO_ALERT, SRF 1-69

LOG_FILE_NAME_CONVERT, SRF 1-69

LOG_FILES, SAD 6-10, SRF 1-70

LOG_SIMULTANEOUS_COPIES, SRF 1-70

LOG_SMALL_ENTRY_MAX_SIZE, SRF 1-70

MAX_COMMIT_PROPAGATION_DELAY, SRF 1-70

MAX_DUMP_FILE_SIZE, SRF 1-71, STU 14-4

MAX_ENABLED_ROLES, SRF 1-71

MAX_PARALLEL_SERVER parameter, SRF 3-3

MAX_ROLLBACK_SEGMENTS, SRF 1-72

MAX_TRANSACTION_BRANCHES, SRF 1-72

MTS_DISPATCHERS, SRF 1-72

MTS_LISTENER_ADDRESS, SRF 1-75

MTS_MAX_DISPATCHERS, SRF 1-75

MTS_MAX_SERVERS, SCN 8-19, SCN 8-20, SRF 1-75

MTS_MULTIPLE_LISTENERS, SRF 1-75

MTS_RATE_LOG_SIZE, SRF 1-76

MTS_RATE_SCALE, SRF 1-76

MTS_SERVERS, SCN 8-19, SRF 1-76

MTS_SERVICE, SRF 1-76

multi-threaded server and, SAD 4-4

MVIEW_REWRITE_ENABLED, SRF 1-103

NLS_CALENDAR, SRF 1-76

NLS_CALENDAR parameter, NLS 2-6, NLS 2-8, NLS 2-11, NLS 2-14, NLS 2-17, NLS 2-19, NLS 2-20, NLS 2-21, NLS 2-22, NLS 2-27, NLS 2-28

NLS_COMP, SRF 1-77

NLS_CURRENCY, SRF 1-78

NLS_DATE_FORMAT, SRF 1-78

NLS_DATE_LANGUAGE, SRF 1-79

NLS_ISO_CURRENCY, SRF 1-80

NLS_LANGUAGE, SCN 11-20, SRF 1-80

NLS_LIST_SEPARATOR parameter, NLS 2-29

NLS_MONETARY_CHARACTERS parameter, NLS 2-23

NLS_NUMERIC_CHARACTERS, SCN 12-9, SRF 1-81

NLS_SORT, SCN 11-20, SRF 1-81

NLS_TERRITORY, SRF 1-82

NLS_UNION_CURRENCY, SRF 1-79

O7_DICTIONARY_ACCESSIBILITY, SRF 1-13

OBJECT_CACHE_MAX_SIZE_PERCENT, SRF 1-83

OBJECT_CACHE_OPTIMAL_SIZE, SRF 1-83

obsolete in Oracle8i, MIG B-6

OGMS_HOME, SRF 1-83

OPEN_CURSORS, ADG 8 - 9, SCN 7-9, SCN 16-7, SRF 1-84

OPEN_LINKS, SCN 7-15, SRF 1-84

OPEN_LINKS_PER_INSTANCE, SRF 1-85

operating system dependent parameters, SRF 1-10

OPS_ADMIN_GROUP, SRF 1-85, SRF 3-3

OPTIMIZER_FEATURES_ENABLE, SCN 23-17, SCN 23-36, SCN 24-12

OPTIMIZER_FEATURES_ENABLED, SRF 1-86

OPTIMIZER_INDEX_CACHING, SRF 1-86

OPTIMIZER_INDEX_COST_ADJ, SRF 1-87

OPTIMIZER_MAX_PERMUTATIONS, SRF 1-87

OPTIMIZER_MODE, SCN 23-31, SRF 1-88, STU 7-24, STU 7-38, STU 28-10, STU 28-11, STU 31-4, STU 32-13

OPTIMIZER_PERCENT_PARALLEL, SCN 22-8, SRF 1-88, STU 28-11, STU 32-14

OPTIMIZER_SEARCH_LIMIT, SRF 1-89

ORACLE_TRACE_COLLECTION_NAME, SRF 1-89

ORACLE_TRACE_COLLECTION_PATH, SRF 1-90

ORACLE_TRACE_COLLECTION_SIZE, SRF 1-90, STU 28-11

ORACLE_TRACE_ENABLE, SRF 1-90, STU 28-11

ORACLE_TRACE_FACILITY_NAME, SRF 1-91, STU 28-11

ORACLE_TRACE_FACILITY_PATH, SRF 1-91, STU 28-11

OS_AUTHENT_PREFIX, SRF 1-92

OS_ROLES, SRF 1-92

overview, SRF 1-2

PARALLEL_ADAPTIVE_MULTI_USER, SRF 1-93

PARALLEL_AUTOMATIC_TUNING, SRF 1-94

PARALLEL_BROADCAST_ENABLED, SRF 1-94

PARALLEL_DEFAULT_MAX_INSTANCES, SRF 1-95

PARALLEL_EXECUTION_MESSAGE_SIZE, SRF 1-95

PARALLEL_INSTANCE_GROUP, SRF 1-96

PARALLEL_MAX_SERVERS, REP 2-42, SBR 14-20, SCN 26-8, SRF 1-96, STU 25-14, STU 28-11, STU 32-13

PARALLEL_MIN_MESSAGE_POOL, SRF 1-97

PARALLEL_MIN_PERCENT, SCN 26-18, SRF 1-97

PARALLEL_MIN_SERVERS, REP 2-42, SCN 26-7, SCN 26-8, SRF 1-98

PARALLEL_SERVER, SCN 5-6, SRF 1-99

PARALLEL_SERVER_IDLE_TIME, REP 2-42, SRF 1-99

PARALLEL_SERVER_INSTANCES, SRF 1-99

PARALLEL_THREADS_PER_CPU, SRF 1-99

PARALLEL_TRANSACTION_RESOURCE_TIMEOUT, SRF 1-100

PARTITION_VIEW_ENABLED, SRF 1-100

performance tuning, SRF 1-11

PLSQL_V2_COMPATIBILITY, SRF 1-101

PRE_PAGE_SGA, SRF 1-102, STU 19-5

PROCESSES, SRF 1-103

PUSH_JOIN_PREDICATE, SRF 1-103

QUERY_REWRITE_ENABLED, STU 28-10, STU 31-4

QUERY_REWRITE_INTEGRITY, STU 28-10

READ_ONLY_OPEN_DELAYED, SRF 1-105

RECOVERY_PARALLELISM, SBR 14-19, SRF 1-106, STU 25-14

REDUCE_ALARM, SRF 1-106

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

REMOTE_LOGIN_PASSWORDFILE, SRF 1-107

REMOTE_OS_AUTHENT, SRF 1-107

REMOTE_OS_ROLES, SRF 1-108

renamed in Oracle8i, MIG B-4

REPLICATION_DEPENDENCY_TRACKING, SRF 1-108

RESOURCE_LIMIT, SRF 1-108, SRF 1-109

RESOURCE_MANAGER_PLAN, SRF 1-109

REWRITE_INTEGRITY, SRF 1-104

rollback segments, SRF 1-125

ROLLBACK_SEGMENTS, SCN 4-27, SRF 1-110

ROW_CACHE_CURSORS, SRF 1-110

ROW_LOCKING, ADG 8 - 11, ADG 8 - 19, SRF 1-111

SEQUENCE_CACHE_ENTRIES, SRF 1-111

SEQUENCE_CACHE_HASH_BUCKET, SRF 1-111

SERIAL_REUSE, SRF 1-111

SERIALIZABLE, ADG 8 - 11

SERVICE_NAMES, SCN 6-6, SRF 1-112

SESSION_CACHED_CURSORS, SRF 1-113, STU 19-18

SESSION_MAX_OPEN_FILES, SRF 1-113

SESSIONS, SRF 1-114

setting, PSC 6-8

SHADOW_CORE_DUMP, SRF 1-114

SHARED_MEMORY_ADDRESS, SCN 7-13, SRF 1-115

SHARED_POOL_RESERVED_MIN_ALLOC, SRF 1-115

SHARED_POOL_RESERVED_SIZE, SRF 1-115, SRF 3-105

SHARED_POOL_SIZE, SCN 7-6, SCN 7-13, SRF 1-116

parallel execution allocation, MIG B-9

SKIP_UNUSABLE_INDEXES, SCN 21-8

SORT_AREA_RETAINED_SIZE, SCN 7-16, SRF 1-117

SORT_AREA_SIZE, SCN 4-18, SCN 7-16, SCN 24-9, SRF 1-118, STU 28-11, STU 32-13

SORT_DIRECT_WRITES, SRF 1-118

SORT_MULTIBLOCK_READ_COUNT, SRF 1-119

SORT_READ_FAC, SRF 1-119

SORT_SPACEMAP_SIZE, SRF 1-119

SORT_WRITE_BUFFER_SIZE, SRF 1-120

SORT_WRITE_BUFFERS, SRF 1-120

specifying in parameter files, SRF 1-3

SPIN_COUNT, SRF 1-120

SQL_TRACE, SCN 8-15, SRF 1-120, STU 14-5

SQL92_SECURITY, SRF 1-120

STANDBY_ARCHIVE_DEST, SBR 16-26, SRF 1-121

STAR_TRANSFORMATION_ENABLED, SCN 24-19, SRF 1-121

TEMPORARY_TABLE_LOCKS, SRF 1-122

TEXT_ENABLE, SRF 1-122

THREAD, SRF 1-122

TIMED_OS_STATISTICS, SRF 1-123

TIMED_STATISTICS, SRF 1-124, STU 14-4

TRANSACTION_AUDITING, SRF 1-124

TRANSACTIONS, SCN 4-27, SRF 1-125

TRANSACTIONS_PER_ROLLBACK_SEGMENT, SCN 4-27, SRF 1-125

USE_INDIRECT_DATA_BUFFERS, SCN 7-14, SRF 1-126

USE_ISM, SRF 1-126

USER_DUMP_DEST, SRF 1-126, STU 14-4

UTL_FILE_DIR, SRF 1-127, STU 28-10, STU 32-6

variable, SRF 1-11

initialization parameters in Oracle Trace, STU 15-21

initialize functions, OCI 15-87

INITIALLY DEFERRED clause

of constraint_clause, SQL 7-226

initially deferred constraints, SCN 28-21

INITIALLY IMMEDIATE clause

of constraint_clause, SQL 7-226

initially immediate constraints, SCN 28-21

INIT.ORA, RAR 1-3, RAR 1-4, REP 2-21

parameter files, SRF 1-2

INIT.ORA file, SRF 1-2

INIT.ORA files, SBR 4-49, SBR 9-15, SCN 5-4, SCN 5-5

INIT.ORA parameters. See initialization parameters

INITRANS parameter, ADG 8 - 26

of ALTER CLUSTER, SQL 7-4

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

of ALTER MATERIALIZED VIEW, SQL 7-46

of ALTER MATERIALIZED VIEW LOG, SQL 7-54

of CREATE CLUSTER, SQL 7-238

of CREATE INDEX. See CREATE TABLE.

of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG. See CREATE TABLE.

of CREATE MATERIALIZED VIEW/SNAPSHOT. See CREATE TABLE.

of CREATE TABLE, SQL 7-370

INITRANS storage parameter

altering, SAD 14-11

default, SAD 12-9

guidelines for setting, SAD 12-9

transaction entries and, SAD 12-9

INITSID.ORA file, PSC 1-11, PSC 6-2, PSC 6-4

inline views, SCN 10-16

example, SCN 10-16

inlists, STU 7-46, STU 7-50

inner capture, SCN 14-8

input host variable

restrictions, PCO 5-2

where allowed, PCO 5-2

input host variables

assigning values to, PC_ 6-3

definition of, PC_ 6-2

restrictions on, PC_ 6-2

uses for, PC_ 6-2

where allowed, PC_ 6-2

Input/Output (IO)

defined, PSC 1-4

described, PSC 1-7

on Windows NT, PSC 1-4

INSERT

append, STU 7-61

functionality, STU 27-22

object privilege, SQL 7-508

statement, SQL 7-512

INSERT ANY TABLE system privilege, SQL 7-500

INSERT command, SCN 16-3

column values and triggers, ADG 13 - 16

direct-load INSERT, SCN 25-2

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

free lists and, SCN 4-9

parallelizing INSERT ... SELECT, SCN 26-23

read consistency, ADG 8 - 11

storage for parallel INSERT, SCN 25-8

triggers and, SCN 20-2, SCN 20-6

BEFORE triggers, SCN 20-9

insert errors

INSERT into table

insert of no rows

INSERT privilege

INSERT privilege for object tables, SCN 14-15, SCN 14-16

INSERT SQL statement, PC_ F-68

examples, PC_ F-71

INSERT statement, PCO F-54

column list, PCO 5-9

column list in, PC_ 6-9

example, PCO 5-9

example of, PC_ 6-9

INTO clause, PCO 5-9

INTO clause in, PC_ 6-9

purpose of, PC_ 6-9

requirements for, PC_ 6-9

RETURNING clause, PLS 5-63

syntax, PLS 11-89

triggers on, SQL 7-404

using host arrays in, PC_ 8-11

using host tables, PCO 7-12

VALUES clause, PCO 5-9

VALUES clause in, PC_ 6-9

inserting

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

inserts

concurrent, SPS 4-8, SPS 11-14, SPS 17-6

free lists, SPS 11-14, SPS 18-16

free space unavailable, SPS 17-11

locating free space, SRF 1-52

performance, SPS 11-12

piecewise, OCI 5-32, OCI 5-34

INST_ID column, SRF 3-2

inst_init_ora parameter, PSC B-5, PSC B-8

inst_oracle_sid parameter, PSC B-5, PSC B-7

inst_sid_list parameter, PSC C-7

installation, PSC 3-7

and creating a database, SAD 2-3

Custom, NET 4-21

Custom install type, PSC 3-2, PSC 4-2

Custom procedure, PSC 3-6

database creation, PSC 3-5, PSC 3-6

default configuration, NET 4-22

default configuration for local naming, NET 6-13

directory structure, PSC A-1 to PSC A-3

INITDB_NAME.ORA, PSC 3-5, PSC 4-8

INITSID.ORA, PSC 3-5, PSC 4-8

Minimal, NET 4-21

Minimal install type, PSC 3-2

Net8 Client, NET 4-24

Net8 Configuration Assistant, PSC 3-6

Net8 Server, NET 4-22

network configuration, PSC 3-6

Operating System Dependent layer, PSC 2-13, PSC 8-3

Oracle Data Gatherer, PSC 5-28

Oracle Database Configuration Assistant, PSC 3-5, PSC 3-6

Oracle Diagnostics Pack, PSC 5-28

Oracle Enterprise Manager, PSC 5-10

Oracle Enterprise Manager requirements, PSC 2-3

Oracle Names, NET 6-24

Oracle Parallel Server Option, PSC 3-3, PSC 8-4

Oracle Performance Manager, PSC 5-28

Oracle Universal Installer, PSC 3-3

Oracle8i, SAD 1-18

Oracle8i Enterprise Edition, PSC 3-3, PSC 8-4

overview, NET 4-21

pre-installation, PSC 2-1 to PSC 2-15

procedure, PSC 3-3

release 8.1 Oracle software, MIG 3-12, MIG 4-11, MIG 5-3

repository database, PSC 5-10

software requirements, PSC 2-2

tuning recommendations for, SAD 2-14

Typical, NET 4-21

Typical install type, PSC 3-2, PSC 4-2

Typical procedure, PSC 3-5

verifying raw devices, PSC 3-5, PSC 3-6

installation directory

naming conventions, DCI 2-6

installation of data cartridge, DCI 2-4

installation requirements, PSC 2-2 to PSC 2-5

disk space, PSC 2-5

hardware, PSC 2-2

hardware requirements, PSC 2-2

Oracle Enterprise Manager, PSC 2-3

shared disk partitions, PSC 2-5

software, PSC 2-2

installation type

Custom, PSC 3-2, PSC 4-2

Minimal, PSC 3-2

Typical, PSC 3-2, PSC 4-2

installing key of server, OAS 9

INSTANCE, PSC 4-29

instance, PLS 9-4

adding instances, SPS 14-4, SPS 17-13, SPS 23-2

affinity, for jobs, SPS 4-9, SPS A-4

associated with data block, SPS 11-11

associated with data file, SPS 17-13

associated with extent, SPS 17-10

background processes, SPS 4-12, SPS 5-4, SPS 5-5

changing current, SPS 18-21

changing default, SPS 18-20

current, SPS 18-20, SPS 18-21, SPS 21-9

failure, SBR 1-12, SPS 22-3

free list, SPS 11-14, SPS 17-11

global name resolution for, SQL 7-102

groups, specifying, SPS 18-23

groups, using, SPS 18-24

instance number, SPS 11-15, SPS 17-13

maximum number, SPS 6-8, SPS 11-15, SPS 14-3, SPS 14-4

number, SPS 17-10

ownership of PCM locks, SPS 9-5

parallel server characteristics, SPS 5-1

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

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

rollback segment required, SPS 6-8

setting parameters for, SQL 7-100

startup order, SPS 18-16

thread number, SPS 6-3, SPS 14-8, SPS 18-15

instance affinity for jobs, GTK 2-63

DBMS_JOB package, GTK 2-63

instance attribute lock enqueue, SRF B-3

instance groups for parallel operations, SCN 26-19

instance lock, SPS 7-2

acquired by background process, SPS 7-6

acquired by foreground process, SPS 7-6

definition, SPS 7-2, SPS 7-4

types, SPS 7-5

instance menu

prevent Connections option, SAD 3-9

instance name, PSC 1-11

described, NET 6-3

verifying, NET 5-17

Instance Name option, NET 7-7

INSTANCE NAME parameter, SPS 18-6

instance number, SPS 11-13

instance number enqueue, SRF B-2

INSTANCE option

allocating, SPS 17-14

allocating extents, SRF 1-52

SET INSTANCE command, SPS 17-10, SPS 18-17

SHOW INSTANCE command, SPS 18-20

INSTANCE parameter

of ALTER SESSION, SQL 7-83

Instance recovery, SRF 1-43

instance recovery, SCN 32-4

abnormal shutdown, SPS 18-27

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

global checkpoint, SPS 21-9

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

multiple failures, SPS 22-3

read-only tablespaces, SCN 32-6

rollback segments, SPS 6-8

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

starting another instance, SPS 14-4

See also crash recovery

instance recovery enqueue, SRF B-2

instance recovery wait event, SRF A-35

instance registration, SPS A-10

purpose, SPS 18-28

instance registration lock enqueue, SRF B-3

instance state change wait event, SRF A-35

instance state enqueue, SRF B-2

INSTANCE_GROUPS parameter, SPS 18-24, SRF 1-50

INSTANCE_ID column, SPS 20-12

INSTANCE_NAME parameter, NET 4-3, NET 4-9, NET 4-16, NET 5-17, NET 6-3, NET 6-4, NET 7-7, NET C-47, PSC 1-11, PSC 4-24, PSC 4-29, PSC 6-4, SRF 1-51

INSTANCE_NUMBER parameter, PSC 6-10, SPS 17-10, SPS 18-5, SRF 1-51

and SQL options, SPS 11-11

assigning free lists to instances, SPS 11-13

conversion to multi-instance, SPS 23-7

exclusive mode, SPS 18-14

exclusive or parallel mode, SRF 1-52

exclusive or shared mode, SPS 18-16

individual parameter files, SPS 18-5

setting, SPS 17-13

unique values for instances, SPS 18-10, SPS 18-16

unspecified, SPS 18-16

instances, SCN 1-6

aborting, SAD 3-12, SCN 5-10, SCN 32-4

acquire rollback segments, SCN 4-26

administering, PSC 6-1 to PSC 6-39

associating with databases, SCN 5-2, SCN 5-6

BSPO process, PSC 1-10

checkpoint, SRF 1-68

control files, PSC 1-10

data files, PSC 1-10, PSC 1-11, PSC 1-14

DBWR process, PSC 1-10

defined, PSC 1-9, SCN 1-16

described, SCN 5-2

Destination Type tasks for, PSC 6-36

diagrammed, SCN 8-6

examples of parameters in
DB_NAME.CONF file, PSC B-7

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

identical parameters, PSC 6-11

initialization files, PSC 6-2

INITSID.ORA, PSC 1-11

instance groups, SCN 26-19

instance name, PSC 1-11

INSTANCE_NAME parameter, PSC 1-11, PSC 4-24

Integrated Distributed Lock Manager (IDLM), PSC 1-10

issues, PSC 6-8

LCKN process, PSC 1-10

LGWR process, PSC 1-10

LMD0 process, PSC 1-10

LMON process, PSC 1-10

management with Oracle Parallel Server Management, PSC 6-13

memory structures of, SCN 7-2

multiple-process, SCN 8-2

Oracle System Identifier (SID), PSC 1-11

ORACLE_SID environment variable, PSC 1-11

ORACLE_SID registry entry, PSC 1-11

overview of, SCN 1-6

PMON process, PSC 1-10

process structure, SCN 8-2

recovery of, SCN 5-10, SCN 32-4

Fast-Start Checkpointing, SCN 32-13

opening a database, SCN 5-8

SMON process, SCN 8-11

restricted mode, SCN 5-6

rollback segments, PSC 1-12

ROLLBACK_SEGMENTS parameter, PSC 1-12

service names, SCN 6-6

setting initialization parameters, PSC 6-8

sharing databases, SCN 1-8

shutting down, SCN 5-9, SCN 5-10

audit record, SCN 31-5

shutting down immediately, SAD 3-11

SID, PSC 1-11, PSC 6-3

SID Prefix, PSC 4-8

SID prefix, PSC 3-4

SMON process, PSC 1-10

starting, SAD 3-2, SCN 5-5

audit record, SCN 31-5

starting before database creation, SAD 2-6

startup order, SRF 1-52

system identifiers (SIDs), SCN 6-6

thread ID, PSC 1-12

THREAD parameter, PSC 1-12

verifying, PSC 4-11

viewing startup and shutdown results, PSC 6-24, PSC 6-27

virtual memory, SCN 7-17

INSTANCES keyword, SPS 18-27

removed from PARALLEL clause, MIG 8-35

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

instantiation

offline, REP 8-14

in advanced replication, REP 8-17

of an advanced replication master site, REP 8-16

instantiation offline, REP A-4

INSTEAD OF clause

of CREATE TRIGGER, SQL 7-404

INSTEAD OF trigger, GTK 3-15

INSTEAD OF triggers, ADG 13 - 7, SCN 20-12, SQL 7-404

nested tables, SCN 15-5

object views, ADG 17 - 16, ADG 17 - 17, SCN 15-5

on nested table view columns, ADG 13 - 16

INSTR function, SQL 4-18

INSTRB function, SQL 4-19

INT datatype (ANSI), SQL 2-24

INT keyword

behavior in Oracle7 and Oracle8i, MIG 8-22

INT subtype, PLS 2-13

INTCHG.ORA file, migration issues, NET 5-22

INTEGER

external datatype, OCI 3-11

INTEGER datatype, PC_ 4-6, PCO 4-11, SUT 5-59

ANSI, SQL 2-24

DB2, SQL 2-25

EXTERNAL format, SUT 5-67

SQL/DS, SQL 2-25

INTEGER subtype, PLS 2-13

integers

generating unique, SQL 7-349

in SQL syntax, SQL 2-3

precision of, SQL 2-3

specifying, SQL 2-13

syntax of, SQL 2-3

Integrated Distributed Lock Manager

capacity for locks and resources, SPS 16-2

configuring, SPS 16-3

definition, SPS 1-11

distributed architecture, SPS 8-8

failover requirements, SPS 16-2

fault tolerant, SPS 8-8

features, SPS 8-8

group-based locking, SPS 8-10

handling lock requests, SPS 8-3

instance architecture, SPS 5-2

internalized, SPS A-8

LCKn process, SPS 9-8

lock mastering, SPS 8-9

minimizing use, SPS 1-16, SPS 4-12

non-PCM lock capacity, SPS 7-6

queues, SPS 8-2

recovery phases, SPS 22-5

resource sharing, SPS 9-8

Integrated Distributed Lock Manager (IDLM)

defined, PSC 1-15

described, PSC 1-15

See IDLM

integrated operations, SPS 1-5

integrity checking, SBR 4-54

integrity constraints, SCN 28-2

application uses, ADG 5 - 2

clusters and, ADG 6 - 16

default column values and, SCN 10-8

defining, ADG 5 - 18

disabling, ADG 5 - 20, ADG 5 - 21, ADG 5 - 22, ADG 5 - 23, SAD 20-14, SAD 20-19

disabling on creation, SAD 20-18

dropping, ADG 5 - 29, SAD 20-21

dropping and disabling, SAD 16-7

dropping tablespaces and, SAD 9-15

enabling, ADG 5 - 21, SAD 20-14

enabling at creation, ADG 5 - 20

enabling on creation, SAD 20-18

enabling when violations exist, ADG 5 - 21, SAD 20-15

examples, ADG 5 - 2

exceptions to, ADG 5 - 25, SAD 20-21

failed on Import, SUT 2-48

listing definitions of, ADG 5 - 32

load method, SUT 8-9

managing, SAD 20-15

naming, ADG 5 - 20

ORA-02055

constraint violation, DDS 4-3

Oracle Version 6 export files, SUT 2-65

performance considerations, ADG 5 - 3

privileges required for creating, ADG 5 - 19

restrictions for adding or dropping, ADG 5 - 19

triggers vs., ADG 13 - 2, ADG 13 - 40

violations, ADG 5 - 21, SAD 20-15

when to disable, ADG 5 - 21, SAD 20-15

when to use, ADG 5 - 2

See also constraints

integrity constraints. See constraints.

integrity rules, SCN 1-22

parallel DML restrictions, SCN 26-45

integrity, definition, OAS Glossary-4

interactive block execution, ADG 10 - 51

interactive method

Export, SUT 1-36

interconnect, SPS 3-3

and scalability, SPS 2-2

high-speed, SPS 1-9

protocols for OPS, SPS 20-6

interface

native, PC_ 5-55, PCO 3-32

XA, PC_ 5-55, PCO 3-32

interfaces

data cartridge, DCI 1-14

DBMS, DCI 1-14

extensibility, DCI 1-13

service, DCI 1-14

inter-language call, PLS 7-27

Inter-Language Method Services (ILMS), SCN 16-20

interMedia

Audio, Image, and Video, GTK 2-8

Audio, Image, and Video Java Client, GTK 2-9

Locator, GTK 2-9

Text, GTK 2-6

Web based tools, GTK 2-3

INTERNAL

alternatives to, SAD 1-8

connecting for shutdown, SAD 3-10

OSOPER and OSDBA, SAD 1-8

security for, SAD 22-8

INTERNAL connection, SCN 5-3

statement execution not audited, SCN 31-5

internal datatype

definition, PCO 2-8

internal datatypes, OCI 3-3, OCI 3-5

CHAR, PCO 4-2

conversions, OCI 3-21

datatype codes, OCI 3-5

DATE, PCO 4-3

definition of, PC_ 2-7

dynamic SQL Method 4, PCO 11-15

lLONG, PCO 4-3

LONG RAW, PCO 4-4

NCHAR, PCO 4-3

new in Oracle8i, MIG E-2

INTERNAL date function

executing jobs and, SAD 8-8

internal errors tracked in trace files, SCN 8-14

internal LOB, DCI 6-2

Internal LOBs

loading, SUT 5-99

internal LOBs, SQL 2-19

INTERNAL option

instance shutdown, SPS 18-26

internal triggers, REP A-2

internal write batch size, STU 20-43

International Standards Organization. See ISO.

Internet, NET 2-14

internet, OAS 9-7

Internet Domain Service (DNS), OAS 11-4

Internet Inter-ORB Protocol (IIOP), OAS Glossary-4

Internet Inter-Orb Protocol (IIOP)

see IIOP

inter-node communication, SPS 1-9

interoperability, MIG 8-1, MIG 8-15

Advanced Queuing, MIG 8-32

applications, MIG 8-16

Heterogeneous Services agents, MIG 8-45

native dynamic SQL, MIG 8-30

NCHAR and NLS, MIG 8-27

OCI, MIG 8-17

Oracle7 clients, MIG 8-18

shared structures, MIG 8-17

PL/SQL, MIG 8-20

precompilers, MIG 8-18

UROWIDs, MIG 8-26

user-defined datatypes, MIG 8-29

interoperability, cursor, PLS 5-16

inter-operator parallelism, SCN 26-13

Inter-Orb Protocol (IIOP)

configuring, NET 7-50

described, NET 7-50

Inter-Process Communication (IPC)

defined, PSC 1-4

described, PSC 1-7

interrupted loads

continuing with SQL*Loader, SUT 5-34

interrupting media recovery, SBR 14-16

INTERSECT operator, SQL 3-12, SQL 7-550

compound queries, SCN 23-4

example, SCN 23-29

optimizing view queries, SCN 23-16

INTERSECT set operator, PLS 5-6

intersection tables, REP 3-13

Interval Expression setting

Setup wizard, REP 2-16

Interval setting

Create Scheduled Link property sheet, REP 2-13

INTO clause, PCO 5-2, PCO 6-36, PLS 5-23

FETCH statement, PCO 5-14

for output host variables, PC_ 6-2

in FETCH statements, PC_ 6-14

in INSERT statements, PC_ 6-9

in SELECT statements, PC_ 6-8

INSERT statement, PCO 5-9

of EXPLAIN PLAN, SQL 7-487

of FETCH DESCRIPTOR statement, PC_ F-62

of FETCH statement, PC_ F-59, PCO F-46, PCO F-49

of INSERT, SQL 7-514

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

SELECT statement, PCO 5-8

used with FETCH instead of SELECT, PC_ 6-12

INTO host_variable clause

of CALL, SQL 7-211

INTO list, PLS 5-9

INTO TABLE clause

effect on bind array size, SUT 5-80

INTO TABLE statement

column names

SQL*Loader, SUT 5-46

discards

SQL*Loader, SUT 5-29

multiple statements with SQL*Loader, SUT 5-51

SQL*Loader, SUT 5-39

intra transaction recovery, STU 25-16

intra-operator parallelism, SCN 26-13

Introducing, PSC 1-1

intype file, PC_ 19-32

providing when running OTT, OCI 14-8, PC_ 19-8

structure of, OCI 14-29, PC_ 19-32

INTYPE OTT parameter, OCI 14-25, PC_ 19-27

INTYPE precompiler option, PC_ 10-26

invalid data

Import, SUT 2-48

invalid destination state

for archived redo logs, SAD 7-13

invalid objects

warning messages

during export, SUT 1-39

INVALID status, SCN 21-2

invalid use

of precompiler preprocessor, PC_ 5-33

invalid views, ADG 3 - 27

INVALID_CURSOR exception, PLS 6-5

INVALID_NUMBER exception, PLS 6-5

invoker rights, GTK 2-78, PLS 7-29, SCN 18-9

advantages, PLS 7-30

name resolution, SCN 18-19

procedure security, SCN 30-8

supplied packages, SCN 30-8

versus definer rights, PLS 7-29

invoker rights clause

of ALTER JAVA, SQL 7-44

of CREATE FUNCTION, SQL 7-270

of CREATE JAVA, SQL 7-294

of CREATE PACKAGE, SQL 7-324

of CREATE PROCEDURE, SQL 7-332

of CREATE TYPE, SQL 7-415

invoker-rights

dynamic SQL, ADG 9 - 8

object types, ADG 18 - 30

invoking Export, SUT 1-10

direct path, SUT 1-43

I/O

io done wait event, SRF A-35

I/O errors

effect on backups, SBR 4-36

IOTs. See index-organized tables

IP errors, troubleshooting, LEG B-1 to LEG B-2

IPC, parameters for addresses, NET 6-78

IPCs

and Cache Fusion, SPS 20-6

IRECLEN precompiler option, PCO 14-26

IS DANGLING predicate, PLS 9-33

IS NOT NULL operator, SQL 3-7

IS NULL comparison operator, PLS 2-45, PLS 5-6

IS NULL operator, SQL 3-7

for testing NULL values, PCO 2-18

IS NULL predicate, SCN 10-8

ISO, SQL B - 1

standards, SQL 1-2, SQL B - 1

ISO SQL standard, SCN 1-3, SCN 12-22

composite foreign keys, SCN 28-16

ISO standard

date format, NLS 2-16, NLS 4-9, NLS 4-10

ISO week number, NLS 4-9

ISOLATION LEVEL, STU 9-5

changing, ADG 8 - 26

SERIALIZABLE, ADG 8 - 26

ISOLATION LEVEL READ COMMITTED clause

of SET TRANSACTION, SQL 7-573

ISOLATION LEVEL SERIALIZABLE clause

of SET TRANSACTION, SQL 7-573

isolation levels

choosing, SCN 27-12

read committed, SCN 27-8

setting, SCN 27-7, SCN 27-31

ISOLATION_LEVEL parameter

of ALTER SESSION, SQL 7-83

%ISOPEN cursor attribute, PLS 5-34, PLS 5-38

iteration

scheme, PLS 3-10

versus recursion, PLS 7-41

iterative control, PLS 3-6

ITIME column

SYS.INCEXP table, SUT 1-51

IW date format element, SQL 2-41

IW format element, NLS 4-10

IY date format element, SQL 2-41

IY format element, NLS 4-10

IYY date format element, SQL 2-41

IYYY date format element, SQL 2-41