---

C

C and C++

debugging DLLs, DCI 4-15

differences from PL/SQL, DCI 5-9

C call specifications

compatibility, MIG 8-14

C clause

of CREATE TYPE, SQL 7-416

of CREATE TYPE BODY, SQL 7-424

C datatypes

manipulating with OCI, OCI 11-5

C method

mapping to an object type, SQL 7-416

C number format element, SQL 2-36

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

cache, PC_ 17-4

buffer cache, SPS 4-5, SPS 5-5

coherency, SPS 4-12, SPS 9-2

consistency, on MPPs, SPS 3-8

database blocks, SRF 1-25

dictionary, SRF 3-70, SRF 3-89, SRF 3-90, SRF 3-91, SRF 3-92

dictionary cache, SPS 4-12, SPS 5-5, SPS 6-6

flushing dictionary, SPS 4-16

management issues, non-PCM, SPS 4-16

parallel cache management, SPS 4-12

recovery, SPS 22-6

row cache, SPS 6-6

sequence cache, SPS 4-7, SPS 6-7

statistics, SRF 1-68

CACHE / NOCACHE, ADL 3-10

CACHE clause, SCN 7-4

of ALTER MATERIALIZED VIEW, SQL 7-48

of ALTER MATERIALIZED VIEW LOG, SQL 7-56

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

of ALTER TABLE, SQL 7-142

of CREATE CLUSTER, SQL 7-240

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

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-303

of CREATE SEQUENCE, SQL 7-351

of CREATE TABLE, SQL 7-383

CACHE FREE ALL SQL statement, PC_ 17-6

CACHE FREE ALL statement, PC_ F-15

cache functions

server roundtrips, OCI C-4

Cache Fusion

and cache coherency conflicts, SPS 20-2

architecture, SPS 5-7

benefits, SPS 20-4

change summary for 8.1, SPS A-1

definition, SPS 4-6, SPS 5-7

description, SPS 20-2

performance, SPS 20-1

read consistency, SCN 27-6

tuning, SPS 20-1

cache fusion, GTK 2-61

CACHE hint, SQL 2-62, STU 7-63

cache hit ratios

increasing, STU 19-29

CACHE keyword, SPS 18-28

CACHE option

CREATE SEQUENCE command, ADG 3 - 41

CACHE option, CREATE SEQUENCE, SPS 6-6

CACHE_SIZE_THRESHOLD parameter, SPS A-17, SRF 1-19

obsolete for 8.1, SPS A-5

Cached Commit SCN referenced statistic, SRF C-2

cached sequence numbers

Export, SUT 1-55

caches

buffer cache, SCN 7-3

multiple buffer pools, SCN 7-5

cache hit, SCN 7-4

cache miss, SCN 7-4

data dictionary, SCN 2-4, SCN 7-10

location of, SCN 7-6

database buffer, SCN 1-16

library cache, SCN 7-6, SCN 7-7, SCN 7-10

object cache, ADL 2-14, SCN 13-14, SCN 14-16

object views, SCN 15-4

private SQL area, SCN 7-8

sequence cache, ADG 3 - 40

sequence numbers, ADG 3 - 36

shared SQL area, SCN 7-6, SCN 7-8

writing of buffers, SCN 8-8

calendar formats, NLS 2-15

Calendar package, SPR 1 - 12

calendar parameter, NLS 2-15

calendar systems, NLS 2-6, NLS 2-8, NLS 2-11, NLS 2-14, NLS 2-17, NLS 2-19, NLS 2-20, NLS 2-21, NLS 2-22, NLS 2-27, NLS 2-28

supported, NLS A-19

calendars, NLS A-19, NLS A-20

CALL clause

of CREATE TRIGGER, SQL 7-407

CALL procedure statement

of CREATE TRIGGER, SQL 7-407

call spec, PLS 8-3

in procedures, SQL 7-333

of CREATE FUNCTION, SQL 7-271

of CREATE PROCEDURE, SQL 7-335

of CREATE TYPE, SQL 7-416

of CREATE TYPE BODY, SQL 7-424

call specifications. See call spec.

call specs, GTK 2-19, GTK 2-44

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

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

compatibility, MIG 8-14

example, PC_ 7-28, PCO 6-30

call, inter-language, PLS 7-27

call, subprogram, PLS 7-13

callback, ADG 11 - 44

example, ADG 11 - 44

failover, STU 25-23

restrictions, ADG 11 - 46, DCI 4-11

callbacks

application failover, OCI 9-18

dynamic registrations, OCI 9-15

for LOB operations, OCI 7-13

for reading LOBs, OCI 7-14

for writing LOBs, OCI 7-15

from external procedures, OCI 9-17

LOB streaming interface, OCI 7-13

parameter modes, OCI 15-63

registration for application failover, OCI 9-20

restrictions, OCI 9-16

user-defined functions, OCI 9-11

callbacks, user exit, PCO 12-14

Calling Java from PL/SQL, PC_ A-5

calls

Oracle call interface, SCN 8-25

remote procedure, DDS 1-12, SCN 33-12

calls to get snapshot scn

kcmgss statistic, SRF C-6

cancel-based media recovery

definition, SBR 3-29

procedures, SBR 14-20, SBR 14-23, SBR 14-26, SBR 14-29

canceling OCI calls, OCI 2-33

cancelling a cursor, ADG 8 - 10

cannot serialize access, SCN 27-11

capacity planning, SPS 19-3

capture avoidance rule, SCN 14-8

cardinality, SCN 10-33, STU 6-20

carriage return, PLS 2-3

Cartesian products, SCN 23-3, SQL 5-22

cartridge services, GTK 2-32

CASCADE actions

DELETE statements and, SCN 28-17

CASCADE clause

of CREATE TABLE, SQL 7-383

of DROP PROFILE, SQL 7-468

of DROP USER, SQL 7-483

CASCADE CONSTRAINTS clause

of DROP CLUSTER, SQL 7-447

of DROP TABLE, SQL 7-476

of DROP TABLESPACE, SQL 7-478

of REVOKE schema_object_privileges, SQL 7-534

CASCADE option

integrity constraints, ADG 6 - 18, SAD 17-11

when dropping unique or primary keys, SAD 20-20

cascading revokes, SAD 24-14

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

case studies

preparing tables for SQL*Loader, SUT 4-4

SQL*Loader, SUT 4-1

SQL*Loader associated files, SUT 4-3

SQL*Loader file names, SUT 4-3

CASE1.RCV sample script

setting size limits for backup pieces, SBR 5-20

case-insensitive sorting, NLS 2-26

case-insensitivity, PCO 2-11

CAST expressions, SQL 5-7

CAT synonym for USER_CATALOG view, SRF 2-68

catalog command (RMAN), SBR 6-5, SBR 6-27, SBR 11-32

CATALOG view, SRF 2-68

catalog, replication, REP 1-13, SCN 34-14

CATALOG5.SQL, obsolete with Oracle8i, MIG 8-24

CATALOG6.SQL, obsolete with Oracle8i, MIG 8-24

cataloging O/S copies, SBR 8-25

CATALOG.SQL

creating V$ views, SRF 3-2

preparing database for Export, SUT 1-9

preparing database for Import, SUT 2-7

CATALOG.SQL script, MIG 3-4, MIG 3-27, MIG 7-19, MIG 12-49, SBR 6-2, SRF 5-2

CATAUDIT.SQL

running, SAD 25-4

CATAUDIT.SQL script

audit trail records created by, SRF 2-191

audit trails for connections and disconnections, SRF 2-192

auditing options created by, SRF 2-224

CATBLOCK.SQL script, SRF 5-3

CATEXP7.SQL

preparing database for Export, SUT 1-60

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

downgrading to Oracle7, MIG 13-3

CATEXP.SQL

preparing database for Export, SUT 1-9

preparing database for Import, SUT 2-7

CATHO.SQL

script to install data dictionary tables and views for HS, DDS 6-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

running, SAD 25-5

CATNOAUD.SQL script, SRF 5-6

CATNOHS.SQL script, SRF 5-6

CATNOPRT.SQL script, SRF 5-6

CATNOQUEUE.SQL script, MIG 7-28, SRF 5-6

CATNORMN.SQL script, SRF 5-6

CATNOSVM.SQL script, SRF 5-6

CATNSNMP.SQL script, SRF 5-6

CATOCTK.SQL script, SRF 5-3

CATPARR.SQL script, MIG 3-28, MIG 7-24, MIG 12-49, SPS 15-12, SPS 20-12, SRF 5-3, STU 19-29

CATPERF.SQL file, STU 19-37

CATPROC.SQL script, ADG 13 - 4, ADG 14 - 2, MIG 3-4, MIG 3-27, MIG 7-19, MIG 12-49, SBR 6-2, SRF 5-2

catproc.sql script, SPR 1 - 2

CATQUEUE.SQL script, MIG 7-28

CATREP.SQL script, MIG 3-28, MIG 4-17, MIG 7-21, MIG 12-49, SRF 5-3

CATRMAN.SQL script, SBR 6-5, SRF 5-3

CC date format, ADG 4 - 12

CC date format element, SQL 2-41

CDS

naming adapter components, OAS 11-4

naming adapter includes, OAS 11-4

CDS value, NET 7-19

CDS, using to perform name lookup, OAS 13-13

cds_attributes file, modifying for name resolution in CDS, OAS 13-14

CEIL function, SQL 4-9

Cell Directory Service (CDS), NET 3-6

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

Cell Directory Service, using to perform name lookup, OAS 13-13

CELL_NAME, DCE address parameter, OAS 13-2

centralized authentication, OAS 1-5

centralized naming

advantages and disadvantages, NET 3-9

described, NET 3-5

establishing a connection with, NET 3-5

recommended for, NET 3-9

century, ADG 4 - 10, SCN 12-12

date format masks, ADG 4 - 8

specifying, SQL 2-42

CERN proxy server, OAS 9-11

certificate

definition, OAS 9-5

certificate authority, GTK 2-74, SCN 29-5

definition, OAS 9-5, OAS Glossary-1

chained row tables

dropping, MIG 12-18

chained rows, STU 20-30

CHAINED_ROWS view, SRF 2-68

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

challenge-response (asynchronous) authentication in RADIUS, OAS 3-5

CHANGE CATEGORY clause

of ALTER OUTLINE, SQL 7-58

change command (RMAN), SBR 6-10, SBR 11-35

available option, SBR 6-8

delete option, SBR 6-28

unavailable option, SBR 6-8

change master definition site, RAR 7-2

change vectors, SAD 6-2

change write time statistic, SRF C-6

CHANGE_PASSWORD command, NET A-4

change-based recovery, SBR 14-32 to SBR 14-35

coordinated in distributed databases, SBR 15-16

definition, SBR 3-29

changes

making permanent, SQL 7-214

changing default storage parameters, SQL 7-168

channel bandwidth, STU 17-4

channel control

overview of RMAN, SBR 4-24

channels

allocating, SBR 4-24

allocating for backup and recovery, SPS 21-8

parallelization of, SBR 4-26

CHAR

external datatype, OCI 3-16

CHAR column

maximum width, PLS 2-14

CHAR columns

maximum width, PCO 4-2

Version 6 export files, SUT 2-65

CHAR datatype, ADG 4 - 2, ADG 4 - 5, PC_ 4-10, PLS 2-14, SCN 12-5, SQL 2-11

ANSI, SQL 2-24

blank-padded comparison semantics, SCN 12-5

column length, ADG 4 - 6

converting to VARCHAR2, SQL 2-35

delimited form and SQL*Loader, SUT 5-70

increasing column length, ADG 3 - 9, SAD 14-10

multi-byte character sets and, NLS 3-14

reference

SQL*Loader, SUT 5-64

space use of, SAD 12-17

trimming whitespace, SUT 5-83

when to use, ADG 4 - 5

CHAR datatypes

external, PCO 4-9

internal, PCO 4-2

CHAR semantics, PLS B-1

CHAR VARYING datatype, ANSI, SQL 2-24

CHAR_CS value, PLS 2-29

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

character data, PC_ 5-2

binary sorts, NLS 2-25

linguistic indexes, NLS 2-26

linguistic sorts, NLS 2-25

special cases, NLS 2-26

sorting, NLS 2-25

CHARACTER datatype

ANSI, SQL 2-24

DB2, SQL 2-25

SQL/DS, SQL 2-25

character datatypes

conflicting fields, SUT 5-73

character fields

datatypes

SQL*Loader, SUT 5-64

delimiters and SQL*Loader, SUT 5-70

determining length for SQL*Loader, SUT 5-73

specified with delimiters

SQL*Loader, SUT 5-64

character functions, SQL 4-3

character host variables

as output variables, PCO 4-34

handling, PCO 4-32

server handling, PCO 4-34

types, PCO 4-32

CHARACTER keyword

behavior in Oracle7 and Oracle8i, MIG 8-22

character large object, see CLOB

character large objects. See CLOB datatype.

character literal, PLS 2-8

character literal. See text.

character set, PLS 2-2

conversion, NLS 3-22

definition files, NLS B-2

for net service name, NET C-5

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

network, for keyword values, NET C-4

parameters, NLS 2-29

setting for use with RMAN, SBR 5-3

CHARACTER SET clause

of CREATE CONTROLFILE, SQL 7-248

OF CREATE DATABASE, SQL 7-252

character set conversion using OCI, NLS 5-33

character set conversions, SUT 2-55

character set form, OCI 5-26

character set Id, OCI 5-26

Unicode, OCI A-20, OCI A-22

CHARACTER SET parameter

of ALTER DATABASE, SQL 7-16

Character sets, DDS A-7

character sets

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

ANY_CS, SPR 17 - 3

CLOB and NCLOB datatypes, SCN 12-13

column lengths, SCN 12-6

common, SQL 2-29

conversion, NLS 3-22

conversion between

during Export/Import, SUT 1-53

CONVERT function, NLS 4-4

converting, NLS 4-4

direct path export, SUT 1-43, SUT 1-53

eight-bit to seven-bit conversions

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

for various languages, SCN 5-5

Migration utility, MIG 3-8

multi-byte, NLS 3-14, PCO 4-41

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

multi-byte and SQL*Loader, SUT 5-30

multi-byte characters

in role names, SAD 24-5

in role passwords, SAD 24-7

user passwords and, SAD 23-12

multibyte characters, SQL 2-67

NCHAR and NVARCHAR2, SCN 12-6

NCHAR data

Export, SUT 1-54

Oracle Data Migration Assistant, MIG 4-6

parameter file and, SAD 3-14

pattern matching characters, NLS 4-9

single-byte

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

sorting data, NLS 2-25

specifying for database, SQL 7-252

specifying when creating a database, SAD 2-2

SQL*Loader conversion between, SUT 5-30

support for, DCI 2-12

supported, NLS 3-16

supported by Oracle, SAD 12-17

varying-width

CLOBs and NCLOBs, MIG 8-25

Version 6 conversions

Import/Export, SUT 2-56

character string functionality and character sets

supported, NLS 3-16

character strings

as part of a field comparison, SUT 5-15

comparison rules, SQL 2-27

exact matching of, SQL 2-46

fixed-length, SQL 2-11

multi-byte, PCO 4-42

multibyte, PC_ 4-52

national character set, SQL 2-11

SQL*Loader, SUT 5-46

variable length, SQL 2-12

variable-length, SQL 2-15

zero-length, SQL 2-11

CHARACTER subtype, PLS 2-14

character value

assigning, PLS B-2

comparing, PLS B-2

inserting, PLS B-4

selecting, PLS B-4

CHARACTER VARYING datatype

ANSI, SQL 2-24

characters

numeric group separators, SRF 1-81

single, comparison rules, SQL 2-28

CHARACTERSET keyword

SQL*Loader, SUT 5-31

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

CHARF datatype specifier, PCO 4-51

using in TYPE statement, PCO 4-51

using in VAR statement, PCO 4-51

CHARF datatypes

external, PCO 4-9

CHARSETFORM property, ADG 11 - 24

CHARSETID property, ADG 11 - 24

CHARTOROWID function, ADG 4 - 25, SCN 12-23, SQL 2-32, SQL 4-9

charts

OPS Overview, PSC 7-19

Oracle Performance Manager, PSC 7-1 to PSC 7-19

Parallel Server Active Users, PSC 7-17

Parallel Server Active Users by Instance, PSC 7-18

Parallel Server Block Ping, PSC 7-6

Parallel Server Block Ping Tablespace Instance, PSC 7-7

Parallel Server Block Ping Tablespace Object, PSC 7-7

Parallel Server Data Block Ping, PSC 7-7

Parallel Server Data Block Ping by Instance, PSC 7-9

Parallel Server File I/O Rate, PSC 7-10

Parallel Server File I/O Rate by Instance, PSC 7-12

Parallel Server File I/O Rate by Object, PSC 7-11

Parallel Server Lock Activity, PSC 7-13

Parallel Server Sessions, PSC 7-14

Parallel Server Users Logged On, PSC 7-15

Parallel Server Users Logged On by Instance, PSC 7-16

CHARZ

external datatype, OCI 3-17

CHARZ datatype, PC_ 4-11

external, PCO 4-10

CHECK clause

of constraint_clause, SQL 7-224

of CREATE TABLE, SQL 7-369

CHECK constraint, SAD 20-19

data integrity, ADG 5 - 22

designing, ADG 5 - 16

NOT NULL constraint and, ADG 5 - 16

number of, ADG 5 - 16

restricting nulls using, ADG 5 - 16

restrictions on, ADG 5 - 15

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

when to use, ADG 5 - 15

CHECK constraints, SCN 28-17

checking mechanism, SCN 28-20

defined, SCN 28-17

multiple constraints on a column, SCN 28-18

partially null foreign keys, SCN 28-16

partition views, SCN 11-11

subqueries prohibited in, SCN 28-18

check constraints, SQL 7-224

Import, SUT 2-48

CHECK DATAFILES clause, SPS 6-2

instance recovery, SPS 22-4

of ALTER SYSTEM, SQL 7-98

check_object procedure, SAD 19-3, SAD 19-7

CHECK_ONLY

Migration utility option, MIG 3-14, MIG 3-18

checkerr() function

code listing, OCI 2-28

checking imported data, REP 7-17

checkpoint

forcing, SPS 21-9, SQL 7-98

CHECKPOINT clause

of ALTER SYSTEM, SQL 7-98

checkpoint completed wait event, SRF A-23

CHECKPOINT option

ALTER SYSTEM statement, STU 25-6

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

starting, SAD 4-12

checkpoint range buffer not saved wait event, SRF A-23

CHECKPOINT_PROCESS parameter, PSC 6-10, SPS 18-10

setting, SAD 4-12

checkpoints

checkpoint interval, SRF 1-67

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

choosing checkpoint frequency, STU 20-39

control files and, SCN 32-22

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

Fast-Start Checkpointing, SCN 32-13

incremental, SCN 8-8

performance, STU 20-39

redo log maintenance, STU 20-39

statistics, SRF 1-68

statistics on, SCN 8-11

tuning, STU 20-38

checksumming and encryption, activating, OAS 2-6

checksums, OAS 1-4

for data blocks, SAD 10-12

redo log blocks, SAD 6-16

child process termination, NET 9-15

CHOOSE hint, SCN 23-33, SQL 2-59, STU 7-40

CHR function, SQL 4-10

CHUNK, ADL 3-11

CHUNK clause

of ALTER TABLE, SQL 7-132

of CREATE TABLE, SQL 7-375

cipher suites, SSL, OAS B-8

circular dependencies in tables

restrictions on adding sites with to master groups, REP 2-33

CKCFG.ORA file, NET 6-25

CKPCCH.ORA file, NET 6-25

CKPREG.ORA file, NET 6-25

CKPT, SAD 4-12

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

CKPT process, SPS 5-5, STU 20-41

clause

AUTHID, PLS 7-32

BULK COLLECT, PLS 4-34

of CREATE TABLE, SQL 7-382

cleanouts and rollbacks - consistent read gets statistic, SRF C-6

cleanouts only - consistent read gets statistic, SRF C-6

CLEANUP_ROLLBACK_ENTRIES parameter, SPS A-9, SPS A-13, SRF 1-19

CLEAR LOGFILE clause

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

CLEAR LOGFILE GROUP option

ALTER DATABASE command, SBR 16-17

CLEAR LOGFILE option

ALTER DATABASE command, SAD 6-17

CLEAR UNARCHIVED LOGFILE option

ALTER DATABASE command, SBR 16-25

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

restrictions, SAD 6-17

Client, PSC 4-25

client

browse policy, LEG 2-6

configuring a profile, NET 7-15

configuring domains, NET 7-16, NET 7-21

configuring for connection concentration, NET 7-33

configuring for multi-protocol support, NET 7-36

configuring for Net8 access control, NET 7-40

configuring for Oracle Connection Manager address, NET 7-43

configuring for Oracle Connection Manager features, NET 7-41

configuring for Oracle Rdb, NET 7-72

configuring for Oracle Rdb database, NET 7-71

configuring with local naming, NET 6-20

configuring with the Net8 Configuration Assistant after install, NET 4-24

discovering Oracle Names servers, NET 6-37

index, LEG 2-5

load balancing, NET 2-30, NET 4-10, NET 7-11, NET C-41

log files, NET 11-20

methods of connecting, NET 8-8

migrating, NET 5-19

overriding multi-threaded server mode, NET 9-11

randomization, NET 2-30, NET C-41

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

retention policy, LEG 2-6

session with multiple protocols, diagram, NET 2-50

SQLNET.LOG, NET 11-20

testing connectivity, NET 8-20

testing using 3GL, NET 8-9

testing using application, NET 8-9

testing using OS, NET 8-9

testing using special commands, NET 8-10

trace files, NET 11-33

upgrading, NET 5-19

client application layer, described, NET 2-10

client authentication in SSL, requiring, OAS 9-28

client connections to services, SPS 18-28

client events, ADG 14 - 5

client load balancing, NET 2-30, NET 4-10, NET C-41, PSC 4-25, SPS 18-32

configuring, NET 7-11

using to improve network performance, NET 3-12

client program, PLS 9-2

Client Registration ID option, NET 7-23

client troubleshooting, NET 11-4

clients

communicating with servers on Windows NT, LEG B-7

DHCP, LEG B-10

role in distributed transactions, DDS 3-6

client/server applications, STU 3-9, STU 18-4

client/server architectures, SCN 6-2

clients, SCN 1-33

diagrammed, SCN 6-2

direct and indirect connections, DDS 1-2, SCN 33-2

distributed databases and, DDS 1-2, SCN 33-2

distributed processing in, SCN 6-2

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

program interface, SCN 8-25

client-server communications, problems with

NT, LEG B-7

UNIX, LEG B-1

client-server configuration, SPS 5-4

description, SPS 1-20

Net8, SPS 1-20

CLOB, DCI 6-2

datatype, OCI 3-20

EMPTY_CLOB function, DCI 6-4

CLOB datatype, ADL 1-2, PLS 2-22, SCN 12-13, SQL 2-21

NCLOBs, ADL 1-2, SPR 17 - 3

transactional support of, SQL 2-21

CLOBs

compatibility, MIG 8-25

example, SUT 4-39

loading, SUT 5-99

CLOBs support, REP A-3

clone database

mounting, SQL 7-11

clone databases

exporting, SBR B-13

mounting, SCN 5-7

opening, SBR B-13

preparing for TSPITR, SBR B-11

preparing parameter files for, SBR B-10

recovering, SBR B-12

CLOSE command

examples, PCO F-15

CLOSE CURSOR statement, PC_ 14-27

CLOSE DATABASE LINK clause

of ALTER SESSION, SQL 7-79

CLOSE DATABASE LINK option, DDS 4-2

CLOSE SQL statements, PC_ F-18

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

dependence on precompiler options, PC_ 6-15

example, PCO 5-15

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

use in dynamic SQL method 4, PC_ 15-37

CLOSE_CACHED_OPEN_CURSORS parameter, SRF 1-20

CLOSE_CURSOR, DDS 7-3

CLOSE_ON_COMMIT

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

CLOSE_ON_COMMIT precompiler option, PCO 14-14

closed backups, SBR 3-4

closed thread, SPS 21-4, SPS 21-16

closing

cursors, PC_ F-18, PCO F-14

CLU synonym for USER_CLUSTERS, SRF 2-68

cluster

allocating extents, SPS 17-14

free list groups, SPS 17-11

free lists, SPS 11-12, SPS 17-7

hash cluster, SPS 11-12, SPS 17-7, SPS A-20

implementations, SPS 2-3

performance, SPS 3-2

version compatibility, SPS 18-22

CLUSTER clause

of CREATE INDEX, SQL 7-279

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-303

of CREATE TABLE, SQL 7-377

of TRUNCATE, SQL 7-583

CLUSTER hint, SQL 2-59, STU 7-43

cluster indexes, SQL 7-279

cluster joins, SCN 24-5

cluster key

changing column names, SQL 7-3

changing the number of columns, SQL 7-3

cluster key scan block gets statistic, SRF C-6

cluster key scans statistic, SRF C-7

cluster keys, SCN 1-27, SCN 10-48

columns for, SAD 17-4

SIZE parameter, SAD 17-5

cluster management, PSC 1-7

Cluster Manager (CM)

defined, PSC 1-4

See CM, PSC 1-6

Cluster Manager (CM) software, SPS 18-13, SPS 18-14

purpose, SPS 18-22

cluster tables

copying data, MIG 2-15

cluster, defined, PSC 1-9

clustered computer systems

Oracle Parallel Server, SCN 5-3

clustered tables, SAD 17-10

clusters, STU 6-24

allocating extents, ADG 6 - 17, SAD 17-9

allocating extents for, SQL 7-3

altering, SAD 17-8

analyzing statistics, SAD 20-3

assigning tables to, SQL 7-377

caching retrieved blocks, SQL 7-240

cannot be partitioned, SCN 11-2

choosing data, ADG 6 - 14, ADG 6 - 15, SAD 17-4

choosing data to cluster, SCN 10-48

collecting statistics on, SQL 7-188

columns for cluster key, SAD 17-4

creating, ADG 6 - 15, SAD 17-6, SQL 7-236, SQL 7-237

data blocks allocated to, SQL 7-238

deallocating unused extents, SQL 7-3

defined, SCN 1-27

degree of parallelism

changing, SQL 7-3

when creating, SQL 7-240

dictionary locks and, SCN 27-29

dropped tables and, ADG 3 - 10, SAD 14-13

dropping, ADG 6 - 17, SAD 17-10

dropping tables of, SQL 7-447

estimating space, SAD 17-5, SAD 17-6

Export, SUT 1-49

granting

system privileges on, SQL 7-495

guidelines for managing, SAD 17-4

hash, SCN 10-50, SQL 7-239

allocation of space for, SCN 10-55

collision resolution, SCN 10-53

contrasted with index, SAD 18-2, SCN 10-51

root blocks, SCN 10-55

scans of, SCN 23-35, SCN 23-39, SCN 23-41

single-table, SCN 10-57, SQL 7-239

storage of, SCN 10-51

hash clusters, SAD 18-1

index, SCN 10-50

contrasted with hash, SAD 18-2, SCN 10-51

scans of, SCN 23-41

index creation, ADG 6 - 16, SAD 17-8

indexed, SQL 7-239

indexes and, SAD 16-2

indexes on, SCN 10-21

cannot be partitioned, SCN 11-2

integrity constraints and, ADG 6 - 16

joins and, SCN 10-48, SCN 23-38, SCN 23-40, SCN 24-5

keys, ADG 6 - 14, SAD 17-2, SCN 1-27, SCN 10-48, SCN 10-49

affect indexing of nulls, SCN 10-8

location, SAD 17-5

managing, SAD 17-1

migrated and chained rows in, SQL 7-192

modifying, SQL 7-2

overview of, SAD 17-2, SCN 10-46

performance considerations, ADG 6 - 15

performance considerations of, SCN 10-48

physical attributes

changing, SQL 7-2

specifying, SQL 7-238

privileges

for creating, SAD 17-6

for dropping, SAD 17-10

privileges for creating, ADG 6 - 16

removing from the database, SQL 7-446

rowids and, SCN 10-7

scans of, SCN 7-4, SCN 23-34, SCN 23-38

hash, SCN 23-39, SCN 23-41

joins, SCN 23-40

setting parameters of, SCN 10-49

space allocated for cluster key values, SQL 7-238

specifying PCTFREE for, SAD 12-4

SQL examples, SQL 7-447

storage attributes

changing, SQL 7-2

storage characteristics, SQL 7-575

specifying, SQL 7-238

storage format of, SCN 10-49

storage parameters, SAD 12-10

storage parameters of, SCN 10-4

tablespace

changing, SQL 7-3

tablespace in which created, SQL 7-239

truncating, SAD 20-9

validating structure, SAD 20-8

validating structure of, SQL 7-191

CM

cluster management, PSC 1-7

defined, PSC 1-4

DefinedNodes registry value, PSC 4-6

described, PSC 1-6

determining groups available, PSC 1-7

determining instances available, PSC 1-7

Group Membership Service (GMS), PSC 1-7

interacting with IDLM, PSC 1-6, PSC 1-16

node monitoring, PSC 1-6

CMADM_PID.LOG file contents, NET 11-18, NET 11-27

CMADM_PID.TRC file contents, NET 11-32

CMADMIN process, NET 4-14, NET 5-21

purpose, NET 2-47

cman, NET 4-14

CMAN parameter, NET C-76

CMAN_ADMIN parameter, NET 4-14, NET 4-19, NET 5-21

CMAN_PID.LOG file contents, NET 11-18, NET 11-27

CMAN_PID.TRC file contents, NET 11-32

CMAN_PROFILE parameter, NET C-77

CMAN_RULES parameter, NET 7-39, NET C-80

CMAN.LOG file, NET 11-18

CMAN.LOG file contents
, NET 11-18

CMAN.ORA

see Oracle Connection Manager, configuration file

CMCTL

purpose, NET 2-47

see Oracle Connection Manager Control Utility

CMGW process

purpose, NET 2-46

CNAME.SMD record, NET 8-17, NET A-45

COALESCE clause

for partitions, SQL 7-149

for subpartitions, SQL 7-146

of ALTER INDEX, SQL 7-39

of ALTER TABLESPACE, SQL 7-169

COALESCE SUBPARTITION clause

of ALTER TABLE, SQL 7-146

coalescing extents, SCN 4-15

coalescing free space

extents, SCN 4-13

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

within data blocks, SCN 4-9

COBOL datatypes, PCO 4-17

COBOL datatypes, additional, PCO A-4

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

COBOL-74, PCO B-2

COBOL-74 restrictions, PCO 2-20

COBOL-85, PCO B-2

CODE

precompiler option, PC_ 12-3

code

example programs, OCI B-1

list of demonstration programs, OCI B-1

code examples

description of, SBR 11-4

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

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

CODE precompiler option, PC_ 10-13

CODE_PIECES view, SRF 2-69

CODE_SIZE view, SRF 2-69

Codepoints, NLS 4-9

codes

functions, OCI 15-230

coding area

for paragraph names, PCO 2-18

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

coding guidelines

function names, OCI 2-36

reserved words, OCI 2-35

Coexistence, PSC 3-8

coexistence, PSC 3-8

Oracle Names, NET 5-10

Oracle8i Client r. 8.0/SQL*Net Client connection to Oracle8i database r. 8.1, NET 5-6

Oracle8i Client r. 8.1 connecting to Oracle8i r. 8.0 or Oracle7 database, NET 5-8

Oracle8i Client r. 8.1 connection to Oracle8i database r. 8.1, NET 5-5

SERVICE_NAME parameter in TNSNAMES.ORA, NET 5-7

SID parameter in TNSNAMES.ORA, NET 5-7

third-party Oracle7 applications, NET 5-7

coexistence issues, NET 5-5 to NET 5-10

coherency

of object cache, OCI 13-4

COL view, SRF 2-69

cold backups, SBR 3-4

whole database backups, SBR 13-3

collating sequence, PLS 2-47

Collation parameters, NLS 2-24

COLLECT GET statement

example, PC_ 18-19

collection, PLS 4-2

assigning, PLS 4-11

bulk binds, PLS 4-29

comparing, PLS 4-13

constructor, PLS 4-8

declaring, PLS 4-7

defining, PLS 4-5

element type, PLS 4-5

initializing, PLS 4-8

referencing, PLS 4-10

scope, PLS 4-8

syntax, PLS 11-21

COLLECTION APPEND, PC_ F-19

COLLECTION APPEND statement, PC_ 18-12

SQL statements

COLLECTION APPEND, PC_ F-19

collection columns

user-specified storage

compatibility, MIG 8-29

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 8-12, MIG 8-29

collection method

applying to parameters, PLS 4-27

COUNT, PLS 4-22

DELETE, PLS 4-26

EXISTS, PLS 4-22

EXTEND, PLS 4-24

FIRST, PLS 4-23

LAST, PLS 4-23

LIMIT, PLS 4-22

NEXT, PLS 4-23

PRIOR, PLS 4-23

syntax, PLS 11-16

TRIM, PLS 4-25

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

collection types, DCI 1-8, PLS 4-1

structs for, PC_ 18-3

COLLECTION_IS_NULL exception, PLS 6-5

Collections, SUT 3-16

collections, ADG 18 - 13, PC_ A-4, SCN 13-10, SUT 3-20

and C, PC_ 18-3

attributes, OCI 6-13

autonomous access, PC_ 18-4

collection unnesting, GTK 2-35

data manipulation functions, OCI 11-18

describing, OCI 6-2

description, OCI 11-17

descriptors, PC_ 18-3

element access, PC_ 18-5

functions for manipulating, OCI 11-18

index-organized tables, SCN 10-38

key compression, SCN 10-30

inserting rows into, SQL 7-515

manipulating, PC_ 18-4

modifying, SQL 7-136

nested tables, PC_ 18-2, SCN 13-12, SQL 2-27

nesting, ADG 18 - 22

OBJECT GET statement, PC_ 18-6

OBJECT SET statement, PC_ 18-6

querying, ADG 18 - 13

scanning functions, OCI 11-19

SQL*Loader support, GTK 2-36

table items, SPR 48 - 15

treating as a table, SQL 7-441, SQL 7-515, SQL 7-586

unnesting, SQL 7-547

examples, SQL 7-564

variable arrays (VARRAYs), SCN 13-11

VARRAYs, PC_ 18-3

varrays, SQL 2-26

collections in Oracle Trace, STU 15-4, STU 15-22

collocated inline view, DDS 4-4

COLS synonym for USER_TAB_COLUMNS, SRF 2-69

column alias, PLS 5-14

when needed, PLS 2-34

column constraint, SQL 7-217

of ALTER TABLE, SQL 7-131

of CREATE TABLE, SQL 7-369

column constraints, SQL 7-221

column group, RAR 6-4, RAR 6-6, RAR 6-9, RAR 6-11, RAR 6-13, RAR 6-16

column groups

adding members to

syntax, SPR 34 - 5, RAR 8-79

and update conflict resolution, REP 6-7

creating

syntax, SPR 34 - 40, SPR 34 - 61, RAR 8-118, RAR 8-144

dropping, REP 6-15

syntax, SPR 34 - 44, RAR 8-123

removing members from

syntax, SPR 34 - 45, RAR 8-124

shadow, REP 6-8

column list, PCO 5-9

in INSERT statements, PC_ 6-9

when permissible to omit, PC_ 6-9

column naming

SQL*Loader, SUT 5-47

column objects

loading, SUT 5-91

loading nested column objects, SUT 5-93

storage, ADG 18 - 2

stream record format, SUT 5-91

variable record format, SUT 5-92

vs. row objects, ADG 18 - 2

column REF constraint, SQL 7-218

of ALTER TABLE, SQL 7-131

of CREATE TABLE, SQL 7-368

column ref constraint

of ALTER TABLE, SQL 7-131

column REF constraints, SQL 7-224

COLUMN_PRIVILEGES view, SRF 2-69

columns

accessing in triggers, ADG 13 - 15

adding, SQL 7-131

adding and removing in column groups, REP 6-14

aliases for, SQL 5-18

associating statistics with, SQL 7-195

attributes, OCI 6-5, OCI 6-15

basing an index on, SQL 7-280

cardinality, SCN 10-33

collecting statistics on, SQL 7-189

column names

qualifying in queries, SCN 14-8, SCN 14-9

column objects, SCN 13-8

indexes, SCN 14-6

creating comments about, SQL 7-212

default values, ADG 5 - 4

default values for, SCN 10-8

defined, SCN 1-23

defining, SQL 7-365

described, SCN 10-3

displaying information about, SAD 20-31

dropping, SCN 10-6

exporting LONG datatypes, SUT 1-55

generating derived values with triggers, ADG 13 - 49

granting privileges for selected, ADG 12 - 17, SAD 24-10

granting privileges on, SAD 24-12

increasing length, ADG 3 - 9, SAD 14-10

INSERT privilege and, SAD 24-12

integrity constraints, SCN 10-4, SCN 10-8, SCN 28-4, SCN 28-7

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

listing users granted to, SAD 24-22

loading REF columns, SUT 5-97

LOB, storage characteristics of, SQL 7-131

maximum in concatenated indexes, SCN 10-23

maximum in view or table, SCN 10-12

maximum number of, SQL 7-368

modifying existing, SQL 7-133

multiple FOREIGN KEY constraints, ADG 5 - 10

nested tables, SCN 10-9

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

number of CHECK constraints limit, ADG 5 - 16

order of, SCN 10-7

parent-child relationships between, SQL 7-260

partially dropped

dropping, MIG 12-8

privileges, SAD 24-12

prohibiting nulls in, SCN 28-7, SQL 7-222

pseudocolumns

ROWID, SCN 12-15

ROWNUM, SCN 23-16, SCN 23-25, SCN 23-49

USER, SCN 30-7

qualifying names of, SQL 5-18

REF

describing, SQL 7-224

reordering before Import, SUT 2-14

restricting values for, SQL 7-220

revoking privileges from, ADG 12 - 19

revoking privileges on, SAD 24-13

selectivity, SCN 22-8

histograms, SCN 22-8, SCN 22-10

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

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

setting value to zero, SUT 5-81

specifying as PIECED

SQL*Loader, SUT 8-15

specifying

SQL*Loader, SUT 5-46

specifying as foreign key, SQL 7-223

specifying as primary key, SQL 7-222

specifying constraints on, SQL 7-369

specifying default values for, SQL 7-368

unique values in, SQL 7-221

unused, SCN 10-6

dropping, MIG 12-8

COLUMNS clause

of ASSOCIATE STATISTICS, SQL 7-194, SQL 7-195

columns, to index, STU 6-4

COM Cartridge, GTK 2-87

combining SSL with other authentication methods, OAS 9-8

command

df, LEG 5-7

dkinfo, LEG 5-7

scanner, LEG 5-6

command files

Recovery Manager, SBR 4-10

command line

arguments for RMAN, SBR 4-9

CMCTL commands from, NET A-89

LSNRCTL commands from, NET A-3

NAMESCTL commands from, NET A-31

command line parameters (RMAN), SBR 11-39

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

command line utility, Oracle

Enterprise Backup Utility, Oracle7, LEG 4-2

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

command-line options

Migration utility, MIG 3-14

command-line parameters

description, SUT 6-2

Export, SUT 1-14

specifying defaults, SUT 5-18

commands

CMCTL reference, NET A-90 to NET A-93

LSNRCTL reference, NET A-4 to NET A-30

NAMESCTL reference, NET A-34 to NET A-88

commands, Recovery Manager

allocate, SBR 11-9

allocate channel for delete, SBR 8-26

allocate channel for maintenance/delete, SBR 11-13

alter database, SBR 11-15

archivelogRecoverSpecifier clause (RMAN), SBR 11-17

backup, SBR 4-29, SBR 8-2, SBR 8-26, SBR 11-21

proxy only option, SBR 4-19

proxy option, SBR 4-19

skip offline option, SBR 8-15

catalog, SBR 6-5, SBR 6-27

change, SBR 6-10, SBR 11-35

delete option, SBR 6-28

connect, SBR 11-44, SBR 11-46

copy, SBR 11-48

create catalog, SBR 11-52

create script, SBR 11-54

crosscheck, SBR 11-57

debug, SBR 11-62

delete expired backupset, SBR 11-63

delete script, SBR 11-65, SBR 11-66

drop catalog, SBR 6-35, SBR 11-68

duplicate, SBR 4-52, SBR 11-69

execute script, SBR 6-20

host, SBR 11-74

list, SBR 4-20, SBR 11-76

incarnation of database option, SBR 6-7

listObjList clause, SBR 11-84

overview, SBR 4-5

print script, SBR 11-86

recover, SBR 4-49, SBR 9-15, SBR 11-88

register, SBR 6-6, SBR 11-93

release channel, SBR 11-95

release channel (of type maintenance), SBR 11-96

replace script, SBR 11-97

replicate, SBR 9-11, SBR 11-100

replicate controlfile, SBR 9-11

report, SBR 4-22, SBR 11-102

need backup option, SBR 7-5

reset database, SBR 6-7, SBR 11-110

incarnation option, SBR 6-7

restore, SBR 9-17, SBR 11-112

resync catalog, SBR 4-14, SBR 6-23, SBR 11-118

from controlfilecopy option, SBR 6-33

rman, SBR 11-121

run, SBR 11-124

send, SBR 5-20, SBR 11-127

set, SBR 11-129

duplex parameter, SBR 8-22

maxcorrupt for datafile option, SBR 8-26

newname for datafile option, SBR 9-9

set (within run command), SBR 11-133

shutdown command, SBR 11-137

sql, SBR 11-140

startup, SBR 11-142

summary, SBR 11-5

switch, SBR 11-144

until, SBR 11-42, SBR 11-146

upgrade catalog, SBR 6-34, SBR 11-148

validate, SBR 11-150

commands, Recovery manager

catalog, SBR 11-32

commands, SQL

ALTER DATABASE, SBR 14-8, SBR 14-12, SBR 14-14, SBR 16-17, SBR 16-25

ALTER SNAPSHOT LOG, REP 7-23

CREATE CONTROLFILE, SBR 16-25

CREATE DATABASE, SAD 6-10

DROP SNAPSHOT LOG, REP 7-28

TRUNCATE, REP 7-25

TRUNCATE TABLE, REP 7-26

commands, SQL*Plus

ARCHIVE LOG, SAD 6-14

HOST, SAD 6-13

RECOVER, SBR 14-9

UNTIL TIME option, SBR 14-31

RECOVER DATAFILE, SBR 14-10

RECOVER TABLESPACE, SBR 14-9

SET, SBR 14-8, SBR 14-12

comment, PLS 2-9

restrictions, PLS 2-10

syntax, PLS 11-27

COMMENT ANY TABLE system privilege, SQL 7-502

COMMENT clause, PLS 5-42

of COMMIT, SQL 7-215

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

COMMENT command, SCN 16-4

COMMENT statement, SQL 7-212

Comments

in COMMIT statements, DDS 3-22

in Export parameter file, SUT 1-13

in Import parameter file, SUT 2-10

in SQL*Loader control file, SUT 4-12

restrictions in PL/SQL block, PC_ 13-31

comments, SQL 2-56

adding to objects, SQL 7-212

ANSI, PC_ 2-11

ANSI SQL-style, PCO 2-13

associating with a transaction, SQL 7-215

C-style, PCO 2-13

differences between Server Manager and SQL*Plus, MIG 10-7

dropping from objects, SQL 7-212

embedded SQL statements, PCO 2-13

how to specify, SQL 2-57

in embedded SQL, PCO 2-12

in SQL statements, SQL 2-56

on schema objects, SQL 2-58

removing from the data dictionary, SQL 7-212

updating, REP 7-38

viewing, SQL 7-212

which allowed, PC_ 2-11

comments field

in views

updating, REP 7-38

comments in configuration files, NET C-3

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

COMMIT

Import parameter, SUT 2-20

commit, OCI 2-26, PCO 3-19

automatic, PC_ 3-17, PCO 3-20, SQL 7-214

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

forcing, DDS 3-31

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

block lost statistic, SRF C-7

buffer being written statistic, SRF C-7

callback failure statistic, SRF C-7

cannot pin statistic, SRF C-7

hot backup in progress statistic, SRF C-7

write disabled statistic, SRF C-7

commit cleanouts statistic, SRF C-7

commit cleanouts successfully completed statistic, SRF C-7

COMMIT command, ADG 8 - 5, SCN 16-5

COMMENT parameter, DDS 3-22, DDS 3-33

differences between Server Manager and SQL*Plus, MIG 10-14

ending a transaction, SCN 17-2, SCN 17-4

fast commit, SCN 8-10

FORCE option, DDS 3-31

forcing, DDS 3-21

implied by DDL, SCN 17-2, SCN 17-4

two-phase commit and, DDS 1-13, SCN 17-7, SCN 33-13

two-phase commit in parallel DML, SCN 26-40

COMMIT IN PROCEDURE clause

of ALTER SESSION, SQL 7-79

COMMIT keyword

behavior in Oracle7 and Oracle8i, MIG 8-22

Commit phase, DDS 3-15

commit phase, DDS 3-3, DDS 3-4

Commit point site, DDS A-2

commit point site, DDS 3-8

commit point strength and, DDS 3-9

determining, DDS 3-10

Commit SCN referenced statistic, SRF C-3

COMMIT SQL statement, PC_ F-24

COMMIT statement, PC_ 3-18, PCO 3-20, PCO F-15, PLS 5-42, SQL 7-214

effect of, PC_ 3-18

effects, PCO 3-20

ending a transaction, PC_ F-101, PCO F-76

example, PCO 3-21

example of, PC_ 3-18

examples, PC_ F-26, PCO F-17

purpose of, PC_ 3-18

RELEASE option, PCO 3-21

RELEASE option in, PC_ 3-18

syntax, PLS 11-28

using in a PL/SQL block, PC_ 3-28, PCO 3-31

where to place, PC_ 3-18, PCO 3-21

COMMIT_POINT_STRENGTH parameter, DDS A-2, SRF 1-20

committed data

checkpoint, SPS 21-9

instance failure, SPS 22-2

sequence numbers, SPS 6-7

committing

transactions, PC_ F-24, PCO F-15

committing transactions

defined, SCN 17-2

distributed

commit point site, DDS 3-8

fast commit, SCN 8-10

group commits, SCN 8-10

implementation, SCN 8-10

overview, SCN 1-54

parallel DML, SCN 26-40

writing redo log buffer and, SAD 6-2

common joins, STU 31-9

Common Object Request Broker Architecture (CORBA), OAS Glossary-2

communicating over a network, PC_ 3-6

communicating over networks, PCO 3-13

communication protocols, SCN 6-5

communications, stack, NET 2-6

COMMUNITY parameter, NET 5-4

COMP_CHARSET precompiler option, PC_ 10-14

comparing

tables, SPR 31 - 2, RAR 8-60

comparison

of character values, PLS B-2

of collections, PLS 4-13

of expressions, PLS 2-46

operators, PLS 2-44, PLS 5-5

comparison functions

MAP, SQL 7-417, SQL 7-423

ORDER, SQL 7-417, SQL 7-423

comparison methods, ADG 16 - 22, SCN 13-6

comparison operators, SQL 3-5

blank padding data, ADG 4 - 6

comparing dates, ADG 4 - 9

comparison semantics

blank-padded, SQL 2-28

nonpadded, SQL 2-28

of character strings, SQL 2-27

compatibility, MIG 8-1, SCN 1-3

8.1.0 compatibility level

features requiring, MIG 8-9

Advanced Queuing, MIG 8-14, MIG 8-32

Advanced Replication, MIG 8-13, MIG 8-45

agent self-registration, MIG 8-13

ALTER DATABASE RESET COMPATIBILITY, MIG 8-7

ANALYZE VALIDATE STRUCTURE command, MIG 8-17

application context, MIG 8-13

applications, MIG 8-16

index-organized tables, MIG 8-16

physical ROWIDs and UROWIDs, MIG 8-16

Tuxedo applications, MIG 8-17

XA calls, MIG 8-17

backup, MIG 8-13, MIG 8-39

compatibility level, MIG 8-5

COMPATIBLE initialization parameter, MIG 8-2

conventional path export, MIG 8-48

CREATE TABLE behavior change, MIG 8-31

database resource manager, MIG 8-14

date columns in dynamic performance views, MIG D-11

DBMS_REPAIR package, MIG 8-14

direct path export, MIG 8-48

DISABLE VALIDATE constraints, MIG 8-14

Export/Import, MIG 8-48

extensible optimizer, MIG 8-14

fine-grained access control, MIG 8-13

Heterogeneous Services agents, MIG 8-45

indexes

key compression, MIG 8-10

initialization parameters, MIG B-8

LOBs, MIG 8-11, MIG 8-25

CLOBS and NCLOBs, MIG 8-25

materialized views, MIG 8-13

NCHAR and NLS, MIG 8-27

nested tables, MIG 8-29

NLS and NCHAR environment variables, MIG 8-28

n-tier authentication and authorization, MIG 8-13

OCI, MIG 8-17

link line, MIG 8-18

thread safety, MIG 8-18

optimization, MIG 8-34

optimizer plan stability, MIG 8-14

Oracle DCE Integration with Net8, NET 7-29

Oracle Media Management API, MIG 8-13

Oracle Parallel Server

instance affinity for jobs, MIG 8-12

packages

DBMS_LOB, MIG 8-33

DBMS_REPAIR, MIG 8-33

partitioning, MIG 8-11

PL/SQL, MIG 8-20

PLSQL_V2_COMPATIBILITY initialization parameter, MIG 8-20

precompilers, MIG 8-18

recovery, MIG 8-13, MIG 8-39

fast-start rollback, MIG 8-13

removing incompatibilities, MIG 12-2

replication, MIG 8-44

resetting for database, MIG 12-42

schema objects, MIG 8-10

collection locators, MIG 8-12

drop column, MIG 8-10

extensible indexing, MIG 8-10

function-based indexes, MIG 8-10

indexes, MIG 8-10

index-organized tables, MIG 8-10

nested tables, MIG 8-12

online index (re)build, MIG 8-10

single-table hash clusters, MIG 8-10

temporary tables, MIG 8-10

scripts

UTLCHAIN1.SQL, MIG 8-14, MIG 8-31

UTLEXCPT1.SQL, MIG 8-14, MIG 8-31

shared and exclusive modes, SPS 6-2, SPS 17-11

Spatial, MIG 8-15

SQL and PL/SQL, MIG 8-14

autonomous transactions, MIG 8-14

bulk binds, MIG 8-14

C call specifications, MIG 8-14

CALL statement, MIG 8-14

native dynamic SQL, MIG 8-14

NOCOPY parameter passing mode, MIG 8-14

standby database, MIG 8-41

summary management, MIG 8-13

tablespaces, MIG 8-9

locally managed tablespaces, MIG 8-9

online read-only tablespaces, MIG 8-9

transportable tablespaces, MIG 8-9

TRCROUTE utility with earlier versions of SQL*Net, NET 8-23

triggers, MIG 8-14

UROWIDs, MIG 8-11

user-defined object identifiers, MIG 8-12

VARRAYs, MIG 8-12

Visual Image Retrieval, MIG 8-15

compatibility flag, GTK 6-6

compatibility levels

transportable tablespaces, SCN 3-14

COMPATIBLE initialization parameter, MIG 8-2

8.1.0 setting

features requiring, MIG 8-9

checking the setting, MIG 8-5

database structures, MIG 8-3

setting the, MIG 8-6

COMPATIBLE parameter, SBR 16-26, SRF 1-20, STU 6-16, STU 26-66

and parallel query, STU 7-57

read-only tablespaces, SCN 3-11

standby database, SBR 16-5

COMPATIBLE_NO_RECOVERY parameter, SRF 1-21

compilation, PCO 2-28

compilation and execution of RMAN commands, SBR 4-6

compilation of object types, SCN 14-17

COMPILE clause

of ALTER DIMENSION, SQL 7-26

of ALTER FUNCTION, SQL 7-27

of ALTER JAVA SOURCE, SQL 7-44

of ALTER MATERIALIZED VIEW, SQL 7-51

of ALTER PACKAGE, SQL 7-60

of ALTER PROCEDURE, SQL 7-63

of ALTER TRIGGER, SQL 7-172

of ALTER TYPE, SQL 7-174

of ALTER VIEW, SQL 7-184

of CREATE JAVA, SQL 7-293

compiled PL/SQL, SCN 18-17

advantages of, SCN 18-8

procedures, SCN 18-9

pseudocode, SCN 18-18, SCN 20-25

recompiling, SCN 18-19

shared pool, SCN 16-16

triggers, SCN 20-25

compiled triggers, SCN 20-25

compiler directives, SQL 7-416

compiler hint, NOCOPY, PLS 7-17

compile-time errors, ADG 10 - 42

compiling, PC_ 2-18

specifying include file locations, PC_ 5-35

complete export, SBR 13-17

complete exports, SUT 1-44, SUT 1-46

restrictions, SUT 1-44

specifying, SUT 1-20

complete recovery

definition, SBR 1-19, SBR 3-28

procedures, SBR 14-20

using RMAN, SBR 9-18

complete refresh, STU 32-4

complete refreshes, REP 3-22

completion messages

Export, SUT 1-40

complex object retrieval, OCI 10-20

for Oracle Call Interface, ADG 19 - 8

implementing, OCI 10-23

navigational prefetching, OCI 10-24

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

attributes, OCI A-26

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

attributes, OCI A-25

complex snapshots, REP 3-5

value for PCTFREE, REP 3-22

value for PCTUSED, REP 3-22

complex view merging, SCN 23-17

COMPLEX_VIEW_MERGING parameter, SRF 1-21

component selector, PLS 1-6

components, LSM, LEG 1-3

composite foreign keys, SQL 7-222

composite indexes, SCN 10-22, STU 6-5

composite keys

restricting nulls in, ADG 5 - 16

composite limits, SAD 23-19

costs and, SAD 23-20

service units, SAD 23-19

composite methods

partitioning and downgrading, MIG 12-17

composite partitioning, GTK 2-46, STU 26-46

examples of, STU 13-17

performance considerations, STU 26-49

composite partitioning clause

of CREATE TABLE, SQL 7-363, SQL 7-378

composite primary keys, SQL 7-222

composite type, PLS 2-10

composite types, PCO 11-18

composite unique constraints, SQL 7-221

COMPOSITE_LIMIT parameter

of ALTER PROFILE, SQL 7-64

of CREATE PROFILE, SQL 7-340

compound conditions, SQL 5-17

compound expressions, SQL 5-4

compound symbol, PLS 2-4

COMPRESS

Export parameter, SUT 1-16, SUT 2-53

COMPRESS clause

nested tables, ADG 18 - 18

of ALTER TABLE, SQL 7-134

of CREATE INDEX, SQL 7-282

of CREATE TABLE, SQL 7-373

COMPRESS parameter

of ALTER INDEX, SQL 7-31

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

compression, index key, SCN 10-29

COMPUTE option

STATISTICS Export parameter, SUT 1-23

COMPUTE STATISTICS clause

of ANALYZE, SQL 7-188

of CREATE INDEX, SQL 7-283

COMPUTE STATISTICS option, SAD 20-7

COMPUTE STATISTICS option of CREATE and ALTER INDEX statements, GTK 2-27

CONCAT function, SQL 4-10

CONCATENATE keyword

SQL*Loader, SUT 5-36

concatenated indexes, SCN 10-22

concatenation operator, NLS 4-11, PLS 2-46, SQL 3-3

treatment of nulls, PLS 2-50

concurrency, ADG 8 - 23, PCO 3-18, PLS 5-40

defined, SCN 1-30

definition of, PC_ 3-16

described, SCN 27-2

direct-load INSERT, SCN 25-11

enforced with locks, SCN 1-32

inserts and updates, SPS 11-14, SPS 17-6

limits on

per database, SCN 29-20

per user, SCN 29-17

maximum number of instances, SPS 11-15, SPS 14-3

partition maintenance, SCN 11-50

restrictions on, SCN 1-43, SCN 25-11

ROW_LOCKING parameter, SRF 1-111

sequences, SPS 6-7

shared mode, SPS 4-2

transactions, SPS 5-4, SPS 11-2

transactions and, SCN 27-15, SRF 1-125

transactions per rollback segment, SRF 1-125

concurrent access, MIG 2-16

concurrent connections, PC_ 3-7

concurrent conventional path loads, SUT 8-25

concurrent logons, PCO 3-14

concurrent users, MIG 2-17

increasing the number of, STU 26-10

conditional control, PLS 3-2

conditional precompilation, PC_ 2-16, PCO 2-26

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

example, PC_ 2-16, PC_ 5-43, PCO 2-26

conditional predicates

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

conditions

compound, SQL 5-17

EXISTS, SQL 5-17

group comparison, SQL 5-15

in SQL syntax, SQL 5-13

LIKE, SQL 5-17

membership, SQL 5-16

NULL, SQL 5-17

range, SQL 5-16

simple comparison, SQL 5-15

confidentiality, definition, OAS Glossary-2

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

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

Configuration Assistant, PSC 5-13

configuration file

listener (LISTENER.ORA), NET B-6

local naming (TNSNAMES.ORA), NET B-5

Oracle Connection Manager (CMAN.ORA), NET B-9

Oracle Names servers (NAMES.ORA), NET B-7

profiles (SQLNET.ORA), NET B-2

protocol addresses, NET 6-76

syntax rules, NET C-2

system versus user, PCO 14-15

configuration file name, PCO A-7

configuration files, PC_ 10-5

and the Object Type Translator, PC_ 19-5

CyberSAFE, OAS B-2

Kerberos, OAS B-2

location, PC_ 10-6

naming conventions, DCI 2-7

needed for servers in DCE, OAS 13-3

SecurID, OAS B-3

system, PC_ 10-3

user, PC_ 10-3

configuration files directory

contents, UNIX, LEG 5-12

contents, Windows NT, LEG 5-20

configuration files for external procedures, DCI 4-5

Configuration folder, REP 2-38

configuration of a database

parameter file, SCN 5-4

process structure, SCN 8-2

configuration tasks

adding nodes to a cluster, PSC 8-6

configuring the listener, PSC 4-13

configuring the listener for failover, PSC 4-36

creating net service names, PSC 4-20

creating the database, PSC 3-6

database creation, PSC 4-3

establishing client load balancing, PSC 4-25

establishing connect-time failover, PSC 4-35

establishing transparent application failover, PSC 4-43

moving from single instance to parallel server, PSC 8-2 to PSC 8-5

Net8 on clients, PSC 4-34

Net8 on Console, PSC 5-11

Net8 on nodes, PSC 4-12

Net8 on Oracle Performance Manager machine, PSC 5-29

OPSCTL utility on UNIX, PSC B-1 to PSC B-12

Oracle Enterprise Manager, PSC 5-11 to PSC 5-28

Oracle Intelligent Agents on UNIX, PSC B-11 to PSC B-12

Oracle Parallel Server, PSC 4-1 to PSC 4-45

Oracle Parallel Server Management, PSC 5-1 to PSC 5-37

Oracle Performance Manager, PSC 5-29 to PSC 5-37

testing the network, PSC 4-45

with Oracle Database Configuration Assistant, PSC 4-4

configuration, LSM

administrators

modifying on NT, LEG 2-28

modifying on UNIX, LEG 2-28

server resource, LEG 2-26

specifying, LEG 2-26, LEG 2-27

configuration roadmap, LEG 2-16

LSM resources

client dialog box, Windows NT, LEG 2-22

client resource, LEG 2-19

server resource, LEG 2-23

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, SPS 14-9

client-server, SPS 1-20

guidelines for parallel server, SPS 5-9

multi-instance database system, SPS 1-16

overview of Oracle, SPS 1-14, SPS 1-15

single instance database system, SPS 1-15

configuring

a profile, NET 7-15

client for connection concentration, NET 7-33

client for multi-protocol support, NET 7-36

client for Net8 access control, NET 7-40

client load balancing, NET 7-11

client Oracle Connection Manager, NET 7-41

clients and servers to use Oracle Names, NET 6-37

clients for local naming, NET 6-20

CMAN.ORA for connection concentration, NET 7-31

CMAN.ORA for multi-protocol support, NET 7-35

CMAN.ORA for Net8 access control, NET 7-38

CONNECT_DATA attributes, NET 7-7

connection concentration, NET 7-31

connection pooling, NET 7-49

connect-time failover, NET 7-11

CORBA Servers, NET 7-51 to NET 7-64

domains, NET 7-16, NET 7-21

Enterprise JavaBeans (EJBs), NET 7-51 to NET 7-64

external naming, NET 3-7, NET 6-5

external procedures, NET 7-65

host naming, NET 6-5, NET 6-7, NET 6-51

IIOP clients, NET 7-50, NET 7-51 to NET 7-64

Inter-Orb Protocol (IIOP) clients, NET 7-50

Java option, NET 7-50

Java Stored Procedures, NET 7-51

listener names, NET 6-69

listeners, NET 6-62 to NET 6-75

listeners for local naming, NET 6-21, NET 6-40

local naming, NET 6-5, NET 6-12

multiple addresses, NET 7-3

multiple domains, NET 6-29, NET 6-34

multi-protocol support, NET 7-35

net service names for external naming, NET 6-51

net service names for local naming, NET 6-14

Net8 access control, NET 7-38

Net8 OPEN, NET 9-8

Oracle Advanced Security, NET 7-29

Oracle Names, NET 6-5, NET 6-21 to NET 6-50

Oracle Names servers, NET 6-27

overview, NET 6-2

prespawned dedicated servers, NET 6-73

protocol addresses, NET 6-64, NET 6-76

region database for Oracle Names, NET 6-26, NET 6-31

replicating data among Oracle Names servers, NET 6-32

routing connection requests in a profile, NET 7-26

server for connection concentration, NET 7-32

servers for local naming, NET 6-14

system to use custom applications, NET 9-9

the listener with Oracle Database Configuration Assistant, NET 4-23

to connect to Heterogeneous Services, NET 7-67

to connect to Oracle Rdb database, NET 7-71

with Oracle Names, NET 6-4

with the Net8 Configuration Assistant, NET 4-22, NET 4-24

without Oracle Names, NET 6-4

configuring a server, in DCE, OAS 13-3

configuring an instance

with dedicated server processes, SAD 4-2

configuring cipher suites in SSL, OAS 9-25

configuring clients

in SQL*Net/DCE, OAS 13-10

to use CDS, OAS 13-13

configuring heterogeneous services, NET 6-71

configuring Oracle

for Net8/DCE, OAS 13-1

configuring RADIUS authentication, OAS 3-9

configuring SSL, OAS 9-12

conflict resolution

additive, RAR 6-10, RAR 8-85

average, RAR 6-10

average prebuilt, RAR 6-10

avoid delete conflicts, RAR 6-24

discard, RAR 6-3

maximum, RAR 6-5

maximum value method, RAR 6-5

minimum, RAR 6-5

minimum value method, RAR 6-5

overwrite, RAR 6-3

priority groups, RAR 6-12

site priority, RAR 6-15

statistics, RAR 8-99, RAR 8-150

timestamp, RAR 6-7

conflicts

additive resolution method, REP 6-18

avoidance

dynamic ownership, REP 8-30

avoiding, REP 6-4

delete, REP 6-3

avoiding, REP 6-5

detecting, REP 6-5, REP 8-8

master sites, avoiding at, REP 6-5

detection

identifying rows during, REP 6-6

how Oracle detects, REP 6-6

maximum value conflict resolution method, REP 6-19

minimum value conflict resolution method, REP 6-19

notification

package, sample, REP 6-54

notification log

creating, REP 6-53

notification log table

sample, REP 6-53

notification methods

user-defined, REP 6-52

notification package

creating, REP 6-54

procedural replication, REP 1-15, SCN 34-16

resolution

adding method of, SPR 34 - 10

auditing, REP 7-18

automatic versus manual, REP 6-7

configuration

overview, REP 6-12

declarative methods, update conflicts, REP 6-18

delete, REP 6-8

strategy, REP 8-28

delete, configuring, REP 6-37

design and preparation guidelines, REP 6-12

detecting conflicts, REP 6-5

gathering statistics, REP 7-18

highest priority, REP 6-31

in synchronous propagation, REP 8-8

information

viewing, REP 6-56

procedural replication and, REP 8-3

RepResolution_Statistics table, deleting, REP 7-19

statistics, SPR 34 - 23, SPR 34 - 66

canceling, REP 7-18

uniqueness, REP 6-8

configuring, REP 6-34

update

and column groups, REP 6-7

user-defined routines

parameters, REP 6-48

user-defined routines, example, REP 6-51

user-defined routines, restrictions, REP 6-51

viewing information, REP 6-56

resolution and notification methods

custom, REP 6-10

resolution methods, REP 6-8

average prebuilt, REP 6-18

delete, assigning, REP 6-37

delete, removing, REP 6-37

discard, REP 6-21

managing, REP 6-16

multiple

using, REP 6-10

overwrite, REP 6-21

prebuilt, restrictions for, REP 6-9

uniqueness, assigning, REP 6-34

uniqueness, removing, REP 6-35

update

prebuilt, REP 6-8

user-defined, REP 6-48

using, for notification, REP 6-11

resolution methods for

removing, REP 6-17

resolution methods for column groups

ordering, REP 6-17

uniqueness, REP 6-3

avoiding, REP 6-5

update, REP 6-3

avoiding, REP 6-5

update resolution

using site priority for, REP 6-29

CONNECT

RMAN ALLOCATE CHANNEL command, SPS 21-8

CONNECT BY, STU 13-26

CONNECT BY clause

of SELECT, SQL 5-20, SQL 7-548

optimizing view queries, SCN 23-16

CONNECT clause

of SELECT and subqueries, SQL 7-543

CONNECT command, SPS 14-7, SPS 18-19, SPS 18-21

forcing a checkpoint, SPS 21-9

Net8, SPS 18-17

SYSDBA option, SPS 18-13, SPS 18-26

connect command (RMAN), SBR 11-44, SBR 11-46

connect descriptor, defined, PSC 4-20

connect descriptors, NET 2-2, NET 6-12, NET C-31

connect functions, OCI 15-87

CONNECT INTERNAL, SCN 5-3

CONNECT INTERNAL desupported, GTK 6-6

connect operations, NET 2-2

CONNECT role, SAD 24-5, SCN 30-22, SQL 7-503

user-defined types, SCN 14-13, SCN 14-14

CONNECT shortcut

of AUDIT sql_statements, SQL 7-198

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

examples, PC_ F-28, PCO F-19

logging on to Oracle, PCO 3-3

placement, PCO 3-3

requirements, PCO 3-3

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

connect string, SPS 18-17, SPS 18-20, SPS 18-21

Net8, SUT 1-52

connect strings, NET 6-2, NET 8-2

connect time failover, SPS 18-32

CONNECT TO clause

of CREATE DATABASE LINK, SQL 7-256

connect to database, to verify roles, OAS 13-8

CONNECT_DATA parameter, NET 6-12, NET 7-7, NET C-43

CONNECT_TIME parameter

of ALTER PROFILE, SQL 7-64

of ALTER RESOURCE COST, SQL 7-69

of CREATE PROFILE, SQL 7-339

CONNECT_TIMEOUT parameter, NET 11-13, NET C-62

connected user database link, DDS 2-11

connectibility, SCN 1-2

connecting

administrator privileges, SAD 3-10

bequeath, NET 8-8

common problems, NET 8-11

connect strings, NET 6-2, NET 8-2

entering a connect string, NET 8-8

host naming, NET 8-8

local naming, NET 8-8

methods of connecting, NET 8-8

Oracle Names, NET 8-8

Oracle7 connections to Oracle8 databases, NET 5-6

Oracle8i Client r. 8.0/SQL*Net Client to Oracle8i database r. 8.1, NET 5-6

Oracle8i Client r. 8.1 to Oracle8i database r. 8.1, NET 5-5

Oracle8i Client r. 8.1 to Oracle8i r. 8.0 or Oracle7 database, NET 5-8

proper startup of components, NET 8-2

release 8.0/7.x service, NET 5-14

release 8.1 service, NET 5-12

routing, NET 1-6

with dedicated server, NET 7-26

with Oracle Connection Manager, NET 7-26

connecting across cells, OAS 13-5

connecting to another cell, OAS 13-6

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

automatic connections, PC_ 3-4

automatically, PCO 3-10

concurrently, PC_ 3-7, PCO 3-14

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

using Net8, PC_ 3-7

via Net8, PCO 3-14

connecting to Oracle database

in DCE, OAS 19

connecting to Oracle server in DCE, OAS 21

with username/password, OAS 21

without username and password, OAS 21

connecting to the database, PSC 4-45

connecting to the repository, PSC 5-31, PSC 5-36

connecting with username/password

with authentication configured, OAS 10-2

connection concentration, NET 2-48, NET 4-30, NET 7-31

advantages relative to connection pooling, NET 3-12

using to improve network performance, NET 3-11

connection load balancing, NET 2-30, NET 4-2

multi-threaded server, STU 23-5

Connection Manager, OAS 1-11

connection manager, STU 22-4

in the multi-threaded server, STU 23-3

Connection Manager, Oracle, GTK 3-6

connection mode

non-blocking, OCI 2-36

connection multiplexing, GTK 3-6

with the multi-threaded server, STU 23-3

connection options

Recovery Manager, SBR 5-8

connection pooling, GTK 3-6, STU 21-9

advantages relative to connection concentration, NET 3-12

using to improve network performance, NET 2-50, NET 3-11

using with multi-threaded servers, NET 7-49

with the multi-threaded server, STU 23-3

connections, NET 7-52

adjusting listener queue size to avoid errors, NET 3-14, NET 6-70, NET 8-13

auditing, SAD 25-8

changing hold time, DDS 3-32

clients and services, SPS 18-28

concurrent, PC_ 3-12, PCO 3-9

concurrent, increasing number of, NET 6-70

connect descriptors, NET 2-2

connect strings, NET 1-3

dedicated server, described, NET 2-23

dedicated servers, SAD 4-2

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

defined, SCN 8-4

during shutdown, SAD 3-9

embedded SQL, SCN 16-6

Explicit connections, PC_ 3-8

implicit, PC_ 3-14, PCO 3-15

listener, NET 2-28

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

load balancing among nodes, SPS 18-32

load balancing in Net8, MIG 8-47

local and remote, MIG 2-16

with multithreaded shared server, MIG 2-16

multi-threaded server, described, NET 2-20

naming, PCO 3-5

naming of, PC_ 3-8

remote

terminating, DDS 4-2

requests, extending size of backlog, NET 8-13

restricting, SCN 5-6

sessions contrasted with, SCN 8-4

sessions-based IIOP, NET 7-52

to services, NET 1-3

usernames, SCN 29-2

verifying, NET 8-25

with administrator privileges, SCN 5-3

audit records, SCN 31-5

with net service names, NET 1-3

with Oracle Connection Manager, NET 1-6

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

connection-to-dispatcher

recommended ratio, STU 23-3

connect-time failover, NET C-40

connect-time failover, NET 2-29, PSC 4-35

Try each address, in order, until one succeeds option, PSC 4-41

Try each address, randomly, until one succeeds option, PSC 4-41

with transparent application failover, PSC 4-43

connect-time failover, configuring, NET 7-11

consistency

multiversion read, SPS 4-6, SRF 1-46

of object cache, OCI 13-4

read-only transactions, ADG 8 - 8

rollback information, SPS 6-8, SRF 1-46

consistency of data, SCN 1-55

multiversion consistency model, SCN 1-31

See also read consistency

consistency, read, STU 18-7

CONSISTENT

Export parameter, SUT 1-17

nested table and, SUT 1-17

partitioned table and, SUT 1-17

consistent backups

definition, SBR 1-16

consistent changes statistic, SRF C-8

consistent gets statistic, SRF C-8, STU 19-26, STU 21-4, STU 21-22

consistent mode, TKPROF, STU 14-13

Consistent Read Server, PSC 1-10

consistent whole database backups, SBR 3-2, SBR 13-3

Console

defined, PSC 2-3, PSC 5-2

Event Management window, PSC 5-2

Group window, PSC 5-2

Job window, PSC 5-2

Navigator window, PSC 5-2

Navigator window with Oracle Parallel Server objects, PSC 6-14

right-mouse menu, PSC 6-17

Connect, PSC 6-17

Disconnect, PSC 6-17

Edit, PSC 6-17, PSC 6-27

Related Tools, PSC 6-17

Remove, PSC 6-17

Results, PSC 6-17, PSC 6-24

Shutdown, PSC 6-17, PSC 6-21

Startup, PSC 6-17, PSC 6-18

scheduling jobs, PSC 6-31

setup, PSC 5-8

starting, PSC 5-15, PSC 6-14

starting Oracle Parallel Server database, PSC 6-18

stopping Oracle Parallel Server database, PSC 6-21

viewing Oracle Parallel Server status, PSC 6-27

viewing shutdown results, PSC 6-24

viewing startup results, PSC 6-24

consolidating extents

Export parameter COMPRESS, SUT 1-16

const

declaring constants, PC_ 5-45

CONSTANT keyword

SQL*Loader, SUT 5-46, SUT 5-55

constant values. See literals.

constants

comparisons and, SCN 23-5

declaring, PLS 2-30

evaluation of expressions, SCN 23-5

in stored procedures, SCN 16-17

syntax, PLS 11-30

when computed, SCN 23-5

constraining tables, ADG 13 - 22

DISABLE, SQL 7-382

CONSTRAINT clause

of constraint_clause, SQL 7-221

constraint clause, SQL 7-217

constraint processing, GTK 3-14

constraint violations, REP 7-31

CONSTRAINT(S) parameter

of ALTER SESSION, SQL 7-81

CONSTRAINTS

Export parameter, SUT 1-18, SUT 2-21

constraints, ADG 16 - 27, SCN 1-58, STU 6-10, STU 30-10, STU 31-22

adding, SQL 7-131

alternatives to, SCN 28-5

application development issues, DDS 4-3

applications can find violations, SCN 28-6

automatic

SQL*Loader, SUT 8-23

CHECK, SCN 28-17

check, SQL 7-224

Import, SUT 2-48

checking at end of transaction, SQL 7-226

checking at start of transaction, SQL 7-226

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

column REF, SQL 7-224

composite unique, SQL 7-221

composite UNIQUE keys, ADG 5 - 6

constraint modification with ALTER TABLE, GTK 2-28

default values and, SCN 28-20

deferrable, SQL 7-226, SQL 7-568

enforcing, SQL 7-81

defined, SCN 10-4

defining, SQL 7-220, SQL 7-365

on a column, SQL 7-369

on a table, SQL 7-369

direct path load, SUT 8-21

DISABLE VALIDATE constraint state, GTK 2-28

disabling, SQL 7-154, SQL 7-227, SQL 7-381

cascading, SQL 7-383

disabling during a direct load, SUT 8-21

disabling referential constraints, SUT 2-14

disabling temporarily, SCN 28-7

dropping, SQL 7-137, SQL 7-478

effect on performance, SCN 28-6

ENABLE or DISABLE, SCN 28-22

enabling, SQL 7-154, SQL 7-227, SQL 7-381, SQL 7-382

enabling after a direct load, SUT 8-21

enforced on a direct load, SUT 8-21

enforced with indexes, SCN 10-23

PRIMARY KEY, SCN 28-12

UNIQUE, SCN 28-10

failed

Import, SUT 2-48

FOREIGN KEY, SCN 1-59, SCN 28-13

foreign key, SQL 7-223

load method, SUT 8-9

mechanisms of enforcement, SCN 28-18

modifying, SCN 28-23

modifying existing, SQL 7-134

NOT NULL, PLS 2-31, SCN 28-7, SCN 28-11

not null, SQL 7-222

Import, SUT 2-48

object tables, SCN 14-5

on columns, SQL 7-221

on Oracle objects, ADG 18 - 39

ORA-02055

constrain violation, DDS 4-3

overview, SCN 1-58

parallel create table, SCN 26-25

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

PRIMARY KEY, SCN 1-59, SCN 28-11

primary key, SQL 7-222

attributes of index, SQL 7-227

enabling, SQL 7-382

prohibited in views, SCN 10-12

recording violations, SQL 7-383

referential

effect of updates, SCN 28-16

self-referencing, SCN 28-15

referential integrity, SQL 7-222, SQL 7-223

Import, SUT 2-48

REFs, ADG 18 - 10

restore, SBR 4-48

restriction on stored functions, ADG 10 - 57

restrictions, SQL 7-221

scope, SQL 7-225

SCOPE FOR constraint, ADG 16 - 30, ADG 16 - 34

setting state for a transaction, SQL 7-568

storing rows in violation, SQL 7-228

table REF, SQL 7-224

triggers cannot violate, SCN 20-21

triggers contrasted with, SCN 20-5

types listed, SCN 1-58, SCN 28-1

unique, SQL 7-221

attributes of index, SQL 7-227

composite, SQL 7-221

enabling, SQL 7-382

UNIQUE key, SCN 1-59, SCN 28-8

partially null, SCN 28-11

uniqueness

Import, SUT 2-48

VALIDATE or NOVALIDATE, SCN 28-22

validating, SQL 7-227

what happens when violated, SCN 28-5

when evaluated, SCN 10-8

where not allowed, PLS 2-25, PLS 7-4

constructor

collection, PLS 4-8

object, PLS 9-12

constructor method, DCI 3-4

constructor methods, SCN 1-57, SCN 13-6, SCN 14-18

and object types, SQL 7-413

literal invocation of, SCN 14-4

contention

block, SPS 6-9, SPS 11-15, SPS 15-6, SPS 17-11, SPS 17-13

block-level, SRF 3-130

disk, SPS 6-2, SPS 6-9

disk access, STU 20-20

distributed lock, SPS 15-6

for data

deadlocks, SCN 8-19, SCN 27-17

lock escalation does not occur, SCN 27-17

for rollback segments, SCN 4-21

free list, SPS 19-5

free lists, STU 21-21

free space, SPS 4-8, SPS 11-2, SPS 11-14

index, SPS 19-6

memory, STU 19-1

memory access, STU 21-1

on single block or row, SPS 2-9

redo allocation latch, STU 21-19

redo copy latches, STU 21-19

rollback segment, SPS 6-8, SPS 6-9

rollback segments, STU 21-3

segment header, SPS 11-14, SPS 19-6

sequence number, SPS 4-7, SPS 6-6

SYSTEM tablespace, SPS 14-5

table data, SPS 6-2, SPS 6-8, SPS 17-13

tuning, STU 21-1

tuning resource, STU 2-11

context

default (same as global), PCO 4-36

global, PCO 4-36

WITH CONTEXT clause, DCI 4-9

CONTEXT ALLOCATE SQL statement, PC_ F-28

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

context area, STU 2-10

context block

definition of, PC_ 20-4

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

context namespaces

removing from the database, SQL 7-448

CONTEXT OBJECT OPTION GET SQL statement, PC_ 17-18

CONTEXT OBJECT OPTION SET SQL statement, PC_ 17-17

context switch, PLS 4-30

context switching, STU 18-4

CONTEXT USE directive, PC_ 11-9

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

CONTEXT USE SQL statement, PC_ 11-9

context, transaction, PLS 5-55

contexts

creating namespaces for, SQL 7-243

granting

system privileges on, SQL 7-495

namespace

associating with package, SQL 7-243

contexts, user-specified, PCO A-3

continuation lines

syntax, PCO 2-13

CONTINUE action

in the WHENEVER statement, PC_ 9-25

of WHENEVER directive, PC_ F-120, PCO 8-29, PCO F-92

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 2-14, REP 2-17

CONTROL

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

control file, SPS 6-1

accessibility, SPS 5-9

backing up, SPS 21-1, SQL 7-19

conversion to multi-instance, SPS 23-6

creating, SPS 14-10

data files, SPS 17-12

log history, SPS 14-4, SPS 21-6

MAXLOGHISTORY, SPS 6-5

parameter values, SPS 18-9

shared, SPS 5-4, SPS 18-7

control file backups

definition, SBR 3-8

using RMAN, SBR 8-6, SBR 8-7

control file character set, GTK 2-52

control files, PSC 1-10, SBR 2-3 to SBR 2-7, SCN 1-13, SCN 32-21

adding, SAD 5-5

allow reuse of, SQL 7-246

allowing reuse of, SQL 7-251

backing up, SBR 13-3, SBR 13-11, SCN 32-25

backup and recovery, SBR 9-20

changes recorded, SCN 32-22

changing size, SAD 5-4

checkpoints and, SCN 32-22

conflicts with data dictionary, SAD 5-8

contents, SBR 1-7, SBR 2-3, SCN 32-21

CONTROL_FILES initialization parameter

for primary and standby databases, SBR 16-25

creating

about, SAD 5-3

additional control files, SAD 5-5

initially, SAD 5-4

new files, SAD 5-5

data definition language syntax, SUT 5-3

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

definition, SBR 1-7

dropping, SAD 5-9

effect on standby databases, SBR 16-25

errors during creation, SAD 5-9

field delimiters, SUT 5-16

finding filenames, SBR 13-3

guidelines for, SAD 5-2

guidelines for creating, SUT 3-3

how specified, SCN 5-4

importance of mirrored, SAD 5-2

incomplete recovery, SBR 14-27

location of, SAD 5-3

log sequence numbers, SAD 6-5

loss of, SBR 15-11, SBR 15-13

maintaining backups, SBR 2-7, SBR 2-9

managing, SAD 5-1

mirrored, SBR 2-9

loss of, SBR 15-12

mirroring, SAD 2-10

moving, SAD 5-5

multiplexed, SBR 2-7, SBR 2-8, SBR 2-9, SCN 1-49, SCN 32-22

names, SAD 5-2, SRF 1-22

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

overview, SBR 1-7, SCN 1-13, SCN 32-21

overwriting existing, SAD 2-10

physical database structure, SCN 1-5

purpose, SBR 1-7

recovery and, SCN 1-49

re-creating, SQL 7-245

refreshing standby database, SBR 16-29

relocating, SAD 5-5

renaming, SAD 5-5

renaming or removing for migration, MIG 3-22

requirement of one, SAD 5-3

restoring using RMAN, SBR 9-11, SBR 9-12

setting the CONTROL_FILES initialization parameter, SBR 2-9

size of, SAD 5-3

snapshot

specifying location of, SBR 5-3

specifying, SRF 1-22

specifying data, SUT 5-21

specifying names before database creation, SAD 2-10

specifying SQL*Loader discard file, SUT 5-27

time-based recovery, SBR 14-29

unavailable during startup, SAD 3-3

updating, SBR 2-5

used in mounting database, SCN 5-6

using instead of a recovery catalog, SBR 4-15

control files raw devices, PSC 2-7

control structure, PLS 3-2

conditional, PLS 3-2

iterative, PLS 3-6

sequential, PLS 3-15

control utilities

described, NET 8-15, NET A-1

Listener Control Utility (LSNRCTL), NET A-3

Oracle Connection Manager Control Utility (CMCTL), NET A-89

Oracle Names Control Utility (NAMESCTL), NET A-31

CONTROL_FILE_RECORD_KEEP_TIME parameter, SRF 1-21

of ALTER SYSTEM, SQL 7-101

CONTROL_FILES initialization parameter, SBR 2-9, SBR 9-11, SBR 15-13, SBR 16-25

CONTROL_FILES parameter, PSC 6-11, SPS 18-11, SPS 22-12, SRF 1-22

overwriting existing control files, SAD 2-10

same for all instances, SPS 18-7, SPS 18-11

setting

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

names for, SAD 5-2

controlfile clauses

of ALTER DATABASE, SQL 7-9

controlfile parallel write wait event, SRF A-23

CONTROLFILE REUSE clause

OF CREATE DATABASE, SQL 7-251

controlfile sequential read wait event, SRF A-24

controlfile single write wait event, SRF A-24

controlfile transaction enqueue, SRF B-2

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

CONVBUFSZ clause in VAR statement, PCO 4-49

conventional path Export

compared to direct path Export, SUT 1-41

conventional path loads

basics, SUT 8-2

compared to direct path loads, SUT 8-7

SQL*Loader bind array, SUT 5-76

using, SUT 8-3

conventions

naming, DCI 2-8, PLS 2-35

conversion

application, SPS 23-3

database, SPS 23-4

database, to multi-instance, SPS 23-1

functions

table of, SQL 2-32

ramifications, SPS 23-3

rules, string to date, SQL 2-48

conversion file read wait event, SRF A-25

conversion function

when needed, PLS 2-28

conversion functions, ADG 4 - 25

SQL functions

conversion, SQL 4-4

TO_CHAR function, ADG 4 - 11, ADG 4 - 12, ADG 4 - 28

TO_DATE function, ADG 4 - 11

TO_LABEL function, ADG 4 - 28

Trusted Oracle Server, ADG 4 - 28

conversion, datatype, PLS 2-27

conversions

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

CONVERT clause

of ALTER DATABASE, SQL 7-11

CONVERT function, NLS 4-4, NLS 4-5, SQL 4-11

convert queue, SPS 8-3

converting character sets, NLS 4-4

converting data, ADG 4 - 25

ANSI datatypes, ADG 4 - 24, SCN 12-22

assignments, ADG 4 - 25

expression evaluation, ADG 4 - 27

program interface, SCN 8-25

SQL/DS and DB2 datatypes, ADG 4 - 24, SCN 12-22

Trusted Oracle Server, ADG 4 - 28

coordinated time-based recovery

distributed databases, SBR 15-16

copy command (RMAN), SBR 11-48

copy semantics for internal LOBs, ADL 3-28

copying

objects, OCI 10-32

copying data

large cluster tables, MIG 2-15

migration method, MIG 2-14

space requirements, MIG 2-15

copying LOBs, ADL 2-12

COR, see complex object retrieval

CORBA, GTK 2-19

CORBA (Common Object Request Broker Architecture), OAS Glossary-2

CORBA Servers

configuring, NET 7-51 to NET 7-64

described, NET 7-50

CORE_DUMP_DEST parameter, SRF 1-23

correlated subqueries, SQL 5-24

correlated subquery, PLS 5-11

correlation identifier, ADQ 1-8

correlation names, ADG 13 - 13, ADG 13 - 15, ADG 13 - 16, ADG 13 - 17

for base tables of indexes, SQL 7-279

in DELETE, SQL 7-441

in SELECT, SQL 7-547

inline views, SCN 10-16

NEW, ADG 13 - 16

OLD, ADG 13 - 16

REFERENCING option and, ADG 13 - 17

when preceded by a colon, ADG 13 - 16

corrupt datafile blocks

records in control file, SBR 4-36

RMAN and, SBR 4-36

setting maximum for backup, SBR 8-26

corruption detection, SBR 4-54, SBR 4-55

corruption of package, DCI 5-10

COS function, SQL 4-12

COSH function, SQL 4-12

cost based optimization, DDS 1-10, DDS 4-5, SCN 33-10

hints, DDS 4-7

cost-based optimization, SCN 22-7, STU 7-3, STU 11-8, STU 27-27

extensible optimization, SCN 22-16

histograms, SCN 22-8

parallel execution, STU 27-27

procedures for Plan Stability, STU 7-32

query rewrite, SCN 10-17

selectivity of predicates, SCN 22-8

histograms, SCN 22-8, SCN 22-10

user-defined, SCN 22-17

star queries, SCN 24-14

statistics, SCN 22-8, SCN 23-32

user-defined, SCN 22-17

upgrading to, STU 7-34

user-defined costs, SCN 22-17

cost-based optimizer, SRF 1-88

cost-based rewrite, STU 31-2

costs

resource limits and, SAD 23-20

COUNT aggregate function, PLS 5-3

COUNT attribute of collection types, ADG 16 - 24

COUNT collection method, PLS 4-22

count column, SQL trace, STU 14-13

COUNT function, SQL 4-12

CPP_SUFFIX

precompiler option, PC_ 12-5

CPP_SUFFIX precompiler option, PC_ 10-15

CPP_SUFFIX precompiler options, PC_ 10-15

CPU

checking utilization, STU 18-3

detecting problems, STU 18-3

system architecture, STU 18-10

tuning, STU 18-1

utilization, STU 18-1, STU 26-3

cpu column, SQL trace, STU 14-13

CPU Statistics data view, STU 15-11

CPU Statistics for Parse/Execute/Fetch drilldown data view, STU 15-18

CPU time limit, SCN 29-17

CPU usage, SPS 19-3

CPU used by this session statistic, SRF C-2

CPU used when call started, SRF C-2

CPU_COUNT initialization parameter, STU 25-16

CPU_COUNT parameter, PSC 6-11, SPS 18-11, SRF 1-23

CPU_PER_CALL parameter

of ALTER PROFILE, SQL 7-64

of CREATE PROFILE, SQL 7-339

CPU_PER_SESSION parameter

of ALTER PROFILE, SQL 7-64

of ALTER RESOURCE COST, SQL 7-69

of CREATE PROFILE, SQL 7-339

CR blocks created statistic, SRF C-2

CR Server, PSC 1-10

change summary for 8.1, SPS A-1

crash recovery, SCN 32-4, SCN 32-13

definition, SBR 1-19

instance failure, SCN 1-46, SCN 5-10, SCN 32-4

opening a database, SCN 5-8

read-only tablespaces, SCN 32-6

required after aborting instance, SCN 5-10

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

Create, REP 2-8

create

deployment template, RAR 4-4

refresh group, RAR 5-4

snapshot group, RAR 5-3

snapshot group object, RAR 5-5

snapshot log, RAR 5-3

template parameter, RAR 4-7

user parameter value, RAR 4-9

CREATE ANY CLUSTER system privilege, SQL 7-495

CREATE ANY CONTEXT system privilege, SQL 7-495

CREATE ANY DIMENSION system privilege, SQL 7-496

CREATE ANY DIRECTORY system privilege, SQL 7-496

CREATE ANY INDEX system privilege, SQL 7-496

CREATE ANY INDEXTYPE system privilege, SQL 7-496

CREATE ANY LIBRARY system privilege, SQL 7-497

CREATE ANY MATERIALIZED VIEW system privilege, SQL 7-497

CREATE ANY OPERATOR system privilege, SQL 7-497

CREATE ANY OUTLINE system privilege, SQL 7-498

CREATE ANY PROCEDURE system privilege, SQL 7-498

CREATE ANY SEQUENCE system privilege, SQL 7-499

CREATE ANY SNAPSHOT system privilege, SQL 7-499

CREATE ANY SYNONYM system privilege, SQL 7-499

CREATE ANY TABLE system privilege, SQL 7-500

CREATE ANY TRIGGER system privilege, SQL 7-501

CREATE ANY TYPE privilege, SCN 14-13

See also privileges

CREATE ANY TYPE system privilege, SQL 7-501

CREATE ANY VIEW system privilege, SQL 7-502

create catalog command (RMAN), SBR 11-52

CREATE CLUSTER

statement, SQL 7-236

system privilege, SQL 7-495

CREATE CLUSTER command, ADG 3 - 6, ADG 6 - 15

example, SAD 17-7

for hash clusters, SAD 18-4

hash clusters, ADG 6 - 20

HASH IS option, ADG 6 - 21, SAD 18-6

HASHKEYS clause, SCN 10-53, SCN 10-57

HASHKEYS option, ADG 6 - 21, SAD 18-7

SINGLE TABLE HASHKEYS, SCN 10-57

SIZE option, SAD 18-6

storage parameters, SCN 4-17

CREATE CLUSTER statement, SPS 17-7, SPS A-20, STU 6-26

FREELIST GROUPS option, SPS 17-6

FREELISTS option, SPS 17-6

CREATE command, SCN 16-4

CREATE CONTEXT statement, GTK 2-70, SQL 7-243

CREATE CONTROLFILE command

about, SAD 5-5

and recovery, SBR 9-16

checking for inconsistencies, SAD 5-8

NORESETLOGS option, SAD 5-7

RESETLOGS option, SAD 5-7

standby database, effect on, SBR 16-25

CREATE CONTROLFILE statement, SQL 7-245

changing database options, SPS 14-10

conversion to multi-instance, SPS 23-5

exclusive mode, SPS B-2

MAXLOGHISTORY, SPS 21-6

CREATE DATABASE command

CONTROLFILE REUSE option, SAD 5-4

database name, SRF 1-33

example, SAD 2-7

MAXLOGFILES option, SAD 6-10

MAXLOGMEMBERS option, SAD 6-10

setting the block size, SRF 1-28

setting the log mode, SRF 1-66

CREATE DATABASE LINK

statement, SQL 7-255

system privilege, SQL 7-495

CREATE DATABASE statement, SPS 14-3, SQL 7-249

exclusive mode, SPS B-2

MAXINSTANCES, SPS 11-15, SPS 14-3

MAXLOGFILES, SPS 14-4

MAXLOGHISTORY, SPS 6-5, SPS 14-4, SPS 21-6

MAXLOGMEMBERS, SPS 14-4

options, SPS 14-3

setting the log mode, SPS 14-2, SPS 14-9

thread number 1, SPS 14-8

CREATE DATAFILE clause

of ALTER DATABASE, SQL 7-8, SQL 7-16

CREATE DATAFILE option

ALTER DATABASE command, SBR 14-7

CREATE DIMENSION

statement, SQL 7-259

system privilege, SQL 7-496

CREATE DIMENSION statement, STU 30-3

CREATE DIRECTORY statement, SQL 7-264

CREATE FUNCTION command, SCN 18-17

CREATE FUNCTION statement, SQL 7-266

CREATE INDEX

statement, SQL 7-273

system privilege, SQL 7-496

CREATE INDEX command, ADG 3 - 6, ADG 6 - 5

explicitly, SAD 16-8

no-logging mode, SCN 11-58, SCN 25-7

object types, SCN 14-6

ON CLUSTER option, ADG 6 - 16, SAD 17-8

partition attributes, SCN 11-37

rules of parallelism, SCN 26-25

storage parameters, SCN 4-17

temporary segments and, SCN 4-18

UNRECOVERABLE, SAD 16-5

with a constraint, SAD 16-8

CREATE INDEX statement, STU 27-21

examples, STU 20-37

FREELISTS option, SPS 17-8

NOSORT option, STU 20-37

CREATE INDEXTYPE

statement, SQL 7-290

system privilege, SQL 7-496

CREATE JAVA statement, SQL 7-292

Create Job property sheet, PSC 6-32 to PSC 6-39

General tab, PSC 6-33

Parameters tab, PSC 6-37

Tasks tab, PSC 6-35

CREATE LIBRARY

statement, SQL 7-297

system privilege, SQL 7-497

CREATE LIBRARY command

differences between Server Manager and SQL*Plus, MIG 10-13

create master group, RAR 3-5

Create Master Sites dialog

setup wizard, REP 2-32

CREATE MATERIALIZED VIEW / SNAPSHOT

statement, SQL 7-299

CREATE MATERIALIZED VIEW LOG / SNAPSHOT LOG statement, SQL 7-313

CREATE MATERIALIZED VIEW statement, GTK 2-22, STU 29-4

enabling query rewrite, STU 31-4

CREATE MATERIALIZED VIEW/SNAPSHOT

system privilege, SQL 7-497

Create New Master Group property sheet

Destinations page, REP 2-19

General page, REP 2-19

Objects page, REP 2-19

Replication Manager, REP 2-19

Create New Scheduled Link property sheet, REP 2-12

General page, REP 2-12

Options page, REP 2-12

CREATE OPERATOR

statement, SQL 7-319

system privilege, SQL 7-497

CREATE OUTLINE statement, GTK 2-37, SCN 22-6, SQL 7-322, STU 7-28

CREATE PACKAGE BODY command, ADG 10 - 14, SPR 1 - 2, SCN 18-12, SCN 18-17

CREATE PACKAGE BODY statement, SQL 7-327

CREATE PACKAGE command, ADG 10 - 14, SPR 1 - 2

examples, SCN 18-12, SCN 20-10

locks, SCN 27-29

package name, SCN 18-17

CREATE PACKAGE statement, SQL 7-324

CREATE PROCEDURE

statement, SQL 7-332

system privilege, SQL 7-498

CREATE PROCEDURE command

example, SCN 18-6

locks, SCN 27-29

procedure name, SCN 18-17

CREATE PROCEDURE statement, PCO 6-21

embedded, PC_ 7-21

CREATE PROFILE

statement, SQL 7-337

system privilege, SQL 7-498

CREATE PROFILE command

about, SAD 23-18

COMPOSITE_LIMIT option, SAD 23-19

create proxy snapshot administrator, RAR 2-6

CREATE PUBLIC DATABASE LINK system privilege, SQL 7-495

CREATE PUBLIC SYNONYM system privilege, SQL 7-499

Create Refresh Group property sheet

General page, REP 5-29

Scheduling page, REP 5-29

Snapshots page, REP 5-29

create refresher, RAR 2-16

create replication administrator, RAR 2-4

create replication object, RAR 3-5

CREATE ROLE

statement, SQL 7-343

system privilege, SQL 7-498

CREATE ROLE command, ADG 12 - 11

IDENTIFIED BY option, SAD 24-7

IDENTIFIED EXTERNALLY option, SAD 24-7

CREATE ROLLBACK SEGMENT

statement, SQL 7-345

system privilege, SQL 7-498

CREATE ROLLBACK SEGMENT command

about, SAD 21-8

tuning guidelines, SAD 2-15

CREATE ROLLBACK SEGMENT statement, SPS 14-5, SPS 14-6

Create Scheduled Link property sheet

setup wizard, REP 2-14, REP 2-17

CREATE SCHEMA command, ADG 3 - 45

multiple tables and views, SAD 20-2

privileges required, ADG 3 - 46, SAD 20-2

Create Schema dialog

setup wizard, REP 2-9

CREATE SCHEMA statement, SQL 7-347

create script command (RMAN), SBR 11-54

CREATE SEQUENCE

statement, SQL 7-349

system privilege, SQL 7-499

CREATE SEQUENCE command, SAD 15-10

CACHE option, ADG 3 - 36, ADG 3 - 41

examples, ADG 3 - 41

NOCACHE option, ADG 3 - 41

CREATE SEQUENCE statement, SPS 6-7

CACHE option, SPS 6-6, SPS 6-7

CYCLE option, SPS 6-6

description, SPS 6-6

ORDER option, SPS 6-6, SPS 6-7

CREATE SESSION privilege, SUT 2-11

Export, SUT 1-4

CREATE SESSION system privilege, SQL 7-499

create snapshot administrator, RAR 2-16

CREATE SNAPSHOT statement, STU 29-2

CREATE SNAPSHOT system privilege, SQL 7-499

CREATE STANDBY CONTROLFILE clause

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

CREATE statement

triggers on, SQL 7-405

CREATE SYNONYM

statement, SQL 7-355

system privilege, SQL 7-499

CREATE SYNONYM command, SAD 15-12

locks, SCN 27-29

CREATE TABLE

behavior change

Oracle7 to Oracle8i, MIG 8-31

CREATE TABLE AS SELECT, STU 11-3, STU 27-18, STU 27-19, STU 27-31

rules of parallelism

index-organized tables, SCN 26-31

CREATE TABLE command, ADG 3 - 3, ADG 3 - 4, ADG 3 - 6

about, SAD 14-9

AS SELECT

decision support systems, SCN 26-31

direct-load INSERT vs., SCN 25-2

no-logging mode, SCN 11-58, SCN 25-7

rules of parallelism, SCN 26-25

space fragmentation, SCN 26-33

temporary storage space, SCN 26-33

AS SELECT option, SBR 14-4

auditing, SCN 31-7, SCN 31-10

CACHE clause, SCN 7-4

CLUSTER option, ADG 6 - 16, SAD 17-7

defining integrity constraints, ADG 5 - 18

enable or disable constraints, SCN 28-22

examples

column objects, SCN 13-5, SCN 14-8

nested tables, SCN 13-12

object tables, SCN 13-8, SCN 13-12, SCN 14-5, SCN 14-8

INITRANS parameter in, ADG 8 - 26

locks, SCN 27-29

parallelism, SCN 26-31

index-organized tables, SCN 26-31

partition attributes, SCN 11-27

PARTITION clause, SAD 13-9

storage parameters, SCN 4-17

triggers and, SCN 20-6

UNRECOVERABLE, SAD 14-4

CREATE TABLE statement, SQL 7-358

clustered tables, SPS 17-7

examples, SPS 17-14

FREELIST GROUPS option, SPS 11-11, SRF 1-52

FREELISTS option, SPS 11-11, SPS 17-6

initial storage, SPS 17-13, SPS 17-14

STORAGE clause, STU 20-24

TABLESPACE clause, STU 20-24

CREATE TABLESPACE

statement, SQL 7-393

system privilege, SQL 7-500

CREATE TABLESPACE command, SBR 15-3

datafile names in, SAD 9-4

example, SAD 9-4

TEMPORARY clause, SCN 3-13

CREATE TABLESPACE statement, SPS A-18, STU 20-24

CREATE TEMPORARY TABLE command, SCN 10-10

CREATE TEMPORARY TABLESPACE command, SCN 3-13

CREATE TEMPORARY TABLESPACE statement, SQL 7-398

CREATE TRIGGER

statement, SQL 7-401

system privilege, SQL 7-500

CREATE TRIGGER command, ADG 13 - 3

compiled and stored, SCN 20-25

examples, SCN 20-11, SCN 20-14, SCN 20-24

object tables, SCN 14-7

locks, SCN 27-29

REFERENCING option, ADG 13 - 17

CREATE TYPE

statement, SQL 7-411

system privilege, SQL 7-501

CREATE TYPE BODY statement, DCI 5-2, SQL 7-421

CREATE TYPE command

differences between Server Manager and SQL*Plus, MIG 10-13

incomplete types, SCN 14-16

nested tables, SCN 13-4, SCN 13-12, SCN 14-4

object types, SCN 13-4, SCN 14-3, SCN 14-4, SCN 14-8

object views, SCN 15-3

VARRAYs, SCN 13-11

CREATE TYPE privilege, SCN 14-13

See also privileges

CREATE TYPE statement

object types, ADG 16 - 16

varray, ADG 16 - 17

CREATE TYPE with OID statement, DCI 3-3

CREATE USER

statement, SQL 7-425

system privilege, SQL 7-501

CREATE USER command

IDENTIFIED BY option, SAD 23-12

IDENTIFIED EXTERNALLY option, SAD 23-12

Import, SUT 2-14

temporary segments and, SCN 4-18

CREATE VIEW

statement, SQL 7-430

system privilege, SQL 7-502

CREATE VIEW command, ADG 3 - 22

about, SAD 15-2

examples, SCN 20-14

object views, SCN 15-3

locks, SCN 27-29

OR REPLACE option, ADG 3 - 24, SAD 15-9

WITH CHECK OPTION, ADG 3 - 22, ADG 3 - 26, SAD 15-3

CREATE_BITMAP_AREA_SIZE parameter, SRF 1-24, STU 6-15, STU 6-18

CREATE_INST_INIT procedure, DDS 6-14

CREATE_MASTER_REPGROUP procedure

DBMS_REPCAT package, REP 2-20

CREATE_STORED_OUTLINES parameter, STU 7-28

of ALTER SESSION, SQL 7-81

of ALTER SYSTEM, SQL 7-101

CREATE_STORED_OUTLINES session parameter, GTK 2-37, SCN 22-6

creating

audit trail, SAD 25-4

cluster index, SAD 17-6

clustered tables, SAD 17-6

clusters, ADG 6 - 15, SAD 17-6

column groups

syntax, SPR 34 - 40, SPR 34 - 61, RAR 8-118, RAR 8-144

control files, SAD 5-3

database, PSC 3-5, SAD 1-19, SAD 2-1

backing up the new database, SAD 2-7

during installation, SAD 2-3

executing CREATE DATABASE, SAD 2-6

migration from different versions, SAD 2-3

preparing to, SAD 2-2

prerequisites for, SAD 2-3

problems encountered while, SAD 2-8

databases, SAD 7-7

setting block size, SRF 1-27, SRF 1-28

datafiles, SAD 9-3, SAD 10-5

DB_NAME.CONF file, PSC B-2

deferred transactions, REP 9-2

hash clustered tables, SAD 18-4

hash clusters, ADG 6 - 20, SAD 18-4

indexes, ADG 6 - 5

explicitly, SAD 16-8

integrity constraints, ADG 5 - 2

master sites, REP 2-8

multiple objects, ADG 3 - 45, SAD 20-2

net service name for each database, PSC 4-25

net service names, PSC 4-20

net service names for each instance, PSC 4-20

net service names for Windows NT, PSC 4-29

network configuration files, PSC 3-6, PSC 4-12, PSC 5-11, PSC 5-29

objects, OCI 10-32

online redo log groups, SAD 6-11

Oracle Names server with region database, NET 6-27

Oracle Names server without region database, NET 6-32

packages, ADG 10 - 14, SPR 1 - 2

parameter file, SAD 2-4

partitioned objects, SAD 13-9

partitioned tables, SAD 13-9

preferred credentials, PSC 5-21

priority groups, SPR 34 - 41, RAR 8-119, REP 6-25

profiles, SAD 23-18

raw devices, PSC 8-3

raw devices on UNIX, PSC 2-7

raw devices on Windows NT, PSC 2-9

redo log members, SAD 6-11

refresh groups, SPR 32 - 5, RAR 8-70

replicated object groups

syntax, SPR 34 - 33, RAR 8-109

replicated objects

generating support for, SPR 34 - 58, RAR 8-140

snapshot sites, SPR 34 - 38, RAR 8-116

syntax, SPR 34 - 34, RAR 8-110

repository, PSC 5-13

rollback segments

about, SAD 21-8

specifying storage parameters, SAD 21-8

savepoints, PC_ F-103, PCO F-78

sequences, ADG 3 - 41, SAD 15-10

site priority groups, REP 6-30

syntax, SPR 34 - 43, RAR 8-121

snapshot sites

syntax, SPR 34 - 37, RAR 8-114

snapshots, REP 5-24

standby databases, SBR 16-3

synonyms, ADG 3 - 43, SAD 15-12

tables, ADG 3 - 3, ADG 3 - 4, SAD 14-9

tablespaces, SAD 9-3

rollback segments required, SAD 9-5

triggers, ADG 13 - 3, ADG 13 - 20

views, ADG 3 - 22, SAD 15-2

creating a rollback segment, SPS 14-5, SPS 14-6

creating a tablespace, SPS A-18

creating an Oracle server account, OAS 7-13

creating duplicate databases, SBR 10-2

on a remote host, SBR 10-10

creating Oracle directories in CDS, OAS 9

creating partitions, LEG 5-7

creating principals and accounts, OAS 8

creating temporary LOB, PC_ 16-15

creating test databases, SBR 4-52

creating the recovery catalog, SBR 6-2

creation of prioritized message queue table and queue, ADQ 4-9, ADQ 4-22, ADQ 8-5

creation of queue table and queue of object type, ADQ 4-9, ADQ 4-21, ADQ 8-4

creation of queue table and queue of RAW type, ADQ 4-9, ADQ 4-22, ADQ 8-4

creation of queue tables and queues, ADQ 8-4

cross instance CR read statistic, SRF C-8

cross joins, SCN 23-3

crosscheck command (RMAN), SBR 11-57

crosschecking

definition, SBR 4-18

recovery catalog with the media manager, SBR 6-9

cross-instance call invocation enqueue, SRF B-2

cross-tabulation values

deriving, SQL 7-549

Cryptographic Toolkit, GTK 6-8

cryptography, definition, OAS Glossary-3

CTIME column

SYS.INCEXP table, SUT 1-51

CUBE operation, GROUP BY clause, GTK 2-24

CUBE operations

of queries and subqueries, SQL 7-549

cumulative export, SBR 13-17

cumulative exports, SUT 1-44, SUT 1-46

recording, SUT 1-23

restrictions, SUT 1-44

specifying, SUT 1-20

SYS.INCFIL table, SUT 1-51

SYS.INCVID table, SUT 1-52

cumulative incremental backups, SBR 4-42, SBR 8-22

currency, SRF 1-78

international currency symbol, SRF 1-80

monetary units characters, NLS 2-23

Currency formats, NLS 2-20

currency symbol

default, NLS 2-8

ISO, SQL 2-36

local, SQL 2-37

local currency symbol, NLS 2-20

union, SQL 2-38

Current blocks converted for CR statistic, SRF C-3

current column, SQL trace, STU 14-13

current instance, SPS 18-21

checkpoint, SPS 21-9

log switch, SPS 21-10

specifying, SPS 18-17

current mode, TKPROF, STU 14-13

CURRENT OF clause, PC_ 8-4, PCO 5-16, PCO 7-5, PLS 5-48

example, PCO 5-16

example of, PC_ 6-17

mimicking with ROWID, PC_ 3-26, PC_ 8-28, PCO 3-29, PCO 7-19

of embedded SQL DELETE statement, PCO F-33

of embedded SQL UPDATE statement, PCO F-88

purpose of, PC_ 6-17

restrictions, PCO 5-17

restrictions on, PC_ 6-17

CURRENT option, SPS 21-4

checkpoints, SPS 21-10

forcing a global log switch, SPS 21-10

global log switch, SPS 21-16

new in Oracle7, SPS A-19

current row, PCO 5-12, PLS 1-5

definition of, PC_ 2-8

using FETCH to retrieve, PC_ 6-12

current user, SCN 18-10

CURRENT_SCHEMA parameter

of ALTER SESSION, SQL 7-81

CURRENT_USER

and database links, SQL 7-256

CURRVAL pseudo-column, ADG 3 - 38

restrictions, ADG 3 - 39

CURRVAL pseudocolumn, PCO 4-6, PLS 5-3, SQL 2-51, SQL 7-350

cursor attribute

%BULK_ROWCOUNT, PLS 4-36

%FOUND, PLS 5-34, PLS 5-38

%ISOPEN, PLS 5-34, PLS 5-38

%NOTFOUND, PLS 5-35

%ROWCOUNT, PLS 5-35, PLS 5-39

implicit, PLS 5-38

syntax, PLS 11-34

values, PLS 5-36

cursor cache, PCO 8-38

definition of, PC_ 9-37

gathering statistics about, PCO 8-40

purpose, PCO 8-36, PCO D-9

purpose of, PC_ C-9

cursor control statements

example of typical sequence, PC_ 6-18

CURSOR expressions, SQL 5-9

cursor FOR loop, PLS 5-13

passing parameters to, PLS 5-15

cursor operations

overview of, PC_ 6-11

cursor variable, PLS 5-15

assignment, PLS 5-31

closing, PLS 5-24

declaring, PLS 5-17

fetching from, PLS 5-23

opening, PLS 5-19

restrictions, PLS 5-33

syntax, PLS 11-39

using to reduce network traffic, PLS 5-30

using with dynamic SQL, PLS 10-5

cursor variables, ADG 10 - 38, PC_ 4-26, PC_ F-12, PCO 6-32, PCO F-10

advantages, PCO 6-32

allocating, PC_ 4-27, PCO 6-33

closing, PCO 6-36

declaring, PC_ 4-26, PCO 6-33

declaring and opening, ADG 10 - 38

error conditions, PCO 6-37

fetching from, PCO 6-35

heap memory usage, PCO 6-33

opening

anonymous block, PCO 6-35

stored procedure, PCO 6-34

restrictions, PCO 6-37

restrictions on, PC_ 4-32

scope, PCO 6-33

use of in recursive functions, PC_ 1-11

CURSOR_ALREADY_OPEN exception, PLS 6-5

CURSOR_NUM column

TKPROF_TABLE, STU 14-19

CURSOR_SPACE_FOR_TIME parameter, SRF 1-24

setting, STU 19-17

cursors, ADG 8 - 9, DDS 7-7, PC_ 2-17, PC_ 4-26, PCO 5-12, PLS 1-5, PLS 5-6

allocating, PC_ F-12, PCO F-10

allocating a cursor variable, PC_ 4-27

analogy, PLS 1-5

analogy for, PC_ 2-8

and closing database links, DDS 4-2

association with queries, PC_ 6-11

association with query, PCO 5-12

cancelling, ADG 8 - 10

closing, ADG 8 - 10, PC_ F-18, PCO F-14, PLS 5-10

closing before reopening, PC_ 6-13

creating, SCN 16-11

DBMS_SQL package, SPR 48 - 4

declaring, PC_ 6-12, PCO 5-12, PLS 5-7

defined, SCN 16-6

definition of, PC_ 2-8

effects on performance, PCO D-7

embedded SQL, SCN 16-5

explicit, PLS 5-6

explicit versus implicit, PC_ 2-8, PCO 5-12

fetching from, PLS 5-9

fetching rows from, PC_ F-58, PC_ F-61, PCO F-45, PCO F-48

for multirow queries, PC_ 6-11

how handling affects performance, PC_ C-7

implicit, PLS 5-11

maximum number of, ADG 8 - 9, SCN 16-7

movement through active set, PC_ 6-14

naming, PCO 5-13

number cached per session, SQL 7-88

number of open, MIG 2-17

object dependencies and, SCN 21-10

OPEN_CURSORS parameter, SRF 1-84

opening, PC_ F-92, PC_ F-94, PCO F-69, PCO F-71, PLS 5-8, SCN 7-9, SCN 16-7

overview of, SCN 1-17

packaged, PLS 5-12

parameterized, PLS 5-8

pointers to, ADG 10 - 38

private SQL areas and, ADG 8 - 9, SCN 7-9, SCN 16-6

purpose of, PC_ 6-11

recursive, SCN 16-7

recursive SQL and, SCN 16-7

reopening, PC_ 6-13, PC_ 6-14, PCO 5-14, PCO 5-15

restricted scope of, PCO 2-28

restrictions, PCO 5-13

restrictions on declaring, PC_ 6-13

RETURN clause, PLS 5-12

rules for naming, PC_ 6-12

scope, PCO 5-14

scope of, PC_ 6-13

scope rules, PLS 5-7

shared pool, SRF 1-49, SRF 1-115, SRF 1-116

statements for manipulating, PC_ 6-11

stored procedures and, SCN 16-18

syntax, PLS 11-45

types of, PC_ 2-8

using for multirow queries, PCO 5-12

using more than one, PC_ 6-13, PCO 5-14

when closed automatically, PC_ 6-15, PCO 5-16

Custom install type, NET 4-21

Custom installation, PSC 3-6

Custom installation type, PSC 3-2, PSC 4-2

custom record separator, SUT 3-18

Customize Master Site property sheet

setup wizard, REP 2-10

Customized Calendars, NLS B-11

customized character sets, NLS B-1

CyberSafe, OAS 1-7

system requirements, OAS 1-12

CyberSAFE authentication method

see Oracle Advanced Security

CyberSAFE benefits, OAS 1-7

CyberSafe Challenger

system requirements, OAS 1-12

CYCLE clause

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

of CREATE SEQUENCE, SQL 7-351

CYCLE option, CREATE SEQUENCE, SPS 6-6

---