Oracle Database Master Index: I
10g Release 1 (10.1)

Shortcuts to Letters

Symbols

Numerals

Index Entries

i option (-input) (JPublisher User's Guide)

I variable in SQLDA

how value is set (Pro*C/C++ Precompiler Programmer's Guide)

purpose of (Pro*C/C++ Precompiler Programmer's Guide)

I/O

and SQL statements (Performance Tuning Guide)

asynchronous (Data Warehousing Guide)

contention (Performance Tuning Guide)

[subentry #2] (Performance Tuning Guide)

[subentry #3] (Performance Tuning Guide)

[subentry #4] (Performance Tuning Guide)

[subentry #5] (Performance Tuning Guide)

distributing (Administrator's Guide)

excessive I/O waits (Performance Tuning Guide)

monitoring (Performance Tuning Guide)

objects causing I/O waits (Performance Tuning Guide)

parallel execution (Data Warehousing Guide)

[subentry #2] (Data Warehousing Guide)

reading multiple blocks (Reference)

redo log files (Reference)

reducing (Performance Tuning Guide)

I/O errors

effect on backups (Backup and Recovery Advanced User's Guide)

ignoring during deletions (Backup and Recovery Advanced User's Guide)

[subentry #2] (Backup and Recovery Basics)

I/O operations

load balancing (High Availability Architecture and Best Practices)

IAF GET statement

example of using (Pro*C/C++ Precompiler Programmer's Guide)

in user exits (Pro*C/C++ Precompiler Programmer's Guide)

purpose of (Pro*C/C++ Precompiler Programmer's Guide)

specifying block and field names in (Pro*C/C++ Precompiler Programmer's Guide)

syntax for (Pro*C/C++ Precompiler Programmer's Guide)

IAF PUT statement

example of using (Pro*C/C++ Precompiler Programmer's Guide)

in user exits (Pro*C/C++ Precompiler Programmer's Guide)

purpose of (Pro*C/C++ Precompiler Programmer's Guide)

specifying block and field names in (Pro*C/C++ Precompiler Programmer's Guide)

syntax for (Pro*C/C++ Precompiler Programmer's Guide)

IANA character sets

mapping with ISO locales (Globalization Support Guide)

IAP in SQL*Forms

purpose of (Pro*C/C++ Precompiler Programmer's Guide)

iasobf (HTTP Server Administrator's Guide)

usage (HTTP Server Administrator's Guide)

iaspt.conf (HTTP Server Administrator's Guide)

IBM datatypes (Application Developer's Guide - Fundamentals)

IBM NetView/6000 (Administrator's Guide)

ICMP (Enterprise Manager Advanced Configuration)

ICX. See Intercartridge Exchange

ID column

PLAN_TABLE table (Performance Tuning Guide)

ID data type (OLAP DML Reference)

IDAP

[entry #2] (XML Developer's Kit Programmer's Guide)

architecture (XML DB Developer's Guide)

message (Streams Advanced Queuing User's Guide and Reference)

[subentry #2] (Streams Advanced Queuing User's Guide and Reference)

schema (Streams Advanced Queuing User's Guide and Reference)

[subentry #2] (Streams Advanced Queuing User's Guide and Reference)

transmitted over Internet (Streams Advanced Queuing User's Guide and Reference)

[subentry #2] (XML DB Developer's Guide)

IDE

[entry #2] (Pro*COBOL Precompiler Getting Started for Windows)

[entry #3] (Pro*COBOL Precompiler Getting Started for Windows)

defined (OLAP Application Developer's Guide)

IDE (integrated development environment) (Java Developer's Guide)

IDE, definition (XML Developer's Kit Programmer's Guide)

identd (HTTP Server Administrator's Guide)

identical hardware (High Availability Architecture and Best Practices)

identification

of a Source (OLAP Developer's Guide to the OLAP API)

IDENTIFIED BY clause

of ALTER ROLE. See CREATE ROLE

of CREATE DATABASE LINK (SQL Reference)

of SET ROLE (SQL Reference)

IDENTIFIED EXTERNALLY clause

of ALTER ROLE. See CREATE ROLE

of ALTER USER. See CREATE USER

of CREATE ROLE (SQL Reference)

of CREATE USER (SQL Reference)

IDENTIFIED GLOBALLY clause

of ALTER ROLE. See CREATE ROLE

of ALTER USER (SQL Reference)

of CREATE ROLE (SQL Reference)

of CREATE USER (SQL Reference)

identifiers

forming (PL/SQL User's Guide and Reference)

maximum length (PL/SQL User's Guide and Reference)

quoted (PL/SQL User's Guide and Reference)

scope rules (PL/SQL User's Guide and Reference)

identifiers, ORACLE

how to form (Pro*C/C++ Precompiler Programmer's Guide)

[subentry #2] (Pro*COBOL Precompiler Programmer's Guide)

identity management

centralized management with distributable tools (Security Guide)

components (Security Guide)

desired benefits (Security Guide)

infrastructure (Security Guide)

Oracle's infrastructure components (Security Guide)

seamless timely distribution (Security Guide)

security (Security Guide)

single sign-on (Security Guide)

sngle point of integration (Security Guide)

solution (Security Guide)

IdentityCheck (HTTP Server Administrator's Guide)

Identix authentication (Net Services Administrator's Guide)

[entry #2] (Net Services Reference Guide)

[entry #3] (Net Services Reference Guide)

ideographic writing systems, encoding (Globalization Support Guide)

IDEPTREE view (Reference)

IDispatch interface (COM Automation Feature Developer's Guide)

[entry #2] (COM Automation Feature Developer's Guide)

[entry #3] (COM Automation Feature Developer's Guide)

IDL (COM Automation Feature Developer's Guide)

idle wait events (Performance Tuning Guide)

SQL*Net message from client (Performance Tuning Guide)

IDLE_TIME parameter

of ALTER PROFILE (SQL Reference)

IDLE_TIMEOUT networking parameter (Net Services Reference Guide)

IDS_ARG procedure (Advanced Replication Management API Reference)

IEEE 754 floating-point compliance (JDBC Developer's Guide and Reference)

IEEE 754 standard for floating-point numbers (Application Developer's Guide - Fundamentals)

IEEE DOUBLE datatype (New Features Guide)

IEEE FLOAT datatype (New Features Guide)

IEEE754

floating-point arithmetic (SQL Reference)

Oracle conformance with (SQL Reference)

IF command (OLAP DML Reference)

used with DO and DOEND (OLAP DML Reference)

IF statement (PL/SQL User's Guide and Reference)

ELSE clause (PL/SQL User's Guide and Reference)

ELSIF clause (PL/SQL User's Guide and Reference)

syntax (PL/SQL User's Guide and Reference)

THEN clause (PL/SQL User's Guide and Reference)

IfDefine directive (HTTP Server Administrator's Guide)

IFILE initialization parameter (Heterogeneous Connectivity Administrator's Guide)

[entry #2] (Reference)

[entry #3] (Reference)

setting with ALTER SYSTEM (SQL Reference)

IFILTER procedure (Text Reference)

IfModule directive (HTTP Server Administrator's Guide)

[entry #2] (HTTP Server Administrator's Guide)

IFNONE keyword (OLAP DML Reference)

ignorable characters (Globalization Support Guide)

IGNORE

format column value (Text Application Developer's Guide)

[subentry #2] (Text Reference)

IGNORE parameter

Import utility (Utilities)

ignore SCN (Streams Replication Administrator's Guide)

IIOP, definition (XML Developer's Kit Programmer's Guide)

ILMS support

Scheduler (New Features Guide)

image

attributes (interMedia User's Guide)

Image Based Tab Attributes (HTML DB User's Guide)

image compression formats

ASCII (interMedia Reference)

BMPRLE (interMedia Reference)

DEFLATE (interMedia Reference)

DEFLATE-ADAM7 (interMedia Reference)

FAX3 (interMedia Reference)

FAX4 (interMedia Reference)

GIFLZW (interMedia Reference)

GIFLZW-INTERLACED (interMedia Reference)

HUFFMAN3 (interMedia Reference)

JPEG (interMedia Reference)

JPEG-PROGRESSIVE (interMedia Reference)

LZW (interMedia Reference)

LZWHDIFF (interMedia Reference)

NONE (interMedia Reference)

PACKBITS (interMedia Reference)

PCXRLE (interMedia Reference)

RAW (interMedia Reference)

SUNRLE (interMedia Reference)

TARGARLE (interMedia Reference)

image copies (Backup and Recovery Advanced User's Guide)

testing restore of (Backup and Recovery Basics)

image data examples

addressing globalization support issues (interMedia User's Guide)

image OCI C sample program (interMedia User's Guide)

PL/SQL

populating ORDImage objects with BFILE data (interMedia User's Guide)

populating ORDImage objects with HTTP data (interMedia User's Guide)

image formats

BMPF (interMedia Reference)

CALS (interMedia Reference)

FPIX (interMedia Reference)

GIFF (interMedia Reference)

JFIF (interMedia Reference)

PBMF (interMedia Reference)

PCXF (interMedia Reference)

PGMF (interMedia Reference)

PICT (interMedia Reference)

PNGF (interMedia Reference)

PNMF (interMedia Reference)

PPMF (interMedia Reference)

RASF (interMedia Reference)

Raw Pixel (interMedia Reference)

RPIX (interMedia Reference)

supported by GeoRaster (Spatial GeoRaster)

TGAF (interMedia Reference)

TIFF (interMedia Reference)

WBMP (interMedia Reference)

image formatting operators (interMedia Reference)

image maps (Application Developer's Guide - Fundamentals)

image processing operators (interMedia Reference)

ImagePath parameter (Platform Guide for Windows)

images

uploading (HTML DB User's Guide)

IMAGE_PREFIX substitution string (HTML DB User's Guide)

imaging support (New Features Guide)

imCompatibilityInit (interMedia Java Classes Reference)

imCompatibilityInit(OracleConnection) (interMedia Java Classes Reference)

IMExample Java sample application (interMedia User's Guide)

[entry #2] (interMedia User's Guide)

IMG function

of HTF package (PL/SQL Packages and Types Reference)

IMG procedure

of HTP package (PL/SQL Packages and Types Reference)

IMG2 procedure

of HTP package (PL/SQL Packages and Types Reference)

IMMEDIATE clause

of SET CONSTRAINTS (SQL Reference)

immediate constraints (Concepts)

immediate failover (Data Guard Broker)

IMMEDIATE mode (SQL*Plus User's Guide and Reference)

implementation class

database standard form (OLAP Application Developer's Guide)

implementation type (Data Cartridge Developer's Guide)

implementing business logic (Performance Tuning Guide)

implicit assignment and parameter passing for LOB columns (Application Developer's Guide - Large Objects)

implicit capture (Streams Concepts and Administration)

implicit connections (Pro*C/C++ Precompiler Programmer's Guide)

multiple (Pro*C/C++ Precompiler Programmer's Guide)

single (Pro*C/C++ Precompiler Programmer's Guide)

implicit conversion

CLOB and NCLOB (New Features Guide)

implicit conversion of CLOB to character type (Application Developer's Guide - Large Objects)

implicit cursors

attributes (PL/SQL User's Guide and Reference)

implicit data conversion (SQL Reference)

[entry #2] (SQL Reference)

[entry #3] (SQL Reference)

implicit datatype conversion (Globalization Support Guide)

[entry #2] (PL/SQL User's Guide and Reference)

effect on performance (PL/SQL User's Guide and Reference)

implicit declarations

cursor FOR loop record (PL/SQL User's Guide and Reference)

FOR loop counter (PL/SQL User's Guide and Reference)

implicit dereferencing (Application Developer's Guide - Object-Relational Features)

[entry #2] (Application Developer's Guide - Object-Relational Features)

[entry #3] (Concepts)

implicit describe (Oracle Call Interface Programmer's Guide)

implicit logons (Pro*COBOL Precompiler Programmer's Guide)

implicit savepoints (Application Developer's Guide - Workspace Manager)

implicit statement caching

definition of (JDBC Developer's Guide and Reference)

Least Recently Used (LRU) scheme (JDBC Developer's Guide and Reference)

implicit VARCHAR (Pro*COBOL Precompiler Programmer's Guide)

implies method (Java Developer's Guide)

Import

BUFFER parameter (Utilities)

character set conversion (Utilities)

[subentry #2] (Utilities)

COMMIT parameter (Utilities)

committing after array insert (Utilities)

COMPILE parameter (Utilities)

consolidated extents (Utilities)

CONSTRAINTS parameter (Utilities)

controlling size of rollback segments (Utilities)

creating

necessary privileges (Utilities)

necessary views (Utilities)

creating an index-creation SQL script (Utilities)

database optimizer statistics (Utilities)

databases (Platform Guide for Windows)

DATAFILES parameter (Utilities)

DESTROY parameter (Utilities)

disabling referential constraints (Utilities)

[subentry #2] (Utilities)

displaying online help (Utilities)

dropping a tablespace (Utilities)

errors importing database objects (Utilities)

example sessions (Utilities)

all tables from one user to another (Utilities)

selected tables for specific user (Utilities)

tables exported by another user (Utilities)

using partition-level Import (Utilities)

exit codes (Utilities)

export file

importing the entire file (Utilities)

listing contents before import (Utilities)

failed integrity constraints (Utilities)

FEEDBACK parameter (Utilities)

FILE parameter (Utilities)

FILESIZE parameter (Utilities)

FROMUSER parameter (Utilities)

FULL parameter (Utilities)

grants

specifying for import (Utilities)

GRANTS parameter (Utilities)

HELP parameter (Utilities)

IGNORE parameter (Utilities)

importing grants (Utilities)

importing objects into other schemas (Utilities)

importing rows (Utilities)

importing tables (Utilities)

INDEXES parameter (Utilities)

INDEXFILE parameter (Utilities)

INSERT errors (Utilities)

interactive mode (Platform Guide for Windows)

[subentry #2] (Platform Guide for Windows)

invalid data (Utilities)

invoking (Utilities)

LOG parameter (Utilities)

LONG columns (Utilities)

[subentry #2] (Utilities)

manually creating tables before import (Utilities)

manually ordering tables (Utilities)

materialized view logs (Advanced Replication)

NLS_LANG environment variable (Utilities)

object creation errors (Utilities)

online help (Utilities)

Oracle Streams (Streams Concepts and Administration)

[subentry #2] (Streams Replication Administrator's Guide)

[subentry #3] (Streams Replication Administrator's Guide)

parameter file (Utilities)

maximum size (Utilities)

parameter mode (Platform Guide for Windows)

[subentry #2] (Platform Guide for Windows)

parameter syntax (Utilities)

PARFILE parameter (Utilities)

partition-level (Utilities)

pattern matching of table names (Utilities)

preferred tools (Platform Guide for Windows)

preserving size of initial extent (Utilities)

read-only tablespaces (Utilities)

RECORDLENGTH parameter (Utilities)

records

specifying length (Utilities)

redirecting output to a log file (Utilities)

reducing database fragmentation (Utilities)

refresh error (Utilities)

remote operation (Utilities)

reorganizing tablespace during (Utilities)

replication check (Advanced Replication)

replication groups

offline instantiation and (Advanced Replication Management API Reference)

resource errors (Utilities)

restrictions

importing into own schema (Utilities)

RESUMABLE parameter (Utilities)

RESUMABLE_NAME parameter (Utilities)

RESUMABLE_TIMEOUT parameter (Utilities)

reusing existing datafiles (Utilities)

rows

specifying for import (Utilities)

ROWS parameter (Utilities)

schema objects (Utilities)

sequences (Utilities)

SHOW parameter (Utilities)

single-byte character sets (Utilities)

SKIP_UNUSABLE_INDEXES parameter (Utilities)

snapshot master table (Utilities)

snapshots (Utilities)

restoring dropped (Utilities)

specifying by user (Utilities)

specifying index creation commands (Utilities)

specifying the export file (Utilities)

STATISTICS parameter (Utilities)

status check (Advanced Replication Management API Reference)

storage parameters

overriding (Utilities)

stored functions (Utilities)

stored procedures (Utilities)

STREAMS_CONFIGURATION parameter (Streams Replication Administrator's Guide)

[subentry #2] (Streams Replication Administrator's Guide)

[subentry #3] (Utilities)

STREAMS_INSTANTIATION parameter (Streams Replication Administrator's Guide)

[subentry #2] (Streams Replication Administrator's Guide)

[subentry #3] (Utilities)

system objects (Utilities)

table name restrictions (Utilities)

table objects

import order (Utilities)

table-level (Utilities)

TABLES parameter (Utilities)

TABLESPACES parameter (Utilities)

TOID_NOVALIDATE parameter (Utilities)

TOUSER parameter (Utilities)

TRANSPORT_TABLESPACE parameter (Utilities)

TTS_OWNER parameter (Utilities)

tuning considerations (Utilities)

types of errors during (Utilities)

uniqueness constraints

preventing import errors (Utilities)

user access privileges (Utilities)

USERID parameter (Utilities)

VOLSIZE parameter (Utilities)

IMPORT command (OLAP DML Reference)

[entry #2] (OLAP DML Reference)

import considerations (Application Developer's Guide - Workspace Manager)

import file

examples of (Text Reference)

structure (Text Reference)

IMPORT from EIF command (OLAP DML Reference)

IMPORT from spreadsheet (OLAP DML Reference)

IMPORT from text command (OLAP DML Reference)

import operations

restricted mode and (Administrator's Guide)

Import procedure (Application Developer's Guide - Workspace Manager)

Import Text Data Wizard (HTML DB User's Guide)

Import Text Wizard (HTML DB User's Guide)

import utilities

about (Administrator's Guide)

Import utility

copying statistics (Performance Tuning Guide)

data copying (Upgrade Guide)

importing labeled data (Label Security Administrator's Guide)

importing policies (Label Security Administrator's Guide)

importing unlabeled data (Label Security Administrator's Guide)

requirements (Upgrade Guide)

user-defined types (Application Developer's Guide - Object-Relational Features)

with Oracle Label Security (Label Security Administrator's Guide)

with spatial indexes and data (Spatial User's Guide and Reference)

Import Wizard

preferred tools (Platform Guide for Windows)

import( ) method (interMedia Reference)

[entry #2] (interMedia Reference)

[entry #3] (interMedia Reference)

[entry #4] (interMedia Reference)

[entry #5] (interMedia Reference)

IMPORT/EXPORT

in XML DB (XML DB Developer's Guide)

importData(byte[ ] [ ] ) (interMedia Java Classes Reference)

[entry #2] (interMedia Java Classes Reference)

[entry #3] (interMedia Java Classes Reference)

importData(byte[ ] [ ], boolean) (interMedia Java Classes Reference)

importFrom procedure (Spatial GeoRaster)

importFrom( ) method (interMedia Reference)

[entry #2] (interMedia Reference)

[entry #3] (interMedia Reference)

[entry #4] (interMedia Reference)

[entry #5] (interMedia Reference)

[entry #6] (interMedia Reference)

importFrom( ) method (all attributes) (interMedia Reference)

importFrom(byte[ ] [ ], String, String, String) (interMedia Java Classes Reference)

[entry #2] (interMedia Java Classes Reference)

[entry #3] (interMedia Java Classes Reference)

importFrom(byte[ ] [ ], String, String, String, boolean) (interMedia Java Classes Reference)

importing

a change table (Data Warehousing Guide)

[subentry #2] (Data Warehousing Guide)

asynchronous change sets (Data Warehousing Guide)

asynchronous change tables (Data Warehousing Guide)

data into a source table (Data Warehousing Guide)

exported application files (HTML DB User's Guide)

tables (Application Developer's Guide - Expression Filter)

importing data (OLAP DML Reference)

controlling update frequency (OLAP DML Reference)

tracking names of objects (OLAP DML Reference)

tracking number of bytes (OLAP DML Reference)

tracking types of objects (OLAP DML Reference)

importing statistics (Text Application Developer's Guide)

IMPORTNODE function (PL/SQL Packages and Types Reference)

[entry #2] (PL/SQL Packages and Types Reference)

IMPORT_COLUMN_STATS procedure (PL/SQL Packages and Types Reference)

IMPORT_DATABASE_STATS procedure (PL/SQL Packages and Types Reference)

IMPORT_DICTIONARY_STATS procedure (PL/SQL Packages and Types Reference)

IMPORT_FIXED_OBJECTS_STATS procedure (PL/SQL Packages and Types Reference)

IMPORT_INDEX_STATS procedure (PL/SQL Packages and Types Reference)

IMPORT_MODEL procedure (PL/SQL Packages and Types Reference)

IMPORT_SCHEMA_STATS procedure (PL/SQL Packages and Types Reference)

IMPORT_SYSTEM_STATS procedure (PL/SQL Packages and Types Reference)

IMPORT_TABLE_STATS procedure (PL/SQL Packages and Types Reference)

Improved LOB Usability, Accessing LOBs Using SQL Character Functions (Application Developer's Guide - Large Objects)

improving default mapping (Data Provider for .NET Developer's Guide)

IMP_FULL_DATABASE role (SQL Reference)

[entry #2] (Security Guide)

[entry #3] (Security Guide)

assigning in Import (Utilities)

IN comparison operator (PL/SQL User's Guide and Reference)

IN condition (Application Developer's Guide - Object-Relational Features)

IN conditions (SQL Quick Reference)

[entry #2] (SQL Quick Reference)

[entry #3] (SQL Reference)

IN operator (OLAP DML Reference)

[entry #2] (OLAP DML Reference)

[entry #3] (OLAP DML Reference)

IN OUT parameter

of CREATE FUNCTION (SQL Reference)

of CREATE PROCEDURE (SQL Reference)

IN OUT parameter mode (Application Developer's Guide - Fundamentals)

[entry #2] (JDBC Developer's Guide and Reference)

[entry #3] (PL/SQL User's Guide and Reference)

[entry #4] (Pro*C/C++ Precompiler Programmer's Guide)

[entry #5] (Pro*COBOL Precompiler Programmer's Guide)

IN parameter

of CREATE function (SQL Reference)

of CREATE PROCEDURE (SQL Reference)

IN parameter mode (Application Developer's Guide - Fundamentals)

[entry #2] (JDBC Developer's Guide and Reference)

[entry #3] (PL/SQL User's Guide and Reference)

[entry #4] (Pro*C/C++ Precompiler Programmer's Guide)

[entry #5] (Pro*COBOL Precompiler Programmer's Guide)

in-degree (Spatial Topology and Network Data Models)

in-doubt transaction (Pro*C/C++ Precompiler Programmer's Guide)

[entry #2] (Pro*COBOL Precompiler Programmer's Guide)

in-doubt transactions (Administrator's Guide)

[entry #2] (Concepts)

after a system failure (Administrator's Guide)

automatic resolution (Administrator's Guide)

[subentry #2] (Administrator's Guide)

deciding how to handle (Administrator's Guide)

deciding whether to perform manual override (Administrator's Guide)

defined (Administrator's Guide)

definition (Services for Microsoft Transaction Server Developer's Guide)

forcing (SQL Reference)

forcing commit of (SQL Reference)

forcing rollback (SQL Reference)

[subentry #2] (SQL Reference)

JOB_QUEUE_PROCESSES initialization parameter (Services for Microsoft Transaction Server Developer's Guide)

manual resolution (Administrator's Guide)

manually committing (Administrator's Guide)

manually committing, example (Administrator's Guide)

manually overriding (Administrator's Guide)

[subentry #2] (Administrator's Guide)

manually overriding, scenario (Administrator's Guide)

manually rolling back (Administrator's Guide)

overview (Administrator's Guide)

pending transactions table (Administrator's Guide)

purging rows from data dictionary (Administrator's Guide)

[subentry #2] (Administrator's Guide)

recoverer process and (Administrator's Guide)

resolving (Services for Microsoft Transaction Server Developer's Guide)

rolling back (Administrator's Guide)

[subentry #2] (Administrator's Guide)

[subentry #3] (Administrator's Guide)

[subentry #4] (Administrator's Guide)

[subentry #5] (SQL Reference)

scheduling automatic recovery (Services for Microsoft Transaction Server Developer's Guide)

SCNs and (Administrator's Guide)

simulating (Administrator's Guide)

starting database job-queue processes (Services for Microsoft Transaction Server Developer's Guide)

tracing session tree (Administrator's Guide)

viewing (Services for Microsoft Transaction Server Developer's Guide)

viewing database links (Administrator's Guide)

in-hierarchy variables

in-line storage (Application Developer's Guide - Large Objects)

IN-list iterators

optimizer use of (Reference)

in-place variable (OLAP DML Reference)

inactive online redo log

loss of (Backup and Recovery Advanced User's Guide)

INAME

command-line option (SQL*Module for Ada Programmer's Guide)

INAME option

when a file extension is required (Pro*COBOL Precompiler Programmer's Guide)

[subentry #2] (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

INAME precompiler option (Pro*C/C++ Precompiler Programmer's Guide)

[entry #2] (Pro*COBOL Precompiler Programmer's Guide)

inbound links (Spatial Topology and Network Data Models)

getting link ID numbers (Spatial Topology and Network Data Models)

getting number of for node (Spatial Topology and Network Data Models)

INBOUND_CONNECT_TIMEOUT networking parameter (Net Services Reference Guide)

INBOUND_CONNECT_TIMEPUT_listener_name networking parameter (Net Services Administrator's Guide)

[entry #2] (Net Services Reference Guide)

incarnation of a database

changed (Data Guard Concepts and Administration)

[subentry #2] (Data Guard Concepts and Administration)

INCARNATION option

of LIST (Backup and Recovery Advanced User's Guide)

of RESET DATABASE (Backup and Recovery Advanced User's Guide)

incarnations

of databases (Concepts)

INCLUDE

[entry #2] (Universal Installer Concepts Guide)

precompiler option, use of (Pro*C/C++ Precompiler Programmer's Guide)

using to include the SQLCA (Pro*C/C++ Precompiler Programmer's Guide)

INCLUDE command (OLAP DML Reference)

[entry #2] (OLAP DML Reference)

INCLUDE CURRENT CONTROLFILE option

BACKUP command (Backup and Recovery Basics)

include directory (Oracle Call Interface Programmer's Guide)

INCLUDE option (Pro*C/C++ Precompiler Getting Started for Windows)

[entry #2] (Pro*COBOL Precompiler Getting Started for Windows)

[entry #3] (Pro*COBOL Precompiler Getting Started for Windows)

INCLUDE parameter

Data Pump Export utility (Utilities)

Data Pump Import utility (Utilities)

INCLUDE precompiler option (Pro*C/C++ Precompiler Programmer's Guide)

[entry #2] (Pro*COBOL Precompiler Programmer's Guide)

INCLUDE statement

case-sensitive operating systems (Pro*COBOL Precompiler Programmer's Guide)

declaring the ORACA (Pro*COBOL Precompiler Programmer's Guide)

declaring the SQLCA (Pro*COBOL Precompiler Programmer's Guide)

declaring the SQLDA (Pro*COBOL Precompiler Programmer's Guide)

effect of (Pro*COBOL Precompiler Programmer's Guide)

[subentry #2] (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

not like PL/I %INCLUDE directive (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

using to declare the ORACA (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

using to declare the SQLCA (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

using to declare the SQLDA (Pro*PL/1 Supplement to the Oracle Precompilers Guide)

INCLUDE statements (Pro*COBOL Precompiler Programmer's Guide)

includeSynonyms connection property (JDBC Developer's Guide and Reference)

INCLUDE_EXTRA_ATTRIBUTE procedure (Streams Concepts and Administration)

[entry #2] (Streams Concepts and Administration)

INCLUDE_EXTRA_ATTRIBUTES procedure (PL/SQL Packages and Types Reference)

INCLUDING CONTENTS clause

of DROP TABLESPACE (SQL Reference)

INCLUDING DATAFILES clause

of ALTER DATABASE TEMPFILE DROP clause (SQL Reference)

INCLUDING NEW VALUES clause

of ALTER MATERIALIZED VIEW LOG (SQL Reference)

of CREATE MATERIALIZED VIEW LOG (SQL Reference)

INCLUDING TABLES clause

of DROP CLUSTER (SQL Reference)

incompatibilities

checking for (Upgrade Guide)

incompatible data

Export/Import (Upgrade Guide)

incomplete media recovery (Backup and Recovery Advanced User's Guide)

definition (Concepts)

in Oracle Real Application Clusters configuration (Backup and Recovery Advanced User's Guide)

time-based (Backup and Recovery Advanced User's Guide)

with backup control file (Backup and Recovery Advanced User's Guide)

incomplete object types (Application Developer's Guide - Object-Relational Features)

[entry #2] (PL/SQL User's Guide and Reference)

[entry #3] (SQL Reference)

creating (SQL Reference)

[subentry #2] (SQL Reference)

incomplete recovery

[entry #2] (Concepts)

overview (Backup and Recovery Advanced User's Guide)

time-based (Backup and Recovery Advanced User's Guide)

using RMAN (Backup and Recovery Advanced User's Guide)

with current control file (Backup and Recovery Advanced User's Guide)

IncompleteSingleFeature

ABN model state (Data Mining Concepts)

inconsistent backups

incremental checkpoint (Concepts)

using RMAN (Backup and Recovery Basics)

whole database

definition (Concepts)

InconsistentProperties property (Data Guard Broker)

Incr Pool Size (Data Provider for .NET Developer's Guide)

increased scalability

benefits (Data Guard Broker)

INCREMENT BY clause

INCREMENT BY parameter

of CREATE SEQUENCE (SQL Reference)

incremental approach

in k-means (Data Mining Concepts)

incremental backups (Backup and Recovery Advanced User's Guide)

[entry #2] (Backup and Recovery Basics)

change-aware (New Features Guide)

differential (Backup and Recovery Advanced User's Guide)

[subentry #2] (Backup and Recovery Basics)

how RMAN applies (Backup and Recovery Advanced User's Guide)

using RMAN (Backup and Recovery Advanced User's Guide)

[subentry #2] (Backup and Recovery Advanced User's Guide)

incremental refresh (Concepts)

IND synonym for USER_INDEXES view (Reference)

index

about (Text Application Developer's Guide)

altering (Ultra Search User's Guide)

[subentry #2] (Ultra Search User's Guide)

collection (XML DB Developer's Guide)

creating (Text Application Developer's Guide)

[subentry #2] (Text Application Developer's Guide)

[subentry #3] (Text Reference)

creating a report on (Text Reference)

creating index script (Text Reference)

creation (Spatial User's Guide and Reference)

cross-schema (Spatial User's Guide and Reference)

parallel execution (Spatial User's Guide and Reference)

deferred updating (Spatial User's Guide and Reference)

describing (Text Reference)

description of Spatial indexing (Spatial User's Guide and Reference)

domain

creating (Data Cartridge Developer's Guide)

dropping (Text Application Developer's Guide)

duplicating with script (Text Reference)

geodetic and non-geodetic (Spatial User's Guide and Reference)

getting report on (Text Application Developer's Guide)

metadata for (Data Cartridge Developer's Guide)

optimizing (Text Application Developer's Guide)

[subentry #2] (Text Application Developer's Guide)

[subentry #3] (Ultra Search User's Guide)

partitioned (Spatial User's Guide and Reference)

exchanging partitions including indexes (Spatial User's Guide and Reference)

quadtree

deprecated feature of Spatial (Spatial User's Guide and Reference)

R-tree

description (Spatial User's Guide and Reference)

requirements before creating (Spatial User's Guide and Reference)

rebuilding (Spatial User's Guide and Reference)

[subentry #2] (Text Application Developer's Guide)

parallel execution (Spatial User's Guide and Reference)

renaming (Text Reference)

script (Text Reference)

show size of objects (Text Reference)

show statistics (Text Reference)

size (R-tree) (Spatial User's Guide and Reference)

statistics on (Text Application Developer's Guide)

structure (Text Application Developer's Guide)

[subentry #2] (Text Application Developer's Guide)

synchronizing (Text Application Developer's Guide)

[subentry #2] (Text Application Developer's Guide)

[subentry #3] (Text Reference)

[subentry #4] (Text Reference)

synchronizing deferred updates (Spatial User's Guide and Reference)

transactional (Text Reference)

transactional CONTEXT (Text Reference)

[subentry #2] (Text Reference)

using to improve performance (Pro*COBOL Precompiler Programmer's Guide)

viewing information on (Text Application Developer's Guide)

viewing registered (Text Reference)

index algorithm (OLAP DML Reference)

INDEX clause

of ANALYZE (SQL Reference)

of CREATE CLUSTER (SQL Reference)

index clusters. See clusters.

index creation

custom preference example (Text Reference)

default example (Text Reference)

index creation parameters

example (Text Reference)

index defaults

general (Text Application Developer's Guide)

index engine

about (Text Application Developer's Guide)

index errors

deleting (Text Reference)

viewing (Text Application Developer's Guide)

[subentry #2] (Text Reference)

index fragmentation (Text Application Developer's Guide)

[entry #2] (Text Application Developer's Guide)

[entry #3] (Text Reference)

INDEX hint (Performance Tuning Guide)

[entry #2] (Performance Tuning Guide)

index keys

compression (SQL Reference)

index maintenance (Text Application Developer's Guide)

[entry #2] (Text Reference)

postponing during Data Pump Import (Utilities)

index memory (Text Application Developer's Guide)

INDEX object privilege (SQL Reference)

on a table (SQL Reference)

index objects (Text Reference)

viewing (Text Reference)

[subentry #2] (Text Reference)

index optimization (Text Reference)

index options

SORTED INDEXES with SQL*Loader (Utilities)

SQL*Loader SINGLEROW parameter (Utilities)

index partitions

creating subpartitions (SQL Reference)

index preference

about (Text Reference)

creating (Text Reference)

[subentry #2] (Text Reference)

INDEX privilege (Security Guide)

index rebuilding (High Availability Architecture and Best Practices)

index reports (Text Reference)

index requests

logging (Text Reference)

index scan (Data Cartridge Developer's Guide)

index segments (Concepts)

index subpartitions (SQL Reference)

index synchronization (Text Application Developer's Guide)

index tablespace parameters

specifying (Text Reference)

index tokens

generating for a document (Text Reference)

[subentry #2] (Text Reference)

index types

choosing (Text Application Developer's Guide)

Index Unusable state

indexes left in Index Unusable state (Utilities)

[subentry #2] (Utilities)

index-by tables

index-organized table (Pro*COBOL Precompiler Programmer's Guide)

cannot create spatial index on (Spatial User's Guide and Reference)

index-organized tables

[entry #2] (Concepts)

[entry #3] (Performance Tuning Guide)

analyzing (Administrator's Guide)

apply process (Streams Replication Administrator's Guide)

AS subquery (Administrator's Guide)

benefits (Concepts)

bitmap indexes on, creating (SQL Reference)

capture process (Streams Concepts and Administration)

converting to heap (Administrator's Guide)

creating (Administrator's Guide)

[subentry #2] (SQL Reference)

described (Administrator's Guide)

INCLUDING clause (Administrator's Guide)

key compression (Administrator's Guide)

key compression in (Concepts)

[subentry #2] (Concepts)

list partitioning (New Features Guide)

logical rowids (Concepts)

maintaining (Administrator's Guide)

mapping tables (SQL Reference)

moving (SQL Reference)

mapping tables, creating (SQL Reference)

merging contents of index blocks (SQL Reference)

modifying (SQL Reference)

[subentry #2] (SQL Reference)

moving (SQL Reference)

ORDER BY clause, using (Administrator's Guide)

overflow clause (Administrator's Guide)

overflow segments

specifying storage (SQL Reference)

parallel CREATE (Data Warehousing Guide)

[subentry #2] (Data Warehousing Guide)

parallel creation (Administrator's Guide)

parallel queries (Data Warehousing Guide)

partitioned (New Features Guide)

[subentry #2] (New Features Guide)

partitioned, updating secondary indexes (SQL Reference)

partitioning (Administrator's Guide)

[subentry #2] (Administrator's Guide)

partitioning secondary indexes (Administrator's Guide)

PCT_ACCESS_DIRECT statistics (SQL Reference)

primary key indexes

coalescing (SQL Reference)

rebuilding (SQL Reference)

rebuilding with MOVE clause (Administrator's Guide)

rowids of (SQL Reference)

secondary indexes on (Concepts)

secondary indexes, updating (SQL Reference)

storing nested tables (Administrator's Guide)

storing nested tables as (Application Developer's Guide - Object-Relational Features)

[subentry #2] (Application Developer's Guide - Object-Relational Features)

storing object types (Administrator's Guide)

threshold value (Administrator's Guide)

index-organized tables, restrictions for LOB columns (Application Developer's Guide - Large Objects)

indexed clusters

creating (SQL Reference)

indexed lookup (Text Application Developer's Guide)

indexed predicates (Application Developer's Guide - Expression Filter)

indexed-by table support

details, general indexed-by tables (JPublisher User's Guide)

details, scalar indexed-by tables (JDBC OCI) (JPublisher User's Guide)

summary, general indexed-by tables (JPublisher User's Guide)

summary, scalar indexed-by tables (JDBC OCI) (JPublisher User's Guide)

indexes

[entry #2] (Concepts)

[entry #3] (Label Security Administrator's Guide)

[entry #4] (SQL Reference)

adding columns (Performance Tuning Guide)

allocating new extents for (SQL Reference)

altering (Administrator's Guide)

analyzing (Administrator's Guide)

appending columns (Performance Tuning Guide)

application-specific (SQL Reference)

ascending (SQL Reference)

avoiding the use of (Performance Tuning Guide)

B-tree (Data Warehousing Guide)

[subentry #2] (Performance Tuning Guide)

[subentry #3] (SQL Reference)

B-tree structure of (Concepts)

based on indextypes (SQL Reference)

bitmap (Performance Tuning Guide)

[subentry #2] (Performance Tuning Guide)

[subentry #3] (SQL Reference)

bitmap indexes (Concepts)

[subentry #2] (Concepts)

[subentry #3] (Data Warehousing Guide)

nulls and (Concepts)

parallel query and DML (Concepts)

bitmap join (Data Warehousing Guide)

[subentry #2] (SQL Reference)

branch blocks (Concepts)

building

using an existing index (Concepts)

cardinality (Concepts)

[subentry #2] (Data Warehousing Guide)

changing attributes (SQL Reference)

changing parallelism of (SQL Reference)

choosing columns for (Performance Tuning Guide)

choosing columns to index (Administrator's Guide)

cluster

cannot be partitioned (Concepts)

cluster indexes (Administrator's Guide)

[subentry #2] (Administrator's Guide)

[subentry #3] (Administrator's Guide)

coalescing (Administrator's Guide)

[subentry #2] (Administrator's Guide)

collecting statistics on (SQL Reference)

column order (Performance Tuning Guide)

column order for performance (Administrator's Guide)

composite (Concepts)

[subentry #2] (Performance Tuning Guide)

computing statistics for (SQL Reference)

concatenated (Concepts)

costs (Performance Tuning Guide)

creating (2 Day DBA)

[subentry #2] (Administrator's Guide)

[subentry #3] (Application Developer's Guide - Fundamentals)

[subentry #4] (Performance Tuning Guide)

[subentry #5] (SQL Reference)

creating for documents stored as CLOBs (Globalization Support Guide)

creating for expression set (Application Developer's Guide - Expression Filter)

[subentry #2] (Application Developer's Guide - Expression Filter)

creating for multilingual document search (Globalization Support Guide)

creating from default parameters (Application Developer's Guide - Expression Filter)

creating from exact parameters (Application Developer's Guide - Expression Filter)

creating from statistics (Application Developer's Guide - Expression Filter)

creating in parallel (Data Warehousing Guide)

creating indexes for documents stored as BLOBs (Globalization Support Guide)

creating manually (Utilities)

creating on a cluster (SQL Reference)

creating on a table (SQL Reference)

deallocating unused space from (SQL Reference)

definition (Concepts)

defragmenting (Application Developer's Guide - Expression Filter)

descending (SQL Reference)

and query rewrite (SQL Reference)

as function-based indexes (SQL Reference)

described (Concepts)

description (2 Day DBA)

design (Performance Tuning Guide)

direct path load

left in direct load state (Utilities)

direct-path inserts, logging (SQL Reference)

disabling and dropping constraints cost (Administrator's Guide)

disassociating statistics types from (SQL Reference)

domain (Concepts)

[subentry #2] (Performance Tuning Guide)

[subentry #3] (SQL Reference)

[subentry #4] (SQL Reference)

[subentry #5] (SQL Reference)

domain, example (SQL Reference)

dropping (Administrator's Guide)

[subentry #2] (Administrator's Guide)

[subentry #3] (Administrator's Guide)

[subentry #4] (Application Developer's Guide - Expression Filter)

[subentry #5] (Application Developer's Guide - Expression Filter)

[subentry #6] (Application Developer's Guide - Fundamentals)

[subentry #7] (Performance Tuning Guide)

SQL*Loader (Utilities)

dropping index partitions (SQL Reference)

enforcing integrity constraints (Concepts)

[subentry #2] (Concepts)

enforcing uniqueness (Performance Tuning Guide)

ensuring the use of (Performance Tuning Guide)

estimating size (Administrator's Guide)

estimating space use (Administrator's Guide)

estimating storage requirements (Utilities)

examples (SQL Reference)

explicitly creating a unique index (Administrator's Guide)

exporting (Utilities)

extensible (Concepts)

function-based (Administrator's Guide)

[subentry #2] (Application Developer's Guide - Fundamentals)

[subentry #3] (Application Developer's Guide - Large Objects)

[subentry #4] (Concepts)

[subentry #5] (Performance Tuning Guide)

[subentry #6] (Performance Tuning Guide)

[subentry #7] (SQL Reference)

[subentry #8] (Upgrade Guide)

creating (SQL Reference)

dependencies (Concepts)

DETERMINISTIC functions (Concepts)

DISABLED (Concepts)

optimization with (Concepts)

privileges (Concepts)

global (2 Day DBA)

[subentry #2] (Data Warehousing Guide)

global partitioned indexes (Data Warehousing Guide)

managing partitions (Data Warehousing Guide)

global partitioned, creating (SQL Reference)

globally partitioned (SQL Reference)

[subentry #2] (SQL Reference)

updating (SQL Reference)

granting system privileges for (SQL Reference)

guidelines (Application Developer's Guide - Fundamentals)

guidelines for managing (Administrator's Guide)

importing (Utilities)

improving selectivity (Performance Tuning Guide)

index joins (Performance Tuning Guide)

index-creation commands

Import (Utilities)

index-organized tables (Concepts)

logical rowids (Concepts)

secondary indexes (Concepts)

internal structure of (Concepts)

join, bitmap (SQL Reference)

joins (Performance Tuning Guide)

keeping when disabling constraint (Administrator's Guide)

keeping when dropping constraint (Administrator's Guide)

key compression (Administrator's Guide)

[subentry #2] (Concepts)

key compression of (SQL Reference)

key compression, enabling (SQL Reference)

keys and (Concepts)

primary key constraints (Concepts)

unique key constraints (Concepts)

keys, eliminating repetition (SQL Reference)

leaf blocks (Concepts)

left in unusable state (Utilities)

[subentry #2] (Utilities)

limiting for a table (Administrator's Guide)

local (2 Day DBA)

[subentry #2] (Data Warehousing Guide)

local indexes (Data Warehousing Guide)

locally partitioned (SQL Reference)

location of (Concepts)

logging rebuild operations (SQL Reference)

LONG RAW datatypes prohibit (Concepts)

low selectivity (Performance Tuning Guide)

maintaining (Application Developer's Guide - Expression Filter)

marking as UNUSABLE (SQL Reference)

materialized view sites (Advanced Replication)

merging block contents (SQL Reference)

merging contents of index blocks (SQL Reference)

merging contents of index partition blocks (SQL Reference)

modifying attributes (SQL Reference)

modifying values of (Performance Tuning Guide)

monitoring space use of (Administrator's Guide)

monitoring usage (Administrator's Guide)

moving (SQL Reference)

multiple-column

SQL*Loader (Utilities)

non-unique (Performance Tuning Guide)

nonunique (Concepts)

nulls and (Concepts)

[subentry #2] (Concepts)

[subentry #3] (Concepts)

[subentry #4] (Data Warehousing Guide)

on clusters (SQL Reference)

on complex datatypes (Concepts)

on composite-partitioned tables, creating (SQL Reference)

on foreign keys (Advanced Replication)

on hash-partitioned tables

creating (SQL Reference)

on index-organized tables (SQL Reference)

on list-partitioned tables

creating (SQL Reference)

on nested table storage tables (SQL Reference)

on partitioned tables (SQL Reference)

on range-partitioned tables (SQL Reference)

[subentry #2] (SQL Reference)

[subentry #3] (SQL Reference)

on range-partitioned tables, creating (SQL Reference)

on REFs (Application Developer's Guide - Object-Relational Features)

on scalar typed object attributes (SQL Reference)

on table columns (SQL Reference)

on XMLType tables (SQL Reference)

online (SQL Reference)

order of columns (Application Developer's Guide - Fundamentals)

overview of (Concepts)

parallel creation (Data Warehousing Guide)

[subentry #2] (Data Warehousing Guide)

[subentry #3] (Data Warehousing Guide)

parallel DDL storage (Data Warehousing Guide)

parallel local (Data Warehousing Guide)

parallelizing creation of (SQL Reference)

parallelizing index creation (Administrator's Guide)

partitioned (2 Day DBA)

[subentry #2] (Administrator's Guide)

[subentry #3] (Globalization Support Guide)

Oracle Database Master Index: I 10g Release 1 (10.1)

Shortcuts to Letters

Index Entries

Oracle Database Master Index: I
10g Release 1 (10.1)