Oracle8i Generic Documentation Master Index

EBU

backup management, MIG 9-40

Edit button, in Oracle Directory Manager, OID 4-12

Edit menu item, in Oracle Directory Manager, OID 4-10

Edit Parallel Server dialog box, PSG 7-16

Edit User Preferences dialog box, PSG 6-25

EE date format element, SQL 2-46

ehlo()

function of UTL_SMTP, SPR 65-6

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

EJB, NLS 6-21

elaboration, PLS 2-31

elapsed column

SQL trace, STU 6-12

electric utility example, DCI 11-1

ElemDeclName - oracle.xml.parser.v2.XMLToken.ElemDeclName, JPR 4-136

ELEMENT - oracle.xml.parser.v2.ElementDecl.ELEMENT, JPR 4-32

element types, collection, PLS 4-5

ElementDecl - oracle.xml.parser.v2.ElementDecl, JPR 4-30

ELEMENTDECL - oracle.xml.parser.v2.XMLNode.ELEMENTDECL, JPR 4-106

elementdecl - oracle.xml.parser.v2.XMLToken.elementdecl, JPR 4-137

ELEMENTS - oracle.xml.parser.v2.ElementDecl.ELEMENTS, JPR 4-32

ellipsis, PC_ xvi

ellipsis, defined, NET xx, PSG xxiii

ELSE clause, PLS 3-3

ELSIF clause, PLS 3-4

e-mail

sending from PL/SQL, ADG 12-1

email

sending with UTL_SMTP, SPR 65-1

embedded DDL, PCO 14-32

embedded objects

fetching, OCI 10-15

embedded parameter files, SRF 1-45

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

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

host variables, PCO 6-2

indicator variables, PCO 6-2

multi-byte NLS features, PCO 4-37

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-5, 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-11

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 9-2, OCI 1-11, SCN 1-52, SCN 14, SQL v, SQL 1-4, SQL 6-5

ALLOCATE DESCRIPTOR statement, PCO F-12

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

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

CLOSE statement, PC_ F-18, PCO 5-16, PCO 6-35, PCO F-14

COMMIT statement, PCO F-15

CONNECT statement, PCO F-17

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

CONTEXT FREE statement, PC_ 11-9, PCO 12-8, 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-4

dynamic SQL in PL/SQL, SCN 28

ENABLE THREADS statement, PC_ 11-7, PCO 12-8

EXEC SQL CACHE FREE ALL, PC_ 17-6

EXECUTE IMMEDIATE statement, PCO F-44

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

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

FETCH DESCRIPTOR statement, PCO F-49

FETCH statement, PCO 5-14, PCO 6-34, PCO F-46, PCO F-49

FREE statement, PCO 6-35, PCO F-51

GET DESCRIPTOR staement, PCO F-52

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

key concepts, PCO 2-2

key concepts of, PC_ 2-2

mixing with host-language statements, PC_ 2-4

mixing with OCI calls, OCI 1-11

OPEN DESCRIPTOR statement, PCO F-72

OPEN statement, PC_ F-91, PCO 5-14, PCO F-70, PCO F-71, PCO F-72

overview of, PC_ 2-2

precompiler support of, SQL 6-5

PREPARE statement, PC_ F-95, PCO F-74

requirements for, PC_ 2-4

ROLLBACK statement, PCO F-76

SAVEPOINT statement, PC_ F-102, PCO 3-17, PCO F-79

SELECT statement, PC_ F-103, PCO 5-8, PCO 7-6, PCO F-80

SET DESCRIPTOR statement, PCO F-83

SET TRANSACTION statement, PCO 3-20

syntax for, PC_ 2-4

testing with SQL*Plus, PC_ 1-3

TYPE directive, PC_ F-110

UPDATE statement, PC_ F-111, PCO 5-10, PCO F-86

using OCI types in, PC_ 17-35

using REFs in, PC_ 17-34

VAR directive, PC_ F-115, PCO F-90

versus interactive SQL, PCO 2-6

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

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

embedded SQL statements

embedded SQL statements, See Pro*C/C++ precompiler and Pro*COBOL precompiler

embedding

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

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

EMP database table, PLS xiii

EMP table, PC_ 2-17, PCO 2-28

EMPHASIS resource allocation method, SAD 25-8, SAD 25-10

EMPTY - oracle.xml.parser.v2.ElementDecl.EMPTY, JPR 4-33

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

EMPTY_BLOB()/EMPTY_CLOB()

when to use FAQ, ADL 6-7

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

EMPTY_CLOB()/BLOB()

to initialize a BFILE, ADL 2-6

to initialize internal LOB

EmptyElemTag - oracle.xml.parser.v2.XMLToken.EmptyElemTag, JPR 4-137

Enable a Propagation Schedule, ADQ 9-79

ENABLE ALL TRIGGERS clause

of ALTER TABLE, SQL 7-165

ENABLE clause

of ALTER INDEX, SQL 7-40

of ALTER TRIGGER, SQL 7-184

of constraint_clause, SQL 7-244

of CREATE TABLE, SQL 7-405

ENABLE constraints, SCN 276

ENABLE DISTRIBUTED RECOVERY clause

of ALTER SYSTEM, SQL 7-106

ENABLE NOVALIDATE constraint state, SQL 7-406

ENABLE option

LOG_ARCHIVE_DEST_n initialization parameter, SBY 5-8

ENABLE PARALLEL DML clause

of ALTER SESSION, SQL 7-84

ENABLE QUERY REWRITE clause

of ALTER MATERIALIZED VIEW, SQL 7-54

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-327

ENABLE RESTRICTED SESSION clause

of ALTER SYSTEM, SQL 7-106

ENABLE ROW MOVEMENT clause, SAD 15-8

of ALTER TABLE, SQL 7-164

of CREATE TABLE, SQL 7-383, SQL 7-404

ENABLE STORAGE IN ROW clause

of ALTER TABLE, SQL 7-141

of CREATE TABLE, SQL 7-398

ENABLE TABLE LOCK clause, PSA 10-4

of ALTER TABLE, SQL 7-165

ENABLE THREAD clause

ALTER DATABASE statement, SBY 4-12

of ALTER DATABASE, SQL 7-15

ENABLE THREADS SQL statement, PC_ F-50, PCO F-38

ENABLE THREADS statement, PC_ 11-7, PCO 12-8

ENABLE VALIDATE constraint state, SQL 7-406

ENABLE_POLICY procedure, ADG 11-38

enabled constraints, STU 12-11

enabled destination state

for archived redo logs, SAD 7-13

ENABLE/DISABLE clause

of ALTER TABLE, SQL 7-137, SQL 7-165

of CREATE TABLE, SQL 7-388

enablePropagationSchedule(Session, String) - oracle.jms.AQjmsDestination.enablePropagationSchedule(javax.jms.Session, java.lang.String), JPR 2-67

enabling

integrity constraints, ADG 4-20

roles, ADG 11-16

threads, PC_ 11-7, PCO 12-8

triggers, ADG 13-31

enabling recoverer process

distributed transactions, DDS 5-28

enabling replication, REP 6-17

enabling resource limits, SAD 22-21

enabling SSL, OID 8-2

encapsulation, data, PLS 1-16

enclosed fields

ENCLOSED BY control file clause, SUT 5-16

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

whitespace, SUT 5-86

enclosure delimiters

SQL*Loader, SUT 5-83

encoding scheme, PCO 4-36

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

encrypting

user password, OID 5-16

encryption, ADG 11-4, ADG 11-72, ADG 11-73, OAS 1-12, OID 2-23

database passwords, SAD 21-5, SAD 22-8

DES40, OID 2-26

levels available in Oracle Internet Directory, OID 2-26

RC4_40, OID 2-26

encryption and checksumming

activating, OAS 2-7

client checksum level setting, OAS A-8

client checksum selected list, OAS A-9

client encryption level setting, OAS A-5

client encryption selected list, OAS A-7

client profile encryption, OAS A-10

negotiating, OAS 2-8

parameter settings, OAS 2-11

parameters supported by Oracle Advanced Security, OAS A-1

server checksum level setting, OAS A-8

server checksum selected list, OAS A-9

server encryption level setting, OAS A-5

server encryption selected list, OAS A-6

END, PCO 14-19

END BACKUP clause, PSA 13-20

of ALTER TABLESPACE, SQL 7-180

END IF reserved words, PLS 3-3

END LOOP reserved words, PLS 3-9

END_OF_FETCH precompiler option, PCO 14-19

endDoctype() - oracle.xml.parser.v2.DefaultXMLDocumentHandler.endDoctype(), JPR 4-12

endDoctype() - oracle.xml.parser.v2.XMLDocumentHandler.endDoctype(), JPR 4-87

endElement(NSName) - oracle.xml.parser.v2.DefaultXMLDocumentHandler.endElement(oracle.xml.parser.v2.NSName), JPR 4-12

endElement(NSName) - oracle.xml.parser.v2.XMLDocumentHandler.endElement(oracle.xml.parser.v2.NSName), JPR 4-87

END-OF_FETCH clause, PCO A-5

Ends With filter, in Oracle Directory Manager, OID 6-8

enforced constraints, STU 12-11

ENFORCED mode, DWG 19-26

Enhanced, ADQ 1-16

enhanced DML array, OCI 4-8

enhanced DML array feature, OCI 4-8

Enhanced Propagation Scheduling Capabilities, ADQ 8-110, ADQ 12-98

Enqueue a Message, ADQ 11-5

enqueue and dequeue of messages

by Correlation and Message Id Using Pro*C/C++, ADQ A-37

by priority, ADQ A-14, ADQ A-16, ADQ A-18

of object type, ADQ A-11

of RAW type, ADQ A-14, ADQ A-16, ADQ A-18

of RAW type using Pro*C/C++, ADQ A-22, ADQ A-25

to/from multiconsumer queues, ADQ A-44, ADQ A-47

with time delay and expiration, ADQ A-36

Enqueue and Dequeue Of Messages, Examples, ADQ A-11

ENQUEUE Features, ADQ 8-35

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

ENQUEUE_RESOURCES initialization parameter, REP 7-3, SRF 1-37

ENQUEUE_RESOURCES parameter, DWG 18-23, DWG 18-25

EnqueueOption must be specified - error, ADQ D-12

enqueues, PSC 4-3

being written redo log, SRF B-1

bind, SRF B-1

buffer cache management, SRF B-1

controlfile transaction, SRF B-1

cross-instance call invocation, SRF B-1

database mount, SRF B-1

datafile, SRF B-1

direct loader index creation, SRF B-1

disabling, SRF 1-36

distributed recovery, SRF B-1

distributed TX, SRF B-1

DML, SRF B-1

ENQUEUE_RESOURCES initialization parameter, SRF 1-37

file set, SRF B-1

global, PSC 4-4

in V$LOCK, PSA 9-13

instance attribute lock, SRF B-1

instance number, SRF B-1

instance recovery, SRF B-1

instance registration lock, SRF B-1

instance state, SRF B-1

job queue, SRF B-1

library cache invalidation, SRF B-1

library cache lock, SRF B-1

library cache pin, SRF B-1

local, PSC 4-4

locking, PC_ 3-16

media recovery, SRF B-1

OPS context, PSC 4-5

parallel slave synchronization, SRF B-1

parallel slaves, SRF B-1

password file, SRF B-1

process startup, SRF B-1

redo log "kick", SRF B-1

redo thread, SRF B-1

row cache, SRF B-1

sequence number, SRF B-1

SMON, SRF B-1

sort segment, SRF B-1

space management transaction, SRF B-1

synchronized replication, SRF B-1

system commit number, SRF B-1

temporary segment, SRF B-1

temporary table, SRF B-1

transaction, SRF B-1

transaction recovery, SRF B-1

undo segment, serialization, SRF B-1

user name, SRF B-1

user-defined locks, SRF B-1

ENT_DOMAIN_NAME initialization parameter: obsolete

entended rowids, PLS 2-17

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

enterprise directory service, SAD 21-7, SAD 23-9

enterprise domain, OAS 17-6

setting up, OAS 17-28

Enterprise Java Beans, NLS 6-21, GTK 3-19

Enterprise Manager. See Oracle Enterprise Manager

enterprise roles, OAS 17-5, GTK 2-9, SAD 21-7, SAD 22-11, SAD 23-9, SRF 1-100

enterprise user login

troubleshooting, OAS 17-32

enterprise user management

interoperability, MIG 9-38

enterprise user security, OAS 17-1, NET 2-41

administrative context, OAS 17-6

architecture, OAS 17-11

components, OAS 17-5, OAS 17-19

enterprise domains, OAS 17-6

enterprise roles, OAS 17-5

enterprise users, OAS 17-5

global roles, OAS 17-6

groups

OracleDBCreators, OAS 17-8

OracleDBSecurity, OAS 17-8

OracleNetAdmins, OAS 17-8

installing and configuring, OAS 17-20

Oracle Conext, OAS 17-6

Oracle Enterprise Security Manager, OAS 17-2

OracleDBSecurity container, OAS 17-9

overview, OAS 17-2

schemaless users, OAS 17-12

enterprise users, ADG 11-19, ADG 11-20, OAS 17-5, SAD 21-7, SAD 22-11, SAD 23-9, SCN 280

definition, DDS 1-28

ENTITIES - oracle.xml.parser.v2.AttrDecl.ENTITIES, JPR 4-6

entities, granting access to, OID 9-24, OID 9-31

ENTITY - oracle.xml.parser.v2.AttrDecl.ENTITY, JPR 4-6

EntityDecl - oracle.xml.parser.v2.XMLToken.EntityDecl, JPR 4-137

EntityDeclName - oracle.xml.parser.v2.XMLToken.EntityDeclName, JPR 4-137

EntityValue - oracle.xml.parser.v2.XMLToken.EntityValue, JPR 4-137

entries

adding

by copying an existing entry, OID 7-15

concurrently, OID 4-14

from other applications, OID A-20

mandatory attributes, OID 7-14

optional attributes, OID 7-14

requires write access to parent, OID 7-12

using bulkload, OID A-20

using command line tools, OID 7-25

using ldapadd, OID 4-14, OID A-7

using ldapaddmt, OID 4-14, OID A-9

using Oracle Directory Manager, OID 7-12

assigning object classes to, OID 6-3

attributes, viewing, OID 7-11

audit log, OID 5-24

searching, OID 5-26

comparing, using ldapcompare, OID 4-14

conceptual discussion, OID 2-2

configuration set

deleting

using command line tools, OID 7-25

using ldapdelete, OID 4-14, OID A-16

using ldapmodify, OID A-14

displaying, OID 7-3

distinguished names of, OAS 17-3, OID 2-2

filters, OID 9-21, OID 9-28

group, OID 2-4

inheriting attributes, OID 6-2

loading, OID 6-2

locating, OID 2-3

managing

using command line tools, OID 7-25

using Oracle Directory Manager, OID 4-13

modifying

concurrently, using ldapmodifymt, OID A-14

large numbers, OID A-23

LDAP conventions, OID 7-22

rules, OID 7-22

multiple

adding concurrently, OID 7-25

modifying, OID 7-25

naming, OAS 17-3, OID 2-2

objects associated with an ACI, OID 9-6

parent, OID 6-2

renaming, OID 7-25

rules for changing, OID 7-22

searching

base level, OID 7-6

one-level, OID 7-6

specifying search depth, OID 7-6

subtree level, OID 7-6

using command line tools, OID 7-25

using ldapsearch, OID A-4

using Oracle Directory Manager, OID 7-2

selecting by DN, OID 9-49

specific, granting access to, OID 9-24, OID 9-31

superclasses, selecting, OID 7-14

user

adding, by using ldapadd, OID 7-26

adding, by using Oracle Directory Manager, OID 7-18

modifying, by using ldapmodify, OID 7-27

modifying, by using Oracle Directory Manager, OID 7-24

entry SQL, PCO cxxvii

entry, defined, NET 2-40

entry-level conflicts, replication, OID 10-25

Enumerated Constants in the Administrative Interface, ADQ 2-5

Enumerated Constants in the Operational Interface, ADQ 2-6

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

environment handle

attributes, OCI A-3

description, OCI 2-8

environment variables

compatibility

NCHAR and NLS, MIG 9-28

LSM, LEG 4-2

NLS_DATE_FORMAT, RMN 2-2

NLS_LANG, RMN 2-2

ORA_NLS32, MIG 9-28

ORA_NLS33, MIG 4-19, MIG 9-28

required for migration, MIG 4-19, MIG 4-23

required for upgrading, MIG 7-19

environment variables, NLS_LANG, OID 11-2

EOF Exception (string) - error, ADQ D-10

EPC, SMS 15-1

equal

one LOB locator to another

internal persistent LOBs, ADL 9-162

one temporary LOB locator, to another, ADL 10-118

equal locators

checking if one BFILE LOB locator equals another, ADL 11-165

equality test, SQL 3-5

equijoins, SQL 5-22, STU 9-5

cluster joins, STU 4-55

defined, STU 4-47

defining for a dimension, SQL 7-280

hash joins, STU 4-53

sort-merge, STU 4-51

equipartitioning, SCN 11-23

examples, SCN 11-24, SCN 11-30, SCN 11-31

LOB columns, SCN 11-37

local indexes, SCN 11-29

on one dimension, SCN 11-23

overflow of index-organized tables, SCN 11-41, SCN 11-43

range partitioning, SCN 11-24

equivalencing

host variable equivalencing, PC_ F-115, PCO F-90

user-defined type equivalencing, PC_ F-110

equivalencing datatypes, PCO 4-42

equivalencing of datatypes

datatype equivalencing, PC_ 2-7

equivalency tests, SQL 3-6

erasing

part of LOB

internal persistent LOBs, ADL 9-227

part of temporary LOBs, ADL 10-171

ERROR - oracle.xml.parser.v2.XMLParseException.ERROR, JPR 4-118

error codes

define calls, OCI 2-29

media manager, RMN 9-4

navigational functions, OCI 16-6

RMAN, RMN 9-2, RMN 9-3

error detection

error reporting, PC_ F-119, PCO F-93

error handle

attributes, OCI A-6

description, OCI 2-9

error handling, PC_ 2-8

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

using the ROLLBACK statement, PCO 3-16

using the SQLGLS routine, PCO 8-21

error message text

SQLGLM subroutine, PCO 8-13

Error Messages, ADQ xi, ADQ D-1

error messages

20002-20021 for Net8 OPEN, NET 10-9

additional, OID C-6

contacting Oracle Customer Support, NET 12-59

example of trace data, NET 12-45

in trace file, NET 12-45

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

maximum length of, PC_ 9-23

naming conventions, DCI 2-6

ORA-12203, NET 12-9, NET 12-10, NET 12-14

sample error stack, NET 12-18

parameter values, PSA 1-6

resolving, NET 12-1 to NET 12-59

rollback segment, PSA 3-5

standard, OID C-2

storage options, PSA 8-4

use in error reporting, PC_ 9-16

using log file to track, NET 12-24

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

where available in SQLCA, PC_ 9-16

error reporting

error message text, PCO 8-9

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

parse error offset, PCO 8-9

rows-processed count, PCO 8-9

status codes, PCO 8-9

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

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

error stack

described, NET 12-17

entries in log files, NET 12-24

sample, NET 12-18

typical layers in, NET 12-17

error stacks

interpreting, RMN 9-6

ERROR_SIZE view, SRF 2-143

ERRORS

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

errors

alert log and, SAD 4-15

application errors raised by Oracle packages, ADG 9-43

archiving, SRF 1-61

call trace stack, PSG C-11

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

common tuning, STU 2-15

creating views with errors, ADG 2-16

database server, OID C-2

during discrete transactions, STU 17-3

during migration. See troubleshooting

during RMAN backups, RMN 5-28

error queue, REP 2-20

conflicts, REP 5-11

DEFERROR view, RAR 7-26

managing, RAR 7-26

error transactions

re-executing as alternate user, RAR 7-27

re-executing as receiver, RAR 7-26

example of handling, OCI 2-28

Export, SUT 1-40

export log file, SUT 1-22

fatal

Export, SUT 1-41

Import, SUT 2-47

generated by DB2 load utility, SUT B-3

handling, OCI 2-27

Export, SUT 1-40

Import, SUT 2-45

handling in object applications, OCI 10-35

Import resource errors, SUT 2-46

in embedded SQL, SCN 14

installation, OID C-2

locating in dynamic SQL, SPR 51-31

LONG data, SUT 2-46

messages

trapping, DDS 3-12

object creation, SUT 2-46

Import parameter IGNORE, SUT 2-22

ORA-02055

integrity constrain violation, DDS 3-3

ORA-02067

rollback required, DDS 3-3

ORA-06510

PL/SQL error, DDS 3-13

ORA-1215, SAD 5-9

ORA-1216, SAD 5-9

ORA-1547, SAD 19-28

ORA-1628 through 1630, SAD 19-28

ORA-600, PSG C-12

ORA-9291, PSG 4-16

Oracle Enterprise Manager discovery, PSG C-2

Recovery Manager, RMN 1-13

remote procedures, ADG 9-46, DDS 3-12

returned by DBMS_ALERT package, SPR 16-3

row errors during import, SUT 2-45

snapshot too old, SAD 11-6

trace files and, SAD 4-15

tracked in trace files, SCN 8-15

user-defined, ADG 9-43, ADG 9-44

warning

Export, SUT 1-40

when creating a database, SAD 2-16

when creating control file, SAD 5-9

while starting a database, SAD 3-6

while starting an instance, SAD 3-6

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

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

Import, SUT 2-27

quoted strings, SUT 5-20

establishing a session

external naming, NET 2-38

through shared servers, NET 2-8, NET 2-14

using centralized naming, NET 2-36

using directory naming, NET 2-35

using host naming, NET 2-37

using local naming, NET 2-35

using Oracle Names, NET 2-35

ESTIMATE option

STATISTICS Export parameter, SUT 1-24

ESTIMATE STATISTICS clause

of ANALYZE, SQL 7-204

ESTIMATE STATISTICS option, SAD 19-5

estimating CPU requirements, OID 12-16

estimating materialized view size, DWG 15-7

estimating size of tables, SAD 13-4

estimating sizes

of tables, SAD 13-4

ETag - oracle.xml.parser.v2.XMLToken.ETag, JPR 4-137

ETagName - oracle.xml.parser.v2.XMLToken.ETagName, JPR 4-137

Ethernet

as used in Oracle Parallel Server, PSC 2-5

ETT

overview, DWG 10-2

process, DWG 7-2, DWG 20-5

tools, DWG 10-2

Euro symbol

supported character sets, NLS A-23

EVALUATE_UTILIZATION_W package, DWG 15-9

evaluation, PLS 2-42

short-circuit, PLS 2-45

evaluation, ACL, OID 9-10

precedence rules, OID 9-11

event attribute functions, ADG 14-2

EVENT initialization parameter, SRF 1-37

event publication, ADG 13-54 to ADG 13-56, ADG 14-1

triggering, ADG 13-54

event triggers, ADG 11-59

events in Oracle Trace, STU 14-5

events, auditable, OID 5-27

everyone, granting access to, OID 9-24, OID 9-31

Exact Match filter, in Oracle Directory Manager, OID 6-8, OID 7-7, OID 9-22, OID 9-29

EXAMPBLD script, PLS A-3

example

demonstration programs, OCI B-1

non-blocking mode, OCI 2-38

using OCIThread, OCI 9-8

Example Application Using AQ, ADQ 8-1

Example JMS Applications, ADQ 12-1

examples

Examples, AQ, ADQ A-1

EXAMPLOD script, PLS A-3

Excel, ADO 3-9

exception

raising (OCIExtProcRaiseExcp), DCI 4-13

raising (OCIExtProcRaiseExcpWithMsg), DCI 4-13

EXCEPTION - oracle.jms.AQjmsConstants.EXCEPTION, JPR 2-54

exception handler, DDS 3-12

local, DDS 3-13

exception handlers, PLS 6-15

branching from, PLS 6-17

in PL/SQL, ADG 9-2

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 Handling, ADQ 8-88

Exception Handling During Propagation, ADQ 12-100

Exception Handling, AQ, ADQ 12-86

Exception javax.jms.InvalidDestinationException, ADQ B-50

Exception javax.jms.InvalidSelectorException, ADQ B-51

Exception javax.jms.JMSException, ADQ B-52

Exception javax.jms.MesageNotWriteableException, ADQ B-56

Exception javax.jms.MessageEOFException, ADQ B-53

Exception javax.jms.MessageFormatException, ADQ B-54

Exception javax.jms.MessageNotReadableException, ADQ B-55

EXCEPTION keyword, DDS 3-12

exception operations, described, NET 2-7

Exception oracle.jms.AQjmsInvalidDestinationException, ADQ B-87

Exception oracle.jms.AQjmsInvalidSelectorException, ADQ B-88

Exception oracle.jms.AQjmsMessageEOFException, ADQ B-89

Exception oracle.jms.AQjmsMessageFormatException, ADQ B-90

Exception oracle.jms.AQjmsMessageNotReadableException, ADQ B-91

Exception oracle.jms.AQjmsMesssageNotWriteableException, ADQ B-92

exception tables

dropping, MIG 13-25

exception, PL/SQL, PCO 6-13

definition of, PC_ 7-13

EXCEPTION_INIT pragma, PLS 6-8

syntax, PLS 11-56

using with raise_application_error, PLS 6-10

exception-handling part

of function, PLS 7-7

of PL/SQL block, PLS 1-3

of procedure, PLS 7-4

Exceptions, ADQ B-2

exceptions, PLS 6-2

EXCEPTIONS INTO clause

of ALTER TABLE, SQL 7-163

of constraint_clause, SQL 7-245

of CREATE TABLE, SQL 7-407

EXCEPTIONS keyword

SQL*Loader, SUT 8-21

EXCEPTIONS view, SRF 2-143

EXCHANGE PARTITION, SCN 11-11

EXCHANGE PARTITION clause, SAD 15-19

of ALTER TABLE, SQL 7-162

EXCHANGE PARTITION statement, DWG 7-6

EXCHANGE SUBPARTITION clause, SAD 15-20

of ALTER TABLE, SQL 7-162

EXCLUDING NEW VALUES clause

of ALTER MATERIALIZED VIEW LOG, SQL 7-61

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

exclusive distributed lock

rollback data, SRF 1-42

EXCLUSIVE lock mode, SQL 7-548

exclusive locks

LOCK TABLE command, ADG 7-16

row locks (TX), SCN 231

RX locks, SCN 234

table locks (TM), SCN 232

exclusive mode, PSA 7-19, PSC 5-9, SCN 4-28

compatibility, PSC B-2

free lists, PSA 8-4, PSA 8-9

MAXLOGHISTORY, PSA 13-8

media recovery, PSA 3-3

required for file operations, PSC A-19

specifying instance number, PSA 8-11, SRF 1-47

specifying thread number, PSA 1-7

startup, PSA 8-11

switching archive log mode, PSA 3-8

taking tablespace offline, PSC A-20

EXCLUSIVE option, PSA 4-2

EXCLUSIVE parameter

obsolete for 8.0.4, PSC A-7

exclusive PCM locks, PSC 4-12

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

EXEC ORACLE ELSE statement, PC_ 2-15, PC_ 5-42, PCO 2-25

EXEC ORACLE ENDIF statement, PC_ 2-15, PC_ 5-42, PCO 2-25

EXEC ORACLE IFDEF statement, PC_ 2-15, PC_ 5-42, PCO 2-25

EXEC ORACLE IFNDEF statement, PC_ 2-15, PC_ 5-42, PCO 2-25

EXEC ORACLE OPTION statement

set option values inline, PC_ 10-9

EXEC ORACLE statement

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

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

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

using to enter options inline, PCO 14-7

EXEC ORACLE statements, PC_ 2-15

EXEC SQL CACHE FREE statement, PC_ 17-6

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

using to embed SQL, PC_ 2-4

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 statements, PC_ 20-14

executable code as data source, STU 11-4

executable part

of function, PLS 7-7

of PL/SQL block, PLS 1-3

of 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-522

EXECUTE ANY OPERATOR system privilege, SQL 7-524

EXECUTE ANY PROCEDURE system privilege, SQL 7-524

EXECUTE ANY TYPE privilege, ADO 2-11

See also privileges

EXECUTE ANY TYPE system privilege, SQL 7-528

EXECUTE DESCRIPTOR statement

SQL statements

EXECUTE DESCRIPTOR, PC_ F-55

Execute Elapsed Time data view, STU 14-11

EXECUTE IMMEDIATE SQL statement, PC_ F-57

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

AT clause, PCO 3-8

AT clause in, PC_ 3-11

examples, PC_ F-58, PCO F-45

use in dynamic SQL method 1, PC_ 13-9

using in dynamic SQL Method 1, PCO 9-9

EXECUTE object privilege, SQL 7-535

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

EXECUTE privilege, ADG 11-22, PLS 7-35

user-defined types, ADO 2-11

verifying user access, SCN 61

See also privileges

EXECUTE SQL statement, PC_ F-53

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

examples, PC_ F-52, PC_ F-54, PCO F-40, PCO F-42

use in dynamic SQL method 2, PC_ 13-13

using in dynamic SQL Method 2, PCO 9-13

EXECUTE user-defined type, ADO 2-11

EXECUTE_CATALOG_ROLE role, SQL 7-530

EXECUTE_CATALOG_ROLE roll, SAD 23-3

EXECUTE_IMMEDIATE procedure, DDS 9-3

restrictions, DDS 9-4

EXECUTE_NON_QUERY procedure, DDS 9-3

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

executing SQL statements, OCI 4-6

execution

against multiple servers, OCI 4-5

modes, OCI 4-7

execution environments, PLS 1-17

execution flow

in dynamic SQL, SPR 51-4

execution of statements, PC_ 13-4

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

accessing views, STU 4-80, STU 4-82, STU 4-84

complex statements, STU 4-75

compound queries, STU 4-91, STU 4-92, STU 4-93

joining views, STU 4-89

joins, STU 4-49, STU 4-58

OR operators, STU 4-73

execution plans, STU 5-2

execution snapshots, OCI 4-7

EXIST clause

for simple subquery snapshots, REP 3-15

existance

check for BFILE, ADL 11-134

EXISTS

conditions, SQL 5-18

operator, SQL 3-6

EXISTS collection method, PLS 4-22

EXISTS comparison operator, PLS 5-5

EXIT command

of CMCTL, NET A-82

of LSNRCTL, NET A-6

of NAMESCTL, NET A-34

Exit menu, in Oracle Directory Manager, OID 4-10

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

syntax, PLS 11-65

WHEN clause, PLS 3-7

where allowed, PLS 3-6

EXP, SMS 16-1

EXP function, SQL 4-33

exp utility, PSG 9-5

EXP_FULL_DATABASE role, SAD 23-5, SCN 324, SQL 7-530, SUT 1-21, SUT 2-10

assigning, SUT 1-9

Export, SUT 1-3

EXPDAT.DMP

Export output file, SUT 1-19

expectations for tuning, STU 1-9

expectedElements(Element) - oracle.xml.parser.v2.ElementDecl.expectedElements(org.w3c.dom.Element), JPR 4-33

expectedElements(Element) - oracle.xml.parser.v2.XMLDocument.expectedElements(org.w3c.dom.Element), JPR 4-75

EXPID column

SYS.INCEXP table, SUT 1-52

expiration, ADQ 2-6

Expiration, Time Specification, ADQ 8-49

expired records

removing from recovery catalog, RMN 3-21

EXPLAIN PLAN statement, DWG 18-67, DWG 19-27, SCN 12, SQL 7-512

explicit connections, PC_ 3-8

description of, PC_ 3-8

multiple, PC_ 3-12

single, PC_ 3-9

explicit cursors, PLS 5-6

explicit data conversion, SQL 2-37, SQL 2-38

explicit locking, SCN 242

manual locking, ADG 7-11

explicit logon

single, PCO 3-5

explicit logons, PCO 3-5

Export

base backup, SUT 1-45

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

CATEXP.SQL

preparing database for Export, SUT 1-9

command line, SUT 1-9

complete, SUT 1-21, SUT 1-45, SUT 1-47

privileges, SUT 1-45

restrictions, SUT 1-45

COMPRESS parameter, SUT 1-17

CONSISTENT parameter, SUT 1-17

CONSTRAINTS parameter, SUT 1-19

creating necessary privileges, SUT 1-9

creating Version 7 export files, SUT 1-61

cumulative, SUT 1-21, SUT 1-45, SUT 1-47

privileges required, SUT 1-45

restrictions, SUT 1-45

data structures, SUT 1-49

database optimizer statistics, SUT 1-24, SUT 2-25

DIRECT parameter, SUT 1-19

direct path, SUT 1-42

displaying help message, SUT 1-21

eight-bit versus seven-bit character sets, SUT 1-54

establishing export views, SUT 1-9

examples, SUT 1-28

full database mode, SUT 1-28

partition-level, SUT 1-34

table mode, SUT 1-32

user mode, SUT 1-31

exporting an entire database, SUT 1-21

exporting indexes, SUT 1-22

exporting sequence numbers, SUT 1-57

exporting synonyms, SUT 1-59

exporting to another operating system, SUT 2-26

RECORDLENGTH parameter, SUT 1-24

FEEDBACK parameter, SUT 1-19

FILE parameter, SUT 1-19

full database mode

example, SUT 1-28

FULL parameter, SUT 1-21

GRANTS parameter, SUT 1-21

HELP parameter, SUT 1-21

incremental, SUT 1-21, SUT 1-45

command syntax, SUT 1-21

example, SUT 1-50

privileges, SUT 1-45

restrictions, SUT 1-45

system tables, SUT 1-51

INCTYPE parameter, SUT 1-21

INDEXES parameter, SUT 1-22

interactive method, SUT 1-10, SUT 1-37

invoking, SUT 1-9

kinds of data exported, SUT 1-49

last valid export

SYS.INCVID table, SUT 1-53

log files

specifying, SUT 1-22

LOG parameter, SUT 1-22

logging error messages, SUT 1-22

LONG columns, SUT 1-57

message log file, SUT 1-40

modes, SUT 1-4

multibyte character sets, SUT 1-56

network issues, SUT 1-53

NLS support, SUT 1-54

objects exported, SUT 1-5

online help, SUT 1-11

OWNER parameter, SUT 1-22

parameter conflicts, SUT 1-28

parameter file, SUT 1-9, SUT 1-12, SUT 1-22

maximum size, SUT 1-13

parameters, SUT 1-13

PARFILE parameter, SUT 1-9, SUT 1-12, SUT 1-22

preparing database, SUT 1-9

previous versions, SUT 1-60

RECORD parameter, SUT 1-23

RECORDLENGTH parameter, SUT 1-24

redirecting output to a log file, SUT 1-40

remote operation, SUT 1-53

restrictions, SUT 1-4

rollback segments, SUT 1-50

ROWS parameter, SUT 1-24

sequence numbers, SUT 1-57

STATISTICS parameter, SUT 1-24

storage requirements, SUT 1-9

SYS.INCEXP table, SUT 1-52

SYS.INCFIL table, SUT 1-52

SYS.INCVID table, SUT 1-53

table mode

example, SUT 1-32

table name restrictions, SUT 1-26

TABLES parameter, SUT 1-25

tracking exported objects, SUT 1-52

transferring export files across a network, SUT 1-53

TRIGGERS parameter, SUT 1-27

user access privileges, SUT 1-3

user mode

examples, SUT 1-31

specifying, SUT 1-22

USER_SEGMENTS view, SUT 1-9

USERID parameter, SUT 1-27

using, SUT 1-9

warning messages, SUT 1-40

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

export data from old database, PSG 9-5

export file

displaying contents, SUT 1-3

importing the entire file, SUT 2-22

listing contents before importing, SUT 2-26

reading, SUT 1-3

specifying, SUT 1-19

Export utility, PSG 9-5, SCN 1-11

Export/Import

advantages and disadvantages, MIG 3-10

basic steps for migration, MIG 6-2

benefits for migration, MIG 3-12

compatibility, MIG 9-48

data definition conversion, MIG 3-13

effects on migrated databases, MIG 3-11

incompatible data, MIG 9-49

limitations for migration, MIG 3-12

migration steps using, MIG 6-3

scripts

CATEXP7.SQL, MIG 9-48

time requirements for migration, MIG 3-13

Trusted Oracle, MIG 6-3

Export/Import utilities, GTK 3-57

exporting

EXP utility, DWG 11-4

exporting jobs, SAD 8-6

Exporting Queue Table Data, ADQ 4-2

Exporting Rules, Queue table, ADQ 4-2

exports

complete, SBR 4-20

cumulative, SBR 4-20

incremental, SBR 4-20

modes, SBR 4-19

expression matching

with query rewrite, DWG 19-23

expressions

computing with the DUAL table, SQL 5-26

CURSOR, SQL 5-10

DECODE, SQL 5-12

function, SQL 5-5

function, built-in, SQL 5-5

how evaluated, PLS 2-42

in SQL syntax, SQL 5-1

list of, SQL 5-14

object access, SQL 5-11

parentheses in, PLS 2-43

simple, SQL 5-3

syntax, PLS 11-67

type constructor, SQL 5-6

variable, SQL 5-4

EXT_TO_OBJ table, PSA 9-8, PSA 12-9

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

extdemo3a.java Demonstration Script, DCI A-31

extdemo3.java Demonstration Script, DCI A-21

extdemo3.sql Demonstration Script, DCI A-13

EXTEND collection method, PLS 4-24

extended address field

Advanced Queuing, MIG 7-31

extended aggregate operators, GTK 3-24

extended ROWID format, ADG 3-21

extended rowid format, SCN 12-17

extended rowids, SQL 2-27

not directly available, SQL 2-27

extensibility, GTK 4-14, 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 3-30 to GTK 3-33

cartridge services, GTK 3-32

extensible indexing, GTK 3-31

extensible optimizer, GTK 3-32

heterogeneous services, GTK 3-66

user-defined operators, GTK 3-31

extensibility, in LDAP Version 3, OID 1-3

extensible indexing, GTK 3-31

compatibility, MIG 9-10

downgrading, MIG 13-20

queries benefitting, DCI 11-14

extensible optimization, SCN 140, STU 4-32

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

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

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

extensible optimizer, GTK 3-32

extensions

default file name, PC_ 19-38

OTT default file name, OCI 14-36

extent

allocating to instance, SRF 1-47

extent allocation

FILE command-line parameter, SUT 6-6

EXTENT MANAGEMENT clause

for temporary tablespaces, SQL 7-425

of CREATE TABLESPACE, SQL 7-420, SQL 7-422

extents

allocating, ADG 5-17, SCN 4-14

clusters, SAD 16-9

index creation, SAD 14-5

tables, SAD 13-13

allocating data blocks for, SCN 4-14

allocating for partitions, SQL 7-150

allocating for subpartitions, SQL 7-150

allocating for tables, SQL 7-150

allocating PCM locks, PSA 8-9, PSC 7-21

allocating to instance, PSA 1-6, PSA 8-8, PSA 8-12

allocation to rollback segments

after segment creation, SCN 4-25

at segment creation, SCN 4-23

allocation, how performed, SCN 4-14

as collections of data blocks, SCN 4-12

coalescing, SCN 4-16

consolidating into one extent

Export, SUT 1-17

data dictionary views for, SAD 19-30

deallocating

clusters, SAD 16-9

deallocation

from rollback segments, SCN 4-26

when performed, SCN 4-15

defined, SCN 4-2

dictionary managed, SCN 3-8

displaying free extents, SAD 19-32

displaying information on, SAD 19-32

dropped tabled and, ADG 2-10

dropped tables and, SAD 13-16

dropping rollback segments and, SCN 4-26

importing consolidated, SUT 2-51

in rollback segments

changing current, SCN 4-24

incremental, SCN 4-12

initial allocation, PSA 8-11

locally managed, SCN 3-8

managing, SCN 4-13

materialized views, SCN 4-16

not allocated to instance, PSA 8-10, PSC 7-25

overview of, SCN 4-12

parallel DDL, SCN 190

parallel INSERT

storage parameters, SCN 153

restricting access by instances, SQL 7-35

rollback segment, PSA 3-6, PSC 7-7

size, DWG 14-13, PSA 3-6, PSA 8-9, PSC 7-7

specifying a file, PSA 8-10

specifying maximum number for an object, SQL 7-608

specifying number allocated upon object creation, SQL 7-607

specifying the first for an object, SQL 7-607

specifying the percentage of size increase, SQL 7-607

specifying the second for an object, SQL 7-607

temporary, DWG 18-52

unlimited, STU 20-28

external authentication, OAS 12-3

by network, SAD 22-11

by operating system, SAD 22-10

external callout, ADL 5-26

EXTERNAL datatypes

DECIMAL

FLOAT

GRAPHIC

numeric

determining length, SUT 5-73

SQL*Loader, SUT 5-67

ZONED

SQL*Loader, SUT 5-67

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

associated with host variables, SQL 2-10

CHAR, OCI 3-16, PCO 4-5

CHARF, PCO 4-5

CHARZ, OCI 3-17, PCO 4-6

conversions, OCI 3-21

DATE, OCI 3-14, PCO 4-6

DECIMAL, PCO 4-7

definition, PCO 2-8

definition of, PC_ 2-6

DISPLAY, PCO 4-7

dynamic SQL method 4, PCO 11-16

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

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

LOBs, OCI 3-19

LONG, OCI 3-13, PCO 4-7

LONG RAW, OCI 3-16, PCO 4-7

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

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

named data types, OCI 3-18

NUMBER, OCI 3-10

parameters, PCO 4-44

RAW, OCI 3-15, PCO 4-8

recognized by precompilers, SQL 2-10

STRING, OCI 3-12, PC_ 4-6, PCO 4-9

table of, PCO 4-4

UNSIGNED, OCI 3-16, PCO 4-9

VARCHAR, OCI 3-13, PCO 4-10

VARCHAR2, OCI 3-9, PCO 4-10

VARNUM, OCI 3-12, PCO 4-10

VARRAW, OCI 3-15, PCO 4-11

external files

exporting, SUT 1-58

external functions, SQL 7-285, SQL 7-354

EXTERNAL keyword

SQL*Loader, SUT 5-67

external library, DCI 1-17

linkage, DCI 1-16

external LOB, DCI 6-2

external LOBs, SQL 2-23

external LOBs (BFILEs), SUT 5-106

loading, SUT 5-98

See BFILEs

external LOBs (BFILEs), See BFILEs

external naming

external procedure, ADG 10-2

configuration files for, DCI 4-5

DEBUG_EXTPROC package, ADG 10-48

debugging, ADG 10-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 10-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 10-50

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

WITH CONTEXT clause, DCI 4-9

external procedure functions

return codes, DCI 13-2, OCI 18-3

with_context type, DCI 13-3, OCI 18-3

external procedures, PC_ A-5, SCN 29, SCN 54, SQL 7-354

callbacks, PC_ 7-29

calling from PL/SQL, PC_ 7-29

configuring, NET 8-45

creating, PC_ 7-30

described, NET 8-45

error-handling, PC_ 7-31

extproc program, NET 8-45

OCI callbacks, OCI 9-19

restrictions, PC_ 7-30

external procedures (routines)

call specification, GTK 3-44

DLL Caching, GTK 3-45

object support, GTK 3-45

Pro*C/C++, GTK 3-82

external procedures. See external routines

External Procedures, Debugging, DCI 4-14

external reference, SCN 50

name resolution, SCN 62

external references, PLS 7-31

how resolved, PLS 7-32

external roles, Net8t/DCE, configuring, OAS 14-7

external routines, GTK 4-12, PLS 7-44

external routines. See external procedures (external routines)

external sequence generators, PSA 6-14

external users, SQL 7-366, SQL 7-452

EXTERNAL_NAME attribute, USERENV, ADG 11-44

ExternalID - oracle.xml.parser.v2.XMLToken.ExternalID, JPR 4-137

externally-authenticated accounts

creating and naming, OAS 14-5

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

extproc program, NET 8-45

extractions

data files, DWG 11-2

distributed operations, DWG 11-5