Oracle8i Generic Documentation Master Index
Release 2 (8.1.6)

A76991-01

Library

Product

Contents

Prev Up Next

Oracle8i 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 Oracle8i, MIG 9-25
CATALOG6.SQL script, obsolete with Oracle8i, MIG 9-25
cataloged attributes
orcleventtype, OID 5-25
orcluserdn, OID 5-25
cataloging
archived redo logs, RMN 3-9
datafiles, RMN 3-9
cataloging operating system copies, RMN 5-27
catalog.sh. See catalog management tool.
CATALOG.SQL
preparing database for Export, SUT 1-9
preparing database for Import, SUT 2-6
CATALOG.SQL script, MIG 4-4, MIG 4-33, MIG 7-22, MIG 13-60, RMN 3-2, SRF 5-3
creating V$ views, SRF 3-1
CATAUDIT.SQL script
audit trail records created by, SRF 2-168
audit trails for connections and disconnections, SRF 2-168
auditing characteristics described by, SRF 2-177
running, SAD 24-4
CATBLOCK.SQL script, SAD 4-15, SRF 5-3
CATEXP7.SQL
preparing database for Export, SUT 1-63
CATEXP7.SQL script, MIG 9-48, SRF 5-3
downgrading to Oracle7, MIG 14-3
CATEXP.SQL
preparing database for Export, SUT 1-9
preparing database for Import, SUT 2-6
CATHO.SQL script
installing data dictionary for Heterogeneous Services, DDS 7-2
CATHS.SQL script, SRF 5-3
CATIO.SQL script, SRF 5-3
CATLDR.SQL
setup script
SQL*Loader, SUT 8-10
CATNOADT.SQL script, SRF 5-6
CATNOAUD.SQL script, SRF 5-6
running, SAD 24-5
CATNOHS.SQL script, SRF 5-6
CATNOPRT.SQL script, SRF 5-6
CATNOQUE.SQL script, MIG 7-33
CATNOQUEUE.SQL script, SRF 5-6
CATNORMN.SQL script, SRF 5-7
CATNOSVM.SQL script, SRF 5-7
CATNSNMP.SQL script, SRF 5-7
CATOCTK.SQL script, SRF 5-4
CATPARR.SQL script, MIG 4-33, MIG 7-29, MIG 13-60, MIG 13-61, PSA 9-8, PSA 12-9, SRF 5-4, STU 19-31
CATPERF.SQL file, STU 19-38
CATPROC.SQL script, ADG 13-4, ADG 14-2, MIG 4-4, MIG 4-33, MIG 7-22, MIG 13-60, RMN 3-2, SRF 5-3
catproc.sql script, SPR 1-2
CATQUEUE.SQL script, MIG 7-33, SRF 5-4
CATREP.SQL script, MIG 4-33, MIG 5-20, MIG 7-24, MIG 13-60, SRF 5-4
CATRMAN.SQL script, RMN 3-10, SRF 5-4
CC date format, ADG 3-12
CC date format element, SQL 2-46
CDATA - oracle.xml.parser.v2.AttrDecl.CDATA, JPR 4-6
cDATASection(char[], int, int) - oracle.xml.parser.v2.DefaultXMLDocumentHandler.cDATASection(char[], int, int), JPR 4-11
cDATASection(char[], int, int) - oracle.xml.parser.v2.XMLDocumentHandler.cDATASection(char[], int, int), JPR 4-86
CDS
naming adapter components, OAS 12-4
naming adapter includes, OAS 12-4
using to perform name lookup, OAS 14-15
CDS external naming, NET 2-37, NET 4-25, NET 6-79, NET 8-20
cds_attributes file
modifying for name resolution in CDS, OAS 14-15
CDSect - oracle.xml.parser.v2.XMLToken.CDSect, JPR 4-136
CEIL function, SQL 4-18
Cell Directory Service
using to perform name lookup, OAS 14-15
Cell Directory Service (CDS), naming adapter includes, OAS 12-4
Cell Directory Services external naming, NET 2-37, NET 4-25, NET 8-20
configuring, NET 6-79
centralized naming, NET 6-4
advantages and disadvantages, NET 5-4
described, NET 2-36
establishing a connection with, NET 6-4
recommended for, NET 5-4
centralized user management
distributed systems, DDS 1-27
century, ADG 3-10, SCN 12-12
date format masks, ADG 3-9
specifying, SQL 2-47
CERN proxy server, OAS 10-10
certificate
definition, OAS 10-4
certificate authorities, OID 2-22
definition, OID 2-22
certificate authority, GTK 3-74, SCN 283
definition, OAS 10-4
certificate-based authentication, OID 1-5, OID 2-22
certificates, OID 2-22, OID F-5
definition, OID 2-22
requests for, OID 2-23
trusted, OID 2-23
X.509 Version 3, OID 2-23
CGI variables, ADG 12-2
Chadwick, David, OID 2-33
chained row tables
dropping, MIG 13-25
chained rows, STU 20-31
listing, SQL 7-207
CHAINED_ROWS view, SRF 2-93
chaining of rows, SCN 4-10, SCN 10-5
challenge-response (asynchronous) authentication in RADIUS, OAS 4-6
change
capture, DWG 11-6
data capture, DWG 11-6
CHANGE CATEGORY clause
of ALTER OUTLINE, SQL 7-63
change command (RMAN), RMN 3-15, RMN 10-38
available option, RMN 3-13
delete option, RMN 3-20, RMN 3-36
unavailable option, RMN 3-13
change log processing thread, OID 2-16
change logs, OID 2-12, OID 2-14, OID 2-16
in replication, OID 1-5, OID 2-15, OID 2-17
worker threads in processing, OID 10-13
change retry count, setting, OID 10-12
change status log, OID 2-16
change types, in ldapmodify input files, OID A-12
change vectors, SAD 6-2
redo records, SBR 1-9
CHANGE_PASSWORD command, NET A-4
change-based media recovery, SBR 5-30
coordinated in distributed databases, SBR 6-17
definition, SBR 3-16
changeLog, OID F-3
change-log flag, OID 10-17
toggling, OID 10-17
changeLogEntry, OID F-3
change-logging, OID 3-4
changeNumber, OID F-3
changes
making permanent, SQL 7-230
changeStatus, OID F-3
changeStatusEntry, OID F-3
changeType, 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 Oracle8i, MIG 9-23
character large object, see CLOB
character large objects. See CLOB datatype
character literal. See text
character literals, PLS 2-8
character mappings
alternate, NLS 4-10
character set
for net service name, NET C-5
network, for keyword values, NET C-4
CHARACTER SET clause
of CREATE CONTROLFILE, SQL 7-266
OF CREATE DATABASE, SQL 7-271
character set form, OCI 5-31
getting
internal persistent LOBs, ADL 9-177
character set ID
getting the
internal persistent LOBs, ADL 9-174
temporary LOB of, getting the, ADL 10-127
See CSID parameter
character set Id, OCI 5-31
Unicode, OCI A-21, OCI A-23
CHARACTER SET parameter
of ALTER DATABASE, SQL 7-16
character sets, NLS 6-9, PLS 2-2
8-bit versus 7-bit, NLS 4-5
ANY_CS, SPR 18-3
Asian, NLS A-7
CLOB and NCLOB datatypes, SCN 12-14
column lengths, SCN 12-6
common, SQL 2-33
conversion, NLS 3-24
during Export/Import, SUT 1-54, SUT 2-52
conversion using OCI, NLS 5-34
converting, NLS 4-5
definition files, NLS B-2
direct path export, SUT 1-44, SUT 1-54
eight-bit to seven-bit conversions
Export/Import, SUT 1-54, SUT 2-53
European, NLS A-9
for various languages, SCN 5-5
Heterogeneous Services, DDS A-6
Middle Eastern, NLS A-15
migrating the database, MIG 4-8, MIG 5-6
Migration utility, MIG 4-8
multi-byte, NLS 3-15, PCO 4-37
multibyte
and SQL*Loader, SUT 5-30
Export/Import, SUT 1-56, SUT 2-54
multi-byte characters
in role names, SAD 23-7
in role passwords, SAD 23-8
multibyte characters, SQL 2-72
NCHAR and NVARCHAR2, SCN 12-7
NCHAR data
Export, SUT 1-56
Oracle Data Migration Assistant, MIG 5-6
parameter file and, SAD 3-15
parameters, NLS 2-34
pattern matching characters, NLS 4-10
RMAN errors, RMN 9-32
setting for use with RMAN, RMN 2-3
single-byte
Export/Import, SUT 1-54, SUT 2-53
sorting data, NLS 2-28
specifying for database, SQL 7-271
specifying when creating a database, SAD 2-2
SQL*Loader conversion between, SUT 5-30
storage, NLS A-6
support for, DCI 2-12
supported, NLS 3-18
supporting Euro symbol, NLS A-23
universal, NLS A-17
varying-width
CLOBs and NCLOBs, MIG 9-26
Version 6 conversions
Import/Export, SUT 2-54
character strings
as part of a field comparison, SUT 5-15
comparison rules, SQL 2-32
exact matching of, SQL 2-51
fixed-length, SQL 2-15
multi-byte, PCO 4-38
multibyte, PC_ 4-52
national character set, SQL 2-15
SQL*Loader, SUT 5-46
variable length, SQL 2-16
variable-length, SQL 2-19
zero-length, SQL 2-15
CHARACTER subtype, PLS 2-15
character values
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
DBWn process, SCN 8-8, SCN 8-11
fast-start checkpointing, SCN 354
forcing, PSA 13-14
incremental, SCN 8-8
recorded in control file, SBR 1-7
statistics, SRF 1-63
statistics on, SCN 8-11
checksumming and encryption, activating, OAS 2-7
checksums, OAS 1-5
for data blocks, SAD 10-12
redo log blocks, SAD 6-17
child process termination, NET 10-12
CHOOSE hint, SQL 2-64, STU 4-11, STU 7-8
CHR function, SQL 4-19
CHUNK, ADL 7-10
CHUNK clause
of ALTER TABLE, SQL 7-141
of CREATE TABLE, SQL 7-399
chunksize, ADL 9-201
multiple of, to improve performance, ADL 9-103
cipher suites, OID 2-23
in SSL, OID 8-2
SSL, OAS B-12
SSL_RSA_EXPORT_WITH_DES40_CBC_SHA, OID 8-2
SSL_RSA_EXPORT_WITH_RC4_40_MD5, OID 8-2
SSL_RSA_WITH_NULL_MD5, OID 8-2
SSL_RSA_WITH_NULL_SHA, OID 8-2
ckcfg.ora file, NET 6-49
ckpcch.ora file, NET 6-49, NET 11-6
ckpreg.ora file, NET 6-49
CKPT background process, SCN 1-17, SCN 8-11
Class - AQjmsQueueConnectionFactory, ADQ B-81
Class - oracle.AQ.AQQueueTableProperty, ADQ B-94
Class - oracle.jms.AQjmsAdtMessage, ADQ B-64
Class - oracle.jms.AQjmsAgent, ADQ B-65
Class - oracle.jms.AQjmsBytesMessage, ADQ B-66
Class - oracle.jms.AQjmsConnection, ADQ B-67
Class - oracle.jms.AQjmsConstants, ADQ B-69
Class - oracle.jms.AQjmsDestination, ADQ B-71
Class - oracle.jms.AQjmsDestinationProperty, ADQ B-73
Class - oracle.jms.AQjmsFactory, ADQ B-74
Class - oracle.jms.AQjmsMapMessage, ADQ B-75
Class - oracle.jms.AQjmsObjectMessage, ADQ B-77
Class - oracle.jms.AQjmsOracleDebug, ADQ B-78
Class - oracle.jms.AQjmsProducer, ADQ B-79
Class - oracle.jms.AQjmsQueueBrowser, ADQ B-80
Class - oracle.jms.AQjmsSession, ADQ B-82
Class - oracle.jms.AQjmsStreamMessage, ADQ B-83
Class - oracle.jms.AQjmsTextMessage, ADQ B-84
Class - oracle.jms.AQjmsTopicConnectionFactory, ADQ B-85
Class must be specified for queues with object payloads
Use dequeue - error, ADQ D-11
Class not found
(string) - error, ADQ D-3
Class oracle.jms.AQjmsException, ADQ B-86
Classes, ADQ B-2
Classes, JMS, ADQ B-5
clauses
AUTHID, PLS 7-4, PLS 7-6, PLS 7-31
BULK COLLECT, PLS 4-37
LIMIT, PLS 4-39
CLEANUP_ROLLBACK_ENTRIES initialization parameter: obsolete
CLEANUP_ROLLBACK_ENTRIES parameter, PSC A-11, PSC A-15
CLEAR LOGFILE clause
ALTER DATABASE statement, SBR 6-9
of ALTER DATABASE, SQL 7-9, SQL 7-19
CLEAR LOGFILE GROUP clause
ALTER DATABASE statement, SBY 4-16
CLEAR LOGFILE option
ALTER DATABASE statement, SAD 6-17
CLEAR UNARCHIVED LOGFILE clause
ALTER DATABASE statement, SBY 4-12, SBY 5-28
clearBody() - oracle.jms.AQjmsAdtMessage.clearBody(), JPR 2-9
clearBody() - oracle.jms.AQjmsBytesMessage.clearBody(), JPR 2-30
clearBody() - oracle.jms.AQjmsMapMessage.clearBody(), JPR 2-86
clearBody() - oracle.jms.AQjmsMessage.clearBody(), JPR 2-102
clearBody() - oracle.jms.AQjmsObjectMessage.clearBody(), JPR 2-127
clearBody() - oracle.jms.AQjmsStreamMessage.clearBody(), JPR 2-186
clearBody() - oracle.jms.AQjmsTextMessage.clearBody(), JPR 2-199
clearing online logs
implication for standby databases, SBY 4-16
clearing redo log files, SAD 6-7, SAD 6-17, SBR 2-14
restrictions, SAD 6-17
clearProperties() - oracle.jms.AQjmsBytesMessage.clearProperties(), JPR 2-31
clearProperties() - oracle.jms.AQjmsMapMessage.clearProperties(), JPR 2-87
clearProperties() - oracle.jms.AQjmsMessage.clearProperties(), JPR 2-103
clearProperties() - oracle.jms.AQjmsObjectMessage.clearProperties(), JPR 2-128
clearProperties() - oracle.jms.AQjmsStreamMessage.clearProperties(), JPR 2-187
clearProperties() - oracle.jms.AQjmsTextMessage.clearProperties(), JPR 2-199
client
load balancing, PSC 8-10
randomization, PSC 8-10
client application failover
configuring, SBY 5-36
client application layer, described, NET 3-6
client authentication in SSL, requiring, OAS 10-28
client configuration
access control with Oracle Connection Manager, NET 8-37
connection concentration, NET 8-30
connect-time failover, NET 2-21
default domains, NET 8-17
discovering Oracle Names servers, NET 6-60
load balancing requests among listeners, NET 2-20, NET 8-4, NET C-40
local naming, NET 6-15
log files, NET 12-20
multi-protocol support, NET 4-9, NET 8-33
multi-threaded server, NET 9-10
Oracle Connection Manager address, NET 8-39
Oracle Connection Manager features, NET 8-38
Oracle Rdb connections, NET 8-53
overriding multi-threaded server configuration, NET 9-10
preferred Oracle Names servers, NET 8-26
shared servers, NET 9-10
sqlnet.log file, NET 12-20
trace files, NET 12-35
Transparent Application Failover (TAF), NET 2-21
client connections
methods of, NET 11-11
syntax, NET 11-10
client events, ADG 14-7
client load balancing, NET xviii, NET 2-20, NET C-40, PSC 8-10
configuring, NET 8-4, PSG 4-2
described, PSG 4-2
using to improve network performance, NET 5-8
with TAF, PSG 5-4
with Transparent Application Failover, PSG 5-4
client programs, PLS 9-2
Client Registration ID field, NET 8-23
client testing
connectivity, NET 11-17
using application, NET 11-11
using OS, NET 11-11
using special commands, NET 11-12
with 3GL, NET 11-12
with Net8 Assistant, NET 11-22
client troubleshooting, NET 12-4
CLIENT_INFO attribute, USERENV, ADG 11-43
client32net.cfg file, NET 6-87
clients
browse policy, LEG 2-6
communicating with servers on Windows NT, LEG B-7
DHCP, LEG B-10
failover, PSC 9-9
index, LEG 2-5
resource attributes, LEG 2-20, LEG 2-21, LEG 2-22, LEG 2-23
retention policy, LEG 2-6
clients, failover options on, OID 14-4
client/server applications, STU 3-11, STU 18-5
client/server architectures, SCN 6-2
clients, SCN 1-32
diagrammed, SCN 6-2
direct and indirect connections, SCN 379
distributed databases, DDS 1-7
direct and indirect connections, DDS 1-9
distributed databases and, SCN 376
distributed processing in, SCN 6-2
Legato
UNIX, LEG B-1
Windows NT, LEG B-7
NLS, DDS 1-47
overview of, SCN 1-32, SCN 6-2
program interface, SCN 8-27
client-server configurations, MIG 1-4
CLOB, DCI 6-2
datatype, OCI 3-21
EMPTY_CLOB function, DCI 6-4
CLOB class, See JDBC
CLOB datatype, PLS 2-23, SCN 12-14, SQL 2-25
NCLOBs, SPR 18-3
transactional support of, SQL 2-25
CLOB-buffering, See JDBC
CLOBs
columns
varying- width character data, ADL 2-4
compatibility, MIG 9-26
datatype, ADL 2-2
varying-width columns, ADL 2-4
DBMS_LOB, offset and amount parameters in characters, ADL 3-7
example, SUT 4-39
loading, SUT 5-98
modify via DBMS_LOB, ADL 3-8
reading/examining with JDBC, ADL 3-41
using JDBC to modify, ADL 3-40
varying-width, ADL 2-4
CLOBs support, REP A-7
clone database
mounting, SQL 7-11
clone databases
exporting, SBR 7-13
mounting, SCN 5-8
opening, SBR 7-13
preparing for TSPITR, SBR 7-11
preparing parameter files for, SBR 7-10
recovering, SBR 7-12
Clone method, See Oracle Objects for OLE (OO4O)
cloneNode(boolean) - oracle.xml.parser.v2.DTD.cloneNode(boolean), JPR 4-24
cloneNode(boolean) - oracle.xml.parser.v2.XMLAttr.cloneNode(boolean), JPR 4-57
cloneNode(boolean) - oracle.xml.parser.v2.XMLDocument.cloneNode(boolean), JPR 4-71
cloneNode(boolean) - oracle.xml.parser.v2.XMLElement.cloneNode(boolean), JPR 4-93
cloneNode(boolean) - oracle.xml.parser.v2.XMLNode.cloneNode(boolean), JPR 4-107
CLOSE command
examples, PCO F-15
CLOSE CURSOR statement, PC_ 14-27
CLOSE DATABASE LINK clause
ALTER SESSION statement, DDS 3-2
of ALTER SESSION, SQL 7-84
CLOSE SQL statements, PC_ F-18
CLOSE statement, PC_ 6-15, PCO F-14, PLS 5-11, PLS 5-24
dependence on precompiler options, PC_ 6-15
example, PCO 5-16
example of, PC_ 6-15
examples, PC_ F-19
in dynamic SQL method 4, PCO 11-38
purpose of, PC_ 6-12, PC_ 6-15
syntax, PLS 11-17
use in dynamic SQL method 4, PC_ 15-37
close() - oracle.jms.AQjmsConnection.close(), JPR 2-44
close() - oracle.jms.AQjmsConsumer.close(), JPR 2-57
close() - oracle.jms.AQjmsProducer.close(), JPR 2-134
close() - oracle.jms.AQjmsQueueBrowser.close(), JPR 2-147
close() - oracle.jms.AQjmsSession.close(), JPR 2-160
close_all_connections()
as a function of UTL_TCP, SPR 66-14
CLOSE_CACHED_OPEN_CURSORS initialization parameter: obsolete
close_connection()
as a function of UTL_TCP, SPR 66-13
CLOSE_CURSOR function, DDS 9-3
CLOSE_ON_COMMIT
precompiler option, PC_ 10-12, PC_ A-5, PCO 3-15, PCO 5-13
CLOSE_ON_COMMIT precompiler option, PCO 14-14
CLOSE_RELAY command, NET A-81
closed backups, SBR 1-18
closed thread, PSA 13-4, PSA 13-21
closing
all open BFILEs, ADL 11-211
BFILEs, ADL 11-196
BFILEs with CLOSE, ADL 11-203
BFILEs with FILECLOSE, ADL 11-198
cursors, PC_ F-18, PCO F-14
closing database links, DDS 2-18
CLU synonym for USER_CLUSTERS, SRF 2-94
cluster
hash cluster, PSC A-22
implementations, PSC 8-11
performance, PSC 8-7
CLUSTER clause
of CREATE INDEX, SQL 7-297
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-322
of CREATE TABLE, SQL 7-401
of TRUNCATE, SQL 7-613
CLUSTER hint, SQL 2-65, STU 7-11
cluster joins, STU 4-55
cluster keys, SCN 1-26, SCN 10-52
Cluster Manager, PSC 9-6
node monitoring, PSC 3-3
purpose, PSC 3-3
Cluster Manager (CM)
defined, PSG 1-5
DefinedNodes registry value, PSG 3-26
Cluster Manager software, PSA 4-2
purpose, PSC 3-3
cluster re-organization, PSC 9-14
cluster, defined, PSG 1-2
clustered computer systems
Oracle Parallel Server, SCN 5-3
clustered tables. See clusters.
clusters, ADG 5-14 to ADG 5-19, STU 12-25
allocating extents, ADG 5-17, PSA 8-12, SAD 16-9
allocating extents for, SQL 7-3
altering, SAD 16-9
analyzing statistics, SAD 19-3
assigning tables to, SQL 7-401
caching retrieved blocks, SQL 7-258
cannot be partitioned, SCN 11-2
choosing data to cluster, SCN 10-52
cluster indexes, SAD 16-10
altering, SAD 16-10
creating, SAD 16-8
dropping, SAD 16-11
cluster indexes on, SQL 7-297
cluster keys
columns for, SAD 16-4
definition, SAD 16-2
SIZE parameter, SAD 16-5
cluster tables
copying data, MIG 3-15
clustered tables, SAD 16-2, SAD 16-4, SAD 16-7, SAD 16-11
ALTER TABLE restrictions, SAD 16-10
collecting statistics on, SQL 7-204
columns for cluster key, SAD 16-4
components of, PSC 2-2
creating, SAD 16-6, SQL 7-254, SQL 7-255
data blocks allocated to, SQL 7-256
deallocating extents, SAD 16-9
deallocating unused extents, SQL 7-3
defined, SCN 1-26
definition of, PSC 1-2
degree of parallelism
changing, SQL 7-3
when creating, SQL 7-258
dictionary locks and, SCN 240
dropped tables and, ADG 2-10, SAD 13-17
dropping, SAD 16-10
dropping tables of, SQL 7-473
estimating space, SAD 16-5, SAD 16-6
Export, SUT 1-50
free list groups, PSA 8-9
free lists, PSA 8-5
granting
system privileges on, SQL 7-521
guidelines for managing, SAD 16-4 to SAD 16-6
hash, SCN 10-54, SQL 7-257
allocation of space for, SCN 10-59
collision resolution, SCN 10-57
contrasted with index, SAD 17-2, SCN 10-55
root blocks, SCN 10-59
scans of, STU 4-22, STU 4-36, STU 4-38
single-table, SCN 10-61, SQL 7-257
storage of, SCN 10-55
hash cluster, PSA 8-5
hash clusters, SAD 17-1 to SAD 17-9
index, SCN 10-54
contrasted with hash, SAD 17-2, SCN 10-55
scans of, STU 4-39
indexed, SQL 7-257
indexes on, SCN 10-23
cannot be partitioned, SCN 11-2
joins and, SCN 10-52, STU 4-36, STU 4-38, STU 4-55
key
changing column names, SQL 7-3
changing the number of columns, SQL 7-3
keys, SCN 1-26, SCN 10-52, SCN 10-53
affect indexing of nulls, SCN 10-9
location, SAD 16-6
migrated and chained rows in, SQL 7-207
modifying, SQL 7-2
overview of, SAD 16-2, SCN 10-49
performance considerations, ADG 5-15
performance considerations of, SCN 10-52
physical attributes
changing, SQL 7-2
specifying, SQL 7-256
privileges
for altering, SAD 16-9
for creating, SAD 16-6
for dropping, SAD 16-11
removing from the database, SQL 7-472
rowids and, SCN 10-8
scans of, SCN 7-4, STU 4-22, STU 4-36
hash, STU 4-36, STU 4-38
joins, STU 4-38
selecting tables, SAD 16-4
setting parameters of, SCN 10-53
single-table hash clusters, SAD 17-5
space allocated for cluster key values, SQL 7-256
specifying PCTFREE for, SAD 12-4
SQL examples, SQL 7-473
storage access in, PSC 2-5
storage attributes
changing, SQL 7-2
storage characteristics, SQL 7-605
specifying, SQL 7-256
storage format of, SCN 10-53
storage parameters of, SCN 10-5
tablespace
changing, SQL 7-3
tablespace in which created, SQL 7-257
truncating, SAD 19-10
validating structure, SAD 19-9
validating structure of, SQL 7-206
CM
defined, PSG 1-5
DefinedNodes registry value, PSG 3-26
interacting with DLM, PSC 3-6
cmadm_pid.log file, NET 12-19, NET 12-29
cmadm_pid.trc file, NET 12-34
CMADMIN process, NET 4-6
CMAN parameter, NET C-70
CMAN_ADMIN parameter, MIG F-16, NET C-70, NET C-85, NET C-88
cman_pid.log file, NET 12-19, NET 12-29
cman_pid.trc file, NET 12-34
CMAN_PROFILE parameter, NET C-71
CMAN_RULES parameter, NET 8-36, NET C-76
CMAN.ORA file
CMAN_ADMIN parameter, MIG F-16
migrating, MIG F-16
upgrading, MIG F-16
cman.ora file
configuration parameter reference, NET C-70 to NET C-76
creating, NET 8-28, NET 8-32, NET 8-35
parameters
ACT, NET C-76
ACT parameter, NET 8-36
ANSWER_TIMEOUT, NET C-73
AUTHENTICATION_LEVEL, NET C-73
CMAN, NET C-70
CMAN_ADMIN, NET C-70, NET C-85, NET C-88
CMAN_PROFILE, NET C-71
CMAN_RULES, NET C-76
DST, NET C-76
DST parameter, NET 8-36
LOG_LEVEL, NET C-73
MAX_FREELIST_BUFFERS, NET C-73
MAXIMUM_CONNECT_DATA, NET C-73
MAXIMUM_RELAYS, NET C-73
RELAY_STATISTICS, NET C-74
REMOTE_ADMIN, NET C-74, NET C-89
SHOW_TNS_INFO, NET C-74
SRC, NET 8-36, NET C-76
SRV, NET 8-36, NET C-76
TRACE_DIRECTORY, NET C-74
TRACE_FILELEN, NET C-74
TRACE_TIMESTAMP, NET C-75
TRACING, NET C-74
USE_ASYNC_CALL, NET C-75
release 8.1, changes in, NET C-88 to NET C-89
CMCTL STATS command
ACTIVE_DELAYS, NET A-94
MOST_RELAYS, NET A-94
OUT_OF_RELAY, NET A-94
TOTAL_REFUSED, NET A-94
TOTAL_RELAYS, NET A-94
CMCTL utility
command reference, NET A-81 to NET A-97
commands
ACCEPT_CONNECTIONS, NET A-81
CLOSE_RELAY, NET A-81
EXIT, NET A-82
HELP, NET A-82
QUIT, NET A-83
SET, NET A-83
SET AUTHENTICATION_LEVEL, NET A-84
SET DISPLAYMODE, NET A-85
SET LOG_LEVEL, NET A-85
SET RELAY_STATISTICS, NET A-86
SHOW, NET A-80, NET A-86
SHOW ADDRESS, NET A-87
SHOW ALL, NET A-88
SHOW DISPLAYMODE, NET A-89
SHOW PROFILE, NET A-89
SHOW RELAY, NET A-90
SHOW RULES, NET A-91
SHUTDOWN, NET A-80, NET A-92
START, NET 11-9, NET A-92
STATS, NET A-93
STATUS, NET A-95
STOP, NET A-96
STOPNOW, NET A-97
VERSION, NET A-97
described, NET 4-29
function of and syntax format
SET commands, NET A-80
shutdown, preferred mechanism, NET A-80
testing the network, NET 11-4
using, NET 11-4
CMGW process, NET 4-5
cn attribute, NET 2-40, OID 2-5
CNAME.SMD record, NET 11-14, NET A-42
COALESCE clause
for partitions, SQL 7-160
for subpartitions, SQL 7-156
of ALTER INDEX, SQL 7-40
of ALTER TABLESPACE, SQL 7-181
COALESCE PARTITION clause, SAD 15-16
COALESCE SUBPARTITION clause
of ALTER TABLE, SQL 7-156
coalescing extents, SCN 4-16
coalescing free space
extents, SCN 4-14
SMON process, SCN 1-18, SCN 8-11
within data blocks, SCN 4-10
COBOL datatypes, PCO 4-13
COBOL datatypes, additional, PCO A-4
COBOL versions supported, PCO 2-11, PCO B-2
COBOL, See Pro*COBOL precompiler
COBOL-74, PCO B-2
COBOL-85, PCO B-2
CODE
precompiler option, PC_ 12-3
code
example programs, ADL 1-5, OCI B-1
list of demonstration programs, ADL 1-5, OCI B-1
code examples
description of, RMN 10-5, SQL xiii
CODE OTT parameter, OCI 14-26, PC_ 19-28
code page, PC_ 4-49, PCO 4-36
CODE precompiler option, PC_ 10-13
CODE_PIECES view, SRF 2-94
CODE_SIZE view, SRF 2-94
codepoints, NLS 4-10
codes
functions, OCI 15-237
coding area
for paragraph names, PCO 2-18
coding conventions, PC_ 2-10, PCO 2-11
coding guidelines
function names, OCI 2-36
reserved words, OCI 2-35
coexistence issues
release 8.1 client connection to version 7 database, MIG F-9
coherency
of object cache, OCI 13-4
COL view, SRF 2-94
cold backup, OID B-1
cold backups, SBR 1-18
whole database backups, SBR 4-3
collating sequence, PLS 2-48
collation parameters, NLS 2-27
COLLECT GET statement
example, PC_ 18-19
COLLECTION APPEND, PC_ F-19
COLLECTION APPEND statement, PC_ 18-12
SQL statements
COLLECTION APPEND, PC_ F-19
COLLECTION DESCRIBE
example, PC_ 18-21
COLLECTION DESCRIBE statement, PC_ 18-14
SQL statements
COLLECTION DESCRIBE, PC_ F-20
collection exceptions
when raised, PLS 4-28
COLLECTION GET statement, PC_ 18-8
SQL statements
COLLECTION GET, PC_ F-21
collection locators
compatibility, MIG 9-11
collection methods
applying to parameters, PLS 4-27
COUNT, PLS 4-22
DELETE, PLS 4-26, PLS 11-20
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-19
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-23
collection types, DCI 1-8
structs for, PC_ 18-3
COLLECTION_IS_NULL exception, PLS 6-5
collections, PC_ A-4, PLS 4-2, SCN 13-11, STU 14-4, STU 14-23, SUT 3-15
and C, PC_ 18-3
assigning, PLS 4-11
attributes, OCI 6-13
autonomous access, PC_ 18-4
bulk binding, PLS 4-29
collection columns
user-specified storage, MIG 9-29
collection locators
compatibility, MIG 9-29
collection unnesting, GTK 3-35
comparing, PLS 4-13
constructors, PLS 4-8
data manipulation functions, OCI 11-18
declaring, PLS 4-7
defining, PLS 4-5
describing, OCI 6-2
description, OCI 11-17
descriptors, PC_ 18-3
element access, PC_ 18-5
element types, PLS 4-5
functions for manipulating, OCI 11-18
index-organized tables, SCN 10-41
key compression, SCN 10-33
initializing, PLS 4-8
inserting rows into, SQL 7-542
kinds, PLS 4-1
manipulating, PC_ 18-4
modifying, SQL 7-145
nested tables, ADO 1-9, PC_ 18-2, SCN 13-12, SQL 2-31
nesting, ADO 6-20
OBJECT GET statement, PC_ 18-6
OBJECT SET statement, PC_ 18-6
querying, ADO 6-12
referencing, PLS 4-10
scanning functions, OCI 11-19
scope, PLS 4-8
SQL*Loader support, GTK 3-36
syntax, PLS 11-24
table items, SPR 51-15
treating as a table, SQL 7-467, SQL 7-542, SQL 7-617
unnesting, SQL 7-576
examples, SQL 7-593
variable arrays (VARRAYs), ADO 1-8, SCN 13-11
VARRAYs, PC_ 18-3
varrays, SQL 2-31
collocated inline views
tuning distributed queries, DDS 3-4
COLS synonym for USER_TAB_COLUMNS, SRF 2-94
column alias, PLS 5-14
when needed, PLS 2-35
column constraints, SQL 7-233, SQL 7-237
of ALTER TABLE, SQL 7-141
of CREATE TABLE, SQL 7-393
column list, PCO 5-9
in INSERT statements, PC_ 6-9
when permissible to omit, PC_ 6-9
column objects
vs. row objects, ADO 6-1
column REF constraints, SQL 7-234, SQL 7-242
of ALTER TABLE, SQL 7-140
of CREATE TABLE, SQL 7-393
COLUMN_PRIVILEGES view, SRF 2-95
columns
accessing in triggers, ADG 13-15
adding, SQL 7-140
aliases for, SQL 5-19
associating statistics with, SQL 7-211
attributes, OCI 6-5, OCI 6-15
basing an index on, SQL 7-298
cardinality, DWG 6-3, SCN 10-35
collecting statistics on, SQL 7-204
column groups, RAR 6-4, RAR 6-6, RAR 6-9, RAR 6-11, RAR 6-13, RAR 6-17, REP 2-28, REP 5-10
adding members to, SPR 37-6, RAR 8-72
creating, SPR 37-44, SPR 37-68, RAR 8-110, RAR 8-134
dropping, SPR 37-49, RAR 8-115
ensuring data integrity with multiple, REP 5-10
removing members from, SPR 37-50, RAR 8-116
shadow, REP 5-11
column level snapshot subsetting, REP A-3
column names
qualifying in queries, ADO 2-7
column objects, ADO 1-6, SCN 13-8
indexes, ADO 2-4
creating comments about, SQL 7-228
default values, ADG 4-4
default values for, SCN 10-9
defined, SCN 1-22
defining, SQL 7-390
described, SCN 10-3
displaying information about, SAD 19-31
dropping, SCN 10-7
exporting LONG datatypes, SUT 1-57
generating derived values with triggers, ADG 13-49
granting privileges for selected, SAD 23-11
granting privileges on, SAD 23-12
increasing length, ADG 2-9, SAD 13-11
INSERT privilege and, SAD 23-12
integrity constraints, SCN 10-4, SCN 10-9, SCN 254, SCN 257
listing in an UPDATE trigger, ADG 13-6, ADG 13-18
listing users granted to, SAD 23-24
loading REF columns, SUT 5-97
LOB, storage characteristics of, SQL 7-141
maximum in concatenated indexes, SCN 10-25
maximum in view or table, SCN 10-13
maximum number of, SQL 7-392, SRF 4-2
modifying existing, SQL 7-143
multiple foreign key constraints, ADG 4-11
naming
SQL*Loader, SUT 5-47
nested tables, SCN 10-10
null columns at the end of a record, SUT 5-81
number of CHECK constraints limit, ADG 4-16
objects
loading, SUT 5-90
loading nested column objects, SUT 5-92
stream record format, SUT 5-90
variable record format, SUT 5-91
order of, SCN 10-8
parent-child relationships between, SQL 7-278
partially dropped
dropping, MIG 13-15
privileges, SAD 23-12
prohibiting nulls in, SCN 257, SQL 7-239
pseudocolumns
ROWID, SCN 12-16
ROWNUM, STU 4-46, STU 4-77, STU 4-88
USER, SCN 309
qualifying in queries, ADO 2-6
qualifying names of, SQL 5-19
REF
describing, SQL 7-242
reordering before Import, SUT 2-13
restricting values for, SQL 7-237
revoking privileges on, SAD 23-14
selectivity, SCN 131, STU 8-2
histograms, SCN 132, SCN 133, STU 8-17
setting to a constant value with SQL*Loader, SUT 5-54
setting to a unique sequence number using SQL*Loader, SUT 5-56
setting to datafile record number with SQL*Loader, SUT 5-55
setting to null, SUT 5-81
setting to null value with SQL*Loader, SUT 5-55
setting to the current date using SQL*Loader, SUT 5-55
setting value to zero, SUT 5-80
specifying
SQL*Loader, SUT 5-47
specifying as foreign key, SQL 7-240
specifying as PIECED
SQL*Loader, SUT 8-15
specifying as primary key, SQL 7-239
specifying constraints on, SQL 7-393
specifying default values for, SQL 7-392
to index, STU 12-4
unique values in, SQL 7-238
unused, SCN 10-7
dropping, MIG 13-15
COLUMNS clause
of ASSOCIATE STATISTICS, SQL 7-210, SQL 7-211
columns, privileges, ADG 11-30, ADG 11-31
COM Cartridge, GTK 3-87
combining SSL with other authentication methods, OAS 10-7
COMMA - oracle.xml.parser.v2.ElementDecl.COMMA, JPR 4-32
command
scanner, LEG 5-6
command files
Recovery Manager, RMN 1-10
command line
arguments for RMAN, RMN 1-10, RMN 10-42
command-line options
Migration utility, MIG 4-17
parameters
description, SUT 6-2
Export, SUT 1-13
specifying defaults, SUT 5-18
command line tools, OID 1-4
adding
configuration set entries, OID 2-32, OID 7-25
entries, OID 7-25
multiple entries concurrently, OID 7-25
and NLS, OID 11-5
catalog management, OID 6-30
comparing attribute values, OID 7-25
deleting entries, OID 7-25
indexing, OID 6-30, OID 6-34
ldapadd, OID 4-14
ldapaddmt, OID 4-14
ldapdelete, OID 4-14
ldapmoddn, OID 4-14
ldapmodify, OID 4-14
ldapmodifymt, OID 4-14
managing
attributes, OID 6-31
entries, OID 7-25
modifying
attributes, OID 7-25
configuration set entries, OID 7-25
multiple entries, OID 7-25
modifying replication agreement parameters, OID 10-16
moving entries, OID 7-25
moving subtrees, OID 7-25
overview, OID 4-14
renaming entries, OID 7-25
renaming subtrees, OID 7-25
searching for entries, OID 7-25
Command Line Utilities Help, LSM, Windows, LEG 1-14
command line utility, Oracle
Enterprise Backup Utility, Oracle7, LEG 4-4
Recovery Manager (RMAN), Oracle8, LEG 4-4
command(), command_replies()
functions of UTL_SMTP, SPR 65-4
commands
df, LEG 5-7
dkinfo, LEG 5-7
scanner, LEG 5-6
standby database, SBY 1-28
commands, Recovery Manager
allocate channel, RMN 10-10
allocate channel for delete, RMN 5-27
allocate channel for maintenance/delete, RMN 10-14
alter database, RMN 10-16
archivelogRecoverSpecifier clause (RMAN), RMN 10-18
backup, RMN 1-33, RMN 5-2, RMN 5-28, RMN 10-22
proxy only option, RMN 1-22
proxy option, RMN 1-22
skip offline option, RMN 5-16
catalog, RMN 3-9, RMN 3-34, RMN 10-35
change, RMN 3-15, RMN 10-38
delete option, RMN 3-36
configure, RMN 10-47
connect, RMN 10-51, RMN 10-53
copy, RMN 10-55
create catalog, RMN 10-59
create script, RMN 10-61
crosscheck, RMN 10-64
debug, RMN 10-68
delete expired backup, RMN 10-69
delete script, RMN 10-71, RMN 10-72
drop catalog, RMN 3-44, RMN 10-74
duplicate, RMN 1-64, RMN 10-76
execute script, RMN 3-27
host, RMN 10-81
list, RMN 1-24, RMN 10-83
incarnation of database option, RMN 3-13
listObjList clause, RMN 10-92
overview, RMN 1-5
print script, RMN 10-94
recover, RMN 1-61, RMN 6-18, RMN 10-96
register, RMN 3-10, RMN 10-101
release channel, RMN 10-103
release channel (of type maintenance), RMN 10-104
replace script, RMN 10-105
replicate, RMN 6-12, RMN 10-108
replicate controlfile, RMN 6-12
report, RMN 1-26, RMN 10-110
need backup option, RMN 4-5
reset database, RMN 3-12, RMN 10-118
incarnation option, RMN 3-13
restore, RMN 6-19, RMN 10-120
resync catalog, RMN 1-15, RMN 3-29, RMN 10-127
from controlfilecopy option, RMN 3-43
rman, RMN 10-130
run, RMN 10-133
send, RMN 2-22, RMN 10-136
set, RMN 10-138
duplex parameter, RMN 5-24
maxcorrupt for datafile option, RMN 5-28
newname for datafile option, RMN 6-10
set (within run command), RMN 10-142
shutdown, RMN 10-147
sql, RMN 10-150
startup, RMN 10-152
summary, RMN 10-6
switch, RMN 10-154
terminating, RMN 1-12
until, RMN 10-45, RMN 10-156
upgrade catalog, RMN 3-43, RMN 10-158
validate, RMN 10-160
commands, SQL
ALTER DATABASE, SBR 5-6, SBR 5-10, SBR 5-12
when constraint checking occurs, ADG 4-17
commands, SQL*Plus
RECOVER, SBR 5-8
UNTIL TIME option, SBR 5-30
RECOVER DATAFILE, SBR 5-8
RECOVER TABLESPACE, SBR 5-8
SET, SBR 5-6, SBR 5-10, SBR 5-11
Comment - oracle.xml.parser.v2.XMLToken.Comment, JPR 4-136
COMMENT ANY TABLE system privilege, SQL 7-529
COMMENT clause, PLS 5-43
of COMMIT, SQL 7-231
of COMMIT statement, PC_ F-25, PCO F-16
COMMENT statement, SCN 13, SQL 7-228
comment(String) - oracle.xml.parser.v2.DefaultXMLDocumentHandler.comment(java.lang.String), JPR 4-11
comment(String) - oracle.xml.parser.v2.XMLDocumentHandler.comment(java.lang.String), JPR 4-86
Comments
restrictions in PL/SQL block, PC_ 13-31
comments, PLS 2-10, SQL 2-62
adding to objects, SQL 7-228
ANSI, PC_ 2-10
ANSI SQL-style, PCO 2-13
associating with a transaction, SQL 7-231
comments field
updating in views, RAR 7-45
C-style, PCO 2-13
differences between Server Manager and SQL*Plus, MIG 11-9
dropping from objects, SQL 7-228
embedded SQL statements, PCO 2-13
how to specify, SQL 2-62
in COMMIT statements, DDS 5-13
in embedded SQL, PCO 2-12
in Export parameter file, SUT 1-13
in Import parameter file, SUT 2-10
in SQL statements, SQL 2-62
in SQL*Loader control file, SUT 4-12
on Oracle documentation, MIG xiii, RAR x, REP xvi
on schema objects, SQL 2-63
removing from the data dictionary, SQL 7-228
restrictions, PLS 2-11
syntax, PLS 11-30
updating, RAR 7-45
viewing, SQL 7-228
which allowed, PC_ 2-10
comments in configuration files, NET C-3
comments in dynamic PL/SQL blocks, PCO 9-31
COMMIT
Import parameter, SUT 2-19
commit, OCI 2-26, PCO 3-13
automatic, PC_ 3-17, PCO 3-14, SQL 7-230
explicit versus implicit, PC_ 3-17, PCO 3-14
function of, PC_ 3-16
in object applications, OCI 13-14
one-phase for global transactions, OCI 8-7
two-phase for global transactions, OCI 8-7
COMMIT command, ADG 7-5
differences between Server Manager and SQL*Plus, MIG 11-17
COMMIT IN PROCEDURE clause
of ALTER SESSION, SQL 7-84
COMMIT keyword
behavior in Oracle7 and Oracle8i, MIG 9-23
commit phase, DDS 4-12, DDS 4-24
two-phase commit, DDS 4-14
commit point site, DDS 4-7
commit point strength, DDS 4-9, DDS 5-5, DDS A-2
determining, DDS 4-10
distributed transactions, DDS 4-7, DDS 4-9
how Oracle determines, DDS 4-9
commit point strength
definition, DDS 4-9
specifying, DDS 5-5
COMMIT SQL statement, PC_ F-24
COMMIT statement, PC_ 3-18, PCO 3-14, PCO F-15, PLS 5-43, SCN 13, SQL 7-230
COMMENT parameter, DDS 5-13, DDS 5-26
effect of, PC_ 3-18
effects, PCO 3-14
ending a transaction, PC_ F-100, PCO F-77, SCN 32, SCN 35
example, PCO 3-14
example of, PC_ 3-18
examples, PC_ F-26, PCO F-17
fast commit, SCN 8-10
FORCE clause, DDS 5-13, DDS 5-14, DDS 5-15
forcing, DDS 5-12
implied by DDL, SCN 32, SCN 35
purpose of, PC_ 3-18
RELEASE option, PCO 3-15
RELEASE option in, PC_ 3-18
syntax, PLS 11-31
two-phase commit, SCN 38, SCN 406
two-phase commit and, DDS 1-36
two-phase commit in parallel DML, SCN 197
using in a PL/SQL block, PC_ 3-28, PCO 3-25
where to place, PC_ 3-18, PCO 3-14
commit() - oracle.jms.AQjmsSession.commit(), JPR 2-160
COMMIT_POINT_STRENGTH initialization parameter, DDS 4-9, DDS 5-6, SRF 1-19
committed data
checkpoint, PSA 13-14
instance failure, PSA 14-3
sequence numbers, PSC 8-14
committing
transactions, PC_ F-24, PCO F-15
committing transactions
defined, SCN 32
distributed
commit point site, DDS 4-7
fast commit, SCN 8-10
group commits, SCN 8-10
implementation, SCN 8-10
overview, SCN 1-54
parallel DML, SCN 197
common joins, DWG 19-11
common parameter files
recommended locations for, PSA 1-2
using multiple, PSA 1-3
Commonly asked questions, ADQ 6-1
commonName attribute, OID 2-5
communicating over a network, PC_ 3-6
communication protocols, SCN 6-5
communications, stack, NET 3-2
COMMUNITY parameter, MIG F-4
COMP_CHARSET precompiler option, PC_ 10-14
comparing
all or part of two LOBs
internal persistent LOBs, ADL 9-120
all or part of two temporary LOBs, ADL 10-75
all or parts of two BFILEs, ADL 11-116
attribute values, OID 7-25
entries, OID 4-14
tables, SPR 34-3, RAR 8-53
two objects, OID 4-10
comparison functions
MAP, SQL 7-443, SQL 7-449
ORDER, SQL 7-443, SQL 7-449
comparison methods, ADO 1-4, ADO 9-20, SCN 13-7
comparison operators, PLS 2-45, PLS 5-5, SQL 3-5
blank padding data, ADG 3-6
comparing dates, ADG 3-9
comparison semantics
blank-padded, SQL 2-33
nonpadded, SQL 2-33
of character strings, SQL 2-32
comparisons
of character values, PLS B-2
of collections, PLS 4-13
of expressions, PLS 2-47
compatibility, ADL 1-5, MIG 9-1, SCN 1-3
8.1.0 compatibility level
features requiring, MIG 9-9
Advanced Queuing, MIG 9-13, MIG 9-32
agent self-registration, MIG 9-12
ALTER DATABASE RESET COMPATIBILITY statement, MIG 9-7
ANALYZE VALIDATE STRUCTURE statement, MIG 9-18
application context, MIG 9-12
applications, MIG 9-16, MIG 10-2
index-organized tables, MIG 9-17
physical ROWIDs and UROWIDs, MIG 9-17
Tuxedo applications, MIG 9-18
XA calls, MIG 9-18
archived redo logs, MIG 9-42
backup, MIG 9-12, MIG 9-39
change in maximum size
CHAR, MIG 9-16
RAW, MIG 9-16
VARCHAR2, MIG 9-16
compatibility level, MIG 9-5
COMPATIBLE initialization parameter, MIG 9-2
CREATE TABLE behavior change, MIG 9-31
data dictionary, MIG 9-25
database resource manager, MIG 9-13
datafiles, MIG 9-23
datatypes, MIG 9-26
date columns in dynamic performance views, MIG D-13
DBMS_REPAIR package, MIG 9-13
DISABLE VALIDATE constraints, MIG 9-13
downgrading, MIG 9-5
Export/Import, MIG 9-48
extensible optimizer, MIG 9-13
fine-grained access control, MIG 9-12
Heterogeneous Services agents, MIG 9-45
indexes
key compression, MIG 9-10
initialization parameters, MIG B-8
level of recovery catalog, RMN 1-16
LOB index clause, MIG 9-27
LOBs, MIG 9-11, MIG 9-26
CLOBS and NCLOBs, MIG 9-26
LogMiner, MIG 9-43
materialized views, MIG 9-14
nested tables, MIG 9-29
NLS and NCHAR environment variables, MIG 9-28
n-tier authentication and authorization, MIG 9-12
OCI, MIG 9-18
link line, MIG 9-19
thread safety, MIG 9-19
optimization, MIG 9-34
optimizer plan stability, MIG 9-13
Oracle Media Management API, MIG 9-12
Oracle Parallel Server
instance affinity for jobs, MIG 9-12
packages
DBMS_LOB, MIG 9-33
DBMS_REPAIR, MIG 9-33
partitioning, MIG 9-10
PL/SQL, MIG 9-21
PLSQL_V2_COMPATIBILITY initialization parameter, MIG 9-21
precompilers, MIG 9-20
recovery, MIG 9-12, MIG 9-39
fast-start rollback, MIG 9-12
recovery catalog
viewing parameter setting, RMN 3-6
Recovery Manager. See Oracle8i Migration
REFs, MIG 9-11
removing incompatibilities, MIG 13-2
replication, MIG 9-12, MIG 9-45
resetting for database, MIG 13-51
rowids, MIG 9-27
schema objects, MIG 9-10
collection locators, MIG 9-11
drop column, MIG 9-10
extensible indexing, MIG 9-10
function-based indexes, MIG 9-10
indexes, MIG 9-10
index-organized tables, MIG 9-10
nested tables, MIG 9-11
online index (re)build, MIG 9-10
single-table hash clusters, MIG 9-10
temporary tables, MIG 9-10
scripts
UTLCHN1.SQL, MIG 9-13, MIG 9-31
UTLEXPT1.SQL, MIG 9-13, MIG 9-31
shared and exclusive modes, PSA 8-9, PSC 7-2
SHUTDOWN IMMEDIATE, MIG 9-23
snapshots, MIG 9-44
Spatial, MIG 9-14
SQL and PL/SQL, MIG 9-13
autonomous transactions, MIG 9-13
bulk binds, MIG 9-13
C call specifications, MIG 9-13
CALL statement, MIG 9-13
native dynamic SQL, MIG 9-13
NOCOPY parameter passing mode, MIG 9-13
standby database, MIG 9-41
summary management, MIG 9-14
tablespaces, MIG 9-9, MIG 9-23
locally managed tablespaces, MIG 9-9
online read-only tablespaces, MIG 9-9
transportable tablespaces, MIG 9-9
triggers, MIG 9-13
UROWIDs, MIG 9-11
user-defined object identifiers, MIG 9-11
varrays, MIG 9-11
stored as LOBs, MIG 9-29
Visual Image Retrieval, MIG 9-14
compatibility flag, GTK 7-6
compatibility level
checking, MIG 13-2
compatibility levels
transportable tablespaces, SCN 3-15
COMPATIBLE initialization parameter, MIG 9-2, REP 7-3, SBY 5-9, SRF 1-20
8.1.0 setting
features requiring, MIG 9-9
checking the setting, MIG 9-5
database structures, MIG 9-3
setting, MIG 9-6
when to set, MIG 9-5
COMPATIBLE parameter, DWG 14-13, DWG 19-5
and parallel query, STU 7-24
read-only tablespaces, SCN 3-11
COMPATIBLE_NO_RECOVERY initialization parameter: obsolete
compilation, PCO 2-27
compilation and execution of RMAN commands, RMN 1-6
compilation of object types, ADO 2-14
COMPILE clause
of ALTER DIMENSION, SQL 7-27
of ALTER FUNCTION, SQL 7-28
of ALTER JAVA SOURCE, SQL 7-46
of ALTER MATERIALIZED VIEW, SQL 7-54
of ALTER PACKAGE, SQL 7-65
of ALTER PROCEDURE, SQL 7-68
of ALTER TRIGGER, SQL 7-184
of ALTER TYPE, SQL 7-187
of ALTER VIEW, SQL 7-199
of CREATE JAVA, SQL 7-312
compiled PL/SQL, SCN 59
advantages of, SCN 51
procedures, SCN 53
pseudocode, SCN 60, SCN 106
recompiling, SCN 62
shared pool, SCN 25
triggers, SCN 106
compiler directives, SQL 7-442
compiler hint, NOCOPY, PLS 7-17
compile-time errors, ADG 9-41
compiling, PC_ 2-17
specifying include file locations, PC_ 5-35
COMPLETE clause, DWG 8-20
complete export, SBR 4-20
complete exports, SUT 1-45, SUT 1-47
restrictions, SUT 1-45
specifying, SUT 1-21
complete recovery
definition, SBR 1-24, SBR 3-16
procedures, SBR 5-19
using RMAN, RMN 6-20
complete refresh, DWG 14-18
complete refreshes, REP 3-28
completion messages
Export, SUT 1-41
complex materialized views, DWG 14-27
complex object retrieval, OCI 10-20
for Oracle Call Interface, ADO 7-9
implementing, OCI 10-23
navigational prefetching, OCI 10-24
complex object retrieval (COR) descriptor, OCI 2-17
attributes, OCI A-27
complex object retrieval (COR) handle, OCI 2-11
attributes, OCI A-26
complex queries
snowflake schemas, DWG 16-3
complex snapshots, REP 3-6
value for PCTFREE, REP 3-28
value for PCTUSED, REP 3-28
complex view merging, STU 4-78
COMPLEX_VIEW_MERGING initialization parameter: obsolete
compliance
ANSI, PC_ xvii
ISO, PC_ xvii
NIST, PC_ xvii
compliance, ANSI/ISO, PCO cxxvi
component selector, PLS 1-6
components, PSG 4-3
directory server, OID 2-29
for Oracle Parallel Server, PSC 6-1
components, LSM, LEG 1-3
components, SSL, OID 2-22
composite foreign keys, SQL 7-239
composite indexes, SCN 10-24, STU 12-5
composite keys
restricting nulls in, ADG 4-16
composite limits
costs and, SAD 22-24
composite methods
partitioning and downgrading, MIG 13-24
composite partitioning, DWG 5-6, GTK 3-46, PSA 5-15, SAD 15-6
performance considerations, DWG 5-9
composite partitioning clause
of CREATE TABLE, SQL 7-386, SQL 7-403
composite partitions
examples of, STU 5-16
composite primary keys, SQL 7-239
composite types, PCO 11-18, PLS 2-11
composite unique constraints, SQL 7-238
COMPOSITE_LIMIT parameter
of ALTER PROFILE, SQL 7-69
of CREATE PROFILE, SQL 7-362
Compositing, ADQ 7-15
compound conditions, SQL 5-18
compound expressions, SQL 5-4
compound symbols, PLS 2-4
COMPRESS
Export parameter, SUT 1-17, SUT 2-51
COMPRESS clause
nested tables, ADO 6-16
of ALTER INDEX, SQL 7-32
of ALTER TABLE, SQL 7-144
of CREATE INDEX, SQL 7-300
of CREATE TABLE, SQL 7-397
compression of free space in data blocks, SCN 4-10
compression, index key, SCN 10-31
COMPUTE option
STATISTICS Export parameter, SUT 1-24
COMPUTE STATISTICS clause
of ANALYZE, SQL 7-204
of CREATE INDEX, SQL 7-301
COMPUTE STATISTICS clause of CREATE and ALTER INDEX statements, GTK 3-27
COMPUTE STATISTICS option, SAD 19-5
CONCAT function, SQL 4-20
CONCATENATE keyword
SQL*Loader, SUT 5-36
concatenated indexes, SCN 10-24
concatenation operator, NLS 4-12, PLS 2-47, SQL 3-3
treatment of nulls, PLS 2-51
concepts, LDAP, OID 2-1
concurrency, ADG 7-22, PCO 3-12, PLS 5-41
defined, SCN 1-29
definition of, PC_ 3-16
described, SCN 212
direct-load INSERT, SCN 154
enforced with locks, SCN 1-31
inserts and updates, PSA 8-4
limits on
per database, SCN 299
per user, SCN 297
maximum number of instances, PSA 3-3, PSC 7-21
partition maintenance, SCN 11-49
restrictions on, SCN 1-42, SCN 154
ROW_LOCKING initialization parameter, SRF 1-106
sequences, PSC 8-14
transactions and, SCN 226
transactions per rollback segment, SRF 1-120
concurrent access, MIG 3-17
concurrent connections, PC_ 3-7
concurrent conventional path loads, SUT 8-25
concurrent database connections, OID 13-11, OID F-5
concurrent logons, PCO 3-3
concurrent users, MIG 3-18
increasing the number of, DWG 18-9
conditional control, PLS 3-2
conditional precompilation, PC_ 2-15, PCO 2-25
defining symbols, PC_ 5-43, PCO 2-26
example, PC_ 2-15, PC_ 5-43, PCO 2-25
conditional predicates
trigger bodies, ADG 13-14, ADG 13-17
conditions
compound, SQL 5-18
EXISTS, SQL 5-18
group comparison, SQL 5-16
in SQL syntax, SQL 5-14
LIKE, SQL 5-18
membership, SQL 5-17
NULL, SQL 5-18
range, SQL 5-18
simple comparison, SQL 5-16
CONFIG OTT parameter, OCI 14-27, PC_ 19-29
CONFIG precompiler option, PC_ 10-15, PCO 14-14, PCO 14-15
configNLDAP.ora, OID B-9
configsets. See configuration set entries.
configuration
of standby environment, SBY 1-19
Configuration Assistant, PSG 6-10
configuration file
system versus user, PCO 14-16
configuration file name, PCO A-7
configuration files, PC_ 10-3
and the Object Type Translator, PC_ 19-5
cman.ora, NET C-70 to NET C-76
CyberSAFE, OAS B-2
Kerberos, OAS B-5
listener.ora, NET C-48 to NET C-58
location, PC_ 10-4
names.ora, NET C-59 to NET C-69
naming conventions, DCI 2-7
needed for servers in DCE, OAS 14-4
protocol addresses, NET B-1
SecurID, OAS B-5
syntax rules, NET C-2
system, PC_ 10-4
tnsnames.ora, NET C-31 to NET C-48
user, PC_ 10-4
configuration files directory
contents, UNIX, LEG 5-12
contents, Windows NT, LEG 5-20
configuration files for external procedures, DCI 4-5
configuration of a database
process structure, SCN 8-2
configuration of RMAN
for use with MTS, RMN 2-4
configuration options
standby databases, SBY 1-2
configuration parameters
configuration set entries, OID 2-30, OID 2-32
adding, OID 2-32, OID 5-2
using command line tools, OID 7-25
using Oracle Directory Manager, OID 5-4
attributes, OID F-5
changing, OID 3-9, OID 5-14
database connections, OID F-5
debug level, OID F-5
deleting, OID 5-2
using Oracle Directory Manager, OID 5-4
directory server processes, OID F-5
disabling SSL, OID F-5
for replication server, OID 10-10
LDIF file, OID 5-12
managing, OID 4-17, OID 5-2
using command line tools, OID 5-12
using Oracle Directory Manager, OID 5-4
modifying, OID 3-9, OID 5-2
in an active server instance, OID 5-4
using command line tools, OID 7-25
using Oracle Directory Manager, OID 5-4, OID 5-11
orcldebuglevel, OID F-5
orclmaxcc, OID F-5
orclserverprocs, OID F-5
orclssl authentication, OID F-5
orclsslenable, OID F-5
orclsslport, OID F-5
orclsslwalletpasswd, OID F-6
orclsslwalleturl, OID F-6
overriding user-specified, OID 3-10
replication
viewing with Oracle Directory Manager, OID 10-11
replication server, OID 10-9
SSL parameters in, OID 8-2
starting directory servers without using, OID 3-10
using different, OID 5-2
using multiple, OID 8-3
configuration set location, OID 5-16
configuration sets. See configuration set entries.
configuration, LSM
administrators
modifying on NT, LEG 2-29
modifying on UNIX, LEG 2-29
server resource, LEG 2-27
specifying, LEG 2-27, LEG 2-28
configuration roadmap, LEG 2-16
LSM resources
client dialog box, Windows NT, LEG 2-23
client resource, LEG 2-20
server resource, LEG 2-24
overview, LEG 2-2
resource dependencies, LEG 2-3
resource types, LEG 2-2, LEG 2-5
storage devices
configuring on UNIX, LEG 3-7, LEG 3-8
configuring on Windows, LEG 3-8, LEG 3-9, LEG 3-10
labeling a volume on UNIX, LEG 3-14
labeling a volume on Windows, LEG 3-15, LEG 3-16
labeling and mounting volumes, LEG 3-13
mounting a volume on UNIX, LEG 3-16
mounting a volume on Windows, LEG 3-17
server features, LEG 3-2
tape device, no-rewind name, LEG 3-2
types that LSM supports, LEG 3-2
unmounting a volume on UNIX, LEG 3-18
unmounting a volume on Windows, LEG 3-18
volume pools, LEG 3-10
configurations
change in redo log, PSA 3-8
for high availability, PSC 9-17
configure compatible command (RMAN), RMN 1-16, RMN 3-4
Configure Entry Management menu item, in Oracle Directory Manager, OID 4-11
Configure Prespawned Servers dialog box, NET 7-19
configuring
a server in DCE, OAS 14-4
Advanced Symmetric Replication (ASR), OID 10-3
using Oracle8 Replication Manager, OID 10-3
archive logs for backup and recovery, PSG 4-9 to PSG 4-16
Biometric Manager, OAS 8-12
cipher suites in SSL, OAS 10-22
client application failover, SBY 5-36
clients
access control with Oracle Connection Manager, NET 8-37
client load balancing, PSG 4-2
connection concentration, NET 8-30
connect-time failover, NET 2-21, NET 8-4, PSG 4-2
default domains, NET 8-17
local naming, NET 6-15
multi-protocol support, NET 8-33
naming methods in profile, NET 8-19
Oracle Connection Manager, NET 8-38
Oracle Names, NET 6-60
primary and secondary instances, PSG 5-8
Transparent Application Failover, NET 2-21
clients for DCE integration, OAS 14-12
clients to use CDS, OAS 14-15
clients to use DCE CDS naming, OAS 14-15
connection concentration, NET 8-28
connection pooling, NET 9-9
connection requests in a profile, NET 8-21
CyberSafe authentication service parameters, OAS 5-6
DCE CDS for use by Oracle DCE Integration, OAS 13-3
DCE GSSAPI authentication, OAS 9-2
DCE to use DCE Integration, OAS 13-2
directory naming, NET 6-16 to NET 6-46
Directory Replication Groups (DRGs), OID 10-2
domains, default, NET 8-26
enterprise domain, OAS 17-28
enterprise user security, OAS 17-20
external naming, NET 6-79 to NET 6-88
external procedures, NET 8-45
global database name, PSG 3-4
Heterogeneous Services connections, NET 7-13, NET 8-49
high availability, PSG 5-1 to PSG 5-16
primary and secondary instances, PSG 5-6
TAF, PSG 5-2
Transparent Application Failover, PSG 5-2
host naming, NET 6-74 to NET 6-78
Identix authentication, OAS 8-8
initialization parameter file, SBY 5-6, SBY 5-8, SBY 5-17, SBY 5-19
Kerberos authentication service parameters, OAS 6-5
listener.ora file, SBY 5-5
listeners, NET 7-1 to NET 7-20
directory naming, NET 6-28
host naming, NET 6-75
local naming, NET 6-15
Oracle Names, NET 6-64
primary and secondary instances, PSG 5-9
local naming, NET 6-5 to NET 6-15
localized management, NET 6-4
multiple addresses, NET 8-2
multiple domains in Oracle Names, NET 6-53, NET 6-58
multi-protocol support, NET 8-32
naming methods, NET 6-1 to NET 6-88
net service names
directory naming, NET 6-23
external naming, NET 6-79
local naming, NET 6-6
Oracle Names, NET 6-65
Net8 access control, NET 8-35
Net8 OPEN, NET 10-7
network files, SBY 2-27, SBY 5-4
Oracle as a SecurID client, OAS 7-4
Oracle Enterprise Manager, PSG 6-10 to PSG 6-27
Oracle for Net8/DCE, OAS 14-1
Oracle Intelligent Agents on UNIX, PSG B-10 to PSG B-11
Oracle Names, NET 6-47 to NET 6-74
Oracle Names servers, NET 6-51
Oracle Parallel Server Management, PSG 6-1 to PSG 6-34
Oracle Performance Manager, PSG 6-27 to PSG 6-34
Oracle Rdb database connections, NET 8-52
Oracle server with CyberSafe, OAS 5-3
Oracle server with Kerberos, OAS 6-3
overview, NET 6-2
parameter file, SCN 5-4
prespawned dedicated servers, NET 7-16
primary and secondary instances, PSG 5-6
process structure, SCN 8-2
protocol addresses, NET 7-6, NET B-1
RADIUS authentication, OAS 4-10
Recovery Manager, PSG 4-9 to PSG 4-16
region database for Oracle Names, NET 6-50, NET 6-54
replicated data among Oracle Names servers, NET 6-55
replication, OID 10-9
agreements, OID 10-9, OID 10-14
server parameters, OID 10-10
schemaless users, OAS 17-13
SecurID authentication service, OAS 7-7
server for DCE Integration, OAS 14-4
server parameters
using command line tools, OID 4-17
using Oracle Directory Manager, OID 4-17
servers
connection concentration, NET 8-29
local naming, NET 6-6
Oracle Names, NET 6-60
servers, using input files, OID 7-25
SID Prefix, PSG 3-4
SSL, OAS 10-10, OID 4-4, OID 8-2
on the client, OAS 10-11
on the server, OAS 10-19
system to use custom applications, NET 10-8
TAF, PSG 5-2
Thin JDBC support, OAS 3-1
tnsnames.ora file, SBY 5-4
Transparent Application Failover, PSG 5-2
configuring generic connectivity, DDS 8-6
configuring transparent gateways, DDS 7-2
conflict resolution, RAR 6-1, REP 2-42, REP 5-1
additive method, SPR 37-12, RAR 6-11, RAR 8-78, REP 5-15
append sequences method, REP 5-25
append site name method, REP 5-24
auditing, RAR 6-29
average method, RAR 6-11, REP 5-16
avoiding conflicts, REP 5-7
column groups, RAR 6-4, RAR 6-6, RAR 6-9, RAR 6-11, RAR 6-13, RAR 6-17, REP 5-10
concepts, REP 5-2
data requirements, REP 5-2
DBA_REPRESOLUTION_STATISTICS view, RAR 6-30
delete conflicts, REP 5-4
detecting conflicts, REP 5-5
discard method, RAR 6-3, REP 5-17, REP 5-25
dynamic site ownership, REP 5-7
in synchronous propagation, REP 2-33
information
viewing, RAR B-10
latest timestamp method, REP 5-12
manual, OID 10-26
maximum method, RAR 6-5
maximum value method, REP 5-18
methods for delete conflicts, REP 5-26
methods for uniqueness conflicts, REP 5-24
methods for update conflicts, REP 5-11
minimum method, RAR 6-5
minimum value method, REP 5-20
overwrite method, RAR 6-3
overwrite methods, REP 5-13
performance, REP 5-26
compare old values, REP 5-27
min communication, REP 5-26
send old values, REP 5-27
preparing for, RAR 6-2
primary site ownership, REP 5-7
priority groups, RAR 6-13
priority groups method, REP 5-21
procedural replication and, REP 6-3
replication, REP 2-10
site priority, RAR 6-16
site priority method, REP 5-22
statistics, SPR 37-25, SPR 37-74, RAR 8-91, RAR 8-140
canceling, RAR 6-30
gathering, RAR 6-29
viewing, RAR 6-29
timestamp methods, RAR 6-7
transaction ordering, REP 5-4
types of conflicts, REP 5-3
uniqueness conflicts, REP 5-3
update conflicts, REP 5-3
user-defined methods, RAR B-2
example, RAR B-4
for delete conflicts, RAR B-4
for uniqueness conflicts, RAR B-3
for update conflicts, RAR B-3
parameters, RAR B-2
restrictions, RAR B-4
viewing information, RAR B-10
conflicting access control policies, OID 9-3
precedence rules for resolving, OID 9-3
conflicts
avoiding, REP 5-7
delete, RAR 6-25
dynamic ownership, REP 6-11
delete, REP 5-4
avoiding, REP 5-8
detecting, REP 2-33, REP 2-41, REP 5-5
identifying rows, REP 2-42, REP 5-6
error queue, REP 5-11
notification log table
creating, RAR B-6
sample, RAR B-7
notification methods
user-defined, RAR B-6
notification package
creating, RAR B-7
sample, RAR B-8
ordering
avoiding, REP 5-8
procedural replication, REP 1-17, SCN 437
token passing, REP 6-12
uniqueness, REP 5-3
avoiding, REP 5-8
update, REP 5-3
avoiding, REP 5-8
workflow, REP 6-11
conflicts, replication
attribute-level, OID 10-25
automated resolution of, OID 10-26
entry-level, OID 10-25
manual resolution of, OID 10-26
resolution, OID 9-11, OID 10-24
messages, OID 10-27
typical causes of, OID 10-25
CONNECT @instance-path command, PSA 3-6
CONNECT BY clause
of SELECT, SQL 5-21, SQL 7-577
optimizing view queries, STU 4-77
CONNECT clause
of SELECT and subqueries, SQL 7-571
CONNECT command, PSA 4-4, PSA 4-6
forcing a checkpoint, PSA 13-14
starting an instance, SAD 3-2
connect command (RMAN), RMN 10-51, RMN 10-53
connect descriptors
described, NET 1-5, NET C-31
connect functions, OCI 15-90
connect identifiers
syntax, NET 11-10
CONNECT INTERNAL, SCN 5-3
example of, PSA 1-5
CONNECT INTERNAL desupported, GTK 7-6
connect operations, NET 2-3
CONNECT role, SAD 23-5, SCN 324, SQL 7-530
user-defined types, ADO 2-11
CONNECT statement, PC_ F-26, PCO F-17
AT clause, PCO 3-6
AT clause in, PC_ 3-9
connecting to Oracle with, PC_ 3-2
enabling a semantic check, PCO E-3
examples, PC_ F-28, PCO F-19
logging on to Oracle, PCO 3-2
placement, PCO 3-2
requirements, PCO 3-2
requirements for, PC_ 3-2
USING clause, PCO 3-6
USING clause in, PC_ 3-9
using to enable a semantic check, PC_ D-4
when not required, PCO 3-10
connect string
Net8, SUT 1-53
connect strings, NET 11-2, PSA 4-4
CONNECT THROUGH privileges
revoking, MIG 13-46
CONNECT TO clause
of CREATE DATABASE LINK, SQL 7-274
CONNECT_DATA parameter, NET C-42
CONNECT_TIME parameter
of ALTER PROFILE, SQL 7-69
of ALTER RESOURCE COST, SQL 7-74
of CREATE PROFILE, SQL 7-361
CONNECT_TIMEOUT_listener_name parameter, NET C-54
Connect/Disconnect button in Oracle Directory Manager, OID 4-11
connected user database links, DDS 2-12
advantages and disadvantages, DDS 1-17
creating, DDS 2-12
definition, DDS 1-17
example, DDS 1-20
REMOTE_OS_AUTHENT initialization parameter, DDS 1-18
connectibility, SCN 1-2
connecting
across cells, OAS 14-6
Oracle Enterprise Manager repository database, PSG 6-28
Oracle Parallel Server database, PSG 4-3
to a directory server, OID 4-3, OID 4-4, OID 4-17
using Oracle Directory Manager, OID 4-11
to additional directory servers, OID 4-12
to an Oracle database
to verify roles, OAS 14-9
to an Oracle database in DCE, OAS 15-1
to an Oracle server in DCE, OAS 15-3
with username/password, OAS 15-3
without username and password, OAS 15-3
to another cell, OAS 14-6
to directory, OID 2-33
to instances, PSA 4-3
to multiple directory servers, OID 4-12
to remote instances, PSA 4-4
connecting to Oracle, PC_ 3-2, PCO 3-2
automatic connections, PC_ 3-4
automatically, PCO 3-9
concurrently, PC_ 3-7, PCO 3-3
example of, PC_ 3-2, PCO 3-2
using Net8, PC_ 3-7
via Net8, PCO 3-3
connecting with username/password
with authentication configured, OAS 11-2
connection
as a function of UTL_TCP, SPR 66-2
function of UTL_SMTP, SPR 65-2
connection concentration, NET 4-6, NET 8-28
advantages relative to connection pooling, NET 5-7
using to improve network performance, NET 5-7
Connection is closed - error, ADQ D-3
Connection is in stopped state - error, ADQ D-3
Connection is invalid - error, ADQ D-3
connection load balancing, NET xviii, NET 2-26, PSG 3-13
service registration, NET 2-24
connection manager, STU 22-17
Connection Manager, Oracle, GTK 4-6
connection mode
non-blocking, OCI 2-37
connection multiplexing, GTK 4-6
Connection must be specified - error, ADQ D-3
connection options
Recovery Manager, RMN 2-9
auxiliary database, RMN 2-12
hiding passwords, RMN 2-13
with a catalog, RMN 2-10
without a catalog, RMN 2-9
connection pooling, OID 1-4, GTK 4-6, SCN 287, STU 21-8
advantages relative to connection concentration, NET 5-7
configuring, NET 9-9
using to improve network performance, NET 2-12, NET 5-6
using with multi-threaded server, NET 9-9
connection qualifiers, REP 2-14
database links and, DDS 2-13
diagnosing problems with, REP B-2
connection redirection, OID 14-9
hardware-based, OID 14-6
network-level, OID 14-6
software-based, OID 14-7
connections, NET 2-9
adjusting listener queue size to avoid errors, NET 7-12
adjusting listener queuesize to avoid errors, NET 5-6
auditing, SAD 24-8
bequeath, NET 2-19
concurrent, PC_ 3-12
concurrent, increasing number of, NET 7-12
connect strings, entering, NET 11-2, NET 11-10
dedicated servers, NET 2-13, NET 8-21
default versus non-default, PC_ 3-8, PCO 3-5
defined, SCN 8-4
directory naming, NET 6-29
embedded SQL, SCN 14
Explicit connections, PC_ 3-8
external procedures, NET 8-45
Heterogeneous Services, NET 8-49
host naming, NET 6-78
implicit, PC_ 3-14, PCO 3-11
listener process and, SCN 6-6, SCN 8-14
load balancing in Net8, MIG 9-47
local and remote, MIG 3-17
with multithreaded shared server, MIG 3-17
local naming, NET 6-15
methods of, NET 11-11
multi-threaded server, NET 2-7, NET 9-2
naming, PCO 3-5
naming of, PC_ 3-8
NDS external naming, NET 6-83
Network Information Service external naming, NET 6-79
NIS external naming, NET 6-79
Novell Directory Services external naming, NET 6-83
Oracle Connection Manager, NET 1-3, NET 8-21
Oracle Names, NET 6-74
Oracle Rdb databases, NET 8-52
Oracle8i JServer, NET 3-16
remote
terminating, DDS 3-2
restricting, SCN 5-6
routing, NET 1-3
sessions contrasted with, SCN 8-4
startup of components, NET 11-4
to services, NET 1-5
with administrator privileges, SCN 5-3
audit records, SCN 333
CONNECTIONS (CON or CONN) attribute, NET 9-5
connect-time failover, NET xviii, NET C-39, PSC 8-10
configuring, NET 8-4, PSG 4-2
described, PSG 4-2
GLOBAL_DBNAME parameter in listener.ora, MIG F-15, NET 7-13, NET 8-4, NET C-39
GLOBAL_DBNAME parameter in listener.ora file, PSG 3-15
service registration, NET 2-23
with TAF, PSG 5-4
with Transparent Application Failover, PSG 5-4
CONSIDER FRESH clause
of ALTER MATERIALIZED VIEW, SQL 7-55
consistency
multiversion read, PSC 1-4, SRF 1-42
of object cache, OCI 13-4
read, STU 18-10
read-only transactions, ADG 7-8
rollback information, PSC 7-6, SRF 1-42
consistency of data, SCN 1-54
multiversion consistency model, SCN 1-30
See also read consistency
CONSISTENT
Export parameter, SUT 1-17
nested table and, SUT 1-17
partitioned table and, SUT 1-17
consistent backups
definition, SBR 1-5, SBR 1-23
whole database, SBR 1-16, SBR 4-4
consistent gets statistic, STU 19-28, STU 21-4, STU 21-21
consistent mode
TKPROF, STU 6-13
consistent-read blocks, PSA 12-2
Console
described, PSG 2-3, PSG 6-2
Event Management window, PSG 6-2
Group window, PSG 6-2
Job window, PSG 6-2
Navigator window, PSG 6-2
Navigator window with Oracle Parallel Server objects, PSG 7-3
right-mouse menu, PSG 7-5
Connect, PSG 7-6
Disconnect, PSG 7-6
Edit, PSG 7-6, PSG 7-16
Related Tools, PSG 7-6
Remove, PSG 7-6
Results, PSG 7-6, PSG 7-12
Shutdown, PSG 7-6, PSG 7-9
Startup, PSG 7-6, PSG 7-7
scheduling jobs, PSG 7-19
setup, PSG 6-7
starting, PSG 6-12
starting Oracle Parallel Server database, PSG 7-7
stopping Oracle Parallel Server database, PSG 7-9
viewing Oracle Parallel Server status, PSG 7-16
viewing shutdown results, PSG 7-12
viewing startup results, PSG 7-12
consolidating extents
Export parameter COMPRESS, SUT 1-17
const
declaring constants, PC_ 5-45
CONSTANT keyword
SQL*Loader, SUT 5-47, SUT 5-54, SUT 8-23
constant values. See literals
constants
comparisons and, STU 4-65
declaring, PLS 2-31
evaluation of expressions, STU 4-65
in stored procedures, SCN 26
syntax, PLS 11-33
when computed, STU 4-65
constraining tables, ADG 13-22
CONSTRAINT clause
of constraint_clause, SQL 7-237
constraint clause, SQL 7-233
constraint processing, GTK 4-15
constraint violations, REP B-4
CONSTRAINT(S) parameter
of ALTER SESSION, SQL 7-86
CONSTRAINTS
Export parameter, SUT 1-19, SUT 2-19
constraints, ADO 9-25, DWG 7-2, DWG 9-13, SCN 1-57, STU 12-11
See also integrity constraints
adding, SQL 7-140
alternatives to, SCN 255
application development issues, DDS 3-3
applications can find violations, SCN 256
automatic
SQL*Loader, SUT 8-22
CHECK, SCN 271
check, SQL 7-241
Import, SUT 2-45
checking at end of transaction, SQL 7-243
checking at start of transaction, SQL 7-243
checking at the end of each DML statement, SQL 7-243
column REF, SQL 7-242
composite unique, SQL 7-238
composite UNIQUE keys, ADG 4-7
constraint modification with ALTER TABLE, GTK 3-28
default values and, SCN 274
deferrable, SQL 7-243, SQL 7-598
enforcing, SQL 7-86
defined, SCN 10-4
defining, SQL 7-237, SQL 7-390
on a column, SQL 7-393
on a table, SQL 7-393
direct path load, SUT 8-20
DISABLE VALIDATE constraint state, GTK 3-28
disabling, SQL 7-165, SQL 7-245, SQL 7-405
cascading, SQL 7-408
disabling at table creation, SAD 19-17
disabling during a direct load, SUT 8-21
disabling referential constraints, SUT 2-14
disabling temporarily, SCN 257
dropping, SQL 7-146, SQL 7-504
dropping integrity constraints, SAD 19-20
effect on performance, SCN 257
enable novalidate state, SAD 19-16
ENABLE or DISABLE, SCN 276
enabling, SQL 7-165, SQL 7-244, SQL 7-405, SQL 7-407
after a direct load, SUT 8-21
after a parallel direct path load, SUT 8-29
enabling example, SAD 19-18
enabling when violations exist, SAD 19-16
enforced on a direct load, SUT 8-21
enforced with indexes, SCN 10-25
PRIMARY KEY, SCN 262
UNIQUE, SCN 260
exceptions, SAD 19-16, SAD 19-21
exceptions to integrity constraints, SAD 19-21
failed
Import, SUT 2-45
FOREIGN KEY, SCN 1-58, SCN 263
foreign key, DWG 7-5, SQL 7-240
integrity constraint states, SAD 19-15
load method, SUT 8-9
mechanisms of enforcement, SCN 271
modifying, SCN 277
modifying existing, SQL 7-144
NOT NULL, PLS 2-32, SCN 257, SCN 261
not null, SQL 7-239
Import, SUT 2-45
object tables, ADO 2-3
on columns, SQL 7-237
on Oracle objects, ADO 6-37
ORA-02055
constrain violation, DDS 3-3
overview, SCN 1-57
parallel create table, SCN 181
preventing Import errors due to uniqueness constraints, SUT 2-19
PRIMARY KEY, SCN 1-58, SCN 261
primary key, SQL 7-239
attributes of index, SQL 7-244
enabling, SQL 7-407
prohibited in views, SCN 10-13
referential
effect of updates, SCN 266
self-referencing, REP 2-16, SCN 265
referential integrity, SQL 7-239, SQL 7-240
Import, SUT 2-45
REFs, ADO 6-9
RELY, DWG 7-5
restore, RMN 1-60
restriction on stored functions, ADG 9-57
restrictions, SQL 7-237
scope, SQL 7-242
SCOPE FOR constraint, ADO 9-30, ADO 9-32
setting at table creation, SAD 19-17
setting state for a transaction, SQL 7-598
storing rows in violation, SQL 7-163, SQL 7-245, SQL 7-407
table REF, SQL 7-242
triggers cannot violate, SCN 102
triggers contrasted with, SCN 85
types listed, SCN 1-57, SCN 251
unique, DWG 7-3, SQL 7-238
attributes of index, SQL 7-244
composite, SQL 7-238
enabling, SQL 7-407
UNIQUE key, SCN 1-58, SCN 258
partially null, SCN 261
uniqueness
Import, SUT 2-45
VALIDATE or NOVALIDATE, SCN 276
validating, SQL 7-244, SQL 7-245
what happens when violated, SCN 255
when evaluated, SCN 10-9
when to disable, SAD 19-16
where not allowed, PLS 7-4
with partitioning, DWG 7-6
with query rewrite, DWG 19-29
constraints, object classes, OID 2-10
constructor method, DCI 3-4
constructor methods, ADO 1-4, ADO 7-2, SCN 1-56, SCN 13-6
and object types, SQL 7-439
literal invocation of, ADO 2-3
constructors
collection, PLS 4-8
object, PLS 9-12
Consumer is closed - error, ADQ D-3
consumer servers, OID 2-12, OID 2-15, OID 2-16
Consumers, ADQ 7-3
content access items, OID 9-20
access control points, OID 9-20
modifying, OID 9-33
contention
block, PSA 7-14, PSA 8-9, PSA 8-11, PSC 7-7, PSC 7-21
block-level, SRF 3-124
disk, PSC 7-2, PSC 7-7
disk access, STU 20-18
distributed lock, PSA 7-14
for data
deadlocks, SCN 8-20, SCN 227
lock escalation does not occur, SCN 227
for rollback segments, SCN 4-23
free lists, STU 21-20
memory, STU 19-2
memory access, STU 21-1
redo allocation latch, STU 21-19
redo copy latches, STU 21-19
rollback segment, PSC 7-6, PSC 7-7
rollback segments, STU 21-3
sequence number, PSC 8-13
SYSTEM tablespace, PSA 3-4
table data, PSA 8-11, PSC 7-2, PSC 7-6
tuning, STU 21-1
tuning resource, STU 2-13
context
switching, PLS 4-30
transaction, PLS 5-55
WITH CONTEXT clause, DCI 4-9
CONTEXT ALLOCATE SQL statement, PC_ F-28
CONTEXT ALLOCATE statement, PC_ 11-8, PCO 12-8, PCO F-19
context area, STU 2-12
context block
definition of, PC_ 20-4
CONTEXT FREE statement, PC_ 11-9, PC_ F-29, PCO 12-8, PCO F-20
context namespaces
removing from the database, SQL 7-474
CONTEXT OBJECT OPTION GET SQL statement, PC_ 17-18
CONTEXT OBJECT OPTION SET SQL statement, PC_ 17-18
context switches
reduced with Cache Fusion, PSA 12-4
context switching, STU 18-6
CONTEXT USE directive, PC_ 11-8, PCO 12-8
CONTEXT USE SQL directive, PC_ F-33, PCO F-21
CONTEXT USE SQL statement, PC_ 11-8, PCO 12-8
contexts
creating namespaces for, SQL 7-261
granting
system privileges on, SQL 7-521
namespace
associating with package, SQL 7-261
continuation lines
syntax, PCO 2-13
CONTINUE action
in the WHENEVER statement, PC_ 9-25
of WHENEVER directive, PC_ F-119, PCO 8-16, PCO F-93
result of, PC_ 9-25
CONTINUE_LOAD keyword
SQL*Loader, SUT 5-35
CONTINUEIF keyword
example, SUT 4-15
SQL*Loader, SUT 5-36
continuing interrupted loads
SQL*Loader, SUT 5-34
continuous pushes
scheduling, REP 7-11, REP 7-12
CONTROL
SQL*Loader command-line parameter, SUT 6-4
control file records
overwriting, RMN 3-47
control files, GTK 3-52, SBR 2-3 to SBR 2-6, SCN 1-10, SCN 362
adding, SAD 5-5
allow reuse of, SQL 7-264
allowing reuse of, SQL 7-269
altering, SBY 4-12, SBY 5-26
backing up, PSA 13-1, SBR 2-5, SBR 4-3, SBR 4-13, SCN 366, SQL 7-20
using RMAN, RMN 5-7
backing up to trace file, SBR 4-14
backup and recovery, RMN 6-22
changes recorded, SCN 363
changing size, SAD 5-4
checkpoints and, SCN 363
conflicts with data dictionary, SAD 5-8
contents, SBR 1-7, SBR 2-3, SCN 362
CONTROL_FILES initialization parameter
for primary and standby databases, SBY 2-19
creating, PSA 3-9, SBR 6-14, SBY 2-8, SBY 5-15
about, SAD 5-2
additional control files, SAD 5-5
initially, SAD 5-4
new files, SAD 5-5
data definition language syntax, SUT 5-3
data files, PSA 8-10
default name, SAD 2-21, SAD 5-4
definition, SBR 1-7
described, PSG 1-14
dropping, SAD 5-9
effect on standby databases, SBY 4-12
errors during creation, SAD 5-9
field delimiters, SUT 5-16
finding filenames, SBR 4-3
guidelines for, SAD 5-2 to SAD 5-3
guidelines for creating, SUT 3-3
how specified, SCN 5-4
importance of multiplexed, SAD 5-3
incomplete recovery, SBR 5-26
location of, SAD 5-3
log history, PSA 3-3, PSA 13-7
log sequence numbers, SAD 6-5
loss of, SBR 6-12
all copies, SBR 6-13
maintaining backups, SBR 2-6, SBR 2-8
MAXLOGHISTORY, PSC 7-5
mirrored, SAD 5-3, SBR 2-8
loss of, SBR 6-12
mirroring, SAD 2-21
moving, SAD 5-5
multiplexed, SBR 2-6, SBR 2-7, SBR 2-8, SCN 1-48, SCN 363
importance of, SAD 5-3
names, SAD 5-2, SRF 1-21
number of, SAD 5-3, SBR 2-8
overview, SBR 1-7, SCN 1-10, SCN 362
overwriting existing, SAD 2-21
overwriting records, RMN 3-47
parameter values, PSA 1-9
purpose, SBR 1-8
raw devices, PSG 2-6
recovering from loss of, SBR 2-8
recovery and, SCN 1-48
re-creating, SQL 7-263
refreshing standby database, SBY 4-15, SBY 5-26
relocating, SAD 5-5
renaming, SAD 5-5
renaming or removing for migration, MIG 4-25, MIG 7-17, MIG 13-58
requirement of one, SAD 5-2
restoring, RMN 6-12
to default location, SBR 6-13
to non-default location, SBR 6-13
using dbid, RMN 6-36
using RMAN, RMN 6-12, RMN 6-13
setting the CONTROL_FILES initialization parameter, SBR 2-8
size of, SAD 5-3
snapshot
specifying location of, RMN 2-3
specifying, SRF 1-21
specifying data, SUT 5-21
specifying names before database creation, SAD 2-21
specifying SQL*Loader discard file, SUT 5-27
time-based recovery, SBR 5-28
troubleshooting, SAD 5-8
unavailable during startup, SAD 3-4
updating, SBR 2-5
used in mounting database, SCN 5-6
using instead of a recovery catalog, RMN 1-17
control structures, PLS 3-2
conditional, PLS 3-2
iterative, PLS 3-6
sequential, PLS 3-15
control utilities
CMCTL, NET 4-29, NET A-81 to NET A-97
described, NET A-1
LSNRCTL, NET 4-29, NET A-4 to NET A-25
NAMESCTL, NET 4-30, NET A-28 to NET A-79
control, access, OID 1-5, OID 9-1
CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, RMN 3-47, SRF 1-21
preventing overwrite of RMAN records, RMN 3-47
CONTROL_FILE_RECORD_KEEP_TIME parameter
of ALTER SYSTEM, SQL 7-108
CONTROL_FILES initialization parameter, RMN 6-12, RMN 8-8, SBR 2-8, SBR 4-3, SBR 6-13, SBY 2-19, SBY 5-2, SBY 5-9, SRF 1-21
overwriting existing control files, SAD 2-21
setting
before database creation, SAD 2-21, SAD 5-4
names for, SAD 5-2
warning about setting, SAD 2-21
CONTROL_FILES parameter, PSA 1-8, PSA 14-11, PSG 4-7
same for all instances, PSA 1-8
controlfile clauses
of ALTER DATABASE, SQL 7-9
CONTROLFILE REUSE clause
of CREATE DATABASE, SQL 7-269
ContText
migrating to interMedia, MIG 4-7, MIG 5-6
CONVBUFSZ clause, PC_ 4-51, PCO A-8
CONVBUFSZ clause in VAR statement, PCO 4-45
conventional path Export
compared to direct path Export, SUT 1-42
conventional path loads
basics, SUT 8-2
compared to direct path loads, SUT 8-7
concurrent, SUT 8-26
SQL*Loader bind array, SUT 5-75
using, SUT 8-3
conventions
description of, PC_ xvi
naming, DCI 2-8, PLS 2-36
notation, PC_ xvi
used in documentation, LEG viii
conventions used in this manual, PCO cxxv
conversion
rules, string to date, SQL 2-53
Conversion failed - invalid property type - error, ADQ D-4
conversion functions, ADG 3-25, SQL 4-5
table of, SQL 2-37
TO_CHAR function, ADG 3-12
TO_CHAR function, year and century considerations, ADG 3-11
TO_DATE function, ADG 3-11
when needed, PLS 2-29
conversion, datatype, PLS 2-28
conversions
between character set ID number and character set name, NLS 4-6
character set, ADL 11-47
character set conversions needed on BFILE before using LOADFROMFILE(), ADL 10-34
from binary data to character set, ADL 11-47
See also binds HEX to RAW
CONVERT clause
of ALTER DATABASE, SQL 7-11
CONVERT function, NLS 4-5, NLS 4-6, SQL 4-21
convert queue, PSC 5-28
converting
auxiliary object classes, OID 6-4
structural object classes, OID 6-4
converting character sets, NLS 4-5
converting data, ADG 3-25
ANSI datatypes, ADG 3-24, SCN 12-23
assignments, ADG 3-25
expression evaluation, ADG 3-27
program interface, SCN 8-27
SQL/DS and DB2 datatypes, ADG 3-24, SCN 12-23
converting to LOB data types, ADL 6-3
cookies, ADG 12-2
coordinated time-based recovery
distributed databases, SBR 6-17
copy command (RMAN), RMN 10-55
copy semantics, ADL 2-3
internal LOBs, ADL 9-27
Copy Template Wizard, REP 8-26
copying
all or part of a LOB to another LOB
internal persistent LOBs, ADL 9-143
all or part of one temporary LOB to another, ADL 10-98
for BFILEs there is no copy function, ADL 11-185
LOB locator
internal persistent LOBs, ADL 9-154
LOB locator for BFILE, ADL 11-152
LONG to LOB, ADL 6-3, ADL 9-59
objects, OCI 10-32
temporary LOB locator, ADL 10-108
TO_LOB limitations, ADL 9-60
copying data
large cluster tables, MIG 3-15
migration method, MIG 3-14
space requirements, MIG 3-15
COR, see complex object retrieval
CORBA, GTK 3-19
CORE_DUMP_DEST initialization parameter, SRF 1-22
CORE_DUMP_DEST parameter
of ALTER SYSTEM, SQL 7-108
CORR function, DWG 17-48, SQL 4-22
correlated subqueries, SQL 5-25
correlated subquery, PLS 5-11
correlation identifier, ADQ 1-10
correlation names, ADG 13-13 to ADG 13-17
for base tables of indexes, SQL 7-298
in DELETE, SQL 7-467
in SELECT, SQL 7-576
inline views, SCN 10-17
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
detecting, RMN 1-66, RMN 1-67
maximum acceptable number, RMN 10-143
records in control file, RMN 1-48
RMAN and, RMN 1-47
setting maximum for backup, RMN 5-28
corruption
data block
repairing, SAD 20-2 to SAD 20-14
corruption detection, RMN 1-66, RMN 1-67
using set maxcorrupt command, RMN 10-143
corruption of package, DCI 5-10
COS function, SQL 4-23
COSH function, SQL 4-24
COST column
PLAN_TABLE table, STU 5-5
cost-based optimization, DDS 3-5, SCN 130, SCN 417, SRF 1-86, STU 4-12
distributed databases, DDS 1-47
extensible optimization, SCN 140, STU 4-32
favoring IN-list iterators, SRF 1-84
hints, DDS 3-8
histograms, SCN 131, STU 8-17
procedures for plan stability, STU 10-8
query rewrite, SCN 10-18
selectivity of predicates, SCN 131, STU 8-2
histograms, SCN 131, SCN 133, STU 8-17
user-defined, SCN 141, STU 4-33
star queries, STU 4-62
statistics, SCN 131, STU 4-10, STU 8-2
user-defined, SCN 141, STU 4-33
upgrading to, STU 10-9
user-defined costs, SCN 141, STU 4-33
using for distributed queries, DDS 3-5
cost-based optimizations, DWG 18-64
parallel execution, DWG 18-64
star queries, DWG 16-2
cost-based rewrite, DWG 19-3
costs
resource limits and, SAD 22-24
COUNT aggregate function, PLS 5-3
COUNT attribute of collection types, ADO 9-21
COUNT collection method, PLS 4-22
count column
SQL trace, STU 6-12
COUNT function, SQL 4-24
COVAR_POP function, DWG 17-47
COVAR_SAMP function, DWG 17-48
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-4
column
SQL trace, STU 6-12
detecting problems, STU 18-4
system architecture, STU 18-13
tuning, STU 18-1
utilization, DWG 5-2, DWG 18-2, STU 9-15
CPU service time required
calculating, PSA 11-8
CPU Statistics data view, STU 14-12
CPU Statistics for Parse/Execute/Fetch drilldown data view, STU 14-19
CPU time limit, SCN 296
CPU utilization
reduced with Cache Fusion, PSA 12-4
CPU_COUNT initialization parameter, SRF 1-22, STU 24-17
CPU_PER_CALL parameter
of ALTER PROFILE, SQL 7-69
of CREATE PROFILE, SQL 7-361
CPU_PER_SESSION parameter
of ALTER PROFILE, SQL 7-69
of ALTER RESOURCE COST, SQL 7-74
of CREATE PROFILE, SQL 7-361
CPUs
adding, PSC 2-3
in capacity planning, OID 12-2
processing power, OID 12-15
requirements
estimating, OID 12-16
in capacity planning, OID 12-15
single, uniprocessor, PSC 2-3
tuning, OID 13-3
tuning for Oracle foreground processes, OID 13-6
when to tune, OID 13-3
CR Server
change summary for 8.1, PSC A-3
crash recovery, SCN 344, SCN 354
instance failure, SCN 1-45, SCN 5-11, SCN 344
opening a database, SCN 5-9
read-only tablespaces, SCN 346
required after aborting instance, SCN 5-10
SMON process, SCN 1-17, SCN 8-11
CREAT DATABASE
MAXLOGHISTORY clause, PSA 3-3
Create a Non-Persistent Queue, ADQ 9-27
Create a Queue, ADQ 9-20
CREATE ANY CLUSTER system privilege, SQL 7-521
CREATE ANY CONTEXT system privilege, SQL 7-521
CREATE ANY DIMENSION system privilege, SQL 7-522
CREATE ANY DIRECTORY system privilege, SQL 7-522
CREATE ANY INDEX system privilege, SQL 7-522
CREATE ANY INDEXTYPE system privilege, SQL 7-522
CREATE ANY LIBRARY system privilege, SQL 7-523
CREATE ANY MATERIALIZED VIEW system privilege, SQL 7-523
CREATE ANY OPERATOR system privilege, SQL 7-524
CREATE ANY OUTLINE system privilege, SQL 7-524
CREATE ANY PROCEDURE system privilege, SQL 7-524
CREATE ANY SEQUENCE system privilege, SQL 7-525
CREATE ANY SNAPSHOT system privilege, SQL 7-526
CREATE ANY SYNONYM system privilege, SQL 7-526
CREATE ANY TABLE system privilege, SQL 7-526
CREATE ANY TRIGGER system privilege, SQL 7-527
CREATE ANY TYPE privilege, ADO 2-10
See also privileges
CREATE ANY TYPE system privilege, SQL 7-528
CREATE ANY VIEW system privilege, SQL 7-529
Create button, in Oracle Directory Manager, OID 4-12
create catalog command (RMAN), RMN 10-59
CREATE CLUSTER
statement, SQL 7-254
system privilege, SQL 7-521
CREATE CLUSTER command, ADG 2-6, ADG 5-15
hash clusters, ADG 5-19
HASH IS option, ADG 5-20
HASHKEYS option, ADG 5-20
CREATE CLUSTER statement, PSA 8-5, PSC A-22, STU 12-27
creating clusters, SAD 16-7
example, SAD 16-7
for hash clusters, SAD 17-4
FREELIST GROUPS option, PSA 8-4
FREELISTS option, PSA 8-4
HASH IS option, SAD 17-4, SAD 17-6
HASHKEYS clause, SCN 10-57, SCN 10-61
HASHKEYS option, SAD 17-4, SAD 17-7
SINGLE TABLE HASHKEYS clause, SCN 10-61
SIZE option, SAD 17-6
storage parameters, SCN 4-18
CREATE CONTEXT statement, ADG 11-52, GTK 3-69, SQL 7-261
CREATE CONTROLFILE statement, PSA 3-9, SQL 7-263
about, SAD 5-5
and recovery, RMN 6-18
changing database options, PSA 3-9
checking for inconsistencies, SAD 5-8
exclusive mode, PSC B-3
MAXLOGHISTORY, PSA 13-7
NORESETLOGS option, SAD 5-7
RESETLOGS option, SAD 5-7
standby database, effect on, SBY 4-12, SBY 5-26
CREATE DATABASE
creating threads, PSA 3-7
MAXDATAFILES clause, PSA 3-3
MAXINSTANCES clause, PSA 3-3
MAXLOGFILES clause, PSA 3-3
MAXLOGMEMBERS clause, PSA 3-3
CREATE DATABASE LINK
statement, SQL 7-273
system privilege, SQL 7-522
CREATE DATABASE LINK statement, DDS 2-9
CREATE DATABASE OPS script, PSG 3-38
CREATE DATABASE statement, PSA 3-2, SQL 7-267
CONTROLFILE REUSE option, SAD 5-4
database name, SRF 1-32
exclusive mode, PSC B-3
MAXINSTANCES, PSA 3-3, PSC 7-21
MAXLOGFILES, PSA 3-3
MAXLOGFILES option, SAD 6-10
MAXLOGHISTORY, PSA 3-3, PSA 13-7, PSC 7-5
MAXLOGMEMBERS, PSA 3-3
MAXLOGMEMBERS parameter, SAD 6-10
setting the block size, SRF 1-28
setting the log mode, PSA 3-2, PSA 3-8, SRF 1-61
CREATE DATAFILE clause
ALTER DATABASE statement, SBR 5-5
of ALTER DATABASE, SQL 7-8, SQL 7-16
CREATE DIMENSION
statement, SQL 7-277
system privilege, SQL 7-522
CREATE DIMENSION statement, DWG 9-6
CREATE DIRECTORY statement, SQL 7-282
Create Entry menu item, in Oracle Directory Manager, OID 4-11
CREATE FUNCTION statement, SCN 60, SQL 7-284
CREATE INDEX
statement, SQL 7-291
CREATE INDEX command, ADG 2-6, ADG 5-5
ON CLUSTER option, ADG 5-16
CREATE INDEX statement, DWG 18-58
examples, STU 20-38
explicitly, SAD 14-9
FREELISTS option, PSA 8-6
no-logging mode, SCN 11-58, SCN 151
NOSORT clause, STU 20-38
object types, ADO 2-5
ON CLUSTER option, SAD 16-8
partition attributes, SCN 11-36
partitioned indexes, SAD 15-9 to SAD 15-11
rules of parallelism, SCN 181
storage parameters, SCN 4-19
temporary segments, SCN 4-19
UNRECOVERABLE, SAD 14-6
with a constraint, SAD 14-10
CREATE INDEXTYPE
statement, SQL 7-309
system privilege, SQL 7-522
CREATE JAVA statement, SQL 7-311
Create Job property sheet, PSG 7-20 to PSG 7-25
General tab, PSG 7-21
Parameters tab, PSG 7-23
Tasks tab, PSG 7-22
CREATE LIBRARY
statement, SQL 7-316
system privilege, SQL 7-523
CREATE LIBRARY command
differences between Server Manager and SQL*Plus, MIG 11-16
Create Like
adding entries using templates, OID 7-15
button, in Oracle Directory Manager, OID 4-12, OID 7-16
operation
using Oracle Directory Manager, OID 4-10
CREATE MATERIALIZED VIEW / SNAPSHOT
statement, SQL 7-318
CREATE MATERIALIZED VIEW LOG / SNAPSHOT LOG statement, SQL 7-333
CREATE MATERIALIZED VIEW statement, DWG 8-17, GTK 3-22
enabling query rewrite, DWG 19-5
CREATE MATERIALIZED VIEW/SNAPSHOT
system privilege, SQL 7-523
CREATE OPERATOR
statement, SQL 7-339
system privilege, SQL 7-524
CREATE OUTLINE statement, GTK 3-37, SCN 129, SQL 7-342, STU 10-5
CREATE PACKAGE BODY command, ADG 9-15, SPR 1-3
CREATE PACKAGE BODY statement, SCN 54, SCN 60, SQL 7-348
CREATE PACKAGE command, ADG 9-15, SPR 1-3
CREATE PACKAGE statement, SQL 7-344
examples, SCN 54, SCN 92
locks, SCN 240
package name, SCN 60
CREATE PROCEDURE
statement, SQL 7-353
system privilege, SQL 7-524
CREATE PROCEDURE statement, PCO 6-21
embedded, PC_ 7-21
example, SCN 48
locks, SCN 240
procedure name, SCN 60
CREATE PROFILE
statement, SQL 7-359
system privilege, SQL 7-524
CREATE PROFILE statement
about, SAD 22-22
CREATE PUBLIC DATABASE LINK system privilege, SQL 7-522
CREATE PUBLIC ROLLBACK SEGMENT statement, PSA 3-5
CREATE PUBLIC SYNONYM system privilege, SQL 7-526
Create Queue Tables and Queues, Examples, ADQ A-4
CREATE ROLE
statement, SQL 7-365
system privilege, SQL 7-525
CREATE ROLE statement, ADG 11-23
IDENTIFIED BY option, SAD 23-8
IDENTIFIED EXTERNALLY option, SAD 23-8
CREATE ROLLBACK SEGMENT
statement, SQL 7-367
system privilege, SQL 7-525
CREATE ROLLBACK SEGMENT statement, PSA 3-4, PSA 3-5
about, SAD 11-6
tuning guidelines, SAD 2-26
CREATE SCHEMA command, ADG 2-37
privileges required, ADG 2-37
CREATE SCHEMA statement, ADG 11-19, SQL 7-369
multiple tables and views, SAD 19-2
create script command (RMAN), RMN 10-61
CREATE SEQUENCE
statement, SQL 7-371
system privilege, SQL 7-525
CREATE SEQUENCE command
CACHE option, ADG 2-29, ADG 2-34
examples, ADG 2-34
NOCACHE option, ADG 2-34
CREATE SEQUENCE statement, PSC 8-14, SAD 18-12
CACHE option, PSC 8-14, PSC 8-15
CYCLE option, PSC 8-14
description, PSC 8-13
ORDER option, PSC 8-14
CREATE SESSION privilege, SUT 2-10
Export, SUT 1-3
CREATE SESSION statement, ADG 11-19
CREATE SESSION system privilege, SQL 7-525
CREATE SNAPSHOT statement, DWG 8-3
CREATE SNAPSHOT system privilege, SQL 7-526
CREATE STANDBY CONTROLFILE clause
ALTER DATABASE statement, SBY 4-15
of ALTER DATABASE, SQL 7-9, SQL 7-20
CREATE statement, SCN 12
setting FREELISTS and FREELIST GROUPS, PSA 8-4
triggers on, SQL 7-430
CREATE SYNONYM
statement, SQL 7-377
system privilege, SQL 7-526
CREATE SYNONYM statement, SAD 18-14
locks, SCN 240
CREATE TABLE
AS subquery
behavior change, MIG 9-31
behavior change
Oracle7 to Oracle8i, MIG 9-31
CREATE TABLE AS SELECT
rules of parallelism
index-organized tables, SCN 187
CREATE TABLE AS SELECT statement, DWG 18-50, DWG 18-68
CREATE TABLE command, ADG 2-3, ADG 2-4, ADG 2-6
CLUSTER option, ADG 5-16
defining integrity constraints, ADG 4-17
INITRANS parameter in, ADG 7-25
CREATE TABLE statement, SQL 7-381
about, SAD 13-9
AS SELECT
comparison with direct-load INSERT, SCN 146
decision support systems, SCN 188
no-logging mode, SCN 11-58, SCN 151
rules of parallelism, SCN 181
space fragmentation, SCN 190
temporary storage space, SCN 190
AS SELECT option, SBR 5-3
auditing, SCN 335, SCN 338
CACHE clause, SCN 7-4
CLUSTER option, SAD 16-7
clustered tables, PSA 8-5
creating partitioned tables, SAD 15-8 to SAD 15-11
enable or disable constraints, SCN 276
examples, PSA 8-12
column objects, ADO 1-11, ADO 2-7, SCN 13-5
nested tables, ADO 1-10, SCN 13-12
object tables, ADO 1-5, ADO 1-10, ADO 2-4, ADO 2-7, SCN 13-8, SCN 13-12
FREELIST GROUPS clause, SRF 1-47
FREELIST GROUPS option, PSC 7-24
FREELISTS option, PSA 8-4, PSC 7-24
initial storage, PSA 8-11, PSA 8-12
locks, SCN 240
parallelism, SCN 188
index-organized tables, SCN 187
partition attributes, SCN 11-26
STORAGE clause, STU 20-24
storage parameters, SCN 4-18
TABLESPACE clause, STU 20-24
triggers, SCN 87
UNRECOVERABLE, SAD 13-4
CREATE TABLESPACE
statement, SQL 7-419
system privilege, SQL 7-527
CREATE TABLESPACE statement, PSC A-20, SBR 6-3, STU 20-23
datafile names in, SAD 9-5
example, SAD 9-5
TEMPORARY clause, SCN 3-13
CREATE TEMPORARY TABLE statement, SCN 10-11
CREATE TEMPORARY TABLESPACE statement, SAD 9-9, SCN 3-13, SQL 7-424
CREATE TRIGGER
statement, SQL 7-426
system privilege, SQL 7-527
CREATE TRIGGER command, ADG 13-3
REFERENCING option, ADG 13-17
CREATE TRIGGER statement
compiled and stored, SCN 106
examples, SCN 92, SCN 95, SCN 105
object tables, ADO 2-5
locks, SCN 240
CREATE TYPE
statement, SQL 7-437
system privilege, SQL 7-528
CREATE TYPE BODY statement, DCI 5-2, SQL 7-447
CREATE TYPE command
differences between Server Manager and SQL*Plus, MIG 11-16
nested tables, ADO 1-9, ADO 1-11
CREATE TYPE privilege, ADO 2-10
See also privileges
CREATE TYPE statement
incomplete types, ADO 2-14
nested tables, ADO 2-3, SCN 13-4, SCN 13-12
object types, ADO 1-10, ADO 2-2, ADO 2-3, ADO 2-7, ADO 9-14, SCN 13-4
object views, ADO 5-3, SCN 14-3
VARRAYs, SCN 13-11
varrays, ADO 1-9, ADO 9-15
CREATE TYPE with OID statement, DCI 3-3
CREATE USER
statement, SQL 7-451
system privilege, SQL 7-528
CREATE USER command
Import, SUT 2-13
CREATE USER statement
IDENTIFIED BY option, SAD 22-15
IDENTIFIED EXTERNALLY option, SAD 22-15
temporary segments, SCN 4-20
CREATE VIEW
statement, SQL 7-456
system privilege, SQL 7-529
CREATE VIEW command, ADG 2-15
OR REPLACE option, ADG 2-18
WITH CHECK OPTION, ADG 2-15, ADG 2-19
CREATE VIEW statement
about, SAD 18-2
examples, SCN 95
object views, ADO 5-4, SCN 14-3
locks, SCN 240
OR REPLACE option, SAD 18-11
WITH CHECK OPTION, SAD 18-3
create(Datum, int) - oracle.jms.AQjmsAgent.create(oracle.sql.Datum, int), JPR 2-25
create(Datum, int) - oracle.ODCI.ODCIArgDesc.create(oracle.sql.Datum, int), JPR 3-4
create(Datum, int) - oracle.ODCI.ODCIArgDescList.create(oracle.sql.Datum, int), JPR 3-7
create(Datum, int) - oracle.ODCI.ODCIArgDescRef.create(oracle.sql.Datum, int), JPR 3-10
create(Datum, int) - oracle.ODCI.ODCIColInfo.create(oracle.sql.Datum, int), JPR 3-12
create(Datum, int) - oracle.ODCI.ODCIColInfoList.create(oracle.sql.Datum, int), JPR 3-15
create(Datum, int) - oracle.ODCI.ODCIColInfoRef.create(oracle.sql.Datum, int), JPR 3-18
create(Datum, int) - oracle.ODCI.ODCICost.create(oracle.sql.Datum, int), JPR 3-20
create(Datum, int) - oracle.ODCI.ODCICostRef.create(oracle.sql.Datum, int), JPR 3-23
create(Datum, int) - oracle.ODCI.ODCIFuncInfo.create(oracle.sql.Datum, int), JPR 3-25
create(Datum, int) - oracle.ODCI.ODCIFuncInfoRef.create(oracle.sql.Datum, int), JPR 3-28
create(Datum, int) - oracle.ODCI.ODCIIndexCtx.create(oracle.sql.Datum, int), JPR 3-30
create(Datum, int) - oracle.ODCI.ODCIIndexCtxRef.create(oracle.sql.Datum, int), JPR 3-33
create(Datum, int) - oracle.ODCI.ODCIIndexInfo.create(oracle.sql.Datum, int), JPR 3-35
create(Datum, int) - oracle.ODCI.ODCIIndexInfoRef.create(oracle.sql.Datum, int), JPR 3-38
create(Datum, int) - oracle.ODCI.ODCIObject.create(oracle.sql.Datum, int), JPR 3-40
create(Datum, int) - oracle.ODCI.ODCIObjectList.create(oracle.sql.Datum, int), JPR 3-43
create(Datum, int) - oracle.ODCI.ODCIObjectRef.create(oracle.sql.Datum, int), JPR 3-46
create(Datum, int) - oracle.ODCI.ODCIPredInfo.create(oracle.sql.Datum, int), JPR 3-48
create(Datum, int) - oracle.ODCI.ODCIPredInfoRef.create(oracle.sql.Datum, int), JPR 3-51
create(Datum, int) - oracle.ODCI.ODCIQueryInfo.create(oracle.sql.Datum, int), JPR 3-53
create(Datum, int) - oracle.ODCI.ODCIQueryInfoRef.create(oracle.sql.Datum, int), JPR 3-56
create(Datum, int) - oracle.ODCI.ODCIRidList.create(oracle.sql.Datum, int), JPR 3-58
create(Datum, int) - oracle.ODCI.ODCIStatsOptions.create(oracle.sql.Datum, int), JPR 3-61
create(Datum, int) - oracle.ODCI.ODCIStatsOptionsRef.create(oracle.sql.Datum, int), JPR 3-64
CREATE_BITMAP_AREA_SIZE initialization parameter, SRF 1-22
CREATE_BITMAP_AREA_SIZE parameter, STU 12-16, STU 12-19
CREATE_INST_INIT procedure, DDS 7-18
CREATE_STORED_OUTLINES parameter, STU 10-4
of ALTER SESSION, SQL 7-86
of ALTER SYSTEM, SQL 7-109
CREATE_STORED_OUTLINES session parameter, GTK 3-37, SCN 129
createAdtMessage() - oracle.jms.AQjmsSession.createAdtMessage(), JPR 2-161
createAdtMessage(CustomDatum) - oracle.jms.AQjmsSession.createAdtMessage(oracle.sql.CustomDatum), JPR 2-161
createAttribute(String) - oracle.xml.parser.v2.XMLDocument.createAttribute(java.lang.String), JPR 4-71
createAttribute(String, String) - oracle.xml.parser.v2.NodeFactory.createAttribute(java.lang.String, java.lang.String), JPR 4-36
createBrowser(Queue) - oracle.jms.AQjmsSession.createBrowser(javax.jms.Queue), JPR 2-161
createBrowser(Queue, CustomDatumFactory) - oracle.jms.AQjmsSession.createBrowser(javax.jms.Queue, oracle.sql.CustomDatumFactory), JPR 2-162
createBrowser(Queue, String) - oracle.jms.AQjmsSession.createBrowser(javax.jms.Queue, java.lang.String), JPR 2-162
createBrowser(Queue, String, boolean) - oracle.jms.AQjmsSession.createBrowser(javax.jms.Queue, java.lang.String, boolean), JPR 2-163
createBrowser(Queue, String, CustomDatumFactory) - oracle.jms.AQjmsSession.createBrowser(javax.jms.Queue, java.lang.String, oracle.sql.CustomDatumFactory), JPR 2-164
createBrowser(Queue, String, CustomDatumFactory, boolean) - oracle.jms.AQjmsSession.createBrowser(javax.jms.Queue, java.lang.String, oracle.sql.CustomDatumFactory, boolean), JPR 2-164
createBytesMessage() - oracle.jms.AQjmsSession.createBytesMessage(), JPR 2-165
createCDATASection(String) - oracle.xml.parser.v2.NodeFactory.createCDATASection(java.lang.String), JPR 4-36
createCDATASection(String) - oracle.xml.parser.v2.XMLDocument.createCDATASection(java.lang.String), JPR 4-72
createComment(String) - oracle.xml.parser.v2.NodeFactory.createComment(java.lang.String), JPR 4-37
createComment(String) - oracle.xml.parser.v2.XMLDocument.createComment(java.lang.String), JPR 4-72
createConnectionConsumer(Queue, String, ServerSessionPool, int) - oracle.jms.AQjmsConnection.createConnectionConsumer(javax.jms.Queue, java.lang.String, javax.jms.ServerSessionPool, int), JPR 2-44
createConnectionConsumer(Topic, String, ServerSessionPool, int) - oracle.jms.AQjmsConnection.createConnectionConsumer(javax.jms.Topic, java.lang.String, javax.jms.ServerSessionPool, int), JPR 2-44
createDocument() - oracle.xml.parser.v2.NodeFactory.createDocument(), JPR 4-37
createDocumentFragment() - oracle.xml.parser.v2.XMLDocument.createDocumentFragment(), JPR 4-73
createDurableSubscriber(Topic, String) - oracle.jms.AQjmsSession.createDurableSubscriber(javax.jms.Topic, java.lang.String), JPR 2-165
createDurableSubscriber(Topic, String, CustomDatumFactory) - oracle.jms.AQjmsSession.createDurableSubscriber(javax.jms.Topic, java.lang.String, oracle.sql.CustomDatumFactory), JPR 2-166
createDurableSubscriber(Topic, String, String, boolean) - oracle.jms.AQjmsSession.createDurableSubscriber(javax.jms.Topic, java.lang.String, java.lang.String, boolean), JPR 2-166
createDurableSubscriber(Topic, String, String, boolean, CustomDatumFactory) - oracle.jms.AQjmsSession.createDurableSubscriber(javax.jms.Topic, java.lang.String, java.lang.String, boolean, oracle.sql.CustomDatumFactory), JPR 2-168
createElement(String) - oracle.xml.parser.v2.NodeFactory.createElement(java.lang.String), JPR 4-37
createElement(String) - oracle.xml.parser.v2.XMLDocument.createElement(java.lang.String), JPR 4-73
createEntityReference(String) - oracle.xml.parser.v2.XMLDocument.createEntityReference(java.lang.String), JPR 4-74
createMapMessage() - oracle.jms.AQjmsSession.createMapMessage(), JPR 2-168
createMessage() - oracle.jms.AQjmsSession.createMessage(), JPR 2-169
createObjectMessage() - oracle.jms.AQjmsSession.createObjectMessage(), JPR 2-169
createObjectMessage(Serializable) - oracle.jms.AQjmsSession.createObjectMessage(java.io.Serializable), JPR 2-169
createProcessingInstruction(String, String) - oracle.xml.parser.v2.NodeFactory.createProcessingInstruction(java.lang.String, java.lang.String), JPR 4-38
createProcessingInstruction(String, String) - oracle.xml.parser.v2.XMLDocument.createProcessingInstruction(java.lang.String, java.lang.String), JPR 4-74
createPublisher(Topic) - oracle.jms.AQjmsSession.createPublisher(javax.jms.Topic), JPR 2-170
createQueue(AQQueueTable, String, AQjmsDestinationProperty) - oracle.jms.AQjmsSession.createQueue(oracle.jms.AQQueueTable, java.lang.String, oracle.jms.AQjmsDestinationProperty), JPR 2-170
createQueue(String) - oracle.jms.AQjmsSession.createQueue(java.lang.String), JPR 2-170
createQueueConnection() - oracle.jms.AQjmsQueueConnectionFactory.createQueueConnection(), JPR 2-151
createQueueConnection(Connection) - oracle.jms.AQjmsQueueConnectionFactory.createQueueConnection(java.sql.Connection), JPR 2-151
createQueueConnection(String, String) - oracle.jms.AQjmsQueueConnectionFactory.createQueueConnection(java.lang.String, java.lang.String), JPR 2-151
createQueueSession(boolean, int) - oracle.jms.AQjmsConnection.createQueueSession(boolean, int), JPR 2-44
createQueueTable(String, String, AQQueueTableProperty) - oracle.jms.AQjmsSession.createQueueTable(java.lang.String, java.lang.String, oracle.jms.AQQueueTableProperty), JPR 2-170
createReceiver(Queue) - oracle.jms.AQjmsSession.createReceiver(javax.jms.Queue), JPR 2-171
createReceiver(Queue, CustomDatumFactory) - oracle.jms.AQjmsSession.createReceiver(javax.jms.Queue, oracle.sql.CustomDatumFactory), JPR 2-172
createReceiver(Queue, String) - oracle.jms.AQjmsSession.createReceiver(javax.jms.Queue, java.lang.String), JPR 2-172
createReceiver(Queue, String, CustomDatumFactory) - oracle.jms.AQjmsSession.createReceiver(javax.jms.Queue, java.lang.String, oracle.sql.CustomDatumFactory), JPR 2-173
createRemoteSubscriber(Topic, AQjmsAgent, String) - oracle.jms.AQjmsSession.createRemoteSubscriber(javax.jms.Topic, oracle.jms.AQjmsAgent, java.lang.String), JPR 2-173
createRemoteSubscriber(Topic, AQjmsAgent, String, CustomDatumFactory) - oracle.jms.AQjmsSession.createRemoteSubscriber(javax.jms.Topic, oracle.jms.AQjmsAgent, java.lang.String, oracle.sql.CustomDatumFactory), JPR 2-174
createSender(Queue) - oracle.jms.AQjmsSession.createSender(javax.jms.Queue), JPR 2-175
createServerSocket(int) - oracle.security.ssl.OracleSSLServerSocketFactoryImpl.createServerSocket(int), OAS F-31
createServerSocket(int, int) - oracle.security.ssl.OracleSSLServerSocketFactoryImpl.createServerSocket(int, int), OAS F-31
createServerSocket(int, int, InetAddress) - oracle.security.ssl.OracleSSLServerSocketFactoryImpl.createServerSocket(int, int, java.net.InetAddress), OAS F-32
createSocket(InetAddress, int) - oracle.security.ssl.OracleSSLSocketFactoryImpl.createSocket(java.net.InetAddress, int), OAS F-44
createSocket(InetAddress, int, InetAddress, int) - oracle.security.ssl.OracleSSLSocketFactoryImpl.createSocket(java.net.InetAddress, int, java.net.InetAddress, int), OAS F-44
createSocket(Socket) - oracle.security.ssl.OracleSSLSocketFactory.createSocket(java.net.Socket), OAS F-42
createSocket(Socket) - oracle.security.ssl.OracleSSLSocketFactoryImpl.createSocket(java.net.Socket), OAS F-45
createSocket(String, int) - oracle.security.ssl.OracleSSLSocketFactoryImpl.createSocket(java.lang.String, int), OAS F-46
createSocket(String, int, InetAddress, int) - oracle.security.ssl.OracleSSLSocketFactoryImpl.createSocket(java.lang.String, int, java.net.InetAddress, int), OAS F-46
createStreamMessage() - oracle.jms.AQjmsSession.createStreamMessage(), JPR 2-175
createSubscriber(Topic) - oracle.jms.AQjmsSession.createSubscriber(javax.jms.Topic), JPR 2-176
createSubscriber(Topic, String, boolean) - oracle.jms.AQjmsSession.createSubscriber(javax.jms.Topic, java.lang.String, boolean), JPR 2-176
createTemporaryQueue() - oracle.jms.AQjmsSession.createTemporaryQueue(), JPR 2-176
createTextMessage() - oracle.jms.AQjmsSession.createTextMessage(), JPR 2-176
createTextMessage(StringBuffer) - oracle.jms.AQjmsSession.createTextMessage(java.lang.StringBuffer), JPR 2-177
createTextNode(String) - oracle.xml.parser.v2.NodeFactory.createTextNode(java.lang.String), JPR 4-38
createTextNode(String) - oracle.xml.parser.v2.XMLDocument.createTextNode(java.lang.String), JPR 4-75
createTimestamp, optional object class in top, OID 2-9
createTopic(AQQueueTable, String, AQjmsDestinationProperty) - oracle.jms.AQjmsSession.createTopic(oracle.jms.AQQueueTable, java.lang.String, oracle.jms.AQjmsDestinationProperty), JPR 2-177
createTopicConnection() - oracle.jms.AQjmsTopicConnectionFactory.createTopicConnection(), JPR 2-202
createTopicConnection(Connection) - oracle.jms.AQjmsTopicConnectionFactory.createTopicConnection(java.sql.Connection), JPR 2-202
createTopicConnection(String, String) - oracle.jms.AQjmsTopicConnectionFactory.createTopicConnection(java.lang.String, java.lang.String), JPR 2-202
createTopicReceiver(Topic, String, String) - oracle.jms.AQjmsSession.createTopicReceiver(javax.jms.Topic, java.lang.String, java.lang.String), JPR 2-177
createTopicReceiver(Topic, String, String, CustomDatumFactory) - oracle.jms.AQjmsSession.createTopicReceiver(javax.jms.Topic, java.lang.String, java.lang.String, oracle.sql.CustomDatumFactory), JPR 2-178
createTopicSession(boolean, int) - oracle.jms.AQjmsConnection.createTopicSession(boolean, int), JPR 2-45
creating
a database
setting block size, SRF 1-27, SRF 1-28
Access Control Policy Points, by using Oracle Directory Manager, OID 4-11
an Oracle server account, OAS 8-13
attributes
using ldapmodify, OID 4-14
using Oracle Directory Manager, OID 4-11
clusters, ADG 5-15
control files, SBY 5-15
datafiles, SBY 5-22
db_name.conf file, PSG B-2
duplicate databases, RMN 7-2
on a remote host, RMN 7-10
hash clusters, ADG 5-19
indexes, ADG 5-5
initdb_name.ora file, PSG 3-36
initialization parameter files, PSG 3-12, PSG 3-36
initsid.ora file, PSG 3-12, PSG 3-36
integrity constraints, ADG 4-2
LDIF input file, OID 5-13
multiple objects, ADG 2-37
new entries
using command line tools, OID 7-25
using Oracle Directory Manager, OID 4-11, OID 7-12
object classes, using Oracle Directory Manager, OID 4-11
objects, OCI 10-32
Oracle directories in CDS, OAS 13-3
Oracle Enterprise Manager repository, PSG 6-10
Oracle Parallel Server database
backing up the new database, PSG 3-39
CREATE DATABASE OPS script, PSG 3-38
db_name.conf file, PSG 3-9, PSG 3-33
during installation, PSG 3-7
initdb_name.ora file, PSG 3-36
initsid.ora file, PSG 3-12, PSG 3-36
ORACLE_SID environment variable, PSG 3-35
OracleServicesid. service, PSG 3-11, PSG 3-35
oratab file, PSG 3-9, PSG 3-32
password files, PSG 3-37
registry entries, PSG 3-10, PSG 3-33
with manual methods, PSG 3-29
with Oracle Database Configuration Assistant, PSG 3-7, PSG 3-24
packages, ADG 9-15, SPR 1-3
password files, PSG 3-37
preferred credentials, PSG 6-19
principals and accounts, OAS 13-2
raw devices on UNIX, PSG 2-7
raw devices on Windows NT, PSG 2-9
recovery catalog, RMN 3-2
rollback segments, OID 10-5
savepoints, PC_ F-102, PCO F-79
sequences, ADG 2-34
similar entries through CreateLike operation, OID 7-15
standby databases, SBY 2-8, SBY 2-12, SBY 2-13, SBY 2-14, SBY 2-32
overview, SBY 1-16
synonyms, ADG 2-35
tables, ADG 2-3, ADG 2-4
tablespaces, OID 10-5
test databases, RMN 1-64
triggers, ADG 13-3, ADG 13-20
views, ADG 2-15
wallets, OID 5-10, OID F-6
creating a parameter file, SAD 2-9
creating a rollback segment, PSA 3-4, PSA 3-5
creating a tablespace, PSC A-20
creating a temporary LOB, ADL 10-14
creating an audit trail, SAD 24-4
Creating Applications in JMS, ADQ 12-1
creating connected user links
scenario, DDS 2-36
creating current user links
scenario, DDS 2-37
creating database links, DDS 2-8
connected user, DDS 2-12
current user, DDS 2-12
example, DDS 1-20
fixed user, DDS 2-11
private, DDS 2-9
public, DDS 2-10
service names within link names, DDS 2-13
specifying types, DDS 2-9
creating databases, SAD 2-1, SAD 7-6
backing up the new database, SAD 2-11
executing CREATE DATABASE, SAD 2-10
manually from a script, SAD 2-4
migration from different versions, SAD 2-4
preparing to, SAD 2-2
prerequisites for, SAD 2-3
problems encountered while, SAD 2-16
using DBCA, SAD 2-4
creating datafiles, SAD 10-5
creating fixed user links
scenario, DDS 2-34, DDS 2-35
creating partitions, LEG 5-7
creating prioritized message queue table and queue, ADQ 9-9, ADQ 9-23
creating profiles, SAD 22-22
creating queue table and queue of object type, ADQ 9-23
creating queue table and queue of RAW type, ADQ 9-23
creating queue tables and queues of object types, ADQ 9-8
creating queue tables and queues of RAW type, ADQ 9-9
creating sequences, SAD 18-12
Creating Statistics Table (PowerCartUserStats), DCI 11-39
creating synonyms, SAD 18-14
creating tables
containing an object type with LOB attribute
internal Persistent LOBs, ADL 9-13
containing BFILEs, ADL 11-14
containing one or more LOB columns
internal persistent LOBs, ADL 9-8
containing one ore more BFILE columns, ADL 11-15
nested, containing LOB
internal persistent LOBs, ADL 9-18
of an object type with BFILE attribute, ADL 11-18
with a nested table containing a BFILE, ADL 11-21
creating temporary LOB, PC_ 16-15
creating threads, PSA 3-7
creating VARRAYs
containing references to LOBs, ADL 5-32
creating views, SAD 18-2
creation of prioritized message queue table and queue, ADQ A-5
creation of queue table and queue of object type, ADQ A-4
creation of queue table and queue of RAW type, ADQ A-5
creation of queue tables and queues, ADQ A-4
creatorsName, optional object class in top, OID 2-9
CRLF
as a function of UTL_TCP, SPR 66-3
cross joins, STU 4-48
crosscheck command (RMAN), RMN 10-64
crosschecking
definition, RMN 1-21
recovery catalog with the media manager, RMN 3-14
cross-registration, PSC 9-21
cross-tabulation values
deriving, SQL 7-578
crtsrv batch file, PSG 3-35
cryptographic functions, ADG 11-72
Cryptographic Toolkit, GTK 7-8
CSID parameter
setting OCILobRead and OCILobWrite to OCI_UCS2ID, ADL 3-11
CTIME column
SYS.INCEXP table, SUT 1-52
CUBE, DWG 17-10
partial, DWG 17-13
when to use, DWG 17-14
CUBE operation, GROUP BY clause, GTK 3-24
CUBE operations
of queries and subqueries, SQL 7-578
CUBE/ROLLUP
with query rewrite, DWG 19-20
CUME_DIST function, DWG 17-31, SQL 4-28
cumulative export, SBR 4-20
cumulative exports, SUT 1-45, SUT 1-47
recording, SUT 1-24
restrictions, SUT 1-45
specifying, SUT 1-21
SYS.INCFIL table, SUT 1-52
SYS.INCVID table, SUT 1-53
cumulative incremental backups, RMN 1-53, RMN 5-23
curly brackets, DCI clix, PC_ xvi
curly brackets, defined, NET xx, PSG xxiii
currencies
formats, NLS 2-23
monetary
units characters, NLS 2-26
symbols
default, NLS 2-10
local currency symbol, NLS 2-23
currency, SRF 1-75
international currency symbol, SRF 1-76
currency symbol
ISO, SQL 2-41
local, SQL 2-42
union, SQL 2-43
CURRENT clause, PSA 13-5
current column
SQL trace, STU 6-13
current instance
checkpoint, PSA 13-14
log switch, PSA 13-15
current mode
TKPROF, STU 6-13
CURRENT OF clause, PC_ 8-4, PCO 5-16, PCO 7-6, PLS 5-49
example, PCO 5-16
example of, PC_ 6-17
mimicking with ROWID, PC_ 3-26, PC_ 8-28, PCO 3-22, PCO 7-19
of embedded SQL DELETE statement, PCO F-33
of embedded SQL UPDATE statement, PCO F-89
purpose of, PC_ 6-17
restrictions, PCO 5-17
restrictions on, PC_ 6-18
CURRENT option
checkpoints, PSA 13-15
forcing a global log switch, PSA 13-15
global log switch, PSA 13-21
new in Oracle7, PSC A-21
current redo log, SBR 1-9
current row, PCO 5-12, PLS 1-5
definition of, PC_ 2-7
using FETCH to retrieve, PC_ 6-12
current user database links, DDS 2-12
advantages and disadvantages, DDS 1-19
cannot access in shared schema, DDS 1-28
creating, DDS 2-12
definition, DDS 1-17
example, DDS 1-20
schema independence, DDS 1-28
CURRENT_SCHEMA attribute, USERENV, ADG 11-44
CURRENT_SCHEMA parameter
of ALTER SESSION, SQL 7-87
CURRENT_USER
and database links, SQL 7-274
CURRENT_USER attribute, USERENV, ADG 11-43
CURRVAL pseudo-column, ADG 2-31
restrictions, ADG 2-32
CURRVAL pseudocolumn, PCO 4-12, PLS 5-3, SQL 2-56, SQL 7-372
cursor attributes
%BULK_ROWCOUNT, PLS 4-34
%FOUND, PLS 5-35, PLS 5-39
%ISOPEN, PLS 5-35, PLS 5-39
%NOTFOUND, PLS 5-36
%ROWCOUNT, PLS 5-36, PLS 5-40
implicit, PLS 5-39
syntax, PLS 11-37
values, PLS 5-37
cursor cache, PCO 8-25
definition of, PC_ 9-38
gathering statistics about, PCO 8-27
purpose, PCO 8-23, PCO D-9
purpose of, PC_ C-9
cursor control statements
example of typical sequence, PC_ 6-18
CURSOR expressions, SQL 5-10
cursor FOR loop
passing parameters to, PLS 5-15
cursor FOR loops, PLS 5-13
cursor operations
overview of, PC_ 6-11
cursor variables, ADG 9-38, PC_ 4-26, PC_ F-12, PCO 6-30, PCO F-10, PLS 5-15
advantages, PCO 6-30
allocating, PC_ 4-27, PCO 6-32
assignment, PLS 5-32
closing, PCO 6-35, PLS 5-24
declaring, PC_ 4-26, PCO 6-31, PLS 5-17
declaring and opening, ADG 9-38
fetching from, PCO 6-34, PLS 5-23
heap memory usage, PCO 6-32
opening, PLS 5-19
anonymous block, PCO 6-33
stored procedure, PCO 6-32
restrictions, PCO 6-35, PLS 5-34
restrictions on, PC_ 4-32
scope, PCO 6-31
syntax, PLS 11-42
use of in recursive functions, PC_ 1-10
using to reduce network traffic, PLS 5-31
using with dynamic SQL, PLS 10-7
cursor, shared, ADG 11-48
CURSOR_ALREADY_OPEN exception, PLS 6-5
CURSOR_NUM column
TKPROF_TABLE table, STU 6-18
CURSOR_SHARING initialization parameter, SRF 1-23
CURSOR_SHARING parameter, STU 19-18
of ALTER SESSION, SQL 7-87, SQL 7-109
CURSOR_SPACE_FOR_TIME initialization parameter, SRF 1-23
CURSOR_SPACE_FOR_TIME parameter
setting, STU 19-19
cursors, ADG 7-9, PC_ 2-16, 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-7
and closing database links, DDS 3-2
association with queries, PC_ 6-11
association with query, PCO 5-12
cancelling, ADG 7-10
closing, ADG 7-10, PC_ F-18, PCO F-14, PLS 5-11
closing before reopening, PC_ 6-13
creating, SCN 20
DBMS_SQL package, SPR 51-4
declaring, PC_ 6-12, PCO 5-12, PLS 5-7
defined, SCN 15
definition of, PC_ 2-7
effects on performance, PCO D-7
embedded SQL, SCN 14
explicit, PLS 5-6
explicit versus implicit, PC_ 2-7, PCO 5-12
fetching from, PLS 5-9
fetching rows from, PC_ F-58, PC_ F-61, PCO F-46, PCO F-49
for multirow queries, PC_ 6-11
how handling affects performance, PC_ C-7
implicit, PLS 5-11
maximum number of, ADG 7-9, SCN 15
movement through active set, PC_ 6-14
naming, PCO 5-13
number cached per session, SQL 7-94
number of open, MIG 3-18
object dependencies and, SCN 116
OPEN_CURSORS initialization parameter, SRF 1-81
opening, PC_ F-91, PC_ F-93, PCO F-70, PCO F-72, PLS 5-8, SCN 7-9, SCN 15
overview of, SCN 1-15
packaged, PLS 5-12
parameterized, PLS 5-8
pointers to, ADG 9-38
private SQL areas and, ADG 7-9, SCN 7-9, SCN 15
purpose of, PC_ 6-11
recursive, SCN 15
recursive SQL and, SCN 15
reopening, PC_ 6-13, PC_ 6-14, PCO 5-14, PCO 5-15
restricted scope of, PCO 2-27
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-45, SRF 1-110, SRF 1-111
statements for manipulating, PC_ 6-11
stored procedures and, SCN 27
syntax, PLS 11-48
types of, PC_ 2-7
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 database
overview, SAD 2-6
Custom database creation type, PSG 1-11
Custom installation type, PSG 3-2
customized
calendars, NLS B-11
character sets, NLS B-2
CyberSafe, OAS 1-8
authentication parameters, OAS B-2
enabling authentication, OAS 5-2
sample for sqlnet.ora file, OAS A-3
system requirements, OAS 1-13
troubleshooting, OAS 5-11
CyberSAFE authentication method
see Oracle Advanced Security
CyberSafe Challenger
system requirements, OAS 1-13
CYCLE clause
of ALTER SEQUENCE. See CREATE SEQUENCE, SQL 7-81
of CREATE SEQUENCE, SQL 7-373
CYCLE option, CREATE SEQUENCE, PSC 8-14

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents