Oracle8i Generic Documentation Master Index

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

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

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

CHARACTER datatype

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

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

clone databases

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

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

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,