Oracle8i Generic Documentation Master Index

E date format element, SQL 2-41

E number format element, SQL 2-36

earliest and latest timestamp

conflict resolution methods, REP 6-20

EBCDIC character set, SQL 2-29

Import, SUT 2-56

sorting order, NLS 2-25

EBU

backup management, MIG 8-40

Edit Database Destination property sheet

Replication Manager, REP 2-39

Edit DB Connection property sheet

setup wizard, REP 2-17

Edit Parallel Server dialog box, PSC 6-27

Edit Replication Object property sheet

Min(imize) Communications setting, REP 2-37

Edit Scheduled Link property sheet

Replication Manager, REP 2-15

setup wizard, REP 2-14

Edit Snapshot property sheet

Tablespace and Extents page, REP 5-27

EE date format element, SQL 2-41

eight-bit character set support, SUT 1-53, SUT 2-56

elaboration, PLS 2-30

elapsed column, SQL trace, STU 14-13

electric utility example, DCI 11-1

element type

collection, PLS 4-5

ELSE clause, PLS 3-3

ELSIF clause, PLS 3-4

embedded DDL, PCO 2-17

embedded objects

fetching, OCI 10-15

embedded parameter files, SRF 1-50

embedded PL/SQL

advantages, PCO 6-3

advantages of, PC_ 7-2

cursor FOR loop, PC_ 7-3, PCO 6-4

example, PCO 6-8, PCO 6-10

example of, PC_ 7-7, PC_ 7-9

host variables, PCO 6-2

indicator variables, PCO 6-2

multi-byte NLS features, PCO 4-41

need for SQLCHECK option, PCO 6-8

need for USERID option, PCO 6-8

PL/SQL table, PCO 6-6

PL/SQL tables, PC_ 7-5

procedures and functions, PC_ 7-3

requirements, PCO 6-2

requirements for, PC_ 7-6

SQLCHECK option, PC_ 7-7

subprogram, PCO 6-4

support for SQL, PC_ 2-6, PCO 2-7

user-defined record, PCO 6-6

user-defined records, PC_ 7-5

using %TYPE, PC_ 7-2, PCO 6-3

using the VARCHAR pseudotype, PCO 6-12

using the VARCHAR pseudotype with, PC_ 7-11

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

VARCHAR variables, PCO 6-2

where allowed, PC_ 7-6, PCO 6-2, PCO 6-7

embedded SQL, ADG 10 - 2, OCI 1-11

ALLOCATE DESCRIPTOR statement, PCO F-12

ALLOCATE statement, PC_ F-12, PCO 4-37, PCO 6-33, PCO F-10

CALL statement, PCO 6-30, PCO F-13

CLOSE statement, PC_ F-18, PCO 5-15, PCO 6-36, PCO F-14

COMMIT statement, PCO F-15

CONNECT statement, PCO F-17

CONTEXT ALLOCATE statement, PC_ 11-8, PC_ F-28, PCO F-19

CONTEXT FREE statement, PC_ 11-10, PCO F-20

CONTEXT USE directive, PCO F-21

DEALLOCATE DESCRIPTOR statement, PCO F-23

DECLARE [CURSOR] directive, PCO 5-12

DECLARE CURSOR directive, PCO F-24

DECLARE DATABASE directive, PCO F-26

DECLARE STATEMENT directive, PCO F-27

DECLARE TABLE directive, PCO F-29

definition of, PC_ 2-2

DELETE statement, PCO 5-11, PCO F-31

DESCRIBE DESCRIPTOR statement, PCO F-36

DESCRIBE statement, PCO F-34

difference from interactive SQL, PC_ 2-5

ENABLE THREADS statement, PC_ 11-8

EXEC SQL CACHE FREE ALL, PC_ 17-6

EXECUTE IMMEDIATE statement, PCO F-43

EXECUTE statement, PC_ F-51, PCO F-40

EXECUTE...END-EXEC statement, PCO F-38

FETCH DESCRIPTOR statement, PCO F-48

FETCH statement, PCO 5-14, PCO 6-35, PCO F-45, PCO F-48

FREE statement, PCO 6-37, PCO F-50

GET DESCRIPTOR statement, PCO F-51

INSERT statement, PCO 5-9, PCO 7-12, PCO F-54

key concepts, PCO 2-2

key concepts of, PC_ 2-2

mixing with host-language statements, PC_ 2-5

mixing with OCI calls, OCI 1-11

OPEN DESCRIPTOR statement, PCO F-71

OPEN statement, PC_ F-92, PCO 5-14, PCO F-69, PCO F-70, PCO F-71

overview of, PC_ 2-2

PREPARE statement, PC_ F-96, PCO F-73

requirements for, PC_ 2-5

ROLLBACK statement, PCO F-74

SAVEPOINT statement, PC_ F-103, PCO 3-24, PCO F-78

SELECT statement, PC_ F-104, PCO 5-8, PCO 7-6, PCO F-79

SET DESCRIPTOR statement, PCO F-82

SET TRANSACTION statement, PCO 3-26

syntax for, PC_ 2-5

testing with SQL*Plus, PC_ 1-3

TYPE directive, PC_ F-111

UPDATE statement, PC_ F-112, PCO 5-10, PCO F-85

using OCI types in, PC_ 17-34

using REFs in, PC_ 17-33

VAR directive, PC_ F-116, PCO F-89

versus interactive SQL, PCO 2-6

when to use, PC_ 1-3, PCO 1-3

WHENEVER directive, PC_ F-119, PCO F-91

embedded SQL statements, SCN 1-53, SCN 16-5, SQL 1-3, SQL 6-5

embedding

PL/SQL blocks in Oracle7 precompiler programs, PCO F-38

PL/SQL blocks in precompiler programs, PC_ F-51

EMP table, PC_ 2-18, PCO 2-29

EMPTY_BLOB function, DCI 6-4, SQL 4-15

EMPTY_CLOB function, DCI 6-4, SQL 4-15

ENABLE ALL TRIGGERS clause

of ALTER TABLE, SQL 7-154

ENABLE clause

of ALTER INDEX, SQL 7-38

of ALTER TRIGGER, SQL 7-171

of constraint_clause, SQL 7-227

of CREATE TABLE, SQL 7-381

ENABLE constraints, SCN 28-22

ENABLE DISTRIBUTED RECOVERY clause

of ALTER SYSTEM, SQL 7-99

ENABLE NOVALIDATE constraint state, SQL 7-381

ENABLE PARALLEL DML clause

of ALTER SESSION, SQL 7-79

ENABLE QUERY REWRITE clause

of ALTER MATERIALIZED VIEW, SQL 7-50

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-307

ENABLE RESTRICTED SESSION clause

of ALTER SYSTEM, SQL 7-99

ENABLE ROW MOVEMENT clause

of ALTER TABLE, SQL 7-153

of CREATE TABLE, SQL 7-360, SQL 7-380

ENABLE STORAGE IN ROW clause

of ALTER TABLE, SQL 7-132

of CREATE TABLE, SQL 7-374

ENABLE TABLE LOCK clause

of ALTER TABLE, SQL 7-154

ENABLE TABLE LOCK option, SPS 16-7

ENABLE THREAD clause

of ALTER DATABASE, SQL 7-15

ENABLE THREAD option

ALTER DATABASE command, SBR 16-24

ENABLE THREADS SQL statement, PC_ F-50

ENABLE THREADS statement, PC_ 11-8

ENABLE VALIDATE constraint state, SQL 7-381

enabled constraint, STU 6-10

enabled destination state

for archived redo logs, SAD 7-13

Enabled setting

Create New Scheduled Link property sheet, REP 2-13

ENABLE/DISABLE clause

of ALTER TABLE, SQL 7-128, SQL 7-154

of CREATE TABLE, SQL 7-365

enabling

archiving, SAD 7-7

auditing options

about, SAD 25-9

privileges for, SAD 25-13

integrity constraints, ADG 5 - 22

at creation, ADG 5 - 20, ADG 5 - 22, SAD 20-18

example, SAD 20-19

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

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

recoverer process, DDS 3-34

resource limits, SAD 23-21

roles, ADG 12 - 14

threads, PC_ 11-8

triggers, ADG 13 - 30, SAD 20-12

enabling replication, REP 8-34

enabling SSL, OAS 9-12

encapsulation, data, PLS 1-16

enclosed fields

ENCLOSED BY control file clause, SUT 5-16

specified with enclosure delimiters and SQL*Loader, SUT 5-71

whitespace, SUT 5-87

enclosure delimiters

SQL*Loader, SUT 5-83

encoding scheme, PCO 4-40

encoding scheme (character set or code page), PC_ 4-49

encrypted data, across protocols, OAS 1-11

encryption, OAS 1-4

Oracle passwords, SAD 23-8

public-key, OAS Glossary-5

encryption and checksumming

activating, OAS 2-6

negotiating, OAS 2-7

encryption and checksumming parameters, OAS 2-9

END, PCO 14-20

END BACKUP clause

of ALTER TABLESPACE, SQL 7-168

END BACKUP option, SPS 21-15

END IF reserved words, PLS 3-3

END LOOP reserved words, PLS 3-9

END_INSTANTIATION procedure

DBMS_OFFLINE_OG package, REP 8-17

END_LOAD procedure

DBMS_OFFLINE_OG package, REP 8-17

END_OF_FETCH precompiler option, PCO 14-20

END_TABLE_REORGANIZATION procedure

DBMS_SNAPSHOT package, REP 7-25

END-OF_FETCH clause, PCO A-5

enforced constraint, STU 6-10

ENFORCED mode, STU 31-19

Enhanced, ADQ 1-14

enhancements

new features, REP A-2

enqueue and dequeue of messages

by Correlation and Message Id Using Pro*C/C++, ADQ 8-29

by priority, ADQ 8-9

of object type, ADQ 8-6

of RAW type, ADQ 8-9

of RAW type using Pro*C/C++, ADQ 8-12, ADQ 8-15

to/from multiconsumer queues, ADQ 8-36, ADQ 8-39

with time delay and expiration, ADQ 8-28

enqueue conversions statistic, SRF C-9

enqueue deadlocks statistic, SRF C-9

enqueue locks

calculating non-PCM resources, SPS 16-4

enqueue procedure, DDS 5-7

enqueue releases statistic, SRF C-9

enqueue requests statistic, SRF C-9

enqueue timeouts statistic, SRF C-9

enqueue wait event, SRF A-29

enqueue waits statistic, SRF C-9

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

ENQUEUE_RESOURCES parameter, SRF 1-39, STU 26-26, STU 26-28

calculating non-PCM resources, SPS 16-4

enqueues

disabling, SRF 1-38

ENQUEUE_RESOURCES parameter, SRF 1-39

locking, PC_ 3-16

enroll

database users, SAD 1-20

ENT_DOMAIN_NAME, SRF 1-40

entended rowid, PLS 2-16

entering options, PC_ 5-31, PC_ 10-9

Enterprise Backup Utility, SBR 3-11

enterprise directory service, SRF 1-40

interoperability, MIG 8-38

enterprise domain, SRF 1-40

Enterprise Java Beans (EJBs)

described, NET 7-50

Enterprise JavaBeans, GTK 2-19

Enterprise JavaBeans (EJBs)

configuring, NET 7-51 to NET 7-64

Enterprise Manager, OAS 7-5, GTK 2-60, SCN 33-19, STU 12-7

ALERT file, SCN 8-15

checkpoint statistics, SCN 8-11

distributed databases, SCN 33-19

executing a package, SCN 18-6

executing a procedure, SCN 18-4

granting roles, SCN 30-18

granting system privileges, SCN 30-3

lock and latch monitors, SCN 27-29

operating system account, SAD 1-4

parallel recovery, SCN 32-11

PL/SQL, SCN 16-17, SCN 16-19

schema object privileges, SCN 30-4

showing size of SGA, SCN 7-13

shutdown, SCN 5-9, SCN 5-10

SQL statements, SCN 16-2

startup, SCN 5-5

statistics monitor, SCN 29-19

enterprise roles, SRF 1-40, SRF 1-104

entry, PSC C-6

environment handle

attributes, OCI A-3

description, OCI 2-8

environment of a job, SAD 8-6

environment variables

compatibility

NCHAR and NLS, MIG 8-28

NLS_DATE_FORMAT, SBR 5-2

NLS_LANG, NLS 2-4, SBR 5-2

ORA_NLS32, MIG 8-28

ORA_NLS33, MIG 3-16, MIG 8-28

required for migration, MIG 3-16, MIG 3-21

required for upgrading, MIG 7-16

TWO_TASK, MIG 3-16

environmentally-dependent SQL functions, DDS 2-26

EPC, SMS 15-1

equality test, SQL 3-5

equijoin, STU 4-9

equijoins, SQL 5-21

cluster joins, SCN 24-5

defined, SCN 23-3

defining for a dimension, SQL 7-261

hash joins, SCN 24-7

sort-merge, SCN 24-4

equipartitioning, SCN 11-24

examples, SCN 11-25, SCN 11-30, SCN 11-32

LOB columns, SCN 11-38

local indexes, SCN 11-29

on one dimension, SCN 11-24

overflow of index-organized tables, SCN 11-42, SCN 11-44

range partitioning, SCN 11-24

equivalencing

host variable equivalencing, PC_ F-116, PCO F-89

user-defined type equivalencing, PC_ F-111

equivalencing datatypes, PCO 4-46

equivalencing of datatypes

datatype equivalencing, PC_ 2-7

equivalency tests, SQL 3-5

error

transactions

managing, REP 7-12

error call trace stack, PSC C-13

error codes

define calls, OCI 2-28

navigational functions, OCI 16-6

error conditions

cursor variable, PCO 6-37

error detection

error reporting, PC_ F-120, PCO F-92

error handle

attributes, OCI A-6

description, OCI 2-9

error handling, PC_ 2-9

alternatives, PC_ 9-2, PCO 8-2

SQLCA versus WHENEVER statement, PC_ 9-3

use of ROLLBACK statement in, PC_ 3-21

using status variables

SQLCA, PCO 8-3, PCO 8-19

SQLCODE, PCO 8-3, PCO 8-5

SQLSTATE, PCO 8-3

using the ROLLBACK statement, PCO 3-23

using the SQLGLS routine, PCO 8-34

error message

parameter values, SPS 18-16

rollback segment, SPS 14-5

storage options, SPS 17-6

error message text

SQLGLM subroutine, PCO 8-26

error messages

12203, NET 11-13

12535, NET 11-13

12547, NET 11-13

20002-20021 for Net8 OPEN, NET 9-12

caused by tab characters in SQL*Loader data, SUT 5-50

contacting Oracle Customer Support, NET 11-58

example of trace data, NET 11-42

Export, SUT 1-39

export log file, SUT 1-21

fatal errors

Export, SUT 1-40

generated by DB2 load utility, SUT B-3

in trace file, NET 11-42

maximum length, PCO 8-27, PLS 6-18

maximum length of, PC_ 9-23

naming conventions, DCI 2-6

ORA-1034, NET 8-13, NET 11-3

ORA-12154, NET 8-13, NET 11-8

ORA-12198, NET 11-8

ORA-12203, NET 8-12, NET 11-8, NET 11-9

ORA-12203, sample error stack, NET 11-17

ORA-12203, troubleshooting, NET 8-12

resolving, NET 11-1 to NET 11-58

row errors during import, SUT 2-47

TNS-0116, NET 8-14

TNS-01169, NET 8-14

use in error reporting, PC_ 9-16

using log file to track, NET 11-25

using the sqlglm() function to get, PC_ 9-22

warning errors

Export, SUT 1-39

where available in SQLCA, PC_ 9-16

error queue, RAR 7-14

error reporting

error message text, PCO 8-22

key components of, PC_ 9-14, PCO 8-22

parse error offset, PCO 8-22

rows-processed count, PCO 8-22

status codes, PCO 8-22

use of error messages in, PC_ 9-16

use of parse error offset in, PC_ 9-15

use of rows-processed count in, PC_ 9-15

use of warning flags in, PC_ 9-15

warning flags, PCO 8-22

WHENEVER directive, PC_ F-120, PCO F-92

error stack

described, NET 11-16

entries in log files, NET 11-25

sample, NET 11-17

typical layers, NET 11-17

ERROR_SIZE view, SRF 2-162

ERRORS

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

errors

ALERT file and, SAD 4-10

application development, DDS 4-4

application errors raised by Oracle packages, ADG 10 - 44

archiving, SRF 1-66

common tuning, STU 2-14

creating views with errors, ADG 3 - 23

distributed transactions, DDS 3-19

during discrete transactions, STU 9-3

during RMAN backups, SBR 8-26

example of handling, OCI 2-28

fatal

Export, SUT 1-40

Import, SUT 2-49

handling, OCI 2-27

handling in object applications, OCI 10-35

Import resource errors, SUT 2-49

in embedded SQL, SCN 16-6

locating in dynamic SQL, SPR 48 - 33

LONG data, SUT 2-48

messages

trapping, DDS 4-11

object creation

Import parameter IGNORE, SUT 2-24

object creation errors, SUT 2-48

ORA-00900

ORA-02015

ORA-02055

integrity constrain violation, DDS 4-3

ORA-02067

rollback required, DDS 4-3

ORA-06510

PL/SQL error, DDS 4-12

ORA-1215, SAD 5-9

ORA-1216, SAD 5-9

ORA-1547, SAD 20-29

ORA-1628 through 1630, SAD 20-29

Recovery Manager, SBR 4-12

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

returned by DBMS_ALERT package, SPR 15 - 3

snapshot too old, SAD 21-5

trace files and, SAD 4-10

tracked in trace files, SCN 8-14

transactions

displaying, REP 7-12

resolving, REP 7-13

user-defined, ADG 10 - 44, ADG 10 - 45

warning

Export, SUT 1-39

when creating a database, SAD 2-8

when creating control file, SAD 5-9

while starting an instance, SAD 3-5

errors during migration. See troubleshooting

ERRORS precompiler option, PC_ 10-20, PCO 14-21

ERRTYPE

precompiler option, PC_ 10-21

ERRTYPE OTT parameter, OCI 14-27, PC_ 19-30

ERRTYPE precompiler option, PC_ 17-21

escape character

Export, SUT 1-25

Import, SUT 2-29

quoted strings, SUT 5-20

establishing, ADG 12 - 1

establishing a session

through multi-threaded servers, NET 2-20

using bequeath, NET 8-8

using centralized naming, NET 3-5

using external naming, NET 3-6

using host naming, NET 3-4, NET 8-8

using local naming, NET 3-5, NET 8-8

using Oracle Names, NET 3-5, NET 8-8

ESTIMATE option

STATISTICS Export parameter, SUT 1-23

ESTIMATE STATISTICS clause

of ANALYZE, SQL 7-188

ESTIMATE STATISTICS option, SAD 20-7

estimating materialized view size, STU 32-20

estimating size

hash clusters, SAD 18-4

tables, SAD 14-5

Euro symbol

supported character sets, NLS A-20

EVALUATE_UTILIZATION_W package, STU 32-21

evaluating

hardware for the Oracle8i, SAD 1-18

evaluation, PLS 2-41

short-circuit, PLS 2-44

event attribute functions, ADG 14 - 2

EVENT parameter, SRF 1-40

event publication, ADG 13 - 55, ADG 14 - 1

advanced queueing, ADG 13 - 54

context, ADG 13 - 55

error handling, ADG 13 - 55

execution model, ADG 13 - 55

framework, ADG 13 - 54

triggering, ADG 13 - 54

events in Oracle Trace, STU 15-5

EXAMPBLD script, PLS A-3

example

creating constraints, SAD 20-19

demonstration programs, OCI B-1

non-blocking mode, OCI 2-37

using OCIThread, OCI 9-9

example, purchase order, ADG 16 - 3

examples

EXAMPLOD script, PLS A-3

EXCEPTION

PL/SQL keyword, DDS 4-11

exception, PLS 6-2

declaring, PLS 6-7

predefined, PLS 6-4

propagation, PLS 6-12

raised in declaration, PLS 6-16

raised in handler, PLS 6-17

raising (OCIExtProcRaiseExcp), DCI 4-13

raising (OCIExtProcRaiseExcpWithMsg), DCI 4-13

raising with RAISE statement, PLS 6-11

reraising, PLS 6-14

scope rules, PLS 6-7

syntax, PLS 11-55

user-defined, PLS 6-7

WHEN clause, PLS 6-15

exception handler, DDS 4-11, PLS 6-15

branching from, PLS 6-17

local, DDS 4-12

OTHERS handler, PLS 6-2

using RAISE statement in, PLS 6-15

using SQLCODE function in, PLS 6-18

using SQLERRM function in, PLS 6-18

exception handlers

in PL/SQL, ADG 10 - 2

exception operations, described, NET 2-4

exception tables

dropping, MIG 12-18

exception, PL/SQL, PCO 6-13

definition of, PC_ 7-13

EXCEPTION_INIT pragma, PLS 6-8

syntax, PLS 11-53

using with raise_application_error, PLS 6-10

exception-handling part

function, PLS 7-6

PL/SQL block, PLS 1-3

procedure, PLS 7-4

exceptions

anonymous blocks, ADG 10 - 3

assigning names

PRAGMA_EXCEPTION_INIT, DDS 4-11

during trigger execution, ADG 13 - 18, SCN 20-23

effects on applications, ADG 10 - 46

integrity constraints, SAD 20-21

raising, SCN 16-18

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

stored procedures and, SCN 16-18

unhandled, ADG 10 - 46

user-defined

PL/SQL, DDS 4-11

EXCEPTIONS INTO clause

of constraint_clause, SQL 7-228

of CREATE TABLE, SQL 7-383

EXCEPTIONS keyword

SQL*Loader, SUT 8-22

EXCEPTIONS view, SRF 2-162

exchange deadlocks statistic, SRF C-9

EXCHANGE PARTITION, SCN 11-11

EXCHANGE PARTITION clause

of ALTER TABLE, SQL 7-152

EXCHANGE SUBPARTITION clause

of ALTER TABLE, SQL 7-152

EXCLUDING NEW VALUES clause

of ALTER MATERIALIZED VIEW LOG, SQL 7-57

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

exclusive distributed lock

rollback data, SRF 1-46

EXCLUSIVE lock mode, SQL 7-521

exclusive locks

LOCK TABLE command, ADG 8 - 16

row locks (TX), SCN 27-20

RX locks, SCN 27-23

table locks (TM), SCN 27-21

exclusive mode, SCN 4-27, SPS 8-7, SPS 18-12

compatibility, SPS B-1

database access, SPS 1-15, SPS 4-1

free lists, SPS 17-6, SPS 17-11

MAXLOGHISTORY, SPS 21-7

media recovery, SPS 14-4

of the database, SAD 3-6

required for file operations, SPS A-17, SPS B-2

rollback segments and, SAD 21-3

specifying instance number, SPS 17-13, SRF 1-52

specifying thread number, SPS 18-15

startup, SPS 17-13, SPS 18-12

switching archive log mode, SPS 14-9

taking tablespace offline, SPS A-18

terminating remaining user sessions, SAD 4-16

EXCLUSIVE option, SPS 18-13

EXCLUSIVE parameter

obsolete for 8.0.4, SPS A-6

exclusive PCM lock, SPS 4-15

EXEC ORACLE DEFINE statement, PC_ 5-42, PCO 2-26

EXEC ORACLE ELSE statement, PC_ 2-16, PC_ 5-42, PCO 2-26

EXEC ORACLE ENDIF statement, PC_ 2-16, PC_ 5-42, PCO 2-26

EXEC ORACLE IFDEF statement, PC_ 2-16, PC_ 5-42, PCO 2-26

EXEC ORACLE IFNDEF statement, PC_ 2-16, PC_ 5-42, PCO 2-26

EXEC ORACLE OPTION statement

set option values inline, PC_ 10-9

EXEC ORACLE statement

scope of, PC_ 10-10, PCO 14-8

syntax for, PC_ 10-9, PCO 14-8

uses for, PC_ 10-10, PCO 14-8

using to enter options inline, PCO 14-8

EXEC ORACLE statements, PC_ 2-16

EXEC SQL CACHE FREE statement, PC_ 17-6

EXEC SQL clause, PCO 2-6, PCO 2-15

using to embed SQL, PC_ 2-5

EXEC SQL INCLUDE

contrasted with #include, PC_ 5-35

EXEC SQL VAR statement

CONVBUFSZ clause, PC_ 4-51

EXEC TOOLS

GET CONTEXT statement, PC_ 20-16

GET statement, PC_ 20-15

MESSAGE statement, PC_ 20-17

SET CONTEXT statement, PC_ 20-16

SET statement, PC_ 20-15

EXEC TOOLS statement, PCO 12-14

GET, PCO 12-15

MESSAGE, PCO 12-16

SET, PCO 12-14

EXEC TOOLS statements, PC_ 20-14

executable code as data source, STU 12-4

executable part

function, PLS 7-6

PL/SQL block, PLS 1-3

procedure, PLS 7-4

executable SQL statements

grouping of, PC_ 2-3

purpose of, PC_ 6-6

uses for, PC_ 2-3

where allowed, PC_ 2-3

EXECUTE ... END-EXEC SQL statement, PC_ F-51

EXECUTE ANY INDEXTYPE system privilege, SQL 7-496

EXECUTE ANY OPERATOR system privilege, SQL 7-497

EXECUTE ANY PROCEDURE system privilege, SQL 7-498

EXECUTE ANY TYPE privilege, SCN 14-13, SCN 14-14

See also privileges

EXECUTE ANY TYPE system privilege, SQL 7-501

execute count statistic, SRF C-9

EXECUTE DESCRIPTOR statement

SQL statements

EXECUTE DESCRIPTOR, PC_ F-55

Execute Elapsed Time data view, STU 15-10

execute error transaction, RAR 7-15

EXECUTE IMMEDIATE SQL statement, PC_ F-57

EXECUTE IMMEDIATE statement, PC_ 14-24, PCO F-43, PLS 10-3

AT clause, PCO 3-8

AT clause in, PC_ 3-11

examples, PC_ F-58, PCO F-44

use in dynamic SQL method 1, PC_ 13-9

using in dynamic SQL Method 1, PCO 9-9

EXECUTE object privilege, SQL 7-508

EXECUTE optional keyword of ARRAYLEN statement, PC_ 7-18, PCO 6-18

EXECUTE privilege, PLS 7-35

user-defined types, SCN 14-14

verifying user access, SCN 18-18

See also privileges

EXECUTE SQL statement, PC_ F-53

EXECUTE statement, PC_ 14-23, PCO F-40

examples, PC_ F-52, PC_ F-54, PCO F-39, PCO F-41

use in dynamic SQL method 2, PC_ 13-13

using in dynamic SQL Method 2, PCO 9-13

EXECUTE user-defined type, SCN 14-13

EXECUTE_CATALOG_ROLE role, SQL 7-503

EXECUTE_DDL procedure

DBMS_REPCAT package, REP 7-2

EXECUTE_IMMEDIATE, DDS 7-3

restrictions, DDS 7-4

EXECUTE_NON_QUERY, DDS 7-3

EXECUTE...END-EXEC statement, PCO F-38

executing SQL statements, OCI 4-6

execution

against multiple servers, OCI 4-5

modes, OCI 4-7

execution environment, PLS 1-17

execution flow

in dynamic SQL, SPR 48 - 4

execution of statements, PC_ 13-4

execution plan, PC_ C-5, PC_ C-6, PCO D-5

accessing views, SCN 23-19, SCN 23-22, SCN 23-23

complex statements, SCN 23-14

compound queries, SCN 23-27, SCN 23-28, SCN 23-29

joining views, SCN 23-25

joins, SCN 24-2, SCN 24-8

OR operators, SCN 23-12

star transformation, SCN 24-18

execution plans, STU 13-1

execution snapshots, OCI 4-7

EXIST clause

for simple subquery snapshots, REP 3-13

EXISTS

conditions, SQL 5-17

operator, SQL 3-6

EXISTS collection method, PLS 4-22

EXISTS comparison operator, PLS 5-5

EXIT command

of CMCTL, reference, NET A-90

of LSNRCTL, reference, NET A-6

of NAMESCTL, reference, NET A-37

EXIT statement, PLS 3-6, PLS 3-14

syntax, PLS 11-61

WHEN clause, PLS 3-7

where allowed, PLS 3-6

EXP, PSC 8-3, SMS 16-1

EXP function, SQL 4-15

EXP_FULL_DATABASE role, SAD 24-5, SCN 30-22, SQL 7-503, SUT 1-20, SUT 2-11

assigning, SUT 1-9

Export, SUT 1-4

EXPDAT.DMP

Export output file, SUT 1-19

expectations for tuning, STU 1-9

EXPID column

SYS.INCEXP table, SUT 1-51

EXPLAIN PLAN command, SCN 16-4

access paths, SCN 23-38, SCN 23-39, SCN 23-40, SCN 23-41, SCN 23-42, SCN 23-43, SCN 23-44, SCN 23-45, SCN 23-46, SCN 23-47, SCN 23-48, SCN 23-49, SCN 23-50

partition pruning, SCN 11-22

star query, SCN 24-17

star transformation, SCN 24-18

EXPLAIN PLAN statement, SQL 7-486, STU 31-20

and DOMAIN INDEX, STU 13-24

and full partition-wise joins, STU 13-21

and partial partition-wise joins, STU 13-19

and partitioned objects, STU 13-13

examples of output, STU 4-7, STU 13-25, STU 14-15

formatting output for, STU 13-24

function of, PC_ C-6

introduction, STU 12-6

invoking with the TKPROF program, STU 14-10

parallel query, STU 27-30

PLAN_TABLE, STU 13-2

query parallelization, STU 26-73

restrictions, STU 13-28

SQL decomposition, STU 8-6

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

explicit connections, PC_ 3-8

description of, PC_ 3-8

multiple, PC_ 3-12

single, PC_ 3-9

explicit cursor, PLS 5-6

explicit data conversion, SQL 2-32, SQL 2-33

explicit locking, SCN 27-31

manual locking, ADG 8 - 11

explicit logon

single, PCO 3-5

explicit logons, PCO 3-5

multiple, PCO 3-9

Export

base backup, SUT 1-44

BUFFER parameter, SUT 1-16

CATALOG.SQL

preparing database for Export, SUT 1-9

CATEXP7.SQL

preparing the database for Version 7 export, SUT 1-60

CATEXP.SQL

preparing database for Export, SUT 1-9

command line, SUT 1-10

complete, SUT 1-20, SUT 1-44, SUT 1-46

privileges, SUT 1-44

restrictions, SUT 1-44

COMPRESS parameter, SUT 1-16

CONSISTENT parameter, SUT 1-17

CONSTRAINTS parameter, SUT 1-18

creating necessary privileges, SUT 1-9

creating Version 7 export files, SUT 1-58

cumulative, SUT 1-20, SUT 1-44, SUT 1-46

privileges required, SUT 1-44

restrictions, SUT 1-44

data structures, SUT 1-48

database optimizer statistics, SUT 1-23, SUT 2-27

DIRECT parameter, SUT 1-18

direct path, SUT 1-41

displaying help message, SUT 1-20

eight-bit vs. seven-bit character sets, SUT 1-53

establishing export views, SUT 1-9

examples, SUT 1-27

full database mode, SUT 1-27

partition-level, SUT 1-33

table mode, SUT 1-31

user mode, SUT 1-30

exporting an entire database, SUT 1-20

exporting indexes, SUT 1-21

exporting sequence numbers, SUT 1-55

exporting to another operating system, SUT 2-27

RECORDLENGTH parameter, SUT 1-23

FEEDBACK parameter, SUT 1-19

FILE parameter, SUT 1-19

full database mode

example, SUT 1-27

FULL parameter, SUT 1-20

GRANTS parameter, SUT 1-20

HELP parameter, SUT 1-20

incremental, SUT 1-20, SUT 1-44

command syntax, SUT 1-20

example, SUT 1-49

privileges, SUT 1-44

restrictions, SUT 1-44

system tables, SUT 1-50

INCTYPE parameter, SUT 1-20

INDEXES parameter, SUT 1-21

interactive method, SUT 1-10, SUT 1-36

invoking, SUT 1-10

kinds of data exported, SUT 1-48

last valid export

SYS.INCVID table, SUT 1-52

log files

specifying, SUT 1-21

LOG parameter, SUT 1-21

logging error messages, SUT 1-21

LONG columns, SUT 1-55

message log file, SUT 1-39

modes, SUT 1-5

multi-byte character sets, SUT 1-54

network issues, SUT 1-52

NLS support, SUT 1-53

objects exported, SUT 1-5

online help, SUT 1-11

Oracle objects, ADG 18 - 41

OWNER parameter, SUT 1-21

parameter conflicts, SUT 1-27

parameter file, SUT 1-10, SUT 1-13, SUT 1-21

maximum size, SUT 1-13

parameters, SUT 1-14

PARFILE parameter, SUT 1-10, SUT 1-13, SUT 1-21

preparing database, SUT 1-9

previous versions, SUT 1-58

RECORD parameter, SUT 1-23

RECORDLENGTH parameter, SUT 1-23

redirecting output to a log file, SUT 1-39

remote operation, SUT 1-52

restrictions, SUT 1-4

rollback segments, SUT 1-49

ROWS parameter, SUT 1-23

sequence numbers, SUT 1-55

STATISTICS parameter, SUT 1-23

storage requirements, SUT 1-9

SYS.INCEXP table, SUT 1-51

SYS.INCFIL table, SUT 1-51

SYS.INCVID table, SUT 1-52

table mode

example, SUT 1-31

table name restrictions, SUT 1-25

TABLES parameter, SUT 1-24

tracking exported objects, SUT 1-51

transferring export files across a network, SUT 1-52

user access privileges, SUT 1-4

user mode

examples, SUT 1-30

specifying, SUT 1-21

USER_SEGMENTS view, SUT 1-9

USERID parameter, SUT 1-26

using, SUT 1-9

warning messages, SUT 1-39

export controls, placed on encryption technology, OAS 2-2

export data from old database, PSC 8-3

export file

displaying contents, SUT 1-4

importing the entire file, SUT 2-23

listing contents before importing, SUT 2-28

reading, SUT 1-4

specifying, SUT 1-19

Export utility, PSC 8-3, SBR 3-10, SBR 3-14, SCN 1-5

Export/Import

advantages and disadvantages, MIG 2-10

basic steps for migration, MIG 5-2

benefits for migration, MIG 2-12

compatibility, MIG 8-48

data definition conversion, MIG 2-13

direct and conventional path, MIG 8-48

effects on migrated databases, MIG 2-11

incompatible data, MIG 8-49

limitations for migration, MIG 2-12

migration steps using, MIG 5-3

scripts

CATEXP7.SQL, MIG 8-48

time requirements for migration, MIG 2-13

Trusted Oracle, MIG 5-3

Export/Import utilities, GTK 2-57

exporting jobs, SAD 8-7

exports

complete, SBR 13-17

cumulative, SBR 13-17

incremental, SBR 13-17

modes, SAD 7-14, SAD 7-18, SAD 7-19, SBR 13-16

expression

Boolean, PLS 2-46

how evaluated, PLS 2-41

parentheses in, PLS 2-42

syntax, PLS 11-63

expressions

CAST, SQL 5-7

compound, SQL 5-4

computing with the DUAL table, SQL 5-24

CURSOR, SQL 5-9

DECODE, SQL 5-12

function, built-in, SQL 5-5

in SQL syntax, SQL 5-1

list of, SQL 5-13

object access, SQL 5-10

simple, SQL 5-3

type constructor, SQL 5-6

user-defined function, SQL 5-5

variable, SQL 5-4

EXT_TO_OBJ table, SPS 15-12, SPS 20-12

extdemo1.sql demo file (extensible indexing in power demand example), DCI 11-15

EXTEND collection method, PLS 4-24

extended address field

Advanced Queuing, MIG 7-26

extended aggregate operators, GTK 2-24

extended ROWID format, ADG 4 - 19

extended rowid format, SCN 12-17

extended rowids, SQL 2-22

not directly available, SQL 2-22

extensibility, GTK 3-13, PLS 7-3

datatypes, DCI 1-7

interfaces, DCI 1-13

server execution environment, DCI 1-10, DCI 2-5

services, DCI 1-6

extensibility framework, GTK 2-31 to GTK 2-33

cartridge services, GTK 2-32

extensible indexing, GTK 2-31

extensible optimizer, GTK 2-32

heterogeneous services, GTK 2-66

user-defined operators, GTK 2-31

extensible indexing, GTK 2-31

compatibility, MIG 8-10

downgrading, MIG 12-13

queries benefitting, DCI 11-14

extensible optimization, SCN 22-16

user-defined costs, SCN 22-17

user-defined selectivity, SCN 22-17

user-defined statistics, SCN 22-17

extensible optimizer, GTK 2-32

extensions

default file name, PC_ 19-38

OTT default file name, OCI 14-36

extent

allocating PCM locks, SPS 11-15, SPS 17-11

allocating to instance, SPS 17-10, SPS 17-14, SPS 18-16, SRF 1-52

definition, SPS 11-3

initial allocation, SPS 17-13

not allocated to instance, SPS 11-6, SPS 11-17, SPS 17-12

rollback segment, SPS 6-8, SPS 14-7

size, SPS 6-8, SPS 14-7, SPS 17-11

specifying a file, SPS 17-12

extent allocation

FILE command line parameter, SUT 6-6

EXTENT MANAGEMENT clause

for temporary tablespaces, SQL 7-399

of CREATE TABLESPACE, SQL 7-394, SQL 7-396

extents

allocating, ADG 6 - 17, SCN 4-12

clusters, SAD 17-9

index creation, SAD 16-6

tables, SAD 14-11

allocating data blocks for, SCN 4-13

allocating for partitions, SQL 7-140

allocating for subpartitions, SQL 7-140

allocating for tables, SQL 7-140

allocation to rollback segments

after segment creation, SCN 4-24

at segment creation, SCN 4-22

allocation, how performed, SCN 4-13

as collections of data blocks, SCN 4-11

coalescing, SCN 4-15

consolidating into one extent

Export, SUT 1-16

data dictionary views for, SAD 20-30

deallocation

from rollback segments, SCN 4-25

when performed, SCN 4-14

defined, SCN 4-2

dictionary managed, SCN 3-7

displaying free extents, SAD 20-33

displaying information on, SAD 20-32

dropped tabled and, ADG 3 - 10

dropped tables and, SAD 14-12

dropping rollback segments and, SCN 4-25

importing consolidated, SUT 2-53

in rollback segments

changing current, SCN 4-22

incremental, SCN 4-11

locally managed, SCN 3-8

managing, SCN 4-12

materialized views, SCN 4-15

overview of, SCN 4-11

parallel DDL, SCN 26-33

parallel INSERT

storage parameters, SCN 25-8

restricting access by instances, SQL 7-34

size, STU 26-66

specifying maximum number for an object, SQL 7-578

specifying number allocated upon object creation, SQL 7-577

specifying the first for an object, SQL 7-577

specifying the percentage of size increase, SQL 7-577

specifying the second for an object, SQL 7-577

temporary, STU 26-70

unlimited, STU 20-28

external, NET 6-71

external authentication, OAS 11-3

external callout, ADL 2-20

EXTERNAL datatypes

DECIMAL

FLOAT

GRAPHIC

numeric

determining length, SUT 5-73

SQL*Loader, SUT 5-67

trimming, SUT 5-83

ZONED

SQL*Loader, SUT 5-67

external datatypes, OCI 3-4, OCI 3-7

associated with host variables, SQL 2-6

CHAR, OCI 3-16, PCO 4-9

CHARF, PCO 4-9

CHARZ, OCI 3-17, PCO 4-10

conversions, OCI 3-21

DATE, OCI 3-14, PCO 4-10

DECIMAL, PCO 4-10

definition, PCO 2-8

definition of, PC_ 2-7

DISPLAY, PCO 4-11

dynamic SQL method 4, PCO 11-16

FLOAT, OCI 3-11, PC_ 4-6, PCO 4-11

INTEGER, OCI 3-11, PC_ 4-6, PCO 4-11

LOBs, OCI 3-18

LONG, OCI 3-13, PCO 4-11

LONG RAW, OCI 3-15, PCO 4-11

LONG VARCHAR, OCI 3-16, PCO 4-12

LONG VARRAW, OCI 3-16, PCO 4-12

named data types, OCI 3-18

NUMBER, OCI 3-10, PCO 4-12

parameters, PCO 4-48

RAW, OCI 3-14, PCO 4-12

recognized by precompilers, SQL 2-6

STRING, OCI 3-11, PC_ 4-6, PCO 4-14

table of, PCO 4-8

UNSIGNED, OCI 3-15, PCO 4-14

VARCHAR, OCI 3-13, PCO 4-14

VARCHAR2, OCI 3-8, PCO 4-14

VARNUM, OCI 3-12, PCO 4-15

VARRAW, OCI 3-15, PCO 4-15

external files

exporting, SUT 1-56

external functions, SQL 7-267, SQL 7-333

EXTERNAL keyword

SQL*Loader, SUT 5-67

external library, DCI 1-17

linkage, DCI 1-16

external LOB, DCI 6-2

external LOBS

loading, SUT 5-99

external LOBs, SQL 2-19

external LOBs (BFILE), SUT 5-107

external LOBs (BFILEs), ADL 1-2

external naming

advantages and disadvantages, NET 3-9

Cell Directory Service, NET 3-6

configuring, NET 3-7, NET 6-51

described, NET 1-4, NET 3-6, NET 6-5

establishing a connection with, NET 3-6

features, NET 4-31

recommended for, NET 3-9

using NetWare Directory Service

using NetWare Directory Service (NDS), NET 4-31

using Network Information Service, NET 3-6, NET 6-51

using Network Information Service (NIS), NET 4-31

using with Oracle Names, NET 3-7

external procedure, ADG 11 - 3

configuration files for, DCI 4-5

DEBUG_EXTPROC package, ADG 11 - 48

debugging, ADG 11 - 47

guidelines, DCI 4-15

guidelines for using with data cartridge, DCI 4-15

how PL/SQL calls, DCI 4-4

LOBs in, DCI 6-11

maximum number of parameters, ADG 11 - 50

OCI access functions, DCI 4-12

overview, DCI 4-2

PARAMETERS clause, DCI 4-9

passing parameters to, DCI 4-6

registering, DCI 4-3

restrictions, ADG 11 - 50

specifying datatypes, ADG 11 - 16, DCI 4-7

WITH CONTEXT clause, DCI 4-9

external procedure functions

return codes, OCI 18-3

with_context type, OCI 18-3

external procedures, PC_ A-5, SCN 16-20, SCN 18-11, SQL 7-333

callbacks, PC_ 7-29

calling from PL/SQL, PC_ 7-29

configuring, NET 7-65

creating, PC_ 7-30

described, NET 7-65

error-handling, PC_ 7-31

OCI callbacks, OCI 9-17

restrictions, PC_ 7-30

external procedures (routines)

call specification, GTK 2-44

DLL Caching, GTK 2-45

object support, GTK 2-45

Pro*C/C++, GTK 2-81

external procedures. See external routines

external reference, PLS 7-32, SCN 18-10

how resolved, PLS 7-32

name resolution, SCN 18-19

external roles, Net8t/DCE, configuring, OAS 13-6

external routine, PLS 7-28

external routines, GTK 3-12

external routines. See external procedures (external routines)

external users, SQL 7-344, SQL 7-426

externally-authenticated accounts, creating and naming, OAS 13-4

extproc process, ADG 11 - 33, DCI 4-4