Oracle8
i
Generic Documentation Master Index
Release 2 (8.1.6)
A76991-01
Library
Product
Contents
Oracle8
i
Generic Documentation Master Index
C
C and C++
debugging DLLs, DCI 4-15
differences from PL/SQL, DCI 5-9
C API, OID 2-33
c attribute, NET 2-40
C clause
of CREATE TYPE, SQL 7-442
of CREATE TYPE BODY, SQL 7-450
C datatypes
manipulating with OCI, OCI 11-5
C language
C call specifications
compatibility, MIG 9-13
C method
mapping to an object type, SQL 7-442
C number format element, SQL 2-41
C preprocessor
directives supported by Pro*C, PC_ 5-28
how used in Pro*C, PC_ 5-28
C structs
generating for a REF, PC_ 17-33
using, PC_ 17-32
C types of collection attributes, PC_ 18-15
C variable in SQLDA
how value is set, PC_ 15-11
purpose of, PC_ 15-11
C++, PC_ 1-8
C++ applications, PC_ 12-1
C++, See Pro*C/C++ precompiler
C, See OCI
cache, PC_ 17-4
buffer cache, PSC 1-4
coherency, PSC 4-9,
PSC 5-2
database blocks, SRF 1-24
dictionary, SRF 3-71,
SRF 3-88,
SRF 3-89,
SRF 3-90,
SRF 3-91,
SRF 3-92
dictionary cache, PSC 4-2
flushing dictionary, PSC 4-8
recovery, PSA 14-6
row cache, PSC 4-2
sequence cache, PSC 8-13,
PSC 8-14
statistics, SRF 1-63
CACHE / NOCACHE, ADL 7-8
CACHE clause, SCN 7-4
of ALTER MATERIALIZED VIEW, SQL 7-51
of ALTER MATERIALIZED VIEW LOG, SQL 7-61
of ALTER SEQUENCE.
See
CREATE SEQUENCE, SQL 7-81
of ALTER TABLE, SQL 7-151
of CREATE CLUSTER, SQL 7-258
of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-336
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-323
of CREATE SEQUENCE, SQL 7-374
of CREATE TABLE, SQL 7-408
CACHE FREE ALL SQL statement, PC_ 17-6
CACHE FREE ALL statement, PC_ F-15
cache functions
server roundtrips, OCI C-4
Cache Fusion, SCN 217
architecture, PSC 6-5
benefits, PSA 12-4
change summary for 8.1, PSC A-3
definition, PSC 6-5
performance, PSA 12-1
tuning, PSA 12-1
cache fusion, GTK 3-61
CACHE hint, SQL 2-67,
STU 7-30
cache hit ratios
increasing, STU 19-31
CACHE option
CREATE SEQUENCE command, ADG 2-34
CACHE option, CREATE SEQUENCE, PSC 8-14
cache reads
for LOBS
discontinue using, MIG 13-3,
MIG 13-26
CACHE READS option, GTK 2-13
cache recovery, PSC 9-16
CACHE_SIZE_THRESHOLD initialization parameter: obsolete
CACHE_SIZE_THRESHOLD parameter, PSC A-19
obsolete for 8.1, PSC A-6
cached sequence numbers
Export, SUT 1-57
caches
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-7
database buffer, SCN 1-14
library cache, SCN 7-7,
SCN 7-8,
SCN 7-10
object cache, ADL 5-20,
ADO 2-13,
ADO 3-2,
ADO 3-6,
SCN 13-14
object views, ADO 5-4,
SCN 14-4
private SQL area, SCN 7-8
sequence cache, ADG 2-33
sequence numbers, ADG 2-29
shared SQL area, SCN 7-7,
SCN 7-8
writing of buffers, SCN 8-8
Calendar package, SPR 1-13
calendar systems
support, NLS A-21
calendars, NLS A-21
customized, NLS B-11
formats, NLS 2-17
parameter, NLS 2-17
systems, NLS 2-20
CALL clause
of CREATE TRIGGER, SQL 7-433
CALL procedure statement
of CREATE TRIGGER, SQL 7-433
call spec
in procedures, SQL 7-354
of CREATE FUNCTION, SQL 7-289
of CREATE PROCEDURE, SQL 7-357
of CREATE TYPE, SQL 7-442
of CREATE TYPE BODY, SQL 7-450
call specification, PLS 8-3
call specifications, ADG 10-3 to
ADG 10-50
downgrading, MIG 13-33
call specifications.
See
call spec
call specs, GTK 3-19,
GTK 3-44
CALL SQL statement, PC_ F-16,
PCO 6-23
CALL statement, PC_ 7-27,
PC_ A-2,
PCO A-2,
PCO F-13,
SQL 7-226
compatibility, MIG 9-13
example, PC_ 7-28,
PCO 6-24
callback, ADL 9-65,
ADL 9-76,
ADL 9-103,
ADL 9-192,
ADL 10-152
restrictions, DCI 4-11
Callback Restrictions, DCI 4-11
callbacks, ADG 10-44 to
ADG 10-46
application failover, OCI 9-20
dynamic registrations, OCI 9-14
for LOB operations, OCI 7-11
for reading LOBs, OCI 7-12
for writing LOBs, OCI 7-13
from external procedures, OCI 9-19
LOB streaming interface, OCI 7-11
parameter modes, OCI 15-64
registration for application failover, OCI 9-22
restrictions, OCI 9-17
user-defined functions, OCI 9-10
Calling Java from PL/SQL, PC_ A-5
calls
inter-language, PLS 7-44
Oracle call interface, SCN 8-27
remote procedure, DDS 1-46,
SCN 416
subprogram, PLS 7-13
Cancel button, in Oracle Directory Manager, OID 4-10
cancel-based media recovery
definition, SBR 3-16
procedures, SBR 5-22,
SBR 5-25,
SBR 5-28
canceling OCI calls, OCI 2-34
cancelling a cursor, ADG 7-10
cancelling RMAN commands, RMN 1-12
Cannot have more than one open QueueBrowser for the same destination - error, ADQ D-15
Cannot have more than one open Session on a JMSConnection, ADQ D-2
cannot serialize access, SCN 221
Cannot specify both payload factory and sql_data_class - error, ADQ D-11
capacity planning
I/O subsystem, OID 12-6
network requirements, OID 12-14
capture avoidance rule, ADO 2-7
cardinality, DWG 6-3,
SCN 10-35,
STU 12-21
CARDINALITY column
PLAN_TABLE table, STU 5-5
carriage returns, PLS 2-2
Cartesian products, SQL 5-23,
STU 4-48
cartridge services, GTK 3-32
Cartridge Services -- File I/O Interface, DCI 13-72
CartridgeServices.jar, MIG 8-5
CAs. See certificate authorities.
CASCADE actions
DELETE statements and, SCN 267
CASCADE clause
of CREATE TABLE, SQL 7-408
of DROP PROFILE, SQL 7-494
of DROP USER, SQL 7-510
CASCADE CONSTRAINTS clause
of DROP CLUSTER, SQL 7-473
of DROP TABLE, SQL 7-502
of DROP TABLESPACE, SQL 7-504
of REVOKE schema_object_privileges, SQL 7-561
CASCADE CONSTRAINTS option, ADG 11-32
CASCADE option
integrity constraints, ADG 5-18
when dropping unique or primary keys, SAD 19-19
cascading revokes, SAD 23-15
CASE expressions, DWG 17-52,
GTK 2-14,
SQL 5-13
CASE OTT parameter, OCI 14-27,
PC_ 19-30
case sensitivity
identifier, PLS 2-5
in precompiler options, PC_ 10-2
string literal, PLS 2-9
case studies
preparing tables for SQL*Loader, SUT 4-4
SQL*Loader, SUT 4-1
SQL*Loader associated files, SUT 4-3
SQL*Loader filenames, SUT 4-3
CASE1.RCV sample script
setting size limits for backup pieces, RMN 2-21
case-insensitive sorting, NLS 2-31
case-insensitivity, PCO 2-11
CAST expressions, SQL 5-7
CAT synonym for USER_CATALOG view, SRF 2-93
catalog command (RMAN), RMN 3-9,
RMN 3-34,
RMN 10-35
Catalog Management tool, OID 4-16,
OID 6-34
catalog management tool, OID 6-30
CATALOG view, SRF 2-93
catalog views
v$temporary_lobs, ADL 10-13
CATALOG5.SQL script, obsolete with Oracle8
i
, MIG 9-25
CATALOG6.SQL script, obsolete with Oracle8
i
, MIG 9-25
cataloged attributes
orcleventtype, OID 5-25
orcluserdn, OID 5-25
cataloging
archived redo logs, RMN 3-9
datafiles, RMN 3-9
cataloging operating system copies, RMN 5-27
catalog.sh. See catalog management tool.
CATALOG.SQL
preparing database for Export, SUT 1-9
preparing database for Import, SUT 2-6
CATALOG.SQL script, MIG 4-4,
MIG 4-33,
MIG 7-22,
MIG 13-60,
RMN 3-2,
SRF 5-3
creating V$ views, SRF 3-1
CATAUDIT.SQL script
audit trail records created by, SRF 2-168
audit trails for connections and disconnections, SRF 2-168
auditing characteristics described by, SRF 2-177
running, SAD 24-4
CATBLOCK.SQL script, SAD 4-15,
SRF 5-3
CATEXP7.SQL
preparing database for Export, SUT 1-63
CATEXP7.SQL script, MIG 9-48,
SRF 5-3
downgrading to Oracle7, MIG 14-3
CATEXP.SQL
preparing database for Export, SUT 1-9
preparing database for Import, SUT 2-6
CATHO.SQL script
installing data dictionary for Heterogeneous Services, DDS 7-2
CATHS.SQL script, SRF 5-3
CATIO.SQL script, SRF 5-3
CATLDR.SQL
setup script
SQL*Loader, SUT 8-10
CATNOADT.SQL script, SRF 5-6
CATNOAUD.SQL script, SRF 5-6
running, SAD 24-5
CATNOHS.SQL script, SRF 5-6
CATNOPRT.SQL script, SRF 5-6
CATNOQUE.SQL script, MIG 7-33
CATNOQUEUE.SQL script, SRF 5-6
CATNORMN.SQL script, SRF 5-7
CATNOSVM.SQL script, SRF 5-7
CATNSNMP.SQL script, SRF 5-7
CATOCTK.SQL script, SRF 5-4
CATPARR.SQL script, MIG 4-33,
MIG 7-29,
MIG 13-60,
MIG 13-61,
PSA 9-8,
PSA 12-9,
SRF 5-4,
STU 19-31
CATPERF.SQL file, STU 19-38
CATPROC.SQL script, ADG 13-4,
ADG 14-2,
MIG 4-4,
MIG 4-33,
MIG 7-22,
MIG 13-60,
RMN 3-2,
SRF 5-3
catproc.sql script, SPR 1-2
CATQUEUE.SQL script, MIG 7-33,
SRF 5-4
CATREP.SQL script, MIG 4-33,
MIG 5-20,
MIG 7-24,
MIG 13-60,
SRF 5-4
CATRMAN.SQL script, RMN 3-10,
SRF 5-4
CC date format, ADG 3-12
CC date format element, SQL 2-46
CDATA - oracle.xml.parser.v2.AttrDecl.CDATA, JPR 4-6
cDATASection(char[], int, int) - oracle.xml.parser.v2.DefaultXMLDocumentHandler.cDATASection(char[], int, int), JPR 4-11
cDATASection(char[], int, int) - oracle.xml.parser.v2.XMLDocumentHandler.cDATASection(char[], int, int), JPR 4-86
CDS
naming adapter components, OAS 12-4
naming adapter includes, OAS 12-4
using to perform name lookup, OAS 14-15
CDS external naming, NET 2-37,
NET 4-25,
NET 6-79,
NET 8-20
cds_attributes file
modifying for name resolution in CDS, OAS 14-15
CDSect - oracle.xml.parser.v2.XMLToken.CDSect, JPR 4-136
CEIL function, SQL 4-18
Cell Directory Service
using to perform name lookup, OAS 14-15
Cell Directory Service (CDS), naming adapter includes, OAS 12-4
Cell Directory Services external naming, NET 2-37,
NET 4-25,
NET 8-20
configuring, NET 6-79
centralized naming, NET 6-4
advantages and disadvantages, NET 5-4
described, NET 2-36
establishing a connection with, NET 6-4
recommended for, NET 5-4
centralized user management
distributed systems, DDS 1-27
century, ADG 3-10,
SCN 12-12
date format masks, ADG 3-9
specifying, SQL 2-47
CERN proxy server, OAS 10-10
certificate
definition, OAS 10-4
certificate authorities, OID 2-22
definition, OID 2-22
certificate authority, GTK 3-74,
SCN 283
definition, OAS 10-4
certificate-based authentication, OID 1-5,
OID 2-22
certificates, OID 2-22,
OID F-5
definition, OID 2-22
requests for, OID 2-23
trusted, OID 2-23
X.509 Version 3, OID 2-23
CGI variables, ADG 12-2
Chadwick, David, OID 2-33
chained row tables
dropping, MIG 13-25
chained rows, STU 20-31
listing, SQL 7-207
CHAINED_ROWS view, SRF 2-93
chaining of rows, SCN 4-10,
SCN 10-5
challenge-response (asynchronous) authentication in RADIUS, OAS 4-6
change
capture, DWG 11-6
data capture, DWG 11-6
CHANGE CATEGORY clause
of ALTER OUTLINE, SQL 7-63
change command (RMAN), RMN 3-15,
RMN 10-38
available option, RMN 3-13
delete option, RMN 3-20,
RMN 3-36
unavailable option, RMN 3-13
change log processing thread, OID 2-16
change logs, OID 2-12,
OID 2-14,
OID 2-16
in replication, OID 1-5,
OID 2-15,
OID 2-17
worker threads in processing, OID 10-13
change retry count, setting, OID 10-12
change status log, OID 2-16
change types, in ldapmodify input files, OID A-12
change vectors, SAD 6-2
redo records, SBR 1-9
CHANGE_PASSWORD command, NET A-4
change-based media recovery, SBR 5-30
coordinated in distributed databases, SBR 6-17
definition, SBR 3-16
changeLog, OID F-3
change-log flag, OID 10-17
toggling, OID 10-17
changeLogEntry, OID F-3
change-logging, OID 3-4
changeNumber, OID F-3
changes
making permanent, SQL 7-230
changeStatus, OID F-3
changeStatusEntry, OID F-3
changeType, OID F-3
changetype
add, OID A-12
delete, OID A-14
modify, OID A-12
modrdn, OID A-14
changing
a configuration set entry, OID 3-9
attribute values, OID 7-22
audit level, OID 5-29
configuration set entry values, OID 5-2
location of Oracle wallet, OID 5-10,
OID F-6
passwords
to directory, OID 5-19
changing default storage parameters, SQL 7-180
channel bandwidth, STU 16-6
channels
allocating, RMN 1-28
allocating to MTS sessions, RMN 10-11,
RMN 10-15
controlling RMAN, RMN 1-28
managing RMAN, RMN 1-28
parellelization of, RMN 1-31
CHAR
class, NLS 6-8
datatype, PLS 2-15
multi-byte character sets and, NLS 3-15
external datatype, OCI 3-16
maximum size
change, MIG 9-16
object, creating, NLS 6-8
semantics, PLS B-1
CHAR column
maximum width, PLS 2-15
CHAR columns
Version 6 export files, SUT 2-62
CHAR datatype, ADG 3-5,
PC_ 4-10,
SCN 12-5,
SQL 2-15
ANSI, SQL 2-28
blank-padded comparison semantics, SCN 12-5
column length, ADG 3-6
converting to VARCHAR2, SQL 2-40
delimited form and SQL*Loader, SUT 5-70
increasing column length, ADG 2-9,
SAD 13-11
reference
SQL*Loader, SUT 5-64
CHAR datatypes
external, PCO 4-5
CHAR VARYING datatype, ANSI, SQL 2-28
CHAR_MAP precompiler option, PC_ 5-2,
PC_ 10-12,
PC_ A-3
character data, PC_ 5-2
binary sorts, NLS 2-28
linguistic indexes, NLS 2-29
linguistic sorts, NLS 2-28
special cases, NLS 2-31
sorting, NLS 2-28
varying width, ADL 2-4
CHARACTER datatype
ANSI, SQL 2-28
DB2, SQL 2-29
SQL/DS, SQL 2-29
character datatypes
conflicting fields, SUT 5-73
character fields
datatypes
SQL*Loader, SUT 5-64
delimiters and SQL*Loader, SUT 5-64,
SUT 5-70
determining length for SQL*Loader, SUT 5-73
character functions, SQL 4-4,
SQL 4-5
character host variables
as output variables, PCO 4-31
handling, PCO 4-29
server handling, PCO 4-31
types, PCO 4-29
CHARACTER keyword
behavior in Oracle7 and Oracle8
i
, MIG 9-23
character large object,
see
CLOB
character large objects.
See
CLOB datatype
character literal.
See
text
character literals, PLS 2-8
character mappings
alternate, NLS 4-10
character set
for net service name, NET C-5
network, for keyword values, NET C-4
CHARACTER SET clause
of CREATE CONTROLFILE, SQL 7-266
OF CREATE DATABASE, SQL 7-271
character set form, OCI 5-31
getting
internal persistent LOBs, ADL 9-177
character set ID
getting the
internal persistent LOBs, ADL 9-174
temporary LOB of, getting the, ADL 10-127
See CSID parameter
character set Id, OCI 5-31
Unicode, OCI A-21,
OCI A-23
CHARACTER SET parameter
of ALTER DATABASE, SQL 7-16
character sets, NLS 6-9,
PLS 2-2
8-bit versus 7-bit, NLS 4-5
ANY_CS, SPR 18-3
Asian, NLS A-7
CLOB and NCLOB datatypes, SCN 12-14
column lengths, SCN 12-6
common, SQL 2-33
conversion, NLS 3-24
during Export/Import, SUT 1-54,
SUT 2-52
conversion using OCI, NLS 5-34
converting, NLS 4-5
definition files, NLS B-2
direct path export, SUT 1-44,
SUT 1-54
eight-bit to seven-bit conversions
Export/Import, SUT 1-54,
SUT 2-53
European, NLS A-9
for various languages, SCN 5-5
Heterogeneous Services, DDS A-6
Middle Eastern, NLS A-15
migrating the database, MIG 4-8,
MIG 5-6
Migration utility, MIG 4-8
multi-byte, NLS 3-15,
PCO 4-37
multibyte
and SQL*Loader, SUT 5-30
Export/Import, SUT 1-56,
SUT 2-54
multi-byte characters
in role names, SAD 23-7
in role passwords, SAD 23-8
multibyte characters, SQL 2-72
NCHAR and NVARCHAR2, SCN 12-7
NCHAR data
Export, SUT 1-56
Oracle Data Migration Assistant, MIG 5-6
parameter file and, SAD 3-15
parameters, NLS 2-34
pattern matching characters, NLS 4-10
RMAN errors, RMN 9-32
setting for use with RMAN, RMN 2-3
single-byte
Export/Import, SUT 1-54,
SUT 2-53
sorting data, NLS 2-28
specifying for database, SQL 7-271
specifying when creating a database, SAD 2-2
SQL*Loader conversion between, SUT 5-30
storage, NLS A-6
support for, DCI 2-12
supported, NLS 3-18
supporting Euro symbol, NLS A-23
universal, NLS A-17
varying-width
CLOBs and NCLOBs, MIG 9-26
Version 6 conversions
Import/Export, SUT 2-54
character strings
as part of a field comparison, SUT 5-15
comparison rules, SQL 2-32
exact matching of, SQL 2-51
fixed-length, SQL 2-15
multi-byte, PCO 4-38
multibyte, PC_ 4-52
national character set, SQL 2-15
SQL*Loader, SUT 5-46
variable length, SQL 2-16
variable-length, SQL 2-19
zero-length, SQL 2-15
CHARACTER subtype, PLS 2-15
character values
assigning, PLS B-2
comparing, PLS B-2
inserting, PLS B-4
selecting, PLS B-4
CHARACTER VARYING datatype
ANSI, SQL 2-28
characters
numeric group separators, SRF 1-78
single, comparison rules, SQL 2-33
CHARACTERSET keyword
SQL*Loader, SUT 5-31
CharData - oracle.xml.parser.v2.XMLToken.CharData, JPR 4-136
CHARF datatype, PC_ 4-11,
PC_ 5-15
CHARF datatype specifier, PCO 4-47
using in VAR statement, PCO 4-47
CHARF datatypes
external, PCO 4-5
CHARSETFORM property, ADG 10-24
CHARSETID property, ADG 10-24
CHARTOROWID function, ADG 3-25,
SCN 12-24,
SQL 2-37,
SQL 4-19
CHARZ
external datatype, OCI 3-17
CHARZ datatype, PC_ 4-11
external, PCO 4-6
CHECK clause
of constraint_clause, SQL 7-241
of CREATE TABLE, SQL 7-393
CHECK constraint
triggers and, ADG 13-40,
ADG 13-47
check constraints, SCN 271,
SQL 7-241
checking mechanism, SCN 273
defined, SCN 271
how to use, ADG 4-15 to
ADG 4-20
Import, SUT 2-45
multiple constraints on a column, SCN 271
partially null foreign keys, SCN 266
subqueries prohibited in, SCN 271
CHECK DATAFILES clause, PSC 7-2
instance recovery, PSA 14-4
of ALTER SYSTEM, SQL 7-105
CHECK_OBJECT procedure, SAD 20-2,
SAD 20-4,
SAD 20-5
example, SAD 20-10
CHECK_ONLY
Migration utility option, MIG 4-17,
MIG 4-21
checkerr() function
code listing, OCI 2-28
checking in a LOB
internal persistent LOBs, ADL 9-75
checking out a LOB
internal persistent LOBs, ADL 9-64
checkNamespace(String, String) - oracle.xml.parser.v2.XMLElement.checkNamespace(java.lang.String, java.lang.String), JPR 4-93
checkpoint
forcing, SQL 7-105
CHECKPOINT clause
ALTER SYSTEM statement, STU 24-7
of ALTER SYSTEM, SQL 7-105
checkpoint process, SAD 4-12
checkpoint process (CKPT), SCN 1-17,
SCN 8-11
checkpoints
checkpoint interval, SRF 1-63
checkpoint process (CKPT), SCN 1-17,
SCN 8-11
choosing checkpoint frequency, STU 20-40
control files and, SCN 363
DBW
n
process, SCN 8-8,
SCN 8-11
fast-start checkpointing, SCN 354
forcing, PSA 13-14
incremental, SCN 8-8
recorded in control file, SBR 1-7
statistics, SRF 1-63
statistics on, SCN 8-11
checksumming and encryption, activating, OAS 2-7
checksums, OAS 1-5
for data blocks, SAD 10-12
redo log blocks, SAD 6-17
child process termination, NET 10-12
CHOOSE hint, SQL 2-64,
STU 4-11,
STU 7-8
CHR function, SQL 4-19
CHUNK, ADL 7-10
CHUNK clause
of ALTER TABLE, SQL 7-141
of CREATE TABLE, SQL 7-399
chunksize, ADL 9-201
multiple of, to improve performance, ADL 9-103
cipher suites, OID 2-23
in SSL, OID 8-2
SSL, OAS B-12
SSL_RSA_EXPORT_WITH_DES40_CBC_SHA, OID 8-2
SSL_RSA_EXPORT_WITH_RC4_40_MD5, OID 8-2
SSL_RSA_WITH_NULL_MD5, OID 8-2
SSL_RSA_WITH_NULL_SHA, OID 8-2
ckcfg.ora file, NET 6-49
ckpcch.ora file, NET 6-49,
NET 11-6
ckpreg.ora file, NET 6-49
CKPT background process, SCN 1-17,
SCN 8-11
Class - AQjmsQueueConnectionFactory, ADQ B-81
Class - oracle.AQ.AQQueueTableProperty, ADQ B-94
Class - oracle.jms.AQjmsAdtMessage, ADQ B-64
Class - oracle.jms.AQjmsAgent, ADQ B-65