Oracle8i Generic Documentation Master Index

I date format element, SQL 2-46

I variable in SQLDA

how value is set, PC_ 15-10

purpose of, PC_ 15-10

IAF GET statement

example of using, PC_ 20-5

in user exits, PC_ 20-4

purpose of, PC_ 20-4

specifying block and field names in, PC_ 20-5

syntax for, PC_ 20-4

IAF PUT statement

example of using, PC_ 20-6

in user exits, PC_ 20-5

purpose of, PC_ 20-5

specifying block and field names in, PC_ 20-6

syntax for, PC_ 20-5

IAP in SQL*Forms

purpose of, PC_ 20-13

IBM's NetView/6000, DDS 1-32, SCN 403

ID - oracle.xml.parser.v2.AttrDecl.ID, JPR 4-7

ID column

PLAN_TABLE table, STU 5-5

IDENTIFIED BY clause

of ALTER ROLE. See CREATE ROLE

of ALTER ROLE. See CREATE ROLE.

of CREATE ROLE, SQL 7-366

IDENTIFIED BY password clause

of CREATE DATABASE LINK, SQL 7-275

of CREATE USER, SQL 7-452

of SET ROLE, SQL 7-601

IDENTIFIED EXTERNALLY clause

of ALTER ROLE. See CREATE ROLE

of ALTER USER. See CREATE USER

of CREATE ROLE, SQL 7-366

of CREATE USER, SQL 7-452

IDENTIFIED GLOBALLY clause

of ALTER ROLE. See CREATE ROLE

of ALTER ROLE. See CREATE ROLE.

of ALTER USER, SQL 7-195

of CREATE ROLE, SQL 7-366

of CREATE USER, SQL 7-452

of CREATE USERIDENTIFIED BY clause

of ALTER USER. See CREATE USER

identifiers

for locks, PSA 9-13

forming, PLS 2-5

maximum length, PLS 2-5

quoted, PLS 2-6

scope rules, PLS 2-38

identifiers, ORACLE

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

Identix

authentication parameters, OAS B-2

configuring authentication, OAS 8-8

sample for sqlnet.ora file, OAS A-3

Identix authentication method

see Oracle Advanced Security

Identix Biometric, system requirements, OAS 1-13

Identix TouchNet II Desktop Sensor, OAS 8-15

Identix TouchNet II Hardware Interface, OAS 8-4

IDEPTREE view, SRF 2-153

IDLE_TIME parameter

of ALTER PROFILE, SQL 7-69

of CREATE PROFILE, SQL 7-361

IDLM parameters, PSA 1-14

IDREF - oracle.xml.parser.v2.AttrDecl.IDREF, JPR 4-7

IDREFS - oracle.xml.parser.v2.AttrDecl.IDREFS, JPR 4-7

IETF

drafts, enforced by Oracle Internet Directory, OID F-2

LDAP approval

RFCs enforced by Oracle Internet Directory, OID F-2

IF statement, PLS 3-2

ELSE clause, PLS 3-3

ELSIF clause, PLS 3-4

syntax, PLS 11-91

THEN clause, PLS 3-3

IFILE

parameter, PSA 1-3

IFILE initialization parameter, SRF 1-4, SRF 1-45

IFILE parameter, PSA 1-4, PSG 4-5

multiple files, PSA 1-4

overriding values, PSA 1-3

specifying identical parameters, PSA 1-5

iFS. See Internet File System

IGNORE

Import parameter, SUT 2-22, SUT 2-55

existing objects, SUT 2-46

IIOP, GTK 3-70

IIOP (Internet Inter-ORB Protocol)

secured by SSL, OAS 10-6

ILMS, SCN 29

image copies, RMN 1-57

crosschecking, RMN 3-17

definition, SBR 1-21

testing restore of, RMN 3-24

image maps, ADG 12-2

IMG, SMS 48-1

IMMEDIATE clause

of SET CONSTRAINTS, SQL 7-598

immediate constraints, SCN 274

IMP, SMS 17-1

imp utility, PSG 9-6

IMP_FULL_DATABASE role, SAD 23-5, SCN 324, SQL 7-530, SUT 2-6, SUT 2-10, SUT 2-22

Import, SUT 2-29

implementing database design, SAD 1-20

implicit connections, PC_ 3-14

multiple, PC_ 3-15

single, PC_ 3-14

implicit cursors, PLS 5-11

attributes, PLS 5-39

implicit data conversion, SQL 2-36, SQL 2-38

implicit datatype conversion, PLS 2-28

effect on performance, PLS 5-68

implicit declarations

cursor FOR loop record, PLS 5-13

FOR loop counter, PLS 3-13

implicit dereferencing, ADO 1-7, ADO 9-22, SCN 13-10

implicit logons, PCO 3-11

implicit VARCHAR, PCO 4-27

IMPLIED - oracle.xml.parser.v2.AttrDecl.IMPLIED, JPR 4-7

Import, SUT 2-1

ANALYZE parameter, SUT 2-18

backup files, SUT 2-49

BUFFER parameter, SUT 2-18

CATEXP.SQL

preparing the database, SUT 2-6

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

character sets, SUT 2-53

COMMIT parameter, SUT 2-19

committing after array insert, SUT 2-19

compatibility, SUT 2-4

complete export file, SUT 2-41

consolidated extents, SUT 2-51

controlling size of rollback segments, SUT 2-19

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

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

cumulative, SUT 2-41

data files

reusing, SUT 2-20

database

reusing existing data files, SUT 2-20

DESTROY parameter, SUT 2-20

disabling referential constraints, SUT 2-14

displaying online help, SUT 2-22

dropping a tablespace, SUT 2-51

error handling, SUT 2-45

errors importing database objects, SUT 2-46

example session, SUT 2-33

export COMPRESS parameter, SUT 2-51

export file

importing the entire file, SUT 2-22

listing contents before import, SUT 2-26

failed integrity constraints, SUT 2-45

fatal errors, SUT 2-46, SUT 2-47

FEEDBACK parameter, SUT 2-20

FILE parameter, SUT 2-20

FROMUSER parameter, SUT 2-21

grants

specifying for import, SUT 2-22

GRANTS parameter, SUT 2-22

HELP parameter, SUT 2-8, SUT 2-22

IGNORE parameter, SUT 2-22, SUT 2-46

importing grants, SUT 2-12, SUT 2-22

importing objects into other schemas, SUT 2-12

importing rows, SUT 2-26

importing tables, SUT 2-27

incremental, SUT 2-41

specifying, SUT 2-24

INCTYPE parameter, SUT 2-23

INDEXES parameter, SUT 2-24

INDEXFILE parameter, SUT 2-24

INSERT errors, SUT 2-46

interactive method, SUT 2-39

invalid data, SUT 2-45

invoking, SUT 2-6

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

log files

LOG parameter, SUT 2-25

LONG columns, SUT 2-59

manually ordering tables, SUT 2-14

modes, SUT 2-4

NLS considerations, SUT 2-52

NLS_LANG environment variable, SUT 2-53

object creation errors, SUT 2-22

objects imported, SUT 1-5

OPTIMAL storage parameter, SUT 2-50

Oracle Version 6 integrity constraints, SUT 2-62

parameter file, SUT 2-9, SUT 2-25

parameters, SUT 2-15

partition-level, SUT 2-5

preparing the database, SUT 2-6

read-only tablespaces, SUT 2-51

recompiling stored procedures, SUT 2-58

RECORDLENGTH parameter, SUT 2-26

records

specifying length, SUT 2-26

reducing database fragmentation, SUT 2-44

refresh error, SUT 2-48

reorganizing tablespace during, SUT 2-52

resource errors, SUT 2-46

rows

specifying for import, SUT 2-26

ROWS parameter, SUT 2-26

schema objects, SUT 2-11, SUT 2-12

sequences, SUT 2-46

SHOW parameter, SUT 1-3, SUT 2-26

single-byte character sets, SUT 2-53

snapshot master table, SUT 2-48

snapshots, SUT 2-48

restoring dropped, SUT 2-49

specifying by user, SUT 2-21

specifying index creation commands, SUT 2-24

specifying the export file, SUT 2-20

storage parameters

overriding, SUT 2-51

stored functions, SUT 2-58

stored packages, SUT 2-58

stored procedures, SUT 2-58

system objects, SUT 2-12

table objects

import order, SUT 2-3

table-level, SUT 2-5

tables created before import, SUT 2-13

TABLES parameter, SUT 2-27

TOUSER parameter, SUT 2-29

transferring files across networks, SUT 2-47

unique indexes, SUT 2-23

uniqueness constraints

preventing import errors, SUT 2-19

user definitions, SUT 2-13

USERID parameter, SUT 2-30

using Oracle Version 6 files, SUT 2-62

import

snapshot logs, REP 3-20

snapshots, REP 3-20

import data, PSG 9-6

Import utility, PSG 9-6, SBR 4-19, SCN 1-11

about, SAD 1-17

Compatibility, PSC B-2

copying statistics, SCN 131, STU 8-2

data definition conversion, MIG 3-13

database recovery, SBR 4-20

free lists, PSC A-22

migration, MIG 3-10, MIG 6-1

partition maintenance operations, SCN 11-47

procedure for using, SBR 4-20

requirements for migration, MIG 6-2

restoring data, PSC B-2

restricted mode and, SAD 3-6

use in recovery, SCN 367

user-defined types, ADO 2-16

importing

object groups

offline instantiation and, SPR 24-4, SPR 24-7, RAR 8-41, RAR 8-44

snapshots

offline instantiation and, SPR 25-3, SPR 25-5, RAR 8-48, RAR 8-50

status check, SPR 37-77, RAR 8-143

importing jobs, SAD 8-6

improving network performance

by randomizing client requests, PSC 8-10

IN comparison operator, PLS 2-47, PLS 5-6

IN operator, STU 4-66

merging views, STU 4-79

IN OUT parameter

of CREATE FUNCTION, SQL 7-287

of CREATE PROCEDURE, SQL 7-356

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

IN parameter

of CREATE function, SQL 7-287

of CREATE PROCEDURE, SQL 7-356

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

in progress save set, LEG 2-8

IN subquery, STU 4-78

inactive destination state

for archived redo logs, SAD 7-13

inactive online redo log

loss of, SBR 6-8

INAME option

when a file extension is required, PCO 14-2

INAME precompiler option, PC_ 10-24

INAMEprecompiler option, PCO 14-24

incarnation of database option (RMAN)

list command, RMN 3-13

incarnation option (RMAN)

reset database command, RMN 3-13

INCLUDE

precompiler option, use of, PC_ 5-34

using to include the SQLCA, PC_ 9-16

include file parameter, PSA 1-4

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

INCLUDE statement

case-sensitive operating systems, PCO 2-22

declaring the ORACA, PCO 8-24

declaring the SQLCA, PCO 8-8

declaring the SQLDA, PCO 11-7

effect of, PCO 2-21

INCLUDE statements, PCO B-2

INCLUDING clause, SAD 13-21

of ALTER TABLE, SQL 7-154

INCLUDING CONTENTS clause

of DROP TABLESPACE, SQL 7-504

INCLUDING NEW VALUES clause

of ALTER MATERIALIZED VIEW LOG, SQL 7-61

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

INCLUDING TABLES clause

of DROP CLUSTER, SQL 7-473

incompatibilities

removing, MIG 13-2

system-defined, MIG 9-6, MIG 13-9

incomplete media recovery

change-based, SBR 5-30

definition, SBR 1-25, SBR 3-16

in OPS configuration, SBR 5-12

procedures for, SBR 5-25

time-based, SBR 5-28 to SBR 5-30

using backup control file, SBR 5-12

incomplete object types, ADO 2-14, ADO 9-14, PLS 9-29, SQL 7-439

creating, SQL 7-437, SQL 7-439

incomplete recovery

change-based (RMAN), RMN 6-27

definition, SBR 1-5

log sequence-based (RMAN), RMN 6-28

restoring in preparation for, RMN 6-16

time-based (RMAN), RMN 6-26

using RMAN, RMN 6-25

with a recovery catalog, RMN 6-26

without a recovery catalog, RMN 6-29, RMN 6-31

inconsistent backups

definition, SBR 1-23

whole database

definition, SBR 1-18

INCREMENT BY clause

of ALTER SEQUENCE. See CREATE SEQUENCE

of CREATE SEQUENCE, SQL 7-373

incremental backups, RMN 5-22

differential, RMN 1-51

using RMAN, RMN 5-11

incremental checkpoint, SCN 8-8

incremental export, SBR 4-20, SUT 1-45

backing up data, SUT 1-50

command syntax, SUT 1-21

data selected, SUT 1-49

recording, SUT 1-24

restrictions, SUT 1-45

session example, SUT 1-50

specifying, SUT 1-21

SYS.INCFIL table, SUT 1-52

SYS.INCVID table, SUT 1-53

incremental growth, PSA 8-11

incremental import

parameter, SUT 2-23

specifying, SUT 2-24

incremental migration, MIG G-5

incremental refresh, SCN 10-19

INCTYPE

Export parameter, SUT 1-21

Import parameter, SUT 2-23

IND synonym for USER_INDEXES, SRF 2-153

independent data marts, DWG 20-2

index

domain

creating, DCI 11-15

metadata for, DCI 11-37

using to improve performance, PCO D-6

index and table structures, ADQ 5-2

INDEX clause

of CREATE CLUSTER, SQL 7-257

index clusters. See clusters.

INDEX hint, SQL 2-65, STU 7-12, STU 12-7, STU 12-17

index joins, DWG 18-39, STU 4-24

INDEX object privilege, SQL 7-535

index options

SORTED INDEXES with SQL*Loader, SUT 5-44

SQL*Loader SINGLEROW keyword, SUT 5-44

index partitions

changing physical attributes of, SQL 7-36

deallocating unused space from, SQL 7-35

dropping, SQL 7-41

marking UNUSABLE, SQL 7-157

modifying the real characteristics of, SQL 7-41

rebuilding, SQL 7-37

unusable, SQL 7-157

renaming, SQL 7-41

specifying tablespace for, SQL 7-38

splitting, SQL 7-41

INDEX privilege, ADG 11-22

index segments, SCN 1-7, SCN 4-19

index subpartitions

allocating extents for, SQL 7-42

changing physical attributes of, SQL 7-36

deallocating unused space from, SQL 7-35, SQL 7-42

marking UNUSABLE, SQL 7-42

rebuilding, SQL 7-37

renaming, SQL 7-41

specifying tablespace for, SQL 7-38

Index Unusable state, SUT 5-34

indexes left in Index Unusable state, SUT 8-11

INDEX_ASC hint, SQL 2-65, STU 7-13

INDEX_COMBINE hint, SQL 2-65, STU 12-7, STU 12-17

INDEX_DESC hint, SQL 2-65, STU 7-14, STU 7-15

INDEX_FFS hint, SQL 2-65, STU 4-23, STU 7-15, STU 12-9

INDEX_HISTOGRAM view, SRF 2-153

INDEX_JOIN hint, STU 4-24

INDEX_STATS view, SRF 2-153

index-by tables

versus nested tables, PLS 4-3

indexed attribute locations, OID 5-16

indexed attributes, OID 6-30

displayed in Oracle Directory Manager, OID 6-12

orcleventtype, OID 5-25

orcluserdn, OID 5-25

indexed clusters

creating, SQL 7-257

INDEXES

Export parameter, SUT 1-22

Import parameter, SUT 2-24

indexes, SCN 1-25, SCN 10-23

allocating new extents for, SQL 7-35

analyzing statistics, SAD 19-3

application-specific, SQL 7-309

ascending, SQL 7-299

auditing partitions, SCN 11-63

avoiding the use of, STU 12-7

based on indextypes, SQL 7-304

bitmap, MIG 8-12, SQL 7-297, STU 12-13, STU 12-14, STU 12-16, STU 12-19

bitmap indexes, DWG 6-6, SCN 10-34, SCN 10-39

nulls and, SCN 10-9

parallel query and DML, SCN 10-35

block contention, PSA 5-5

branch blocks, SCN 10-30

B-tree, DWG 6-6

B-tree structure of, SCN 10-29

building

using an existing index, SCN 10-24

building online, GTK 3-41

cardinality, DWG 6-3, SCN 10-35

changing attributes of, SQL 7-36

choosing columns for, STU 12-4

client, LEG 2-5

cluster, SCN 10-54

cannot be partitioned, SCN 11-2

contrasted with table, SCN 10-54

dropping, SCN 10-54

scans of, STU 4-39

cluster indexes, SAD 16-8, SAD 16-10

collecting statistics on, SQL 7-202

compatibility, MIG 9-10

composite, SCN 10-24, STU 12-5

scans of, STU 4-39

on composite-partitioned tables, SQL 7-303

concatenated, SCN 10-24

correct tables and columns, SAD 14-9

created by bulkload, OID 7-29

creating, ADG 5-5, PSA 8-6, SQL 7-295

after inserting table data, SAD 14-3

explicitly, SAD 14-9

unrecoverable, SAD 14-6

creating as cluster indexes, SQL 7-297

creating in parallel, DWG 18-57

creating manually, SUT 2-25

data partitioning, PSA 7-14

deallocating unused space from, SQL 7-35

defragment using COALESCE, GTK 3-42

descending, GTK 3-25, SQL 7-299

and query rewrite, SQL 7-299

as function-based indexes, SQL 7-299

described, SCN 1-25, SCN 10-23

design, STU 2-9

direct path load

left in direct load state, SUT 8-11

disabling and dropping constraints and, SAD 14-8

disassociating statistics types from, SQL 7-480

domain, SCN 10-45, SQL 7-295, SQL 7-304, SQL 7-309, STU 12-24

dropping, MIG 13-20

domain indexes

extensible optimization, SCN 140, STU 4-32

user-defined statistics, SCN 141, STU 4-33

dropped tables and, ADG 2-10, SAD 13-16

dropping, ADG 5-5, SAD 14-16

before continuing a direct path load, SUT 5-34

SQL*Loader, SUT 8-20

dropping from attributes

using Oracle Directory Manager, OID 6-31

dropping index partitions of, SQL 7-480

enforcing integrity constraints, SCN 260, SCN 262

enforcing uniqueness, STU 12-10

ensuring the use of, STU 12-6

estimating size, SAD 14-5

example, STU 9-4

examples, SQL 7-305

explicitly creating, SAD 14-9

exporting, SUT 1-22

extensible, SCN 10-45

extensible indexing, GTK 3-31

extent allocation for, SAD 14-5

fast full scan, STU 12-8

fast full scans of, STU 4-23

FREELISTS clause, SRF 1-28

FREELISTS option, PSA 8-6

function-based, ADG 5-6, MIG 8-14, GTK 3-24, SAD 14-11 to SAD 14-13, SCN 10-26, SQL 7-295, STU 12-12

creating, SQL 7-298

dependencies, SCN 10-28, SCN 113, SCN 115

DETERMINISTIC functions, SCN 114

DISABLED, SCN 114

dropping, MIG 13-20

optimization with, SCN 10-27

privileges, SCN 10-28, SCN 114

global, DWG 18-55

global partitioned indexes, SCN 11-31

managing partitions, SCN 11-32, SCN 11-60

globally partitioned, SQL 7-302

granting

system privileges on, SQL 7-522

guidelines, ADG 5-2

guidelines for managing, SAD 14-2

on hash-partitioned tables, SQL 7-303

importing, SUT 2-24

index joins, STU 4-24

index unusable (IU), SCN 11-61

index-creation commands

Import, SUT 2-24

index-organized tables, SCN 10-39

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

secondary indexes, SCN 10-42

INITRANS for, SAD 14-4

internal structure of, SCN 10-29

issues for inter-instance contention, PSA 6-10

key compression, MIG 9-10, SCN 10-31

key compression of, SQL 7-39, SQL 7-300

keys and, SCN 10-25

primary key constraints, SCN 262

unique key constraints, SCN 260

leaf blocks, SCN 10-30

left direct load state

SQL*Loader, SUT 8-17

limiting per table, SAD 14-4

local, DWG 18-55

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

building partitions in parallel, SCN 11-29

locally partitioned, SQL 7-302

location of, SCN 10-28

locking policy for, PSA 6-13

logging attributes of, SQL 7-301

logging rebuild operations on, SQL 7-39

LONG RAW datatypes prohibit, SCN 12-15

maintenance options, SUT 6-9, SUT 8-20

managing partitions, SCN 11-59

marking as UNUSABLE, SQL 7-40

MAXTRANS for, SAD 14-4

media, LEG 2-5

merging contents of index blocks, SQL 7-40

modifying values of, STU 12-5

monitoring space use of, SAD 14-16

multiple-column

SQL*Loader, SUT 8-17

no-logging mode, SCN 151

non-unique, STU 12-10

nonunique, SCN 10-24

nulls and, DWG 6-5, SCN 10-9, SCN 10-25, SCN 10-38

on complex data types, SCN 10-45

on physical ROWID, MIG 12-8

on REFs, ADO 2-4

online, SQL 7-301

optimization and, STU 4-71

order of columns, ADG 5-4

overview of, SCN 1-25, SCN 10-23

parallel creation, DWG 18-57, DWG 18-58

parallel DDL storage, SCN 190

parallel index scans, SCN 161

parallel local, DWG 18-58

parallel queries and DML on, SQL 7-36

parallelizing creation of, SQL 7-304

parallelizing index creation, SAD 14-6

partition pruning, SCN 11-4

partitioned, NLS 4-9, SAD 15-2, SQL 2-70, SQL 7-295

see also partitioned indexes

user-defined, SQL 7-302

partitioned tables, DWG 6-6, SCN 10-39

partitioned tables and, REP A-8

partitioning, DWG 5-6

partitioning guidelines, SCN 11-35

partitions, SCN 11-2, SCN 11-28

adding new, SQL 7-41

marking UNUSABLE, SQL 7-41

PCM locks, PSA 7-14

PCTFREE for, SAD 14-4

PCTUSED for, SAD 14-4

performance and, SCN 10-24

physical attributes of, SQL 7-300

placement on disk, STU 20-21

presorting data, SUT 4-25

SQL*Loader, SUT 8-16

privileges, ADG 5-5

for altering, SAD 14-15

for dropping, SAD 14-16

privileges for partitions, SCN 11-62

range scans, STU 4-23

on range-partitioned tables, SQL 7-302

rebuild partition, SCN 11-60

rebuilding, SQL 7-37, STU 12-9

physical ROWIDs, MIG 12-8

rebuilding while online, SQL 7-39

rebuilt after direct-load INSERT, SCN 152

recreating, STU 12-9

removing from the database, SQL 7-480

renaming, SQL 7-40

replication, REP 2-16

reverse, SQL 7-38, SQL 7-300

reverse key indexes, SCN 10-33

reverse-key, for minimizing contention, PSA 6-11

rowids and, SCN 10-30

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

scans of, STU 4-22

bounded range, STU 4-41

cluster key, STU 4-39

composite, STU 4-39

MAX or MIN, STU 4-44

ORDER BY, STU 4-45

restrictions, STU 4-46

single-column, STU 4-40

unbounded range, STU 4-42

secondary for index-organized tables, GTK 3-29

selectivity of, STU 12-4

separating from a table, SAD 13-5

setting storage parameters for, SAD 14-5

skipping maintenance, SUT 6-9, SUT 8-20

skipping unusable, SUT 2-26, SUT 6-10, SUT 8-20

space used by, SAD 14-16

specifying PCTFREE for, ADG 2-6, SAD 12-4

specifying tablespace for, SQL 7-38

SQL*Loader, SUT 5-43

SQL*Loader and, ADG 5-2, SAD 14-4

state after discontinued load, SUT 5-34

statement conversion and, STU 4-71

statistics on, SQL 7-301

statistics on rebuild, SQL 7-39

statistics, gathering, STU 8-6

storage characteristics of, SQL 7-300, SQL 7-605

STORAGE clause, DWG 18-58

storage format of, SCN 10-29

tablespace containing, SQL 7-300

tablespace for, SAD 14-5

temporary segments and, ADG 5-2, SAD 14-3

unique, SCN 10-24, SQL 7-296, SUT 2-23

unique scans, STU 4-22

unsorted, SQL 7-300

user-defined types, ADO 2-4

using to improve performance, PC_ C-6

validating structure, SAD 19-9

validating structure of, SQL 7-206

when to create, ADG 5-2, STU 12-2

when used with views, SCN 10-15

see also bitmap indexes

INDEXES clause

of ASSOCIATE STATISTICS, SQL 7-210, SQL 7-212

INDEXFILE

Import parameter, SUT 2-24

indexing

attributes, OID 6-30, OID 6-34

by using command line tools, OID 6-33

using catalog management tool, OID 6-30

using Oracle Directory Manager, OID 6-30

extensible

queries benefitting, DCI 11-14

queries not benefitting, DCI 11-14

using Catalog Management tool, OID 6-34

index-organized table, PCO 4-32

not used in power demand example, DCI 11-75

index-organized table clause

of CREATE TABLE, SQL 7-384, SQL 7-396

index-organized tables, ADG 6-1 to ADG 6-20, GTK 4-14, SAD 13-17 to SAD 13-26, SCN 10-39

applications, SCN 10-43

AS subquery, SAD 13-20

benefits, SCN 10-41

compatibility, MIG 9-10

creating, SAD 13-19, SQL 7-390, SQL 7-396

description, SAD 13-17

full table functionality, GTK 3-29

INCLUDING clause, SAD 13-21

inline storage for LOBs and, ADL 6-6

key compression, GTK 3-29, SAD 13-22

key compression in, SCN 10-33, SCN 10-41

LOB column support, GTK 3-29

logical ROWIDs, GTK 3-29

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

maintaining, SAD 13-23

modifying, SQL 7-153

nested table data, GTK 3-34

overflow clause, SAD 13-20

parallel CREATE, SCN 187

parallel loading of, GTK 3-29

parallel queries, SCN 185

partition of, SCN 11-41

partitioned secondary indexes on, SCN 11-44

partitioning, GTK 3-47, SAD 15-9

partitioning secondary indexes, SAD 15-9

queue tables, SCN 79

rebuild of, SCN 10-43

rebuilding, SQL 7-144

rebuilding with ALTER TABLE MOVE, GTK 3-29

rebuilding with MOVE clause, SAD 13-23

removing LOBs from, MIG 13-14

removing partitions from, MIG 13-22

reserving space in the index block, SQL 7-154

row overflow area, SCN 10-41

rowids of, SQL 2-27

secondary indexes, GTK 3-29

secondary indexes on, SCN 10-42

storing nested tables as, ADO 6-15

threshold value, SAD 13-21

updating key column, SAD 13-24

indextype, SCN 10-46

INDEXTYPE clause

of CREATE INDEX, SQL 7-304

indextype implememntation methods, DCI 11-22

indextypes

associating statistics with, SQL 7-212

creating, SQL 7-309

disassociating from statistics types, SQL 7-482

drop routines, invoking, SQL 7-480

dropping, MIG 13-20

granting

system privileges on, SQL 7-522

indexes based on, SQL 7-304

instances of, SQL 7-295

removing from the database, SQL 7-482

INDEXTYPES clause

of ASSOCIATE STATISTICS, SQL 7-210, SQL 7-212

indicator arrays, PC_ 8-4

example of using, PC_ 8-4

uses for, PC_ 8-4

INDICATOR keyword, PC_ 4-16

INDICATOR property, ADG 10-23

indicator table, PCO 7-2

indicator tables

example, PCO 7-5

purpose, PCO 7-5

indicator variable, OCI 2-32

arrays of structures, OCI 5-25

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

for REF, OCI 2-32

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

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

declarations, PC_ 18-4

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

definition of, PC_ 2-6

function, PCO 4-23

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

guidelines, PC_ 4-18

interpreting value, PCO 5-3

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

naming of, PC_ 4-43

NULLs, PCO 6-2

referencing, PC_ 4-16, PCO 4-24

required size, PCO 4-24

requirements for, PC_ 6-4

truncated values, PCO 6-2

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

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

using to detect truncated values, PC_ 6-4, PCO 4-23, 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-27, PCO 3-24

in-doubt transactions, DDS 4-14, SCN 4-25, SCN 5-9

after a system failure, DDS 5-11

automatic resolution, DDS 4-17

failure during commit phase, DDS 4-18

failure during prepare phase, DDS 4-17

deciding how to handle, DDS 5-10

deciding whether to perform manual override, DDS 5-12

forcing, SQL 7-231

forcing commit of, SQL 7-231

forcing rollback, SQL 7-565

forcing rollback of, SQL 7-565

intentionally creating, DDS 5-26

manually committing, DDS 5-14

manually overriding, DDS 4-19, DDS 5-13

scenario, DDS 5-17

manually rolling back, DDS 5-15

overriding manually, DDS 5-12

overview, DDS 4-16

pending transactions table, DDS 5-25

purging rows from data dictionary, DDS 5-15

deciding when necessary, DDS 5-16

recoverer process, DDS 5-27

rollback segments, DDS 5-12

rolling back, DDS 5-13, DDS 5-14, DDS 5-15, SQL 7-564

SCNs and, DDS 4-19

simulating, DDS 5-26

tracing session tree, DDS 5-9

viewing information about, DDS 5-7

INDX tablespace

described, PSG 1-12

raw device, PSG 2-6

inequality test, SQL 3-5

INFILE keyword

SQL*Loader, SUT 5-22

infinite loops, PLS 3-6

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

information retrieval (IR) applications

index-organized tables, SCN 10-44

inheritance, ADO 1-10, OID 2-8

and access control policies, OID 9-3

and superclasses, OID 6-3

dual subtype/super-type reference, ADO 6-36

from superclasses, OID 6-12

of attributes, OID 6-12

subtype contains super-type, ADO 6-33

super-type contains all subtypes, ADO 6-35

INIT_SQL_FILES parameter

data dictionary creation, SRF 5-2

INITCAP function, SQL 4-38

initdb_name.ora file

ACTIVE_INSTANCE_COUNT parameter, PSG 5-6

BACKGROUND_DUMP_DEST parameter, PSG 4-7, PSG C-9, PSG C-10

CONTROL_FILES parameter, PSG 4-7

creating, PSG 3-36

DB_DOMAIN parameter, PSG 4-8

DB_NAME parameter, PSG 1-15, PSG 4-4, PSG 4-7

defined, PSG 1-14

described, PSG 4-6

LOCAL_LISTENER parameter, PSG 3-6

MTS_DISPATCHER parameter, PSG 4-8

SERVICE_NAMES parameter, PSG 4-9

USER_DUMP_DEST parameter, PSG 4-9, PSG C-10

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

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

INITIAL extent size, DWG 14-13, DWG 18-44

INITIAL parameter

of STORAGE clause, SQL 7-607

Initial Preallocated Requests field, NET 6-63

INITIAL storage parameter

altering, SAD 13-12

cannot alter, SAD 12-13

description, SAD 12-9

minimum value, PSA 8-11

rollback segments, PSC 7-7, SAD 11-5, SAD 11-8

when deallocating unused space, SAD 12-15

initialization

using DEFAULT, PLS 2-31

variable, PLS 2-41

when required, PLS 2-32

initialization files

location, PSA 1-4

initialization function

calling, PC_ 19-20

tasks of, PC_ 19-22

initialization parameter

obsolete, PSC A-23

initialization parameter file, RMN 1-61, RMN 6-18, SCN 5-4, SCN 5-6, SRF 1-1

common file, SRF 1-45

embedded, SRF 1-45

example, SCN 5-4

INITDW.ORA, SRF 1-1

INSTANCE_NAME parameter, NET 2-32

line continuation character (), SRF 1-3

LOCAL_LISTENER parameter, NET 7-7, NET 7-10

MTS_DISPATCHERS parameter, NET 9-4

parameters for clients and servers using CyberSafe, OAS B-2

parameters for clients and servers using Kerberos, OAS B-5

parameters for clients and servers using RADIUS, OAS B-6

parameters for clients and servers using SecurID, OAS B-5

parameters for clients and servers using SSL, OAS B-11

SERVICE_NAMES parameter, NET 2-32, NET 9-6

startup, SCN 5-6

initialization parameter files

initialization parameters

ACTIVE_INSTANCE_COUNT, SRF 1-12

added in Oracle8i, MIG B-2

adjusting for release 8.1, MIG 4-29, MIG 5-11, MIG 7-18, MIG 8-8

altering, SRF 1-5

ALWAYS_ANTI_JOIN, SRF 1-13, STU 4-61

ALWAYS_SEMI_JOIN, SRF 1-14, STU 4-62

AQ_TM_PROCESS, SCN 72, SCN 73

AQ_TM_PROCESSES, SRF 1-14

archive log destination

switching to new, MIG B-13

archiving, PSA 13-4

AUDIT_FILE_DEST, SRF 1-14

AUDIT_TRAIL, SRF 1-15

BACKGROUND_CORE_DUMP, SRF 1-15

BACKGROUND_DUMP_DEST, SRF 1-16

BACKUP_TAPE_IO_SLAVES, RMN 5-24, SRF 1-16

BITMAP_MERGE_AREA_SIZE, SRF 1-17

BLANK_TRIMMING, SRF 1-17

BUFFER_POOL_KEEP, SCN 7-6, SRF 1-18

BUFFER_POOL_RECYCLE, SCN 7-6, SRF 1-19

case significance in filenames, SRF 1-3

changes in Oracle8i, MIG B-1

COMMIT_POINT_STRENGTH, SRF 1-19

compatibility, MIG B-8

DB_DOMAIN, MIG B-9

DML_LOCKS, MIG B-9

LOG_CHECKPOINT_TIMEOUT, MIG B-9

O7_DICTIONARY_ACCESSIBILITY, MIG B-9

SORT_AREA_SIZE, MIG B-8

SORT_DIRECT_WRITES, MIG B-8

COMPATIBLE, MIG 9-2, SBY 5-9, SCN 3-11, SRF 1-20

CONTROL_FILE_RECORD_KEEP_TIME, SRF 1-21

CONTROL_FILES, RMN 6-12, SBR 6-13, SBY 2-19, SBY 5-2, SBY 5-9, SRF 1-21

for primary and standby databases, SBY 2-19

CORE_DUMP_DEST, SRF 1-22

CPU_COUNT, SRF 1-22, STU 24-17

CREATE_BITMAP_AREA_SIZE, SRF 1-22

CURSOR_SHARING, SRF 1-23

CURSOR_SPACE_FOR_TIME, SRF 1-23

database creation, SRF 1-32

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

DB_BLOCK_CHECKING, SRF 1-25

DB_BLOCK_CHECKSUM, SRF 1-26

DB_BLOCK_MAX_DIRTY_TARGET, SRF 1-27

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

DB_DOMAIN, SRF 1-28

DB_FILE_DIRECT_IO_COUNT, SRF 1-29

DB_FILE_MULTIBLOCK_READ_COUNT, SRF 1-30, STU 4-26, STU 4-59

DB_FILE_NAME_CONVERT, SBY 2-20, SBY 2-21, SBY 5-2, SBY 5-9, SRF 1-31

for primary and standby databases, SBY 2-19

DB_FILES, SBY 5-9, SCN 7-17, SRF 1-31

DB_NAME, SBY 5-9, SCN 363, SRF 1-32

DB_WRITER_PROCESSES, SCN 1-17, SRF 1-33

DBLINK_ENCRYPT_LOGIN, SRF 1-34

DBWR_IO_SLAVES, SRF 1-34

derived, SRF 1-10

DISK_ASYNCH_IO, SRF 1-35

display current settings, SRF 1-9

displaying values, PSA 1-6

DISTRIBUTED_TRANSACTIONS, SCN 8-12, SRF 1-35

DML_LOCKS, ADG 7-11, SRF 1-36

duplicate values, PSA 1-3

dynamic, SRF 1-6

editing, REP 3-36

ENQUEUE_RESOURCES, SRF 1-37

EVENT, SRF 1-37

FAST_START_IO_TARGET, SCN 354, SRF 1-38

FAST_START_PARALLEL_ROLLBACK, SRF 1-39, STU 24-17

files, SRF 1-1

FIXED_DATE, SRF 1-39

for primary and standby databases, SBY 2-19

GC parameters, SRF 1-10

GC_DEFER_TIME, SRF 1-39

GC_FILES_TO_LOCKS, SRF 1-40

GC_RELEASABLE_LOCKS, SRF 1-41

GC_ROLLBACK_LOCKS, SRF 1-42

global cache, SRF 1-10

global constant, PSA 1-9

global constant parameters, SRF 1-10

GLOBAL_NAMES, SRF 1-43

HASH_AREA_SIZE, SRF 1-43, STU 4-54

HASH_JOIN_ENABLED, SRF 1-44, STU 4-53

HASH_MULTIBLOCK_IO_COUNT, SRF 1-44, STU 4-54

HI_SHARED_MEMORY_ADDRESS, SCN 7-14, SRF 1-45

HS_AUTOREGISTER, SRF 1-45

identical, PSA 3-2

identical for all instances, PSA 1-8

IFILE, SRF 1-4, SRF 1-45

in Oracle Trace, STU 14-22

INIT_SQL_FILES, SRF 5-2

INSTANCE_GROUPS, SRF 1-46

INSTANCE_NAME, SRF 1-47

JAVA_POOL_SIZE, SRF 1-48

JOB_QUEUE_INTERVAL, REP 2-23, SRF 1-49

JOB_QUEUE_PROCESSES, REP 2-23, SCN 76, SRF 1-50

LARGE_POOL_SIZE, SRF 1-50

parallel execution allocation, MIG B-10

LICENSE_MAX_SESSIONS, SCN 299, SRF 1-51

LICENSE_MAX_USERS, SRF 1-51

LICENSE_SESSIONS_WARNING, SCN 299, SRF 1-52

LM_LOCKS, SRF 1-52

LM_RESS, SRF 1-53

LOCAL_LISTENER, SRF 1-54

LOCK_NAME_SPACE, SBY 5-2, SBY 5-9, SRF 1-54

LOCK_SGA, SCN 7-14, SCN 7-18, SRF 1-55

LOG_ARCHIVE_BUFFER_SIZE, SAD 7-21, SAD 7-22

LOG_ARCHIVE_BUFFERS, SAD 7-21, SAD 7-22

LOG_ARCHIVE_DEST, SBR 2-21, SBR 5-6, SBR 5-9, SBR 5-27, SBR 5-30, SBY 3-4, SRF 1-55

LOG_ARCHIVE_DEST_n, SRF 1-56

LOG_ARCHIVE_DEST_n, SAD 7-10, SBR 2-21, SBR 5-6, SBR 5-9, SBY 3-4, SBY 5-7, SBY 5-9

LOG_ARCHIVE_DEST_STATE_n, SRF 1-57

LOG_ARCHIVE_DEST_STATE_n, SAD 7-12, SBY 2-18

LOG_ARCHIVE_DUPLEX_DEST, SBR 2-21, SRF 1-58

LOG_ARCHIVE_FORMAT, SBR 5-6, SBR 5-9, SBY 5-7, SRF 1-58

LOG_ARCHIVE_MAX_PROCESSES, SAD 7-20, SCN 1-18, SCN 8-13, SCN 360, SRF 1-59

LOG_ARCHIVE_MIN_SUCCEED_DEST, SAD 7-16, SRF 1-60

LOG_ARCHIVE_START, SAD 7-8, SAD 7-14, SBY 5-18, SCN 360, SRF 1-61

LOG_ARCHIVE_TRACE, SAD 7-25, SBY 4-6, SRF 1-62

LOG_BLOCK_CHECKSUM, SAD 6-17

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

LOG_CHECKPOINT_INTERVAL, SCN 354, SRF 1-63, STU 24-5

LOG_CHECKPOINT_TIMEOUT, SCN 354, SRF 1-64, STU 24-4

LOG_CHECKPOINTS_TO_ALERT, SRF 1-65

LOG_FILE_NAME_CONVERT, SBY 5-2, SBY 5-18, SRF 1-65

LOG_FILES, SAD 6-10

MAX_COMMIT_PROPAGATION_DELAY, SRF 1-66

MAX_DUMP_FILE_SIZE, SRF 1-67, STU 6-4

MAX_ENABLED_ROLES, SRF 1-67

MAX_ROLLBACK_SEGMENTS, SRF 1-68

MTS_CIRCUITS, SRF 1-68

MTS_DISPATCHERS, SRF 1-68

MTS_MAX_DISPATCHERS, SRF 1-71

MTS_MAX_SERVERS, SCN 8-20, SCN 8-21, SRF 1-72

MTS_SERVERS, SCN 8-20, SRF 1-72

MTS_SESSIONS, SRF 1-73

multiple instance issues regarding, PSA 1-10

multi-threaded server and, SAD 4-5

NLS_CALENDAR, SRF 1-73

NLS_COMP, SRF 1-74

NLS_CURRENCY, SRF 1-75

NLS_DATE_FORMAT, SRF 1-75

NLS_DATE_LANGUAGE, SRF 1-76

NLS_ISO_CURRENCY, SRF 1-76

NLS_LANGUAGE, SCN 11-20, SRF 1-77

NLS_NUMERIC_CHARACTERS, SCN 12-9, SRF 1-78

NLS_SORT, SCN 11-20, SRF 1-78

NLS_TERRITORY, SRF 1-79

NLS_UNION_CURRENCY, SRF 1-76

O7_DICTIONARY_ACCESSIBILITY, SRF 1-79

OBJECT_CACHE_MAX_SIZE_PERCENT, SRF 1-80

OBJECT_CACHE_OPTIMAL_SIZE, SRF 1-81

obsolete in Oracle8i, MIG B-6

OPEN_CURSORS, ADG 7-9, SCN 7-9, SCN 15, SRF 1-81

OPEN_LINKS, REP 2-15, SCN 7-17, SRF 1-82

OPEN_LINKS_PER_INSTANCE, SRF 1-82

operating system dependent values, SRF 1-10

OPTIMIZER_FEATURES_ENABLE, STU 4-23, STU 4-24, STU 4-78, STU 4-87

OPTIMIZER_INDEX_CACHING, SRF 1-84

OPTIMIZER_INDEX_COST_ADJ, SRF 1-85

OPTIMIZER_MAX_PERMUTATIONS, SRF 1-85

OPTIMIZER_MODE, SRF 1-86, STU 4-10, STU 4-34, STU 7-6

OPTIMIZER_PERCENT_PARALLEL, SCN 131, SRF 1-86, STU 4-9

ORACLE_TRACE_COLLECTION_NAME, SRF 1-87

ORACLE_TRACE_COLLECTION_PATH, SRF 1-88

ORACLE_TRACE_COLLECTION_SIZE, SRF 1-88

ORACLE_TRACE_ENABLE, SRF 1-88

ORACLE_TRACE_FACILITY_NAME, SRF 1-89

ORACLE_TRACE_FACILITY_PATH, SRF 1-90

OS_AUTHENT_PREFIX, SRF 1-90

OS_ROLES, SRF 1-91

overview, SRF 1-1

PARALLEL_ADAPTIVE_MULTI_USER, SRF 1-91

PARALLEL_AUTOMATIC_TUNING, SRF 1-92

PARALLEL_BROADCAST_ENABLED, SRF 1-93

PARALLEL_EXECUTION_MESSAGE_SIZE, SRF 1-93

PARALLEL_INSTANCE_GROUP, SRF 1-94

PARALLEL_MAX_SERVERS, REP 2-37, SCN 164, SRF 1-94, STU 24-15

PARALLEL_MIN_PERCENT, SCN 175, SRF 1-95

PARALLEL_MIN_SERVERS, REP 2-37, SCN 163, SCN 165, SRF 1-96

PARALLEL_SERVER, SCN 5-7, SRF 1-96

PARALLEL_SERVER_INSTANCES, SRF 1-96

PARALLEL_THREADS_PER_CPU, SRF 1-97

PARTITION_VIEW_ENABLED, SRF 1-97

performance tuning, SRF 1-10

planning LM capacity, PSA 10-3

PLSQL_V2_COMPATIBILITY, SRF 1-98

PRE_PAGE_SGA, SRF 1-98, STU 19-5

PROCESSES, SRF 1-99

QUERY_REWRITE_ENABLED, SRF 1-99

READ_ONLY_OPEN_DELAYED, SRF 1-101

RECOVERY_PARALLELISM, SBR 5-19, SRF 1-101, STU 24-15

REMOTE_DEPENDENCIES_MODE, ADG 9-35, SCN 117, SRF 1-102

REMOTE_LOGIN_PASSWORDFILE, SRF 1-102

REMOTE_OS_AUTHENT, SRF 1-103

REMOTE_OS_ROLES, SRF 1-103

renamed in Oracle8i, MIG B-4

replication, REP 7-3

REPLICATION_DEPENDENCY_TRACKING, SRF 1-104

RESOURCE_LIMIT, SRF 1-104

RESOURCE_MANAGER_PLAN, SAD 25-18, SRF 1-105

REWRITE_INTEGRITY, SRF 1-100

rollback segments, SRF 1-120

ROLLBACK_SEGMENTS, SCN 4-28, SRF 1-105

ROW_LOCKING, ADG 7-11, SRF 1-106

SERIAL_REUSE, SRF 1-107

SERIALIZABLE, ADG 7-11

SERVICE_NAMES, SCN 6-6, SRF 1-107

SESSION_CACHED_CURSORS, SRF 1-108, STU 19-20

SESSION_MAX_OPEN_FILES, SRF 1-108

SESSIONS, SRF 1-109

setting for multiple instances, PSA 1-7

SHADOW_CORE_DUMP, SRF 1-110

SHARED_MEMORY_ADDRESS, SCN 7-14, SRF 1-110

SHARED_POOL_RESERVED_SIZE, SRF 1-111, SRF 3-103

SHARED_POOL_SIZE, SCN 7-7, SCN 7-13, SRF 1-111

parallel execution allocation, MIG B-10

SKIP_UNUSABLE_INDEXES, SCN 114

SORT_AREA_RETAINED_SIZE, SCN 7-17, SRF 1-112

SORT_AREA_SIZE, SCN 4-20, SCN 7-17, SRF 1-112, STU 4-59

SORT_MULTIBLOCK_READ_COUNT, SRF 1-113

specifying in parameter files, SRF 1-2

SQL_TRACE, SCN 8-15, SRF 1-114, STU 6-5

SQL92_SECURITY, SRF 1-114

STANDBY_ARCHIVE_DEST, SBY 2-21, SBY 5-9, SRF 1-115

STAR_TRANSFORMATION_ENABLED, SRF 1-116

that must be identical on all instances, PSA 1-8

that must be unique on all instances, PSA 1-8

THREAD, SRF 1-117

TIMED_OS_STATISTICS, SRF 1-117

TIMED_STATISTICS, SRF 1-118, STU 6-4

TRANSACTION_AUDITING, SRF 1-119

TRANSACTIONS, SCN 4-28

TRANSACTIONS_PER_ROLLBACK_SEGMENT, SCN 4-28, SRF 1-120

USE_INDIRECT_DATA_BUFFERS, SCN 7-14, SRF 1-120

USER_DUMP_DEST, SBY 4-6, SRF 1-121, STU 6-4

using default value, PSA 1-9

UTL_FILE_DIR, SRF 1-121

variable, SRF 1-10

initialize functions, OCI 15-90

initialized

checking if BFILE LOB locator is, ADL 11-160

initializing

BFILE column or locator variable using BFILENAME(), ADL 11-25

BLOB attribute using EMPTY_BLOB() FAQ, ADL 6-8

during CREATE TABLE or INSERT, ADL 9-24

external LOBs, ADL 2-6

internal LOBs, See LOBs

internal LOBs

using EMPTY_CLOB(), EMPTY_BLOB()

INITIALLY DEFERRED clause

of constraint_clause, SQL 7-243

initially deferred constraints, SCN 274

INITIALLY IMMEDIATE clause

of constraint_clause, SQL 7-243

initially immediate constraints, SCN 274

INITJVM.SQL script, SRF 5-8

initNLDAP.ora, OID B-9

INIT.ORA file. See initialization parameter file

INIT.ORA Parameter, ADQ 2-7

INIT.ORA parameters. See initialization parameters

INIT.ORA. See initialization parameter file.

INITRANS parameter, ADG 7-25

of ALTER CLUSTER, SQL 7-4

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

of ALTER MATERIALIZED VIEW, SQL 7-49

of ALTER MATERIALIZED VIEW LOG, SQL 7-58

of CREATE CLUSTER, SQL 7-256

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

INITRANS storage parameter

altering, SAD 13-12

guidelines for setting, SAD 12-7

initsid.ora file

creating, PSG 3-12, PSG 3-36

described, PSG 1-14, PSG 4-4

IFILE parameter, PSG 4-5

INSTANCE_NAME parameter, PSG 1-15, PSG 1-16, PSG 4-5

LOG_ARCHIVE_DEST parameter, PSG 4-11

REMOTE_LOGIN_PASSWORDFILE parameter, PSG 4-5

ROLLBACK_SEGMENTS parameter, PSG 1-16, PSG 4-5

THREAD parameter, PSG 1-16, PSG 4-5

initsid.ora, modifying, OID 10-5

inline views, SCN 10-17

example, SCN 10-17

IN-list iterators

optimizer use of, SRF 1-84

IN-lists, STU 7-13, STU 7-17

inner capture, ADO 2-7

input file, creating, OID 5-13

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

INSERT

functionality, DWG 18-59

processing within Oracle, PSA 6-4

INSERT ANY TABLE system privilege, SQL 7-527

INSERT command

column values and triggers, ADG 13-16

read consistency, ADG 7-11

insert errors

Import, SUT 2-46

specifying, SUT 6-5

INSERT into table

SQL*Loader, SUT 5-32

INSERT object privilege, SQL 7-535

insert of no rows

cause of, PC_ 9-20

INSERT privilege, ADG 11-22

granting, SAD 23-12

revoking, SAD 23-14

INSERT privilege for object tables, ADO 2-12, ADO 2-13

INSERT SQL statement, PC_ F-67

examples, PC_ F-70

INSERT statement, PCO F-55, SCN 12, SQL 7-539

INSERT statements

binds of greater than 4000 bytes, ADL 7-16

insertBefore(Node, Node) - oracle.xml.parser.v2.XMLNode.insertBefore(org.w3c.dom.Node, org.w3c.dom.Node), JPR 4-111

inserting

a row by initializing a LOB locator

internal persistent LOBs, ADL 9-29

a row by initializing BFILE locator, ADL 11-34

a row by selecting a LOB from another table

internal persistent LOBs, ADL 9-27

a row containing a BFILE, ADL 11-23

a row containing a BFILE by selecting BFILE from another table, ADL 11-32

a row using BFILENAME(), ADL 11-24

binds of more than 4,000 bytes, ADL 9-22

LOB value using EMPTY_CLOB()/EMPTY_BLOB()

internal persistent LOBs, ADL 9-23

one or more LOB values into a row, ADL 9-21

rows into tables and views, PC_ F-67, PCO F-55

INSERTS

concurrent, PSA 8-4

free lists, PSA 1-6

free space unavailable, PSA 8-9

inserts

locating free space, SRF 1-47

performance, PSC 7-19

piecewise, OCI 5-37, OCI 5-39

INST_ID column, SRF 3-2

inst_init_ora parameter, PSG B-5, PSG B-7

inst_oracle_sid parameter, PSG B-4, PSG B-6

inst_sid_list parameter, PSG C-4

installation

installation directory

naming conventions, DCI 2-6

installation errors, OID C-2

installation of data cartridge, DCI 2-4

installation requirements, PSG 2-2 to PSG 2-5

disk space, PSG 2-5

hardware, PSG 2-2

hardware requirements, PSG 2-2

Oracle Enterprise Manager, PSG 2-3

shared disk partitions, PSG 2-5

installation type

installing

Advanced Symmetric Replication (ASR), OID 10-3

Directory Replication Groups (DRGs), OID 10-2

key of server, OAS 13-2

Operating System Dependent layer, PSG 2-11, PSG 9-5

Oracle Enterprise Manager, PSG 6-9

Oracle Parallel Server, PSG 3-3

with Custom installation type, PSG 3-5

with Typical installation type, PSG 3-5

Oracle8i Enterprise Edition, PSG 3-3

with Oracle Universal Installer, PSG 3-3

instance

affinity, for jobs, PSC A-6

instance affinity for jobs, GTK 3-63

DBMS_JOB package, GTK 3-63

INSTANCE clause

of ALTER TABLE

allocating extents, SRF 1-47

instance failure, SBR 1-12, SBR 1-13

instance groups for parallel operations, SCN 175

instance name, PSG 1-15, PSG 1-16

Instance Name field, NET 8-9

instance number, PSC 7-23

INSTANCE option

allocating, PSA 8-12

SET INSTANCE command, PSA 8-8

SHOW INSTANCE command, PSA 4-4

INSTANCE parameter

of ALTER SESSION, SQL 7-88

instance recovery, SCN 344

access to files, PSC 7-3

instance failure, SCN 1-45, SCN 344

read-only tablespaces, SCN 346

rollback segments, PSC 7-6

SMON process, SCN 1-17, SCN 8-11, SCN 198

See also crash recovery

instance registration, PSC A-12

INSTANCE_GROUPS initialization parameter, SRF 1-46

INSTANCE_GROUPS parameter, PSA 2-3

INSTANCE_ID column, PSA 12-9

INSTANCE_NAME initialization parameter, MIG F-12, SRF 1-47

INSTANCE_NAME parameter, NET 2-32, NET 6-3, NET 8-9, NET C-46, NET C-87, PSG 1-15, PSG 1-16, PSG 3-18, PSG 4-5

instance_num event attribute, ADG 14-3

INSTANCE_NUMBER

as determined by startup order, PSA 1-6

INSTANCE_NUMBER initialization parameter

exclusive or parallel mode, SRF 1-47

INSTANCE_NUMBER parameter, PSA 1-8, PSA 8-8

and SQL options, PSC 7-24

assigning free lists to instances, PSC 7-23

exclusive mode, PSA 1-6

exclusive or shared mode, PSA 1-6

recommended settings for, PSA 1-6

setting, PSA 8-11

setting for freelist groups, PSA 6-6

unique values for instances, PSA 1-6, PSA 1-10

unspecified, PSA 1-6

instances, PLS 9-4, SCN 1-4

aborting, SAD 3-13, SCN 5-10, SCN 344

acquire rollback segments, SCN 4-28

adding, PSA 5-16

adding instances, PSA 3-3, PSA 8-11

adding to cluster, PSG 9-7

affinity, PSA 5-17

associated with data block, PSC 7-24

associated with data file, PSA 8-11

associated with extent, PSA 8-8

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

checkpoint, SRF 1-63

control files, PSG 1-3

current, PSA 4-4, PSA 13-14

data files, PSG 1-3

db_name.conf file, PSG B-6

defined, PSG 1-2, SCN 1-14

described, SCN 5-2

Destination Type tasks for, PSG 7-23

diagrammed, SCN 8-6

failure, PSA 14-3

failure in, SCN 1-45, SCN 344

free list, PSA 8-9

global name resolution for, SQL 7-110

initialization parameter files, PSG 4-4 to PSG 4-9

initsid.ora file, PSG 1-14

instance groups, SCN 175

instance name, PSG 1-15, PSG 1-16

instance number, PSA 8-11, PSC 7-20

INSTANCE_NAME parameter, PSG 1-15, PSG 1-16

maximum number, PSA 3-3, PSC 7-6, PSC 7-21

memory structures of, SCN 7-2

multiple-process, SCN 8-2

number, PSA 8-8

Oracle Parallel Server Management, PSG 7-2

Oracle System Identifier (SID), PSG 1-15

ORACLE_SID environment variable, PSG 1-15

ORACLE_SID registry entry, PSG 1-15

overview of, SCN 1-4

ownership of PCM locks, PSC 5-17

process structure, SCN 8-2

recovery, PSA 3-3, PSA 4-5, PSA 14-2, PSC 9-15

recovery of, SCN 5-11, SCN 344

fast-start checkpointing, SCN 354

opening a database, SCN 5-9

SMON process, SCN 8-11

recovery, abnormal shutdown, PSA 4-5

recovery, access to files, PSA 14-4

recovery, global checkpoint, PSA 13-14

recovery, multiple failures, PSA 14-3

recovery, starting another instance, PSA 3-3

remote, PSA 1-4, PSA 1-5, PSA 4-4

restricted mode, SCN 5-6

rollback segment required, PSC 7-6

rollback segments, PSG 1-16

ROLLBACK_SEGMENTS parameter, PSG 1-16

scalability, PSA 5-16

service names, SCN 6-6

setting parameters for, SQL 7-108

sharing databases, SCN 1-4

shutting down, SCN 5-10, SCN 5-11

audit record, SCN 333

shutting down immediately, SAD 3-12

SID, PSG 1-15, PSG 4-4

SID Prefix, PSG 3-4, PSG 3-27

starting, SCN 5-5

audit record, SCN 333

starting up, SAD 3-2 to SAD 3-7

startup and shutdown results, PSG 7-12, PSG 7-17

startup order, PSA 1-6, SRF 1-47

system identifiers (SIDs), SCN 6-6

thread ID, PSG 1-16

thread number, PSA 1-7, PSA 3-7, PSC 7-3

THREAD parameter, PSG 1-16

verifying, PSG 3-42

virtual memory, SCN 7-18

INSTANCES keyword

removed from PARALLEL clause, MIG 9-35

INSTANCES parameter (Oracle Version 6), PSC A-23

instance-specific parameter files, PSA 1-2

conditions requiring, PSA 1-3

instantiation, RAR 4-17, SCN 431

offline, RAR 4-11

refresh after, RAR 4-18

script, RAR 4-15

INSTEAD OF clause

of CREATE TRIGGER, SQL 7-429

INSTEAD OF trigger, GTK 4-15

INSTEAD OF triggers, ADG 13-7, SCN 93, SQL 7-429

nested tables, ADO 5-11, SCN 14-5

object views, SCN 14-5

on nested table view columns, ADG 13-16

INSTR function, SQL 4-38

INSTRB function, SQL 4-39

insufficient memory, OID 13-8

INT datatype (ANSI), SQL 2-28

INT keyword

behavior in Oracle7 and Oracle8i, MIG 9-23

INT subtype, PLS 2-14

intchg.ora file, MIG F-17

INTEGER

external datatype, OCI 3-11

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

ANSI, SQL 2-28

DB2, SQL 2-29

EXTERNAL format, SUT 5-67

SQL/DS, SQL 2-29

INTEGER subtype, PLS 2-14

integers

generating unique, SQL 7-371

in SQL syntax, SQL 2-3

precision of, SQL 2-3

specifying, SQL 2-17

syntax of, SQL 2-3

Integrated Distributed Lock Manager

internalized, PSC A-9

integrity constraints

See also constraints

integrity checking, RMN 1-66

integrity constraints, SCN 252

application uses, ADG 4-2

clusters and, ADG 5-16

default column values and, SCN 10-9

defining, ADG 4-17

disabled during direct path load, SUT 8-21

disabling, ADG 4-19, ADG 4-20, ADG 4-21

effects on indexes, SAD 14-8

dropping, ADG 4-24

effects on indexes, SAD 14-8

dropping and disabling, SAD 14-8

dropping tablespaces and, SAD 9-23

enabled during direct path load, SUT 8-21

enabling, ADG 4-19

enabling when violations exist, ADG 4-20

examples, ADG 4-2

exceptions to, ADG 4-22

failed on Import, SUT 2-45

listing definitions of, ADG 4-27

load method, SUT 8-9

naming, ADG 4-18

ORA-02055

constraint violation, DDS 3-3

Oracle Version 6 export files, SUT 2-62

performance considerations, ADG 4-3

privileges required for creating, ADG 4-18

reenabled after direct path load, SUT 8-21

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

violations, ADG 4-20

when to disable, ADG 4-19

when to use, ADG 4-2

See also constraints

integrity constraints. See constraints

integrity rules, SCN 1-21

parallel DML restrictions, SCN 202

interactive block execution, ADG 9-50

interactive method

Export, SUT 1-37

interconnect, PSA 5-3

and scalability, PSC 8-11

as a cluster component, PSC 2-2

definition of, PSC 2-4

high-speed, PSC 4-2

latency, PSC 2-7

protocols for OPS, PSA 12-5

redundancy of, PSC 9-6

interface

native, PC_ 5-55

XA, PC_ 5-55

Interface - javax.jms.BytesMessage, ADQ B-20

Interface - javax.jms.Connection, ADQ B-22

Interface - javax.jms.ConnectionFactory, ADQ B-23

Interface - javax.jms.ConnectionMetaData, ADQ B-24

Interface - javax.jms.DeliveryMode, ADQ B-25

Interface - javax.jms.MapMessage, ADQ B-27

Interface - javax.jms.Message, ADQ B-28

Interface - javax.jms.MessageConsumer, ADQ B-29

Interface - javax.jms.MessageListener, ADQ B-30

Interface - javax.jms.MessageProducer, ADQ B-31

Interface - javax.jms.ObjectMessage, ADQ B-32

Interface - javax.jms.Queue, ADQ B-33

Interface - javax.jms.QueueBrowser, ADQ B-34

Interface - javax.jms.QueueConnection, ADQ B-35

Interface - javax.jms.QueueConnectionFactory, ADQ B-36

Interface - javax.jms.QueueReceiver, ADQ B-37

Interface - javax.jms.QueueSender, ADQ B-38

Interface - javax.jms.QueueSession, ADQ B-39

Interface - javax.jms.Session, ADQ B-40

Interface - javax.jms.StreamMessage, ADQ B-41

Interface - javax.jms.TextMessage, ADQ B-43

Interface - javax.jms.Topic, ADQ B-44

Interface - javax.jms.TopicSession, ADQ B-48

Interface - javax.jms.TopicSubscriber, ADQ B-49

Interface - oracle.AQ.AQQueueTable, ADQ B-93

Interface - oracle.jms.AdtMessage, ADQ B-57

Interface - oracle.jms.AQjmsConnectionMetadata, ADQ B-68

Interface - oracle.jms.AQjmsConsumer, ADQ B-70

Interface - oracle.jms.AQjmsQueueReceiver, ADQ B-58

Interface - oracle.jms.AQjmsQueueSender, ADQ B-59

Interface - oracle.jms.AQjmsTopicPublisher, ADQ B-60

Interface - oracle.jms.AQjmsTopicReceiver, ADQ B-63

Interface - oracle.jms.AQjmsTopicSubscriber, ADQ B-62

Interface - oracle.jms.TopicReceiver, ADQ B-61

interfaces

data cartridge, DCI 1-14

DBMS, DCI 1-14

extensibility, DCI 1-13

service, DCI 1-14

interfaces for LOBs, see programmatic environments

Interfaces, Classes, and Exceptions, ADQ B-2

inter-language calls, PLS 7-44

Inter-Language Method Services (ILMS), SCN 29

interMedia

migrating from ConText to, MIG 4-7, MIG 5-6

interMedia, GTK 2-6

Audio, Image, and Video, GTK 3-8

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

Locator, GTK 3-9

Text, GTK 3-6

Web based tools, GTK 3-3

INTERNAL

alternatives to, SAD 1-8

OSOPER and OSDBA, SAD 1-8

security for, SAD 21-8

internal codes for datatypes

datatype codes, OCI 3-5

INTERNAL connection, SCN 5-3

statement execution not audited, SCN 332

internal datatype

definition, PCO 2-8

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

conversions, OCI 3-21

definition of, PC_ 2-6

dynamic SQL method 4, PCO 11-15

new in Oracle8i, MIG E-2

INTERNAL date function

executing jobs and, SAD 8-8

Internal error (string) - error, ADQ D-4

internal errors tracked in trace files, SCN 8-15

internal LOB, DCI 6-2

internal LOBs, SQL 2-23

loading, SUT 5-98

INTERNAL option

instance shutdown, PSA 4-5

internal triggers, REP A-6

INTERNAL username

connecting for shutdown, SAD 3-10

internal write batch size, STU 20-45

International Standards Organization. See ISO

internationalization, and LDAP, OID 1-3, OID 11-1

internet, OAS 10-6

internet addressing

using UTL_INADDR, SPR 62-1

Internet Domain Service (DNS), OAS 12-4

Internet Engineering Task Force (IETF). See IETF.

Internet File System, GTK 3-3

Internet, and LDAP, OID 1-3

inter-node communication, PSC 4-2

interoperability, MIG 9-1, MIG 9-15

Advanced Queuing, MIG 9-32

applications, MIG 9-16

Heterogeneous Services agents, MIG 9-45

native dynamic SQL, MIG 9-30

OCI, MIG 9-18

Oracle7 clients, MIG 9-19

shared structures, MIG 9-18

PL/SQL, MIG 9-21

precompilers, MIG 9-20

UROWIDs, MIG 9-27

user-defined datatypes, MIG 9-29

inter-operator parallelism, SCN 169

interpreting RMAN error stacks, RMN 9-6

Inter-Process Communication (IPC)

described, PSG 1-5, PSC 6-5

interrupted loads

continuing with SQL*Loader, SUT 5-34

interrupting media recovery, SBR 5-14

INTERSECT operator

compound queries, STU 4-48

example, STU 4-93

optimizing view queries, STU 4-77

INTERSECT set operator, PLS 5-6, SQL 3-13, SQL 7-579

intersection tables, REP 3-15

Interval must be atleast (integer) seconds - error, ADQ D-4

INTO clause, PCO 5-2, PCO 6-34, 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-513

of FETCH DESCRIPTOR statement, PC_ F-62

of FETCH statement, PC_ F-59, PCO F-47, PCO F-50

of INSERT, SQL 7-540

of SELECT statement, PC_ F-105, PCO F-82

SELECT statement, PCO 5-8

used with FETCH instead of SELECT, PC_ 6-12

INTO host_variable clause

of CALL, SQL 7-227

INTO list, PLS 5-9

INTO TABLE statement

effect on bind array size, SUT 5-80

multiple statements with SQL*Loader, SUT 5-51

SQL*Loader, SUT 5-39

column names, SUT 5-47

discards, SUT 5-29

intra transaction recovery, STU 24-17

intra-operator parallelism, SCN 169

Introduction, PSG 1-1

introduction

to Oracle Parallel Server, 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 Class (string) - error, ADQ D-9

invalid data

Import, SUT 2-46

Invalid delivery mode (string) - error, ADQ D-2

Invalid Dequeue mode - error, ADQ D-4

Invalid Destination - error, ADQ D-5

invalid destination state

for archived redo logs, SAD 7-13

Invalid Navigation mode - error, ADQ D-5

Invalid object type

object must implement CustomDatum or SQLData interface - error, ADQ D-14

invalid objects

warning messages

during export, SUT 1-40

Invalid operation

Privileged message listener - error, ADQ D-15

Invalid payload type

Use dequeue - error, ADQ D-12

Invalid Payload type - error, ADQ D-6

Invalid Property value - error, ADQ D-4

Invalid Queue name - (string) - error, ADQ D-12

Invalid Queue specified - error, ADQ D-4

Invalid Queue Table name - (string) - error, ADQ D-12

Invalid Queue Type - error, ADQ D-12

Invalid recipient list - error, ADQ D-8

Invalid ReplyTo destination type - error, ADQ D-8

Invalid selector (string) - error, ADQ D-10

INVALID status, SCN 109

Invalid System property - error, ADQ D-7

Invalid System property type - error, ADQ D-9

Invalid Topic specified - error, ADQ D-5

invalid use

of precompiler preprocessor, PC_ 5-33

Invalid value for sequence deviation - error, ADQ D-9

Invalid value for wait_time - error, ADQ D-12

invalid views, ADG 2-20

Invalid Visibility value - error, ADQ D-14

INVALID_CURSOR exception, PLS 6-5

INVALID_NUMBER exception, PLS 6-5

invalidate() - oracle.security.ssl.OracleSSLSession.invalidate(), OAS F-39

invalidate() - oracle.security.ssl.SSLSocketSession.invalidate(), OAS F-50

invalidating

materialized views, DWG 8-34

invoker rights, GTK 3-79, PLS 7-29, SCN 49

advantages, PLS 7-30

name resolution, SCN 62

procedure security, SCN 310

supplied packages, SCN 311

versus definer rights, PLS 7-29

invoker rights clause

of ALTER JAVA, SQL 7-46

of CREATE FUNCTION, SQL 7-288

of CREATE JAVA, SQL 7-313

of CREATE PACKAGE, SQL 7-344

of CREATE PROCEDURE, SQL 7-353

of CREATE TYPE, SQL 7-188, SQL 7-441

invoker's rights stored procedures, ADG 11-10

invoker-rights

dynamic SQL, ADG 8-8

object types, ADO 6-29

invokers-rights clause

downgrading, MIG 13-33

invoking Export, SUT 1-9

direct path, SUT 1-44

I/O

I/O errors

effect on backups, RMN 1-47

IO Exception (string) - error, ADQ D-9

I/O subsystem

in capacity planning, OID 12-2, OID 12-6

sizing, OID 12-6

I/O throughput, maximizing, OID 12-7

iostat utility, OID 13-2

IOT. See index organized tables.

IOTs. See index-organized tables

IP address takeover (IPAT), OID 14-8

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

IPC protocol

KEY parameter, NET B-3

IPC, parameters for addresses, NET B-3

IPCs

and Cache Fusion, PSA 12-5

IRECLEN precompiler option, PCO 14-25

IS DANGLING predicate, PLS 9-33

IS NOT NULL operator, SQL 3-7

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

IS NULL operator, SQL 3-7

for testing NULL values, PCO 2-17

IS NULL predicate, SCN 10-9

is_alter_column event attribute, ADG 14-3

is_creating_nested_table event attribute, ADG 14-4

is_drop_column event attribute, ADG 14-4

is_servererror event attribute, ADG 14-4

ISDBA attribute, USERENV, ADG 11-43

ISO, SQL B - 1

compliance, PC_ xvii

standards, SQL v, SQL 1-2, SQL B - 1

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

composite foreign keys, SCN 266

ISO standard

date format, NLS 2-18, NLS 4-11

ISO week number, NLS 4-11

ISOLATION LEVEL

changing, ADG 7-25

SERIALIZABLE, ADG 7-25

isolation level

of transactions, STU 17-6

ISOLATION LEVEL READ COMMITTED clause

of SET TRANSACTION, SQL 7-603

ISOLATION LEVEL SERIALIZABLE clause

of SET TRANSACTION, SQL 7-603

isolation levels

choosing, SCN 223

read committed, SCN 218

setting, SCN 218, SCN 242

ISOLATION_LEVEL parameter

of ALTER SESSION, SQL 7-89

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

isten, ADQ 8-98

italic, defined, NET xx, PSG xxiii

itemExists(String) - oracle.jms.AQjmsMapMessage.itemExists(java.lang.String), JPR 2-93

iteration

scheme, PLS 3-10

versus recursion, PLS 7-43

iterative control, PLS 3-6

ITIME column

SYS.INCEXP table, SUT 1-52

IW date format element, SQL 2-46

IW format element, NLS 4-11

IY date format element, SQL 2-46

IY format element, NLS 4-11

IYY date format element, SQL 2-46

IYYY date format element, SQL 2-46