Oracle8i Generic Documentation Master Index

C and C++

debugging DLLs, DCI 4-15

differences from PL/SQL, DCI 5-9

C API, OID 2-33

c attribute, NET 2-40

C clause

of CREATE TYPE, SQL 7-442

of CREATE TYPE BODY, SQL 7-450

C datatypes

manipulating with OCI, OCI 11-5

C language

C call specifications

compatibility, MIG 9-13

C method

mapping to an object type, SQL 7-442

C number format element, SQL 2-41

C preprocessor

directives supported by Pro*C, PC_ 5-28

how used in Pro*C, PC_ 5-28

C structs

generating for a REF, PC_ 17-33

using, PC_ 17-32

C types of collection attributes, PC_ 18-15

C variable in SQLDA

how value is set, PC_ 15-11

purpose of, PC_ 15-11

C++, PC_ 1-8

C++ applications, PC_ 12-1

C++, See Pro*C/C++ precompiler

C, See OCI

cache, PC_ 17-4

buffer cache, PSC 1-4

coherency, PSC 4-9, PSC 5-2

database blocks, SRF 1-24

dictionary, SRF 3-71, SRF 3-88, SRF 3-89, SRF 3-90, SRF 3-91, SRF 3-92

dictionary cache, PSC 4-2

flushing dictionary, PSC 4-8

recovery, PSA 14-6

row cache, PSC 4-2

sequence cache, PSC 8-13, PSC 8-14

statistics, SRF 1-63

CACHE / NOCACHE, ADL 7-8

CACHE clause, SCN 7-4

of ALTER MATERIALIZED VIEW, SQL 7-51

of ALTER MATERIALIZED VIEW LOG, SQL 7-61

of ALTER SEQUENCE. See CREATE SEQUENCE, SQL 7-81

of ALTER TABLE, SQL 7-151

of CREATE CLUSTER, SQL 7-258

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

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-323

of CREATE SEQUENCE, SQL 7-374

of CREATE TABLE, SQL 7-408

CACHE FREE ALL SQL statement, PC_ 17-6

CACHE FREE ALL statement, PC_ F-15

cache functions

server roundtrips, OCI C-4

Cache Fusion, SCN 217

architecture, PSC 6-5

benefits, PSA 12-4

change summary for 8.1, PSC A-3

definition, PSC 6-5

performance, PSA 12-1

tuning, PSA 12-1

cache fusion, GTK 3-61

CACHE hint, SQL 2-67, STU 7-30

cache hit ratios

increasing, STU 19-31

CACHE option

CREATE SEQUENCE command, ADG 2-34

CACHE option, CREATE SEQUENCE, PSC 8-14

cache reads

for LOBS

discontinue using, MIG 13-3, MIG 13-26

CACHE READS option, GTK 2-13

cache recovery, PSC 9-16

CACHE_SIZE_THRESHOLD initialization parameter: obsolete

CACHE_SIZE_THRESHOLD parameter, PSC A-19

obsolete for 8.1, PSC A-6

cached sequence numbers

Export, SUT 1-57

caches

Calendar package, SPR 1-13

calendar systems

CALL clause

of CREATE TRIGGER, SQL 7-433

CALL procedure statement

of CREATE TRIGGER, SQL 7-433

call spec

in procedures, SQL 7-354

of CREATE FUNCTION, SQL 7-289

of CREATE PROCEDURE, SQL 7-357

of CREATE TYPE, SQL 7-442

of CREATE TYPE BODY, SQL 7-450

call specification, PLS 8-3

call specifications, ADG 10-3 to ADG 10-50

downgrading, MIG 13-33

call specifications. See call spec

call specs, GTK 3-19, GTK 3-44

CALL SQL statement, PC_ F-16, PCO 6-23

CALL statement, PC_ 7-27, PC_ A-2, PCO A-2, PCO F-13, SQL 7-226

compatibility, MIG 9-13

example, PC_ 7-28, PCO 6-24

callback, ADL 9-65, ADL 9-76, ADL 9-103, ADL 9-192, ADL 10-152

restrictions, DCI 4-11

Callback Restrictions, DCI 4-11

callbacks, ADG 10-44 to ADG 10-46

application failover, OCI 9-20

dynamic registrations, OCI 9-14

for LOB operations, OCI 7-11

for reading LOBs, OCI 7-12

for writing LOBs, OCI 7-13

from external procedures, OCI 9-19

LOB streaming interface, OCI 7-11

parameter modes, OCI 15-64

registration for application failover, OCI 9-22

restrictions, OCI 9-17

user-defined functions, OCI 9-10

Calling Java from PL/SQL, PC_ A-5

calls

inter-language, PLS 7-44

Oracle call interface, SCN 8-27

remote procedure, DDS 1-46, SCN 416

subprogram, PLS 7-13

Cancel button, in Oracle Directory Manager, OID 4-10

cancel-based media recovery

definition, SBR 3-16

procedures, SBR 5-22, SBR 5-25, SBR 5-28

canceling OCI calls, OCI 2-34

cancelling a cursor, ADG 7-10

cancelling RMAN commands, RMN 1-12

Cannot have more than one open QueueBrowser for the same destination - error, ADQ D-15

Cannot have more than one open Session on a JMSConnection, ADQ D-2

cannot serialize access, SCN 221

Cannot specify both payload factory and sql_data_class - error, ADQ D-11

capacity planning

I/O subsystem, OID 12-6

network requirements, OID 12-14

capture avoidance rule, ADO 2-7

cardinality, DWG 6-3, SCN 10-35, STU 12-21

CARDINALITY column

PLAN_TABLE table, STU 5-5

carriage returns, PLS 2-2

Cartesian products, SQL 5-23, STU 4-48

cartridge services, GTK 3-32

Cartridge Services -- File I/O Interface, DCI 13-72

CartridgeServices.jar, MIG 8-5

CAs. See certificate authorities.

CASCADE actions

DELETE statements and, SCN 267

CASCADE clause

of CREATE TABLE, SQL 7-408

of DROP PROFILE, SQL 7-494

of DROP USER, SQL 7-510

CASCADE CONSTRAINTS clause

of DROP CLUSTER, SQL 7-473

of DROP TABLE, SQL 7-502

of DROP TABLESPACE, SQL 7-504

of REVOKE schema_object_privileges, SQL 7-561

CASCADE CONSTRAINTS option, ADG 11-32

CASCADE option

integrity constraints, ADG 5-18

when dropping unique or primary keys, SAD 19-19

cascading revokes, SAD 23-15

CASE expressions, DWG 17-52, GTK 2-14, SQL 5-13

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

case sensitivity

identifier, PLS 2-5

in precompiler options, PC_ 10-2

string literal, PLS 2-9

case studies

preparing tables for SQL*Loader, SUT 4-4

SQL*Loader, SUT 4-1

SQL*Loader associated files, SUT 4-3

SQL*Loader filenames, SUT 4-3

CASE1.RCV sample script

setting size limits for backup pieces, RMN 2-21

case-insensitive sorting, NLS 2-31

case-insensitivity, PCO 2-11

CAST expressions, SQL 5-7

CAT synonym for USER_CATALOG view, SRF 2-93

catalog command (RMAN), RMN 3-9, RMN 3-34, RMN 10-35

Catalog Management tool, OID 4-16, OID 6-34

catalog management tool, OID 6-30

CATALOG view, SRF 2-93

catalog views

v$temporary_lobs, ADL 10-13

CATALOG5.SQL script, obsolete with Oracle8i, MIG 9-25

CATALOG6.SQL script, obsolete with Oracle8i, MIG 9-25

cataloged attributes

orcleventtype, OID 5-25

orcluserdn, OID 5-25

cataloging

archived redo logs, RMN 3-9

datafiles, RMN 3-9

cataloging operating system copies, RMN 5-27

catalog.sh. See catalog management tool.

CATALOG.SQL

preparing database for Export, SUT 1-9

preparing database for Import, SUT 2-6

CATALOG.SQL script, MIG 4-4, MIG 4-33, MIG 7-22, MIG 13-60, RMN 3-2, SRF 5-3

creating V$ views, SRF 3-1

CATAUDIT.SQL script

audit trail records created by, SRF 2-168

audit trails for connections and disconnections, SRF 2-168

auditing characteristics described by, SRF 2-177

running, SAD 24-4

CATBLOCK.SQL script, SAD 4-15, SRF 5-3

CATEXP7.SQL

preparing database for Export, SUT 1-63

CATEXP7.SQL script, MIG 9-48, SRF 5-3

downgrading to Oracle7, MIG 14-3

CATEXP.SQL

preparing database for Export, SUT 1-9

preparing database for Import, SUT 2-6

CATHO.SQL script

installing data dictionary for Heterogeneous Services, DDS 7-2

CATHS.SQL script, SRF 5-3

CATIO.SQL script, SRF 5-3

CATLDR.SQL

setup script

SQL*Loader, SUT 8-10

CATNOADT.SQL script, SRF 5-6

CATNOAUD.SQL script, SRF 5-6

running, SAD 24-5

CATNOHS.SQL script, SRF 5-6

CATNOPRT.SQL script, SRF 5-6

CATNOQUE.SQL script, MIG 7-33

CATNOQUEUE.SQL script, SRF 5-6

CATNORMN.SQL script, SRF 5-7

CATNOSVM.SQL script, SRF 5-7

CATNSNMP.SQL script, SRF 5-7

CATOCTK.SQL script, SRF 5-4

CATPARR.SQL script, MIG 4-33, MIG 7-29, MIG 13-60, MIG 13-61, PSA 9-8, PSA 12-9, SRF 5-4, STU 19-31

CATPERF.SQL file, STU 19-38

CATPROC.SQL script, ADG 13-4, ADG 14-2, MIG 4-4, MIG 4-33, MIG 7-22, MIG 13-60, RMN 3-2, SRF 5-3

catproc.sql script, SPR 1-2

CATQUEUE.SQL script, MIG 7-33, SRF 5-4

CATREP.SQL script, MIG 4-33, MIG 5-20, MIG 7-24, MIG 13-60, SRF 5-4

CATRMAN.SQL script, RMN 3-10, SRF 5-4

CC date format, ADG 3-12

CC date format element, SQL 2-46

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

cDATASection(char[], int, int) - oracle.xml.parser.v2.DefaultXMLDocumentHandler.cDATASection(char[], int, int), JPR 4-11

cDATASection(char[], int, int) - oracle.xml.parser.v2.XMLDocumentHandler.cDATASection(char[], int, int), JPR 4-86

CDS

naming adapter components, OAS 12-4

naming adapter includes, OAS 12-4

using to perform name lookup, OAS 14-15

CDS external naming, NET 2-37, NET 4-25, NET 6-79, NET 8-20

cds_attributes file

modifying for name resolution in CDS, OAS 14-15

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

CEIL function, SQL 4-18

Cell Directory Service

using to perform name lookup, OAS 14-15

Cell Directory Service (CDS), naming adapter includes, OAS 12-4

Cell Directory Services external naming, NET 2-37, NET 4-25, NET 8-20

configuring, NET 6-79

centralized naming, NET 6-4

advantages and disadvantages, NET 5-4

described, NET 2-36

establishing a connection with, NET 6-4

recommended for, NET 5-4

centralized user management

distributed systems, DDS 1-27

century, ADG 3-10, SCN 12-12

date format masks, ADG 3-9

specifying, SQL 2-47

CERN proxy server, OAS 10-10

certificate

definition, OAS 10-4

certificate authorities, OID 2-22

definition, OID 2-22

certificate authority, GTK 3-74, SCN 283

definition, OAS 10-4

certificate-based authentication, OID 1-5, OID 2-22

certificates, OID 2-22, OID F-5

definition, OID 2-22

requests for, OID 2-23

trusted, OID 2-23

X.509 Version 3, OID 2-23

CGI variables, ADG 12-2

Chadwick, David, OID 2-33

chained row tables

dropping, MIG 13-25

chained rows, STU 20-31

listing, SQL 7-207

CHAINED_ROWS view, SRF 2-93

chaining of rows, SCN 4-10, SCN 10-5

challenge-response (asynchronous) authentication in RADIUS, OAS 4-6

change

capture, DWG 11-6

data capture, DWG 11-6

CHANGE CATEGORY clause

of ALTER OUTLINE, SQL 7-63

change command (RMAN), RMN 3-15, RMN 10-38

available option, RMN 3-13

delete option, RMN 3-20, RMN 3-36

unavailable option, RMN 3-13

change log processing thread, OID 2-16

change logs, OID 2-12, OID 2-14, OID 2-16

in replication, OID 1-5, OID 2-15, OID 2-17

worker threads in processing, OID 10-13

change retry count, setting, OID 10-12

change status log, OID 2-16

change types, in ldapmodify input files, OID A-12

change vectors, SAD 6-2

redo records, SBR 1-9

CHANGE_PASSWORD command, NET A-4

change-based media recovery, SBR 5-30

coordinated in distributed databases, SBR 6-17

definition, SBR 3-16

changeLog, OID F-3

change-log flag, OID 10-17

toggling, OID 10-17

changeLogEntry, OID F-3

change-logging, OID 3-4

changeNumber, OID F-3

changes

making permanent, SQL 7-230

changeStatus, OID F-3

changeStatusEntry, OID F-3

changetype

changing

a configuration set entry, OID 3-9

attribute values, OID 7-22

audit level, OID 5-29

configuration set entry values, OID 5-2

location of Oracle wallet, OID 5-10, OID F-6

passwords

to directory, OID 5-19

changing default storage parameters, SQL 7-180

channel bandwidth, STU 16-6

channels

allocating, RMN 1-28

allocating to MTS sessions, RMN 10-11, RMN 10-15

controlling RMAN, RMN 1-28

managing RMAN, RMN 1-28

parellelization of, RMN 1-31

CHAR

class, NLS 6-8

datatype, PLS 2-15

multi-byte character sets and, NLS 3-15

external datatype, OCI 3-16

maximum size

change, MIG 9-16

object, creating, NLS 6-8

semantics, PLS B-1

CHAR column

maximum width, PLS 2-15

CHAR columns

Version 6 export files, SUT 2-62

CHAR datatype, ADG 3-5, PC_ 4-10, SCN 12-5, SQL 2-15

ANSI, SQL 2-28

blank-padded comparison semantics, SCN 12-5

column length, ADG 3-6

converting to VARCHAR2, SQL 2-40

delimited form and SQL*Loader, SUT 5-70

increasing column length, ADG 2-9, SAD 13-11

reference

SQL*Loader, SUT 5-64

CHAR datatypes

external, PCO 4-5

CHAR VARYING datatype, ANSI, SQL 2-28

CHAR_MAP precompiler option, PC_ 5-2, PC_ 10-12, PC_ A-3

character data, PC_ 5-2

binary sorts, NLS 2-28

linguistic indexes, NLS 2-29

linguistic sorts, NLS 2-28

special cases, NLS 2-31

sorting, NLS 2-28

varying width, ADL 2-4

CHARACTER datatype

ANSI, SQL 2-28

DB2, SQL 2-29

SQL/DS, SQL 2-29

character datatypes

conflicting fields, SUT 5-73

character fields

datatypes

SQL*Loader, SUT 5-64

delimiters and SQL*Loader, SUT 5-64, SUT 5-70

determining length for SQL*Loader, SUT 5-73

character functions, SQL 4-4, SQL 4-5

character host variables

as output variables, PCO 4-31

handling, PCO 4-29

server handling, PCO 4-31

types, PCO 4-29

CHARACTER keyword

behavior in Oracle7 and Oracle8i, MIG 9-23

character large object, see CLOB

character large objects. See CLOB datatype

character literal. See text

character literals, PLS 2-8

character mappings

alternate, NLS 4-10

character set

for net service name, NET C-5

network, for keyword values, NET C-4

CHARACTER SET clause

of CREATE CONTROLFILE, SQL 7-266

OF CREATE DATABASE, SQL 7-271

character set form, OCI 5-31

getting

internal persistent LOBs, ADL 9-177

character set ID

getting the

internal persistent LOBs, ADL 9-174

temporary LOB of, getting the, ADL 10-127

See CSID parameter

character set Id, OCI 5-31

Unicode, OCI A-21, OCI A-23

CHARACTER SET parameter

of ALTER DATABASE, SQL 7-16

character sets, NLS 6-9, PLS 2-2

8-bit versus 7-bit, NLS 4-5

ANY_CS, SPR 18-3

Asian, NLS A-7

CLOB and NCLOB datatypes, SCN 12-14

column lengths, SCN 12-6

common, SQL 2-33

conversion, NLS 3-24

during Export/Import, SUT 1-54, SUT 2-52

conversion using OCI, NLS 5-34

converting, NLS 4-5

definition files, NLS B-2

direct path export, SUT 1-44, SUT 1-54

eight-bit to seven-bit conversions

Export/Import, SUT 1-54, SUT 2-53

European, NLS A-9

for various languages, SCN 5-5

Heterogeneous Services, DDS A-6

Middle Eastern, NLS A-15

migrating the database, MIG 4-8, MIG 5-6

Migration utility, MIG 4-8

multi-byte, NLS 3-15, PCO 4-37

multibyte

and SQL*Loader, SUT 5-30

Export/Import, SUT 1-56, SUT 2-54

multi-byte characters

in role names, SAD 23-7

in role passwords, SAD 23-8

multibyte characters, SQL 2-72

NCHAR and NVARCHAR2, SCN 12-7

NCHAR data

Export, SUT 1-56

Oracle Data Migration Assistant, MIG 5-6

parameter file and, SAD 3-15

parameters, NLS 2-34

pattern matching characters, NLS 4-10

RMAN errors, RMN 9-32

setting for use with RMAN, RMN 2-3

single-byte

Export/Import, SUT 1-54, SUT 2-53

sorting data, NLS 2-28

specifying for database, SQL 7-271

specifying when creating a database, SAD 2-2

SQL*Loader conversion between, SUT 5-30

storage, NLS A-6

support for, DCI 2-12

supported, NLS 3-18

supporting Euro symbol, NLS A-23

universal, NLS A-17

varying-width

CLOBs and NCLOBs, MIG 9-26

Version 6 conversions

Import/Export, SUT 2-54

character strings

as part of a field comparison, SUT 5-15

comparison rules, SQL 2-32

exact matching of, SQL 2-51

fixed-length, SQL 2-15

multi-byte, PCO 4-38

multibyte, PC_ 4-52

national character set, SQL 2-15

SQL*Loader, SUT 5-46

variable length, SQL 2-16

variable-length, SQL 2-19

zero-length, SQL 2-15

CHARACTER subtype, PLS 2-15

character values

CHARACTER VARYING datatype

ANSI, SQL 2-28

characters

numeric group separators, SRF 1-78

single, comparison rules, SQL 2-33

CHARACTERSET keyword

SQL*Loader, SUT 5-31

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

CHARF datatype, PC_ 4-11, PC_ 5-15

CHARF datatype specifier, PCO 4-47

using in VAR statement, PCO 4-47

CHARF datatypes

external, PCO 4-5

CHARSETFORM property, ADG 10-24

CHARSETID property, ADG 10-24

CHARTOROWID function, ADG 3-25, SCN 12-24, SQL 2-37, SQL 4-19

CHARZ

external datatype, OCI 3-17

CHARZ datatype, PC_ 4-11

external, PCO 4-6

CHECK clause

of constraint_clause, SQL 7-241

of CREATE TABLE, SQL 7-393

CHECK constraint

triggers and, ADG 13-40, ADG 13-47

check constraints, SCN 271, SQL 7-241

checking mechanism, SCN 273

defined, SCN 271

how to use, ADG 4-15 to ADG 4-20

Import, SUT 2-45

multiple constraints on a column, SCN 271

partially null foreign keys, SCN 266

subqueries prohibited in, SCN 271

CHECK DATAFILES clause, PSC 7-2

instance recovery, PSA 14-4

of ALTER SYSTEM, SQL 7-105

CHECK_OBJECT procedure, SAD 20-2, SAD 20-4, SAD 20-5

example, SAD 20-10

CHECK_ONLY

Migration utility option, MIG 4-17, MIG 4-21

checkerr() function

code listing, OCI 2-28

checking in a LOB

internal persistent LOBs, ADL 9-75

checking out a LOB

internal persistent LOBs, ADL 9-64

checkNamespace(String, String) - oracle.xml.parser.v2.XMLElement.checkNamespace(java.lang.String, java.lang.String), JPR 4-93

checkpoint

forcing, SQL 7-105

CHECKPOINT clause

ALTER SYSTEM statement, STU 24-7

of ALTER SYSTEM, SQL 7-105

checkpoint process, SAD 4-12

checkpoint process (CKPT), SCN 1-17, SCN 8-11

checkpoints

checkpoint interval, SRF 1-63

checkpoint process (CKPT), SCN 1-17, SCN 8-11

choosing checkpoint frequency, STU 20-40

control files and, SCN 363

DBWn process, SCN 8-8, SCN 8-11

fast-start checkpointing, SCN 354

forcing, PSA 13-14

incremental, SCN 8-8

recorded in control file, SBR 1-7

statistics, SRF 1-63

statistics on, SCN 8-11

checksumming and encryption, activating, OAS 2-7

checksums, OAS 1-5

for data blocks, SAD 10-12

redo log blocks, SAD 6-17

child process termination, NET 10-12

CHOOSE hint, SQL 2-64, STU 4-11, STU 7-8

CHR function, SQL 4-19

CHUNK, ADL 7-10

CHUNK clause

of ALTER TABLE, SQL 7-141

of CREATE TABLE, SQL 7-399

chunksize, ADL 9-201

multiple of, to improve performance, ADL 9-103

cipher suites, OID 2-23

in SSL, OID 8-2

SSL, OAS B-12

SSL_RSA_EXPORT_WITH_DES40_CBC_SHA, OID 8-2

SSL_RSA_EXPORT_WITH_RC4_40_MD5, OID 8-2

SSL_RSA_WITH_NULL_MD5, OID 8-2

SSL_RSA_WITH_NULL_SHA, OID 8-2

ckcfg.ora file, NET 6-49

ckpcch.ora file, NET 6-49, NET 11-6

ckpreg.ora file, NET 6-49

CKPT background process, SCN 1-17, SCN 8-11

Class - AQjmsQueueConnectionFactory, ADQ B-81

Class - oracle.AQ.AQQueueTableProperty, ADQ B-94

Class - oracle.jms.AQjmsAdtMessage, ADQ B-64

Class - oracle.jms.AQjmsAgent, ADQ B-65

Class - oracle.jms.AQjmsBytesMessage, ADQ B-66

Class - oracle.jms.AQjmsConnection, ADQ B-67

Class - oracle.jms.AQjmsConstants, ADQ B-69

Class - oracle.jms.AQjmsDestination, ADQ B-71

Class - oracle.jms.AQjmsDestinationProperty, ADQ B-73

Class - oracle.jms.AQjmsFactory, ADQ B-74

Class - oracle.jms.AQjmsMapMessage, ADQ B-75

Class - oracle.jms.AQjmsObjectMessage, ADQ B-77

Class - oracle.jms.AQjmsOracleDebug, ADQ B-78

Class - oracle.jms.AQjmsProducer, ADQ B-79

Class - oracle.jms.AQjmsQueueBrowser, ADQ B-80

Class - oracle.jms.AQjmsSession, ADQ B-82

Class - oracle.jms.AQjmsStreamMessage, ADQ B-83

Class - oracle.jms.AQjmsTextMessage, ADQ B-84

Class - oracle.jms.AQjmsTopicConnectionFactory, ADQ B-85

Class must be specified for queues with object payloads
Use dequeue - error, ADQ D-11

Class not found

(string) - error, ADQ D-3

Class oracle.jms.AQjmsException, ADQ B-86

Classes, ADQ B-2

Classes, JMS, ADQ B-5

clauses

AUTHID, PLS 7-4, PLS 7-6, PLS 7-31

BULK COLLECT, PLS 4-37

LIMIT, PLS 4-39

CLEANUP_ROLLBACK_ENTRIES initialization parameter: obsolete

CLEANUP_ROLLBACK_ENTRIES parameter, PSC A-11, PSC A-15

CLEAR LOGFILE clause

ALTER DATABASE statement, SBR 6-9

of ALTER DATABASE, SQL 7-9, SQL 7-19

CLEAR LOGFILE GROUP clause

ALTER DATABASE statement, SBY 4-16

CLEAR LOGFILE option

ALTER DATABASE statement, SAD 6-17

CLEAR UNARCHIVED LOGFILE clause

ALTER DATABASE statement, SBY 4-12, SBY 5-28

clearBody() - oracle.jms.AQjmsAdtMessage.clearBody(), JPR 2-9

clearBody() - oracle.jms.AQjmsBytesMessage.clearBody(), JPR 2-30

clearBody() - oracle.jms.AQjmsMapMessage.clearBody(), JPR 2-86

clearBody() - oracle.jms.AQjmsMessage.clearBody(), JPR 2-102

clearBody() - oracle.jms.AQjmsObjectMessage.clearBody(), JPR 2-127

clearBody() - oracle.jms.AQjmsStreamMessage.clearBody(), JPR 2-186

clearBody() - oracle.jms.AQjmsTextMessage.clearBody(), JPR 2-199

clearing online logs

implication for standby databases, SBY 4-16

clearing redo log files, SAD 6-7, SAD 6-17, SBR 2-14

restrictions, SAD 6-17

clearProperties() - oracle.jms.AQjmsBytesMessage.clearProperties(), JPR 2-31

clearProperties() - oracle.jms.AQjmsMapMessage.clearProperties(), JPR 2-87

clearProperties() - oracle.jms.AQjmsMessage.clearProperties(), JPR 2-103

clearProperties() - oracle.jms.AQjmsObjectMessage.clearProperties(), JPR 2-128

clearProperties() - oracle.jms.AQjmsStreamMessage.clearProperties(), JPR 2-187

clearProperties() - oracle.jms.AQjmsTextMessage.clearProperties(), JPR 2-199

client

load balancing, PSC 8-10

randomization, PSC 8-10

client application failover

configuring, SBY 5-36

client application layer, described, NET 3-6

client authentication in SSL, requiring, OAS 10-28

client configuration

client connections

methods of, NET 11-11

syntax, NET 11-10

client events, ADG 14-7

client load balancing, NET xviii, NET 2-20, NET C-40, PSC 8-10

configuring, NET 8-4, PSG 4-2

described, PSG 4-2

using to improve network performance, NET 5-8

with TAF, PSG 5-4

with Transparent Application Failover, PSG 5-4

client programs, PLS 9-2

Client Registration ID field, NET 8-23

client testing

connectivity, NET 11-17

using application, NET 11-11

using OS, NET 11-11

using special commands, NET 11-12

with 3GL, NET 11-12

with Net8 Assistant, NET 11-22

client troubleshooting, NET 12-4

CLIENT_INFO attribute, USERENV, ADG 11-43

client32net.cfg file, NET 6-87

clients

browse policy, LEG 2-6

communicating with servers on Windows NT, LEG B-7

DHCP, LEG B-10

failover, PSC 9-9

index, LEG 2-5

resource attributes, LEG 2-20, LEG 2-21, LEG 2-22, LEG 2-23

retention policy, LEG 2-6

clients, failover options on, OID 14-4

client/server applications, STU 3-11, STU 18-5

client/server architectures, SCN 6-2

clients, SCN 1-32

diagrammed, SCN 6-2

direct and indirect connections, SCN 379

distributed databases, DDS 1-7

direct and indirect connections, DDS 1-9

distributed databases and, SCN 376

distributed processing in, SCN 6-2

Legato

UNIX, LEG B-1

Windows NT, LEG B-7

NLS, DDS 1-47

overview of, SCN 1-32, SCN 6-2

program interface, SCN 8-27

client-server configurations, MIG 1-4

CLOB, DCI 6-2

datatype, OCI 3-21

EMPTY_CLOB function, DCI 6-4

CLOB class, See JDBC

CLOB datatype, PLS 2-23, SCN 12-14, SQL 2-25

NCLOBs, SPR 18-3

transactional support of, SQL 2-25

CLOB-buffering, See JDBC

CLOBs

columns

varying- width character data, ADL 2-4

compatibility, MIG 9-26

datatype, ADL 2-2

varying-width columns, ADL 2-4

DBMS_LOB, offset and amount parameters in characters, ADL 3-7

example, SUT 4-39

loading, SUT 5-98

modify via DBMS_LOB, ADL 3-8

reading/examining with JDBC, ADL 3-41

using JDBC to modify, ADL 3-40

varying-width, ADL 2-4

CLOBs support, REP A-7

clone database

clone databases

preparing for TSPITR, SBR 7-11

preparing parameter files for, SBR 7-10

recovering, SBR 7-12

Clone method, See Oracle Objects for OLE (OO4O)

cloneNode(boolean) - oracle.xml.parser.v2.DTD.cloneNode(boolean), JPR 4-24

cloneNode(boolean) - oracle.xml.parser.v2.XMLAttr.cloneNode(boolean), JPR 4-57

cloneNode(boolean) - oracle.xml.parser.v2.XMLDocument.cloneNode(boolean), JPR 4-71

cloneNode(boolean) - oracle.xml.parser.v2.XMLElement.cloneNode(boolean), JPR 4-93

cloneNode(boolean) - oracle.xml.parser.v2.XMLNode.cloneNode(boolean), JPR 4-107

CLOSE command

examples, PCO F-15

CLOSE CURSOR statement, PC_ 14-27

CLOSE DATABASE LINK clause

ALTER SESSION statement, DDS 3-2

of ALTER SESSION, SQL 7-84

CLOSE SQL statements, PC_ F-18

CLOSE statement, PC_ 6-15, PCO F-14, PLS 5-11, PLS 5-24

dependence on precompiler options, PC_ 6-15

example, PCO 5-16

example of, PC_ 6-15

examples, PC_ F-19

in dynamic SQL method 4, PCO 11-38

purpose of, PC_ 6-12, PC_ 6-15

syntax, PLS 11-17

use in dynamic SQL method 4, PC_ 15-37

close() - oracle.jms.AQjmsConnection.close(), JPR 2-44

close() - oracle.jms.AQjmsConsumer.close(), JPR 2-57

close() - oracle.jms.AQjmsProducer.close(), JPR 2-134

close() - oracle.jms.AQjmsQueueBrowser.close(), JPR 2-147

close() - oracle.jms.AQjmsSession.close(), JPR 2-160

close_all_connections()

as a function of UTL_TCP, SPR 66-14

CLOSE_CACHED_OPEN_CURSORS initialization parameter: obsolete

close_connection()

as a function of UTL_TCP, SPR 66-13

CLOSE_CURSOR function, DDS 9-3

CLOSE_ON_COMMIT

precompiler option, PC_ 10-12, PC_ A-5, PCO 3-15, PCO 5-13

CLOSE_ON_COMMIT precompiler option, PCO 14-14

CLOSE_RELAY command, NET A-81

closed backups, SBR 1-18

closed thread, PSA 13-4, PSA 13-21

closing

all open BFILEs, ADL 11-211

BFILEs, ADL 11-196

BFILEs with CLOSE, ADL 11-203

BFILEs with FILECLOSE, ADL 11-198

cursors, PC_ F-18, PCO F-14

closing database links, DDS 2-18

CLU synonym for USER_CLUSTERS, SRF 2-94

cluster

hash cluster, PSC A-22

implementations, PSC 8-11

performance, PSC 8-7

CLUSTER clause

of CREATE INDEX, SQL 7-297

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-322

of CREATE TABLE, SQL 7-401

of TRUNCATE, SQL 7-613

CLUSTER hint, SQL 2-65, STU 7-11

cluster joins, STU 4-55

cluster keys, SCN 1-26, SCN 10-52

Cluster Manager, PSC 9-6

node monitoring, PSC 3-3

purpose, PSC 3-3

Cluster Manager (CM)

defined, PSG 1-5

DefinedNodes registry value, PSG 3-26

Cluster Manager software, PSA 4-2

purpose, PSC 3-3

cluster re-organization, PSC 9-14

cluster, defined, PSG 1-2

clustered computer systems

Oracle Parallel Server, SCN 5-3

clustered tables. See clusters.

clusters, ADG 5-14 to ADG 5-19, STU 12-25

allocating extents, ADG 5-17, PSA 8-12, SAD 16-9

allocating extents for, SQL 7-3

altering, SAD 16-9

analyzing statistics, SAD 19-3

assigning tables to, SQL 7-401

caching retrieved blocks, SQL 7-258

cannot be partitioned, SCN 11-2

choosing data to cluster, SCN 10-52

cluster indexes, SAD 16-10

altering, SAD 16-10

creating, SAD 16-8

dropping, SAD 16-11

cluster indexes on, SQL 7-297

cluster keys

columns for, SAD 16-4

definition, SAD 16-2

SIZE parameter, SAD 16-5

cluster tables

copying data, MIG 3-15

clustered tables, SAD 16-2, SAD 16-4, SAD 16-7, SAD 16-11

ALTER TABLE restrictions, SAD 16-10

collecting statistics on, SQL 7-204

columns for cluster key, SAD 16-4

components of, PSC 2-2

creating, SAD 16-6, SQL 7-254, SQL 7-255

data blocks allocated to, SQL 7-256

deallocating extents, SAD 16-9

deallocating unused extents, SQL 7-3

defined, SCN 1-26

definition of, PSC 1-2

degree of parallelism

changing, SQL 7-3

when creating, SQL 7-258

dictionary locks and, SCN 240

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

dropping, SAD 16-10

dropping tables of, SQL 7-473

estimating space, SAD 16-5, SAD 16-6

Export, SUT 1-50

free list groups, PSA 8-9

free lists, PSA 8-5

granting

system privileges on, SQL 7-521

guidelines for managing, SAD 16-4 to SAD 16-6

hash, SCN 10-54, SQL 7-257

allocation of space for, SCN 10-59

collision resolution, SCN 10-57

contrasted with index, SAD 17-2, SCN 10-55

root blocks, SCN 10-59

scans of, STU 4-22, STU 4-36, STU 4-38

single-table, SCN 10-61, SQL 7-257

storage of, SCN 10-55

hash cluster, PSA 8-5

hash clusters, SAD 17-1 to SAD 17-9

index, SCN 10-54

contrasted with hash, SAD 17-2, SCN 10-55

scans of, STU 4-39

indexed, SQL 7-257

indexes on, SCN 10-23

cannot be partitioned, SCN 11-2

joins and, SCN 10-52, STU 4-36, STU 4-38, STU 4-55

key

changing column names, SQL 7-3

changing the number of columns, SQL 7-3

keys, SCN 1-26, SCN 10-52, SCN 10-53

affect indexing of nulls, SCN 10-9

location, SAD 16-6

migrated and chained rows in, SQL 7-207

modifying, SQL 7-2

overview of, SAD 16-2, SCN 10-49

performance considerations, ADG 5-15

performance considerations of, SCN 10-52

physical attributes

changing, SQL 7-2

specifying, SQL 7-256

privileges

for altering, SAD 16-9

for creating, SAD 16-6

for dropping, SAD 16-11

removing from the database, SQL 7-472

rowids and, SCN 10-8

scans of, SCN 7-4, STU 4-22, STU 4-36

hash, STU 4-36, STU 4-38

joins, STU 4-38

selecting tables, SAD 16-4

setting parameters of, SCN 10-53

single-table hash clusters, SAD 17-5

space allocated for cluster key values, SQL 7-256

specifying PCTFREE for, SAD 12-4

SQL examples, SQL 7-473

storage access in, PSC 2-5

storage attributes

changing, SQL 7-2

storage characteristics, SQL 7-605

specifying, SQL 7-256

storage format of, SCN 10-53

storage parameters of, SCN 10-5

tablespace

changing, SQL 7-3

tablespace in which created, SQL 7-257

truncating, SAD 19-10

validating structure, SAD 19-9

validating structure of, SQL 7-206

CM

defined, PSG 1-5

DefinedNodes registry value, PSG 3-26

interacting with DLM, PSC 3-6

cmadm_pid.log file, NET 12-19, NET 12-29

cmadm_pid.trc file, NET 12-34

CMADMIN process, NET 4-6

CMAN parameter, NET C-70

CMAN_ADMIN parameter, MIG F-16, NET C-70, NET C-85, NET C-88

cman_pid.log file, NET 12-19, NET 12-29

cman_pid.trc file, NET 12-34

CMAN_PROFILE parameter, NET C-71

CMAN_RULES parameter, NET 8-36, NET C-76

CMAN.ORA file

CMAN_ADMIN parameter, MIG F-16

migrating, MIG F-16

upgrading, MIG F-16

cman.ora file

CMCTL STATS command

ACTIVE_DELAYS, NET A-94

MOST_RELAYS, NET A-94

OUT_OF_RELAY, NET A-94

TOTAL_REFUSED, NET A-94

TOTAL_RELAYS, NET A-94

CMCTL utility

CMGW process, NET 4-5

cn attribute, NET 2-40, OID 2-5

CNAME.SMD record, NET 11-14, NET A-42

COALESCE clause

for partitions, SQL 7-160

for subpartitions, SQL 7-156

of ALTER INDEX, SQL 7-40

of ALTER TABLESPACE, SQL 7-181

COALESCE PARTITION clause, SAD 15-16

COALESCE SUBPARTITION clause

of ALTER TABLE, SQL 7-156

coalescing extents, SCN 4-16

coalescing free space

extents, SCN 4-14

SMON process, SCN 1-18, SCN 8-11

within data blocks, SCN 4-10

COBOL datatypes, PCO 4-13

COBOL datatypes, additional, PCO A-4

COBOL versions supported, PCO 2-11, PCO B-2

COBOL, See Pro*COBOL precompiler

COBOL-74, PCO B-2

COBOL-85, PCO B-2

CODE

precompiler option, PC_ 12-3

code

example programs, ADL 1-5, OCI B-1

list of demonstration programs, ADL 1-5, OCI B-1

code examples

description of, RMN 10-5, SQL xiii

CODE OTT parameter, OCI 14-26, PC_ 19-28

code page, PC_ 4-49, PCO 4-36

CODE precompiler option, PC_ 10-13

CODE_PIECES view, SRF 2-94

CODE_SIZE view, SRF 2-94

codepoints, NLS 4-10

codes

functions, OCI 15-237

coding area

for paragraph names, PCO 2-18

coding conventions, PC_ 2-10, PCO 2-11

coding guidelines

function names, OCI 2-36

reserved words, OCI 2-35

coexistence issues

release 8.1 client connection to version 7 database, MIG F-9

coherency

of object cache, OCI 13-4

COL view, SRF 2-94

cold backup, OID B-1

cold backups, SBR 1-18

whole database backups, SBR 4-3

collating sequence, PLS 2-48

collation parameters, NLS 2-27

COLLECT GET statement

example, PC_ 18-19

COLLECTION APPEND, PC_ F-19

COLLECTION APPEND statement, PC_ 18-12

SQL statements

COLLECTION APPEND, PC_ F-19

COLLECTION DESCRIBE

example, PC_ 18-21

COLLECTION DESCRIBE statement, PC_ 18-14

SQL statements

COLLECTION DESCRIBE, PC_ F-20

collection exceptions

when raised, PLS 4-28

COLLECTION GET statement, PC_ 18-8

SQL statements

COLLECTION GET, PC_ F-21

collection locators

compatibility, MIG 9-11

collection methods

applying to parameters, PLS 4-27

COUNT, PLS 4-22

DELETE, PLS 4-26, PLS 11-20

collection object types

handling, PC_ 18-4

COLLECTION RESET statement, PC_ 18-11

example, PC_ 18-22

SQL statements

COLLECTION RESET, PC_ F-22

COLLECTION SET statement, PC_ 18-10

example, PC_ 18-19

SQL statements

COLLECTION SET, PC_ F-23

COLLECTION TRIM statement, PC_ 18-13

SQL statements

COLLECTION TRIM, PC_ F-23

collection types, DCI 1-8

structs for, PC_ 18-3

COLLECTION_IS_NULL exception, PLS 6-5

collections, PC_ A-4, PLS 4-2, SCN 13-11, STU 14-4, STU 14-23, SUT 3-15

and C, PC_ 18-3

assigning, PLS 4-11

attributes, OCI 6-13

autonomous access, PC_ 18-4

bulk binding, PLS 4-29

collection columns

user-specified storage, MIG 9-29

collection locators

compatibility, MIG 9-29

collection unnesting, GTK 3-35

comparing, PLS 4-13

constructors, PLS 4-8

data manipulation functions, OCI 11-18

declaring, PLS 4-7

defining, PLS 4-5

describing, OCI 6-2

description, OCI 11-17

descriptors, PC_ 18-3

element access, PC_ 18-5

element types, PLS 4-5

functions for manipulating, OCI 11-18

index-organized tables, SCN 10-41

key compression, SCN 10-33

initializing, PLS 4-8

inserting rows into, SQL 7-542

kinds, PLS 4-1

manipulating, PC_ 18-4

modifying, SQL 7-145

nested tables, ADO 1-9, PC_ 18-2, SCN 13-12, SQL 2-31

nesting, ADO 6-20

OBJECT GET statement, PC_ 18-6

OBJECT SET statement, PC_ 18-6

querying, ADO 6-12

referencing, PLS 4-10

scanning functions, OCI 11-19

scope, PLS 4-8

SQL*Loader support, GTK 3-36

syntax, PLS 11-24

table items, SPR 51-15

treating as a table, SQL 7-467, SQL 7-542, SQL 7-617

unnesting, SQL 7-576

examples, SQL 7-593

variable arrays (VARRAYs), ADO 1-8, SCN 13-11

VARRAYs, PC_ 18-3

varrays, SQL 2-31

collocated inline views

tuning distributed queries, DDS 3-4

COLS synonym for USER_TAB_COLUMNS, SRF 2-94

column alias, PLS 5-14

when needed, PLS 2-35

column constraints, SQL 7-233, SQL 7-237

of ALTER TABLE, SQL 7-141

of CREATE TABLE, SQL 7-393

column list, PCO 5-9

in INSERT statements, PC_ 6-9

when permissible to omit, PC_ 6-9

column objects

vs. row objects, ADO 6-1

column REF constraints, SQL 7-234, SQL 7-242

of ALTER TABLE, SQL 7-140

of CREATE TABLE, SQL 7-393

COLUMN_PRIVILEGES view, SRF 2-95

columns

accessing in triggers, ADG 13-15

adding, SQL 7-140

aliases for, SQL 5-19

associating statistics with, SQL 7-211

attributes, OCI 6-5, OCI 6-15

basing an index on, SQL 7-298

cardinality, DWG 6-3, SCN 10-35

collecting statistics on, SQL 7-204

column groups, RAR 6-4, RAR 6-6, RAR 6-9, RAR 6-11, RAR 6-13, RAR 6-17, REP 2-28, REP 5-10

adding members to, SPR 37-6, RAR 8-72

creating, SPR 37-44, SPR 37-68, RAR 8-110, RAR 8-134

dropping, SPR 37-49, RAR 8-115

ensuring data integrity with multiple, REP 5-10

removing members from, SPR 37-50, RAR 8-116

shadow, REP 5-11

column level snapshot subsetting, REP A-3

column names

qualifying in queries, ADO 2-7

column objects, ADO 1-6, SCN 13-8

indexes, ADO 2-4

creating comments about, SQL 7-228

default values, ADG 4-4

default values for, SCN 10-9

defined, SCN 1-22

defining, SQL 7-390

described, SCN 10-3

displaying information about, SAD 19-31

dropping, SCN 10-7

exporting LONG datatypes, SUT 1-57

generating derived values with triggers, ADG 13-49

granting privileges for selected, SAD 23-11

granting privileges on, SAD 23-12

increasing length, ADG 2-9, SAD 13-11

INSERT privilege and, SAD 23-12

integrity constraints, SCN 10-4, SCN 10-9, SCN 254, SCN 257

listing in an UPDATE trigger, ADG 13-6, ADG 13-18

listing users granted to, SAD 23-24

loading REF columns, SUT 5-97

LOB, storage characteristics of, SQL 7-141

maximum in concatenated indexes, SCN 10-25

maximum in view or table, SCN 10-13

maximum number of, SQL 7-392, SRF 4-2

modifying existing, SQL 7-143

multiple foreign key constraints, ADG 4-11

naming

SQL*Loader, SUT 5-47

nested tables, SCN 10-10

null columns at the end of a record, SUT 5-81

number of CHECK constraints limit, ADG 4-16

objects

loading, SUT 5-90

loading nested column objects, SUT 5-92

stream record format, SUT 5-90

variable record format, SUT 5-91

order of, SCN 10-8

parent-child relationships between, SQL 7-278

partially dropped

dropping, MIG 13-15

privileges, SAD 23-12

prohibiting nulls in, SCN 257, SQL 7-239

pseudocolumns

ROWID, SCN 12-16

ROWNUM, STU 4-46, STU 4-77, STU 4-88

USER, SCN 309

qualifying in queries, ADO 2-6

qualifying names of, SQL 5-19

REF

describing, SQL 7-242

reordering before Import, SUT 2-13

restricting values for, SQL 7-237

revoking privileges on, SAD 23-14

selectivity, SCN 131, STU 8-2

histograms, SCN 132, SCN 133, STU 8-17

setting to a constant value with SQL*Loader, SUT 5-54

setting to a unique sequence number using SQL*Loader, SUT 5-56

setting to datafile record number with SQL*Loader, SUT 5-55

setting to null, SUT 5-81

setting to null value with SQL*Loader, SUT 5-55

setting to the current date using SQL*Loader, SUT 5-55

setting value to zero, SUT 5-80

specifying

SQL*Loader, SUT 5-47

specifying as foreign key, SQL 7-240

specifying as PIECED

SQL*Loader, SUT 8-15

specifying as primary key, SQL 7-239

specifying constraints on, SQL 7-393

specifying default values for, SQL 7-392

to index, STU 12-4

unique values in, SQL 7-238

unused, SCN 10-7

dropping, MIG 13-15

COLUMNS clause

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

columns, privileges, ADG 11-30, ADG 11-31

COM Cartridge, GTK 3-87

combining SSL with other authentication methods, OAS 10-7

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

command

scanner, LEG 5-6

command files

Recovery Manager, RMN 1-10

command line

arguments for RMAN, RMN 1-10, RMN 10-42

command-line options

Migration utility, MIG 4-17

parameters

description, SUT 6-2

Export, SUT 1-13

specifying defaults, SUT 5-18

command line tools, OID 1-4

Command Line Utilities Help, LSM, Windows, LEG 1-14

command line utility, Oracle

Enterprise Backup Utility, Oracle7, LEG 4-4

Recovery Manager (RMAN), Oracle8, LEG 4-4

command(), command_replies()

functions of UTL_SMTP, SPR 65-4

commands

df, LEG 5-7

dkinfo, LEG 5-7

scanner, LEG 5-6

standby database, SBY 1-28

commands, Recovery Manager

allocate channel, RMN 10-10

allocate channel for delete, RMN 5-27

allocate channel for maintenance/delete, RMN 10-14

alter database, RMN 10-16

archivelogRecoverSpecifier clause (RMAN), RMN 10-18

backup, RMN 1-33, RMN 5-2, RMN 5-28, RMN 10-22

proxy only option, RMN 1-22

proxy option, RMN 1-22

skip offline option, RMN 5-16

catalog, RMN 3-9, RMN 3-34, RMN 10-35

change, RMN 3-15, RMN 10-38

delete option, RMN 3-36

configure, RMN 10-47

connect, RMN 10-51, RMN 10-53

copy, RMN 10-55

create catalog, RMN 10-59

create script, RMN 10-61

crosscheck, RMN 10-64

debug, RMN 10-68

delete expired backup, RMN 10-69

delete script, RMN 10-71, RMN 10-72

drop catalog, RMN 3-44, RMN 10-74

duplicate, RMN 1-64, RMN 10-76

execute script, RMN 3-27

host, RMN 10-81

list, RMN 1-24, RMN 10-83

incarnation of database option, RMN 3-13

listObjList clause, RMN 10-92

overview, RMN 1-5

print script, RMN 10-94

recover, RMN 1-61, RMN 6-18, RMN 10-96

register, RMN 3-10, RMN 10-101

release channel, RMN 10-103

release channel (of type maintenance), RMN 10-104

replace script, RMN 10-105

replicate, RMN 6-12, RMN 10-108

replicate controlfile, RMN 6-12

report, RMN 1-26, RMN 10-110

need backup option, RMN 4-5

reset database, RMN 3-12, RMN 10-118

incarnation option, RMN 3-13

restore, RMN 6-19, RMN 10-120

resync catalog, RMN 1-15, RMN 3-29, RMN 10-127

from controlfilecopy option, RMN 3-43

rman, RMN 10-130

run, RMN 10-133

send, RMN 2-22, RMN 10-136

set, RMN 10-138

duplex parameter, RMN 5-24

maxcorrupt for datafile option, RMN 5-28

newname for datafile option, RMN 6-10

set (within run command), RMN 10-142

terminating, RMN 1-12

until, RMN 10-45, RMN 10-156

upgrade catalog, RMN 3-43, RMN 10-158

validate, RMN 10-160

commands, SQL

ALTER DATABASE, SBR 5-6, SBR 5-10, SBR 5-12

when constraint checking occurs, ADG 4-17

commands, SQL*Plus

RECOVER, SBR 5-8

UNTIL TIME option, SBR 5-30

RECOVER DATAFILE, SBR 5-8

RECOVER TABLESPACE, SBR 5-8

SET, SBR 5-6, SBR 5-10, SBR 5-11

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

COMMENT ANY TABLE system privilege, SQL 7-529

COMMENT clause, PLS 5-43

of COMMIT, SQL 7-231

of COMMIT statement, PC_ F-25, PCO F-16

COMMENT statement, SCN 13, SQL 7-228

comment(String) - oracle.xml.parser.v2.DefaultXMLDocumentHandler.comment(java.lang.String), JPR 4-11

comment(String) - oracle.xml.parser.v2.XMLDocumentHandler.comment(java.lang.String), JPR 4-86

Comments

restrictions in PL/SQL block, PC_ 13-31

comments, PLS 2-10, SQL 2-62

comments in configuration files, NET C-3

comments in dynamic PL/SQL blocks, PCO 9-31

COMMIT

Import parameter, SUT 2-19

commit, OCI 2-26, PCO 3-13

automatic, PC_ 3-17, PCO 3-14, SQL 7-230

explicit versus implicit, PC_ 3-17, PCO 3-14

function of, PC_ 3-16

in object applications, OCI 13-14

one-phase for global transactions, OCI 8-7

two-phase for global transactions, OCI 8-7

COMMIT command, ADG 7-5

differences between Server Manager and SQL*Plus, MIG 11-17

COMMIT IN PROCEDURE clause

of ALTER SESSION, SQL 7-84

COMMIT keyword

behavior in Oracle7 and Oracle8i, MIG 9-23

commit phase, DDS 4-12, DDS 4-24

two-phase commit, DDS 4-14

commit point site, DDS 4-7

commit point strength, DDS 4-9, DDS 5-5, DDS A-2

determining, DDS 4-10

distributed transactions, DDS 4-7, DDS 4-9

how Oracle determines, DDS 4-9

commit point strength

definition, DDS 4-9

specifying, DDS 5-5

COMMIT SQL statement, PC_ F-24

COMMIT statement, PC_ 3-18, PCO 3-14, PCO F-15, PLS 5-43, SCN 13, SQL 7-230

commit() - oracle.jms.AQjmsSession.commit(), JPR 2-160

COMMIT_POINT_STRENGTH initialization parameter, DDS 4-9, DDS 5-6, SRF 1-19

committed data

checkpoint, PSA 13-14

instance failure, PSA 14-3

sequence numbers, PSC 8-14

committing

transactions, PC_ F-24, PCO F-15

committing transactions

defined, SCN 32

distributed

commit point site, DDS 4-7

fast commit, SCN 8-10

group commits, SCN 8-10

implementation, SCN 8-10

overview, SCN 1-54

parallel DML, SCN 197

common joins, DWG 19-11

common parameter files

recommended locations for, PSA 1-2

using multiple, PSA 1-3

Commonly asked questions, ADQ 6-1

commonName attribute, OID 2-5

communicating over a network, PC_ 3-6

communication protocols, SCN 6-5

communications, stack, NET 3-2

COMMUNITY parameter, MIG F-4

COMP_CHARSET precompiler option, PC_ 10-14

comparing

all or part of two LOBs

internal persistent LOBs, ADL 9-120

all or part of two temporary LOBs, ADL 10-75

all or parts of two BFILEs, ADL 11-116

attribute values, OID 7-25

entries, OID 4-14

tables, SPR 34-3, RAR 8-53

two objects, OID 4-10

comparison functions

MAP, SQL 7-443, SQL 7-449

ORDER, SQL 7-443, SQL 7-449

comparison methods, ADO 1-4, ADO 9-20, SCN 13-7

comparison operators, PLS 2-45, PLS 5-5, SQL 3-5

blank padding data, ADG 3-6

comparing dates, ADG 3-9

comparison semantics

blank-padded, SQL 2-33

nonpadded, SQL 2-33

of character strings, SQL 2-32

comparisons

of character values, PLS B-2

of collections, PLS 4-13

of expressions, PLS 2-47

compatibility, ADL 1-5, MIG 9-1, SCN 1-3

8.1.0 compatibility level

features requiring, MIG 9-9

Advanced Queuing, MIG 9-13, MIG 9-32

agent self-registration, MIG 9-12

ALTER DATABASE RESET COMPATIBILITY statement, MIG 9-7

ANALYZE VALIDATE STRUCTURE statement, MIG 9-18

application context, MIG 9-12

applications, MIG 9-16, MIG 10-2

index-organized tables, MIG 9-17

physical ROWIDs and UROWIDs, MIG 9-17

Tuxedo applications, MIG 9-18

XA calls, MIG 9-18

archived redo logs, MIG 9-42

backup, MIG 9-12, MIG 9-39

change in maximum size

CHAR, MIG 9-16

RAW, MIG 9-16

VARCHAR2, MIG 9-16

compatibility level, MIG 9-5

COMPATIBLE initialization parameter, MIG 9-2

CREATE TABLE behavior change, MIG 9-31

data dictionary, MIG 9-25

database resource manager, MIG 9-13

datafiles, MIG 9-23

datatypes, MIG 9-26

date columns in dynamic performance views, MIG D-13

DBMS_REPAIR package, MIG 9-13

DISABLE VALIDATE constraints, MIG 9-13

downgrading, MIG 9-5

Export/Import, MIG 9-48

extensible optimizer, MIG 9-13

fine-grained access control, MIG 9-12

Heterogeneous Services agents, MIG 9-45

indexes

key compression, MIG 9-10

initialization parameters, MIG B-8

level of recovery catalog, RMN 1-16

LOB index clause, MIG 9-27

LOBs, MIG 9-11, MIG 9-26

CLOBS and NCLOBs, MIG 9-26

LogMiner, MIG 9-43

materialized views, MIG 9-14

nested tables, MIG 9-29

NLS and NCHAR environment variables, MIG 9-28

n-tier authentication and authorization, MIG 9-12

OCI, MIG 9-18

link line, MIG 9-19

thread safety, MIG 9-19

optimization, MIG 9-34

optimizer plan stability, MIG 9-13

Oracle Media Management API, MIG 9-12

Oracle Parallel Server

instance affinity for jobs, MIG 9-12

packages

DBMS_LOB, MIG 9-33

DBMS_REPAIR, MIG 9-33

partitioning, MIG 9-10

PL/SQL, MIG 9-21

PLSQL_V2_COMPATIBILITY initialization parameter, MIG 9-21

precompilers, MIG 9-20

recovery, MIG 9-12, MIG 9-39

fast-start rollback, MIG 9-12

recovery catalog

viewing parameter setting, RMN 3-6

Recovery Manager. See Oracle8i Migration

REFs, MIG 9-11

removing incompatibilities, MIG 13-2

replication, MIG 9-12, MIG 9-45

resetting for database, MIG 13-51

rowids, MIG 9-27

schema objects, MIG 9-10

collection locators, MIG 9-11

drop column, MIG 9-10

extensible indexing, MIG 9-10

function-based indexes, MIG 9-10

indexes, MIG 9-10

index-organized tables, MIG 9-10

nested tables, MIG 9-11

online index (re)build, MIG 9-10

single-table hash clusters, MIG 9-10

temporary tables, MIG 9-10

scripts

UTLCHN1.SQL, MIG 9-13, MIG 9-31

UTLEXPT1.SQL, MIG 9-13, MIG 9-31

shared and exclusive modes, PSA 8-9, PSC 7-2

SHUTDOWN IMMEDIATE, MIG 9-23

snapshots, MIG 9-44

Spatial, MIG 9-14

SQL and PL/SQL, MIG 9-13

autonomous transactions, MIG 9-13

bulk binds, MIG 9-13

C call specifications, MIG 9-13

CALL statement, MIG 9-13

native dynamic SQL, MIG 9-13

NOCOPY parameter passing mode, MIG 9-13

standby database, MIG 9-41

summary management, MIG 9-14

tablespaces, MIG 9-9, MIG 9-23

locally managed tablespaces, MIG 9-9

online read-only tablespaces, MIG 9-9

transportable tablespaces, MIG 9-9

triggers, MIG 9-13

UROWIDs, MIG 9-11

user-defined object identifiers, MIG 9-11

varrays, MIG 9-11

stored as LOBs, MIG 9-29

Visual Image Retrieval, MIG 9-14

compatibility flag, GTK 7-6

compatibility level

checking, MIG 13-2

compatibility levels

transportable tablespaces, SCN 3-15

COMPATIBLE initialization parameter, MIG 9-2, REP 7-3, SBY 5-9, SRF 1-20

8.1.0 setting

features requiring, MIG 9-9

checking the setting, MIG 9-5

database structures, MIG 9-3

setting, MIG 9-6

when to set, MIG 9-5

COMPATIBLE parameter, DWG 14-13, DWG 19-5

and parallel query, STU 7-24

read-only tablespaces, SCN 3-11

COMPATIBLE_NO_RECOVERY initialization parameter: obsolete

compilation, PCO 2-27

compilation and execution of RMAN commands, RMN 1-6

compilation of object types, ADO 2-14

COMPILE clause

of ALTER DIMENSION, SQL 7-27

of ALTER FUNCTION, SQL 7-28

of ALTER JAVA SOURCE, SQL 7-46

of ALTER MATERIALIZED VIEW, SQL 7-54

of ALTER PACKAGE, SQL 7-65

of ALTER PROCEDURE, SQL 7-68

of ALTER TRIGGER, SQL 7-184

of ALTER TYPE, SQL 7-187

of ALTER VIEW, SQL 7-199

of CREATE JAVA, SQL 7-312

compiled PL/SQL, SCN 59

advantages of, SCN 51

procedures, SCN 53

pseudocode, SCN 60, SCN 106

recompiling, SCN 62

shared pool, SCN 25

triggers, SCN 106

compiler directives, SQL 7-442

compiler hint, NOCOPY, PLS 7-17

compile-time errors, ADG 9-41

compiling, PC_ 2-17

specifying include file locations, PC_ 5-35

COMPLETE clause, DWG 8-20

complete export, SBR 4-20

complete exports, SUT 1-45, SUT 1-47

restrictions, SUT 1-45

specifying, SUT 1-21

complete recovery

definition, SBR 1-24, SBR 3-16

procedures, SBR 5-19

using RMAN, RMN 6-20

complete refresh, DWG 14-18

complete refreshes, REP 3-28

completion messages

Export, SUT 1-41

complex materialized views, DWG 14-27

complex object retrieval, OCI 10-20

for Oracle Call Interface, ADO 7-9

implementing, OCI 10-23

navigational prefetching, OCI 10-24

complex object retrieval (COR) descriptor, OCI 2-17

attributes, OCI A-27

complex object retrieval (COR) handle, OCI 2-11

attributes, OCI A-26

complex queries

snowflake schemas, DWG 16-3

complex snapshots, REP 3-6

value for PCTFREE, REP 3-28

value for PCTUSED, REP 3-28

complex view merging, STU 4-78

COMPLEX_VIEW_MERGING initialization parameter: obsolete

compliance

ANSI, PC_ xvii

ISO, PC_ xvii

NIST, PC_ xvii

compliance, ANSI/ISO, PCO cxxvi

component selector, PLS 1-6

components, PSG 4-3

directory server, OID 2-29

for Oracle Parallel Server, PSC 6-1

components, LSM, LEG 1-3

components, SSL, OID 2-22

composite foreign keys, SQL 7-239

composite indexes, SCN 10-24, STU 12-5

composite keys

restricting nulls in, ADG 4-16

composite limits

costs and, SAD 22-24

composite methods

partitioning and downgrading, MIG 13-24

composite partitioning, DWG 5-6, GTK 3-46, PSA 5-15, SAD 15-6

performance considerations, DWG 5-9

composite partitioning clause

of CREATE TABLE, SQL 7-386, SQL 7-403

composite partitions

examples of, STU 5-16

composite primary keys, SQL 7-239

composite types, PCO 11-18, PLS 2-11

composite unique constraints, SQL 7-238

COMPOSITE_LIMIT parameter

of ALTER PROFILE, SQL 7-69

of CREATE PROFILE, SQL 7-362

Compositing, ADQ 7-15

compound conditions, SQL 5-18

compound expressions, SQL 5-4

compound symbols, PLS 2-4

COMPRESS

Export parameter, SUT 1-17, SUT 2-51

COMPRESS clause

nested tables, ADO 6-16

of ALTER INDEX, SQL 7-32

of ALTER TABLE, SQL 7-144

of CREATE INDEX, SQL 7-300

of CREATE TABLE, SQL 7-397

compression of free space in data blocks, SCN 4-10

compression, index key, SCN 10-31

COMPUTE option

STATISTICS Export parameter, SUT 1-24

COMPUTE STATISTICS clause

of ANALYZE, SQL 7-204

of CREATE INDEX, SQL 7-301

COMPUTE STATISTICS clause of CREATE and ALTER INDEX statements, GTK 3-27

COMPUTE STATISTICS option, SAD 19-5

CONCAT function, SQL 4-20

CONCATENATE keyword

SQL*Loader, SUT 5-36

concatenated indexes, SCN 10-24

concatenation operator, NLS 4-12, PLS 2-47, SQL 3-3

treatment of nulls, PLS 2-51

concepts, LDAP, OID 2-1

concurrency, ADG 7-22, PCO 3-12, PLS 5-41

defined, SCN 1-29

definition of, PC_ 3-16

described, SCN 212

direct-load INSERT, SCN 154

enforced with locks, SCN 1-31

inserts and updates, PSA 8-4

limits on

per database, SCN 299

per user, SCN 297

maximum number of instances, PSA 3-3, PSC 7-21

partition maintenance, SCN 11-49

restrictions on, SCN 1-42, SCN 154

ROW_LOCKING initialization parameter, SRF 1-106

sequences, PSC 8-14

transactions and, SCN 226

transactions per rollback segment, SRF 1-120

concurrent access, MIG 3-17

concurrent connections, PC_ 3-7

concurrent conventional path loads, SUT 8-25

concurrent database connections, OID 13-11, OID F-5

concurrent logons, PCO 3-3

concurrent users, MIG 3-18

increasing the number of, DWG 18-9

conditional control, PLS 3-2

conditional precompilation, PC_ 2-15, PCO 2-25

defining symbols, PC_ 5-43, PCO 2-26

example, PC_ 2-15, PC_ 5-43, PCO 2-25

conditional predicates

trigger bodies, ADG 13-14, ADG 13-17

conditions

compound, SQL 5-18

EXISTS, SQL 5-18

group comparison, SQL 5-16

in SQL syntax, SQL 5-14

simple comparison, SQL 5-16

CONFIG OTT parameter, OCI 14-27, PC_ 19-29

CONFIG precompiler option, PC_ 10-15, PCO 14-14, PCO 14-15

configNLDAP.ora, OID B-9

configsets. See configuration set entries.

configuration

of standby environment, SBY 1-19

Configuration Assistant, PSG 6-10

configuration file

system versus user, PCO 14-16

configuration file name, PCO A-7

configuration files, PC_ 10-3

and the Object Type Translator, PC_ 19-5

cman.ora, NET C-70 to NET C-76

CyberSAFE, OAS B-2

Kerberos, OAS B-5

listener.ora, NET C-48 to NET C-58

location, PC_ 10-4

names.ora, NET C-59 to NET C-69

naming conventions, DCI 2-7

needed for servers in DCE, OAS 14-4

protocol addresses, NET B-1

SecurID, OAS B-5

syntax rules, NET C-2

system, PC_ 10-4

tnsnames.ora, NET C-31 to NET C-48

user, PC_ 10-4

configuration files directory

contents, UNIX, LEG 5-12

contents, Windows NT, LEG 5-20

configuration files for external procedures, DCI 4-5

configuration of a database

process structure, SCN 8-2

configuration of RMAN

for use with MTS, RMN 2-4

configuration options

standby databases, SBY 1-2

configuration parameters

configuration set entries, OID 2-30, OID 2-32

adding, OID 2-32, OID 5-2

using command line tools, OID 7-25

using Oracle Directory Manager, OID 5-4

attributes, OID F-5

changing, OID 3-9, OID 5-14

database connections, OID F-5

debug level, OID F-5

deleting, OID 5-2

using Oracle Directory Manager, OID 5-4

directory server processes, OID F-5

disabling SSL, OID F-5

for replication server, OID 10-10

LDIF file, OID 5-12

managing, OID 4-17, OID 5-2

using command line tools, OID 5-12

using Oracle Directory Manager, OID 5-4

modifying, OID 3-9, OID 5-2

in an active server instance, OID 5-4

using command line tools, OID 7-25

using Oracle Directory Manager, OID 5-4, OID 5-11

orcldebuglevel, OID F-5

orclmaxcc, OID F-5

orclserverprocs, OID F-5

orclssl authentication, OID F-5

orclsslenable, OID F-5

orclsslport, OID F-5

orclsslwalletpasswd, OID F-6

orclsslwalleturl, OID F-6

overriding user-specified, OID 3-10

replication

viewing with Oracle Directory Manager, OID 10-11

replication server, OID 10-9

SSL parameters in, OID 8-2

starting directory servers without using, OID 3-10

using different, OID 5-2

using multiple, OID 8-3

configuration set location, OID 5-16

configuration sets. See configuration set entries.

configuration, LSM

administrators

modifying on NT, LEG 2-29

modifying on UNIX, LEG 2-29

server resource, LEG 2-27

specifying, LEG 2-27, LEG 2-28

configuration roadmap, LEG 2-16

LSM resources

client dialog box, Windows NT, LEG 2-23

client resource, LEG 2-20

server resource, LEG 2-24

overview, LEG 2-2

resource dependencies, LEG 2-3

resource types, LEG 2-2, LEG 2-5

storage devices

configuring on UNIX, LEG 3-7, LEG 3-8

configuring on Windows, LEG 3-8, LEG 3-9, LEG 3-10

labeling a volume on UNIX, LEG 3-14

labeling a volume on Windows, LEG 3-15, LEG 3-16

labeling and mounting volumes, LEG 3-13

mounting a volume on UNIX, LEG 3-16

mounting a volume on Windows, LEG 3-17

server features, LEG 3-2

tape device, no-rewind name, LEG 3-2

types that LSM supports, LEG 3-2

unmounting a volume on UNIX, LEG 3-18

unmounting a volume on Windows, LEG 3-18

volume pools, LEG 3-10

configurations

change in redo log, PSA 3-8

for high availability, PSC 9-17

configure compatible command (RMAN), RMN 1-16, RMN 3-4

Configure Entry Management menu item, in Oracle Directory Manager, OID 4-11

Configure Prespawned Servers dialog box, NET 7-19

configuring

a server in DCE, OAS 14-4

Advanced Symmetric Replication (ASR), OID 10-3

using Oracle8 Replication Manager, OID 10-3

archive logs for backup and recovery, PSG 4-9 to PSG 4-16

Biometric Manager, OAS 8-12

cipher suites in SSL, OAS 10-22

client application failover, SBY 5-36

clients

access control with Oracle Connection Manager, NET 8-37

client load balancing, PSG 4-2

connection concentration, NET 8-30

connect-time failover, NET 2-21, NET 8-4, PSG 4-2

default domains, NET 8-17

local naming, NET 6-15

multi-protocol support, NET 8-33

naming methods in profile, NET 8-19

Oracle Connection Manager, NET 8-38

Oracle Names, NET 6-60

primary and secondary instances, PSG 5-8

Transparent Application Failover, NET 2-21

clients for DCE integration, OAS 14-12

clients to use CDS, OAS 14-15

clients to use DCE CDS naming, OAS 14-15

connection concentration, NET 8-28

connection pooling, NET 9-9

connection requests in a profile, NET 8-21

CyberSafe authentication service parameters, OAS 5-6

DCE CDS for use by Oracle DCE Integration, OAS 13-3

DCE GSSAPI authentication, OAS 9-2

DCE to use DCE Integration, OAS 13-2

directory naming, NET 6-16 to NET 6-46

Directory Replication Groups (DRGs), OID 10-2

domains, default, NET 8-26

enterprise domain, OAS 17-28

enterprise user security, OAS 17-20

external naming, NET 6-79 to NET 6-88

external procedures, NET 8-45

global database name, PSG 3-4

Heterogeneous Services connections, NET 7-13, NET 8-49

high availability, PSG 5-1 to PSG 5-16

primary and secondary instances, PSG 5-6

TAF, PSG 5-2

Transparent Application Failover, PSG 5-2

host naming, NET 6-74 to NET 6-78

Identix authentication, OAS 8-8

initialization parameter file, SBY 5-6, SBY 5-8, SBY 5-17, SBY 5-19

Kerberos authentication service parameters, OAS 6-5

listener.ora file, SBY 5-5

listeners, NET 7-1 to NET 7-20

directory naming, NET 6-28

host naming, NET 6-75

local naming, NET 6-15

Oracle Names, NET 6-64

primary and secondary instances, PSG 5-9

local naming, NET 6-5 to NET 6-15

localized management, NET 6-4

multiple addresses, NET 8-2

multiple domains in Oracle Names, NET 6-53, NET 6-58

multi-protocol support, NET 8-32

naming methods, NET 6-1 to NET 6-88

net service names

directory naming, NET 6-23

external naming, NET 6-79

local naming, NET 6-6

Oracle Names, NET 6-65

Net8 access control, NET 8-35

Net8 OPEN, NET 10-7

network files, SBY 2-27, SBY 5-4

Oracle as a SecurID client, OAS 7-4

Oracle Enterprise Manager, PSG 6-10 to PSG 6-27

Oracle for Net8/DCE, OAS 14-1

Oracle Intelligent Agents on UNIX, PSG B-10 to PSG B-11

Oracle Names, NET 6-47 to NET 6-74

Oracle Names servers, NET 6-51

Oracle Parallel Server Management, PSG 6-1 to PSG 6-34

Oracle Performance Manager, PSG 6-27 to PSG 6-34

Oracle Rdb database connections, NET 8-52

Oracle server with CyberSafe, OAS 5-3

Oracle server with Kerberos, OAS 6-3

overview, NET 6-2

parameter file, SCN 5-4

prespawned dedicated servers, NET 7-16

primary and secondary instances, PSG 5-6

process structure, SCN 8-2

protocol addresses, NET 7-6, NET B-1

RADIUS authentication, OAS 4-10

Recovery Manager, PSG 4-9 to PSG 4-16

region database for Oracle Names, NET 6-50, NET 6-54

replicated data among Oracle Names servers, NET 6-55

replication, OID 10-9

agreements, OID 10-9, OID 10-14

server parameters, OID 10-10

schemaless users, OAS 17-13

SecurID authentication service, OAS 7-7

server for DCE Integration, OAS 14-4

server parameters

using command line tools, OID 4-17

using Oracle Directory Manager, OID 4-17

servers

connection concentration, NET 8-29

local naming, NET 6-6

Oracle Names, NET 6-60

servers, using input files, OID 7-25

SID Prefix, PSG 3-4

SSL, OAS 10-10, OID 4-4, OID 8-2

on the client, OAS 10-11

on the server, OAS 10-19

system to use custom applications, NET 10-8

TAF, PSG 5-2

Thin JDBC support, OAS 3-1

tnsnames.ora file, SBY 5-4

Transparent Application Failover, PSG 5-2

configuring generic connectivity, DDS 8-6

configuring transparent gateways, DDS 7-2

conflict resolution, RAR 6-1, REP 2-42, REP 5-1

additive method, SPR 37-12, RAR 6-11, RAR 8-78, REP 5-15

append sequences method, REP 5-25

append site name method, REP 5-24

auditing, RAR 6-29

average method, RAR 6-11, REP 5-16

avoiding conflicts, REP 5-7

column groups, RAR 6-4, RAR 6-6, RAR 6-9, RAR 6-11, RAR 6-13, RAR 6-17, REP 5-10

concepts, REP 5-2

data requirements, REP 5-2

DBA_REPRESOLUTION_STATISTICS view, RAR 6-30

delete conflicts, REP 5-4

detecting conflicts, REP 5-5

discard method, RAR 6-3, REP 5-17, REP 5-25

dynamic site ownership, REP 5-7

in synchronous propagation, REP 2-33

information

viewing, RAR B-10

latest timestamp method, REP 5-12

manual, OID 10-26

maximum method, RAR 6-5

maximum value method, REP 5-18

methods for delete conflicts, REP 5-26

methods for uniqueness conflicts, REP 5-24

methods for update conflicts, REP 5-11

minimum method, RAR 6-5

minimum value method, REP 5-20

overwrite method, RAR 6-3

overwrite methods, REP 5-13

performance, REP 5-26

compare old values, REP 5-27

min communication, REP 5-26

send old values, REP 5-27

preparing for, RAR 6-2

primary site ownership, REP 5-7

priority groups, RAR 6-13

priority groups method, REP 5-21

procedural replication and, REP 6-3

replication, REP 2-10

site priority, RAR 6-16

site priority method, REP 5-22

statistics, SPR 37-25, SPR 37-74, RAR 8-91, RAR 8-140

canceling, RAR 6-30

gathering, RAR 6-29

viewing, RAR 6-29

timestamp methods, RAR 6-7

transaction ordering, REP 5-4

types of conflicts, REP 5-3

uniqueness conflicts, REP 5-3

update conflicts, REP 5-3

user-defined methods, RAR B-2

example, RAR B-4

for delete conflicts, RAR B-4

for uniqueness conflicts, RAR B-3

for update conflicts, RAR B-3

parameters, RAR B-2

restrictions, RAR B-4

viewing information, RAR B-10

conflicting access control policies, OID 9-3

precedence rules for resolving, OID 9-3

conflicts

avoiding, REP 5-7

delete, RAR 6-25

dynamic ownership, REP 6-11

delete, REP 5-4

avoiding, REP 5-8

detecting, REP 2-33, REP 2-41, REP 5-5

identifying rows, REP 2-42, REP 5-6

error queue, REP 5-11

notification log table

creating, RAR B-6

sample, RAR B-7

notification methods

user-defined, RAR B-6

notification package

creating, RAR B-7

sample, RAR B-8

ordering

avoiding, REP 5-8

procedural replication, REP 1-17, SCN 437

token passing, REP 6-12

conflicts, replication

attribute-level, OID 10-25

automated resolution of, OID 10-26

entry-level, OID 10-25

manual resolution of, OID 10-26

resolution, OID 9-11, OID 10-24

messages, OID 10-27

typical causes of, OID 10-25

CONNECT @instance-path command, PSA 3-6

CONNECT BY clause

of SELECT, SQL 5-21, SQL 7-577

optimizing view queries, STU 4-77

CONNECT clause

of SELECT and subqueries, SQL 7-571

CONNECT command, PSA 4-4, PSA 4-6

forcing a checkpoint, PSA 13-14

starting an instance, SAD 3-2

connect command (RMAN), RMN 10-51, RMN 10-53

connect descriptors

described, NET 1-5, NET C-31

connect functions, OCI 15-90

connect identifiers

syntax, NET 11-10

CONNECT INTERNAL, SCN 5-3

example of, PSA 1-5

CONNECT INTERNAL desupported, GTK 7-6

connect operations, NET 2-3

CONNECT role, SAD 23-5, SCN 324, SQL 7-530

user-defined types, ADO 2-11

CONNECT statement, PC_ F-26, PCO F-17

AT clause, PCO 3-6

AT clause in, PC_ 3-9

connecting to Oracle with, PC_ 3-2

enabling a semantic check, PCO E-3

examples, PC_ F-28, PCO F-19

logging on to Oracle, PCO 3-2

placement, PCO 3-2

requirements, PCO 3-2

requirements for, PC_ 3-2

USING clause, PCO 3-6

USING clause in, PC_ 3-9

using to enable a semantic check, PC_ D-4

when not required, PCO 3-10

connect string

Net8, SUT 1-53

connect strings, NET 11-2, PSA 4-4

CONNECT THROUGH privileges

revoking, MIG 13-46

CONNECT TO clause

of CREATE DATABASE LINK, SQL 7-274

CONNECT_DATA parameter, NET C-42

CONNECT_TIME parameter

of ALTER PROFILE, SQL 7-69

of ALTER RESOURCE COST, SQL 7-74

of CREATE PROFILE, SQL 7-361

CONNECT_TIMEOUT_listener_name parameter, NET C-54

Connect/Disconnect button in Oracle Directory Manager, OID 4-11

connected user database links, DDS 2-12

advantages and disadvantages, DDS 1-17

creating, DDS 2-12

definition, DDS 1-17

example, DDS 1-20

REMOTE_OS_AUTHENT initialization parameter, DDS 1-18

connectibility, SCN 1-2

connecting

across cells, OAS 14-6

Oracle Enterprise Manager repository database, PSG 6-28

Oracle Parallel Server database, PSG 4-3

to a directory server, OID 4-3, OID 4-4, OID 4-17

using Oracle Directory Manager, OID 4-11

to additional directory servers, OID 4-12

to an Oracle database

to verify roles, OAS 14-9

to an Oracle database in DCE, OAS 15-1

to an Oracle server in DCE, OAS 15-3

with username/password, OAS 15-3

without username and password, OAS 15-3

to another cell, OAS 14-6

to directory, OID 2-33

to instances, PSA 4-3

to multiple directory servers, OID 4-12

to remote instances, PSA 4-4

connecting to Oracle, PC_ 3-2, PCO 3-2

automatic connections, PC_ 3-4

automatically, PCO 3-9

concurrently, PC_ 3-7, PCO 3-3

example of, PC_ 3-2, PCO 3-2

using Net8, PC_ 3-7

via Net8, PCO 3-3

connecting with username/password

with authentication configured, OAS 11-2

connection

as a function of UTL_TCP, SPR 66-2

function of UTL_SMTP, SPR 65-2

connection concentration, NET 4-6, NET 8-28

advantages relative to connection pooling, NET 5-7

using to improve network performance, NET 5-7

Connection is closed - error, ADQ D-3

Connection is in stopped state - error, ADQ D-3

Connection is invalid - error, ADQ D-3

connection load balancing, NET xviii, NET 2-26, PSG 3-13

service registration, NET 2-24

connection manager, STU 22-17

Connection Manager, Oracle, GTK 4-6

connection mode

non-blocking, OCI 2-37

connection multiplexing, GTK 4-6

Connection must be specified - error, ADQ D-3

connection options

Recovery Manager, RMN 2-9

auxiliary database, RMN 2-12

hiding passwords, RMN 2-13

with a catalog, RMN 2-10

without a catalog, RMN 2-9

connection pooling, OID 1-4, GTK 4-6, SCN 287, STU 21-8

advantages relative to connection concentration, NET 5-7

configuring, NET 9-9

using to improve network performance, NET 2-12, NET 5-6

using with multi-threaded server, NET 9-9

connection qualifiers, REP 2-14

database links and, DDS 2-13

diagnosing problems with, REP B-2

connection redirection, OID 14-9

hardware-based, OID 14-6

network-level, OID 14-6

software-based, OID 14-7

connections, NET 2-9

adjusting listener queue size to avoid errors, NET 7-12

adjusting listener queuesize to avoid errors, NET 5-6

auditing, SAD 24-8

bequeath, NET 2-19

concurrent, PC_ 3-12

concurrent, increasing number of, NET 7-12

connect strings, entering, NET 11-2, NET 11-10

dedicated servers, NET 2-13, NET 8-21

default versus non-default, PC_ 3-8, PCO 3-5

defined, SCN 8-4

directory naming, NET 6-29

embedded SQL, SCN 14

Explicit connections, PC_ 3-8

external procedures, NET 8-45

Heterogeneous Services, NET 8-49

host naming, NET 6-78

implicit, PC_ 3-14, PCO 3-11

listener process and, SCN 6-6, SCN 8-14

load balancing in Net8, MIG 9-47

local and remote, MIG 3-17

with multithreaded shared server, MIG 3-17

local naming, NET 6-15

methods of, NET 11-11

multi-threaded server, NET 2-7, NET 9-2

naming, PCO 3-5

naming of, PC_ 3-8

NDS external naming, NET 6-83

Network Information Service external naming, NET 6-79

NIS external naming, NET 6-79

Novell Directory Services external naming, NET 6-83

Oracle Connection Manager, NET 1-3, NET 8-21

Oracle Names, NET 6-74

Oracle Rdb databases, NET 8-52

Oracle8i JServer, NET 3-16

remote

terminating, DDS 3-2

restricting, SCN 5-6

routing, NET 1-3

sessions contrasted with, SCN 8-4

startup of components, NET 11-4

to services, NET 1-5

with administrator privileges, SCN 5-3

audit records, SCN 333

CONNECTIONS (CON or CONN) attribute, NET 9-5

connect-time failover, NET xviii, NET C-39, PSC 8-10

configuring, NET 8-4, PSG 4-2

described, PSG 4-2

GLOBAL_DBNAME parameter in listener.ora, MIG F-15, NET 7-13, NET 8-4, NET C-39

GLOBAL_DBNAME parameter in listener.ora file, PSG 3-15

service registration, NET 2-23

with TAF, PSG 5-4

with Transparent Application Failover, PSG 5-4

CONSIDER FRESH clause

of ALTER MATERIALIZED VIEW, SQL 7-55

consistency

multiversion read, PSC 1-4, SRF 1-42

of object cache, OCI 13-4

read, STU 18-10

read-only transactions, ADG 7-8

rollback information, PSC 7-6, SRF 1-42

consistency of data, SCN 1-54

multiversion consistency model, SCN 1-30

See also read consistency

CONSISTENT

Export parameter, SUT 1-17

nested table and, SUT 1-17

partitioned table and, SUT 1-17

consistent backups

definition, SBR 1-5, SBR 1-23

whole database, SBR 1-16, SBR 4-4

consistent gets statistic, STU 19-28, STU 21-4, STU 21-21

consistent mode

TKPROF, STU 6-13

consistent-read blocks, PSA 12-2

Console

consolidating extents

Export parameter COMPRESS, SUT 1-17

const

declaring constants, PC_ 5-45

CONSTANT keyword

SQL*Loader, SUT 5-47, SUT 5-54, SUT 8-23

constant values. See literals

constants

comparisons and, STU 4-65

declaring, PLS 2-31

evaluation of expressions, STU 4-65

in stored procedures, SCN 26

syntax, PLS 11-33

when computed, STU 4-65

constraining tables, ADG 13-22

CONSTRAINT clause

of constraint_clause, SQL 7-237

constraint clause, SQL 7-233

constraint processing, GTK 4-15

constraint violations, REP B-4

CONSTRAINT(S) parameter

of ALTER SESSION, SQL 7-86

CONSTRAINTS

Export parameter, SUT 1-19, SUT 2-19

constraints, ADO 9-25, DWG 7-2, DWG 9-13, SCN 1-57, STU 12-11

See also integrity constraints

adding, SQL 7-140

alternatives to, SCN 255

application development issues, DDS 3-3

applications can find violations, SCN 256

automatic

checking at end of transaction, SQL 7-243

checking at start of transaction, SQL 7-243

checking at the end of each DML statement, SQL 7-243

column REF, SQL 7-242

composite unique, SQL 7-238

composite UNIQUE keys, ADG 4-7

constraint modification with ALTER TABLE, GTK 3-28

default values and, SCN 274

deferrable, SQL 7-243, SQL 7-598

enforcing, SQL 7-86

defined, SCN 10-4

defining, SQL 7-237, SQL 7-390

on a column, SQL 7-393

on a table, SQL 7-393

direct path load, SUT 8-20

DISABLE VALIDATE constraint state, GTK 3-28

disabling, SQL 7-165, SQL 7-245, SQL 7-405

cascading, SQL 7-408

disabling at table creation, SAD 19-17

disabling during a direct load, SUT 8-21

disabling referential constraints, SUT 2-14

disabling temporarily, SCN 257

dropping, SQL 7-146, SQL 7-504

dropping integrity constraints, SAD 19-20

effect on performance, SCN 257

enable novalidate state, SAD 19-16

ENABLE or DISABLE, SCN 276

enabling, SQL 7-165, SQL 7-244, SQL 7-405, SQL 7-407

after a direct load, SUT 8-21

after a parallel direct path load, SUT 8-29

enabling example, SAD 19-18

enabling when violations exist, SAD 19-16

enforced on a direct load, SUT 8-21

enforced with indexes, SCN 10-25

PRIMARY KEY, SCN 262

UNIQUE, SCN 260

exceptions, SAD 19-16, SAD 19-21

exceptions to integrity constraints, SAD 19-21

failed

Import, SUT 2-45

FOREIGN KEY, SCN 1-58, SCN 263

foreign key, DWG 7-5, SQL 7-240

integrity constraint states, SAD 19-15

load method, SUT 8-9

mechanisms of enforcement, SCN 271

modifying, SCN 277

modifying existing, SQL 7-144

NOT NULL, PLS 2-32, SCN 257, SCN 261

not null, SQL 7-239

Import, SUT 2-45

object tables, ADO 2-3

on columns, SQL 7-237

on Oracle objects, ADO 6-37

ORA-02055

constrain violation, DDS 3-3

overview, SCN 1-57

parallel create table, SCN 181

preventing Import errors due to uniqueness constraints, SUT 2-19

PRIMARY KEY, SCN 1-58, SCN 261

primary key, SQL 7-239

attributes of index, SQL 7-244

enabling, SQL 7-407

prohibited in views, SCN 10-13

referential

effect of updates, SCN 266

self-referencing, REP 2-16, SCN 265

referential integrity, SQL 7-239, SQL 7-240

restriction on stored functions, ADG 9-57

restrictions, SQL 7-237

scope, SQL 7-242

SCOPE FOR constraint, ADO 9-30, ADO 9-32

setting at table creation, SAD 19-17

setting state for a transaction, SQL 7-598

storing rows in violation, SQL 7-163, SQL 7-245, SQL 7-407

table REF, SQL 7-242

triggers cannot violate, SCN 102

triggers contrasted with, SCN 85

types listed, SCN 1-57, SCN 251

unique, DWG 7-3, SQL 7-238

attributes of index, SQL 7-244

composite, SQL 7-238

enabling, SQL 7-407

UNIQUE key, SCN 1-58, SCN 258

partially null, SCN 261

uniqueness

Import, SUT 2-45

VALIDATE or NOVALIDATE, SCN 276

validating, SQL 7-244, SQL 7-245

what happens when violated, SCN 255

when evaluated, SCN 10-9

when to disable, SAD 19-16

where not allowed, PLS 7-4

with partitioning, DWG 7-6

with query rewrite, DWG 19-29

constraints, object classes, OID 2-10

constructor method, DCI 3-4

constructor methods, ADO 1-4, ADO 7-2, SCN 1-56, SCN 13-6

and object types, SQL 7-439

literal invocation of, ADO 2-3

constructors

collection, PLS 4-8

object, PLS 9-12

Consumer is closed - error, ADQ D-3

consumer servers, OID 2-12, OID 2-15, OID 2-16

Consumers, ADQ 7-3

content access items, OID 9-20

access control points, OID 9-20

modifying, OID 9-33

contention

context

switching, PLS 4-30

transaction, PLS 5-55

WITH CONTEXT clause, DCI 4-9

CONTEXT ALLOCATE SQL statement, PC_ F-28

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

context area, STU 2-12

context block

definition of, PC_ 20-4

CONTEXT FREE statement, PC_ 11-9, PC_ F-29, PCO 12-8, PCO F-20

context namespaces

removing from the database, SQL 7-474

CONTEXT OBJECT OPTION GET SQL statement, PC_ 17-18

CONTEXT OBJECT OPTION SET SQL statement, PC_ 17-18

context switches

reduced with Cache Fusion, PSA 12-4

context switching, STU 18-6

CONTEXT USE directive, PC_ 11-8, PCO 12-8

CONTEXT USE SQL directive, PC_ F-33, PCO F-21

CONTEXT USE SQL statement, PC_ 11-8, PCO 12-8

contexts

creating namespaces for, SQL 7-261

granting

system privileges on, SQL 7-521

namespace

associating with package, SQL 7-261

continuation lines

syntax, PCO 2-13

CONTINUE action

in the WHENEVER statement, PC_ 9-25

of WHENEVER directive, PC_ F-119, PCO 8-16, PCO F-93

result of, PC_ 9-25

CONTINUE_LOAD keyword

SQL*Loader, SUT 5-35

CONTINUEIF keyword

example, SUT 4-15

SQL*Loader, SUT 5-36

continuing interrupted loads

SQL*Loader, SUT 5-34

continuous pushes

scheduling, REP 7-11, REP 7-12

CONTROL

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

control file records

overwriting, RMN 3-47

control files, GTK 3-52, SBR 2-3 to SBR 2-6, SCN 1-10, SCN 362

adding, SAD 5-5

allow reuse of, SQL 7-264

allowing reuse of, SQL 7-269

altering, SBY 4-12, SBY 5-26

backing up, PSA 13-1, SBR 2-5, SBR 4-3, SBR 4-13, SCN 366, SQL 7-20

using RMAN, RMN 5-7

backing up to trace file, SBR 4-14

backup and recovery, RMN 6-22

changes recorded, SCN 363

changing size, SAD 5-4

checkpoints and, SCN 363

conflicts with data dictionary, SAD 5-8

contents, SBR 1-7, SBR 2-3, SCN 362

CONTROL_FILES initialization parameter

for primary and standby databases, SBY 2-19

creating, PSA 3-9, SBR 6-14, SBY 2-8, SBY 5-15

about, SAD 5-2

additional control files, SAD 5-5

initially, SAD 5-4

new files, SAD 5-5

data definition language syntax, SUT 5-3

data files, PSA 8-10

default name, SAD 2-21, SAD 5-4

definition, SBR 1-7

described, PSG 1-14

dropping, SAD 5-9

effect on standby databases, SBY 4-12

errors during creation, SAD 5-9

field delimiters, SUT 5-16

finding filenames, SBR 4-3

guidelines for, SAD 5-2 to SAD 5-3

guidelines for creating, SUT 3-3

how specified, SCN 5-4

importance of multiplexed, SAD 5-3

incomplete recovery, SBR 5-26

location of, SAD 5-3

log history, PSA 3-3, PSA 13-7

log sequence numbers, SAD 6-5

loss of, SBR 6-12

all copies, SBR 6-13

maintaining backups, SBR 2-6, SBR 2-8

MAXLOGHISTORY, PSC 7-5

mirrored, SAD 5-3, SBR 2-8

loss of, SBR 6-12

mirroring, SAD 2-21

moving, SAD 5-5

multiplexed, SBR 2-6, SBR 2-7, SBR 2-8, SCN 1-48, SCN 363

importance of, SAD 5-3

names, SAD 5-2, SRF 1-21

number of, SAD 5-3, SBR 2-8

overview, SBR 1-7, SCN 1-10, SCN 362

overwriting existing, SAD 2-21

overwriting records, RMN 3-47

parameter values, PSA 1-9

purpose, SBR 1-8

raw devices, PSG 2-6

recovering from loss of, SBR 2-8

recovery and, SCN 1-48

re-creating, SQL 7-263

refreshing standby database, SBY 4-15, SBY 5-26

relocating, SAD 5-5

renaming, SAD 5-5

renaming or removing for migration, MIG 4-25, MIG 7-17, MIG 13-58

requirement of one, SAD 5-2

restoring, RMN 6-12

to default location, SBR 6-13

to non-default location, SBR 6-13

using dbid, RMN 6-36

using RMAN, RMN 6-12, RMN 6-13

setting the CONTROL_FILES initialization parameter, SBR 2-8

size of, SAD 5-3

snapshot

specifying location of, RMN 2-3

specifying, SRF 1-21

specifying data, SUT 5-21

specifying names before database creation, SAD 2-21

specifying SQL*Loader discard file, SUT 5-27

time-based recovery, SBR 5-28

troubleshooting, SAD 5-8

unavailable during startup, SAD 3-4

updating, SBR 2-5

used in mounting database, SCN 5-6

using instead of a recovery catalog, RMN 1-17

control structures, PLS 3-2

conditional, PLS 3-2

iterative, PLS 3-6

sequential, PLS 3-15

control utilities

CMCTL, NET 4-29, NET A-81 to NET A-97

described, NET A-1

LSNRCTL, NET 4-29, NET A-4 to NET A-25

NAMESCTL, NET 4-30, NET A-28 to NET A-79

control, access, OID 1-5, OID 9-1

CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, RMN 3-47, SRF 1-21

preventing overwrite of RMAN records, RMN 3-47

CONTROL_FILE_RECORD_KEEP_TIME parameter

of ALTER SYSTEM, SQL 7-108

CONTROL_FILES initialization parameter, RMN 6-12, RMN 8-8, SBR 2-8, SBR 4-3, SBR 6-13, SBY 2-19, SBY 5-2, SBY 5-9, SRF 1-21

overwriting existing control files, SAD 2-21

setting

before database creation, SAD 2-21, SAD 5-4

names for, SAD 5-2

warning about setting, SAD 2-21

CONTROL_FILES parameter, PSA 1-8, PSA 14-11, PSG 4-7

same for all instances, PSA 1-8

controlfile clauses

of ALTER DATABASE, SQL 7-9

CONTROLFILE REUSE clause

of CREATE DATABASE, SQL 7-269

ContText

migrating to interMedia, MIG 4-7, MIG 5-6

CONVBUFSZ clause, PC_ 4-51, PCO A-8

CONVBUFSZ clause in VAR statement, PCO 4-45

conventional path Export

compared to direct path Export, SUT 1-42

conventional path loads

basics, SUT 8-2

compared to direct path loads, SUT 8-7

concurrent, SUT 8-26

SQL*Loader bind array, SUT 5-75

using, SUT 8-3

conventions

description of, PC_ xvi

naming, DCI 2-8, PLS 2-36

notation, PC_ xvi

used in documentation, LEG viii

conventions used in this manual, PCO cxxv

conversion

rules, string to date, SQL 2-53

Conversion failed - invalid property type - error, ADQ D-4

conversion functions, ADG 3-25, SQL 4-5

table of, SQL 2-37

TO_CHAR function, ADG 3-12

TO_CHAR function, year and century considerations, ADG 3-11

TO_DATE function, ADG 3-11

when needed, PLS 2-29

conversion, datatype, PLS 2-28

conversions

between character set ID number and character set name, NLS 4-6

character set, ADL 11-47

character set conversions needed on BFILE before using LOADFROMFILE(), ADL 10-34

from binary data to character set, ADL 11-47