Oracle8i Generic Documentation Master Index
Release 2 (8.1.6)

A76991-01

Library

Product

Contents

Prev Up Next

Oracle8i Generic Documentation Master Index


D

D date format element, SQL 2-46
D number format element, SQL 2-41
daemons, OID 3-2
DAEMON.TRACE_DIRECTORY parameter, NET C-5
DAEMON.TRACE_LEVEL parameter, NET C-6
DAEMON.TRACE_MASK parameter, NET C-6
dangling REFs, ADO 1-7, SCN 13-10
dangling refs, PLS 9-33
DAP. See Directory Access Protocol (DAP)
.dat files, generated by bulkload, OID 7-29
DATA
SQL*Loader command-line parameter, SUT 6-4
data
abstraction, PLS 9-2
access to, SCN 1-50
concurrent, SCN 212
control of, SCN 280
fine-grained access control, SCN 325
message queues, SCN 73
security domains, SCN 280
comparative, STU 11-5
consistency of
defined, SCN 1-54
examples of lock behavior, SCN 243
locks, SCN 213
manual locking, SCN 242
read consistency, SCN 1-30
repeatable reads, SCN 216
transaction level, SCN 216
underlying principles, SCN 225
conversion, NLS 4-5
delimiter marks in data and SQL*Loader, SUT 5-72
design tuning, STU 2-8
distinguishing different input formats for SQL*Loader, SUT 5-51
distributed manipulation of, SCN 1-34
encapsulation, PLS 1-16
exporting, SUT 1-24
formatted data and SQL*Loader, SUT 4-28
generating unique values with SQL*Loader, SUT 5-56
how stored in tables, SCN 10-4
including in control files, SUT 5-21
integrity, OAS 1-5, PLS 5-41
ensuring with multiple column groups, REP 5-10
parallel propagation, REP 6-21
serial propagation, REP 6-21
integrity checking on input, SQL 2-18
integrity of, SCN 1-29, SCN 10-4, SCN 252
CHECK constraints, SCN 271
enforcing, SCN 254, SCN 255
overview, SCN 1-57
parallel DML restrictions, SCN 202
referential, SCN 253
two-phase commit, SCN 1-35
types, SCN 253
loading data contained in the SQL*Loader control file, SUT 5-54
loading in sections
SQL*Loader, SUT 8-15
loading into more than one table
SQL*Loader, SUT 5-51
loading LONG
SQL*Loader, SUT 5-64
locks, PLS 5-42
locks on, SCN 230
maximum length of delimited data for SQL*Loader, SUT 5-73
moving between operating systems using SQL*Loader, SUT 5-74
partitioning, DWG 5-4
privacy, OAS 1-4
purging, DWG 14-7
replicating, SCN 1-36
retrieving, SQL 5-19
saving in a direct path load, SUT 8-12
saving rows
SQL*Loader, SUT 8-18
security of, SAD 21-3
sources for tuning, STU 11-2
SQL*Loader methods of loading into tables, SUT 5-32
substitutions, DWG 13-5
sufficiency check, DWG 19-15
undo
storing, SQL 7-367
unsorted
SQL*Loader, SUT 8-17
values optimized for SQL*Loader performance, SUT 5-54
volume, STU 11-2
data block addresses
translating to lock name, PSA 8-13
data block corruption
repairing, SAD 20-2 to SAD 20-14
data blocks, PSA 7-5, SCN 1-7, SCN 4-2, STU 20-10
allocating for extents, SCN 4-14
altering size of, SAD 2-22
block-level recovery, SCN 355
cached in memory, SCN 8-8
clustered, SCN 10-53
coalescing extents, SCN 4-14
coalescing free space in blocks, SCN 4-10
controlling free space in, SCN 4-5
factors affecting size of, ADG 2-6
format, SCN 4-3
free lists and, SCN 4-10
hash keys and, SCN 10-59
how rows stored in, SCN 10-5
managing space in, SAD 12-2 to SAD 12-6
operating system blocks versus, SAD 2-22
overview, SCN 4-2
PCTFREE in clusters, SAD 16-5
reading multiple, SRF 1-30
read-only transactions and, SCN 243
row directory, SCN 10-7
shared in clusters, SAD 16-2, SCN 10-49
shown in ROWIDs, ADG 3-22
shown in rowids, SCN 12-17, SCN 12-18
size of, SAD 2-22, SRF 1-27, SRF 1-28
space available for inserted rows, SCN 4-9
stored in the buffer cache, SCN 7-3
transaction entry settings, SAD 12-7
types accessed by transactions, PSA 6-3
verifying, SAD 10-12
writing to disk, SCN 8-8
data cache, STU 23-2
data cartridge
definition, DCI 1-2
development process, DCI 2-2
domains, DCI 1-4
external procedures (guidelines), DCI 4-15
installation, DCI 2-4
interfaces, DCI 1-14
method, DCI 1-8
naming conventions, DCI 2-8
suggested development approach, DCI 2-14
data cartridges
OCI functions, OCI xvii, OCI 2-3
data control in OO4O, ADG 1-19
data conversion, ADG 3-25, SQL 2-36
ANSI datatypes, ADG 3-24, SCN 12-23
assignments, ADG 3-25
expression evaluation, ADG 3-27
implicit versus explicit, SQL 2-38
program interface, SCN 8-27
SQL*Loader, SUT 3-8
SQL/DS and DB2 datatypes, ADG 3-24, SCN 12-23
when performed implicitly, SQL 2-36
when specified explicitly, SQL 2-37
data definition conversion
Import utility, MIG 3-13
data definition language, SCN 1-52, SUT 5-3
asynchronous, SPR 37-63, RAR 8-129
auditing, SCN 335
BEGINDATA keyword, SUT 5-21
BLANKS keyword, SUT 5-46
CHARACTERSET keyword
SQL*Loader, SUT 5-31
column_name, SUT 5-16
commit implied by, SCN 35
CONCATENATE keyword, SUT 5-36
CONSTANT keyword, SUT 5-47, SUT 5-54
CONTINUEIF keyword, SUT 5-36
date mask, SUT 5-16
DEFAULTIF keyword, SUT 5-80
defined, SCN 1-52
delimiter_spec, SUT 5-16
described, SCN 12
DISABLED_CONSTRAINTS keyword
SQL*Loader, SUT 8-21
DISCARDDN keyword, SUT 5-28
DISCARDMAX keyword
SQL*Loader, SUT 5-30
embedding in PL/SQL, SCN 28
events and triggers, SQL 7-430
EXCEPTIONS keyword
SQL*Loader, SUT 8-21
expanded syntax diagrams, SUT 5-15
EXTERNAL keyword, SUT 5-67
field_condition, SUT 5-15
FILE keyword
SQL*Loader, SUT 8-28
FLOAT keyword, SUT 5-67
in transactions, PC_ 3-17
INFILE keyword, SUT 5-22
length, SUT 5-16
loading data in sections
SQL*Loader, SUT 8-15
locks, SCN 239
NULLIF keyword, SUT 5-81
parallel DDL, SCN 159
parallel keyword
SQL*Loader, SUT 8-27
parsing with DBMS_SQL, SCN 28
pos_spec, SUT 5-15
POSITION keyword, SUT 5-48
precision, SUT 5-16
processing statements, SCN 23
RECNUM keyword, SUT 5-47
REENABLE keyword
SQL*Loader, SUT 8-21
roles and privileges, SCN 323
SEQUENCE keyword, SUT 5-56
SQL statements, OCI 1-7
statements, SQL 6-1
and implicit commit, SQL 6-2
causing recompilation, SQL 6-2
PL/SQL support of, SQL 6-2
supplying asynchronous, SPR 37-63, RAR 8-129
syntax diagrams
high-level, SUT 5-4
SYSDATE keyword, SUT 5-55
TERMINATED keyword, SUT 5-70
UNRECOVERABLE keyword
SQL*Loader, SUT 8-19
WHITESPACE keyword, SUT 5-70
data definition language (DDL)
description, PCO 5-2
embedded, PCO 14-32
data dictionary, SRF 2-1, STU 2-12, STU 11-3, STU 19-22
access to, SCN 2-3
adding comments to, SQL 7-228
adding objects to, SCN 2-5
ALL prefixed views, SCN 2-6
audit trail (SYS.AUD$), SCN 2-5
backups, SCN 366
base tables, SRF 5-2
cache, SCN 7-10, SRF 3-71, SRF 3-88, SRF 3-89, SRF 3-90, SRF 3-91, SRF 3-92
location of, SCN 7-7
changing storage parameters, SAD 19-28
compatibility, MIG 9-25
compile-time errors, ADG 9-42
conflicts with control files, SAD 5-8
content of, SCN 2-2, SCN 7-10
procedures, SCN 61
contents with generic connectivity, DDS C-3
datafiles, SCN 3-6, SCN 366, SRF 1-40
DBA prefixed views, SCN 2-6
defined, SCN 1-29, SCN 2-2
dependencies tracked by, SCN 109
DICTIONARY view, SRF 2-156
dictionary-managed tablespaces, SCN 3-8
dropped tables and, ADG 2-10, SAD 13-16
DUAL table, SCN 2-7
dynamic performance tables, SCN 2-7
installing for Heterogeneous Services, DDS 7-2
integrity constraints in, ADG 4-27
location, SRF 5-2
locks, SCN 239
mapping for generic connectivity, DDS C-4
objects, PSC 4-2
Oracle server name/SQL Server name, DDS C-4
owner of, SCN 2-3
prefixes to views of, SCN 2-5
procedure source code, ADG 9-43
protection, MIG 9-25
public synonyms for, SCN 2-4
purging pending rows from, DDS 5-15, DDS 5-16
querying views, PSA 12-9
replication, REP 1-14, SCN 434
rollback segments, SRF 1-105
row cache, PSC 4-2
row cache and, SCN 7-10
schema object views, ADG 2-41, SAD 19-29
scripts, SRF 5-3
segments in the, SAD 19-27
sequence cache, PSC 8-14
setting storage parameters of, SAD 19-26
SQL scripts, SRF 5-2
statistics in, SCN 138, STU 4-10, STU 8-13
partition statistics, SCN 11-13
structure of, SCN 2-3
SYSTEM tablespace, SCN 2-2, SCN 2-5, SCN 3-6
tables, DDS 6-4, SRF 2-2
translation support for generic connectivity, DDS C-2
updates of, SCN 2-5
USER prefixed views, SCN 2-6
uses of, SCN 2-3
table and column definitions, SCN 20
V$DBFILE view, SAD 2-16
V$LOGFILE view, SAD 2-16
validity of procedures, SCN 61
views, PSA 3-5, SRF 1-40
overview, SRF 2-2
user views, SRF 2-1
views used in optimization, SCN 138, STU 8-13
data dictionary cache locks, PSA 7-19
data dictionary views, SBR 4-6, SBR 4-7, SBR 4-12
DBA_DB_LINKS, DDS 2-21, DDS 5-7, DDS 5-9
deferred transactions, RAR 9-47
generic connectivity, DDS C-3
Heterogeneous Services, DDS 7-9, DDS B-1
replication, RAR 9-1
snapshots, RAR 9-53
USER, DDS 5-7, DDS 5-9
data encryption, ADG 11-4, ADG 11-72
distributed systems, DDS 1-30
Data Encryption Standard, SPR 23-1
Data Encryption Standard (DES), ADG 11-72
data field
specifying the SQL*Loader datatype, SUT 5-48
data file
adding, PSC A-20
dropping, PSC A-20
maximum number, PSC B-3
recovery, PSC A-24
renaming, PSC A-20
tablespace, PSC A-20
taking offline or online, PSC A-20
data files, PSG 1-3
access in high availability, PSC 9-6
adding, PSA 9-2, PSA 9-5, PSA 9-8
allocating extents, PSA 8-10
backing up, PSA 13-1
described, PSG 1-12
disk contention, PSC 7-2
file ID, PSA 7-3
instance recovery, PSA 14-4, PSC 7-3
mapping locks to blocks, PSC 5-20
multiple files per table, PSA 8-9, PSA 8-11, PSC 7-21
number of blocks, PSA 7-3
parallel recovery, PSA 14-7
raw devices, PSG 2-6
recovery, PSA 14-7
shared, PSC 7-2
tablespace name, PSA 7-3
unspecified for PCM locks, PSC 5-20
validity, PSA 9-7
data files and data blocks
examining, PSA 7-3
data integrity, OAS 1-5, OID 2-20, OID 2-23, OID 2-25, PC_ 3-13, PCO 3-12
definition of, PC_ 3-16
data lock, PCO 3-12
data locks, PC_ 3-16
conversion, SCN 227
duration of, SCN 226
escalation, SCN 227
data manipulation language
auditing, SCN 335
defined, SCN 1-52
described, SCN 12
locks acquired by, SCN 236
operations
and triggers, SQL 7-429
during index creation, SQL 7-301
during index rebuild, SQL 7-144
parallel DML, SCN 159, SCN 192
partition locks, SCN 11-45
privileges controlling, SCN 307
processing statements, SCN 19
serializable isolation for subqueries, SCN 224
SQL statements, OCI 1-8
statements, SQL 6-4
PL/SQL support of, SQL 6-4
statements allowed in distributed transactions, DDS 1-33, SCN 404
transaction model for parallel DML, SCN 196
triggers and, SCN 83, SCN 104
data manipulation language (DML), PCO 5-7
data marts
definition of, DWG 20-2
dependent, DWG 20-2
differences from data warehouse, DWG 20-2
independent, DWG 20-2
Data Migration Assistant, GTK 2-4, GTK 3-60
data mining, GTK 3-24
data models, SCN 1-20
data modification attack, OAS 2-5
data object number
extended ROWID, ADG 3-21, ADG 3-22
extended rowid, SCN 12-17
in extended rowids, SQL 2-27
data path loads
direct and conventional, SUT 8-2
data privacy, OID 2-20, OID 2-26
using SSL, OID 1-5
data privacy and integrity
components of, OAS 12-3
data propagation
and dependency maintenance, REP 6-21
reduced, REP A-6
synchronous, REP 2-31
data recovery
direct path load
SQL*Loader, SUT 8-13
data segments, SCN 1-7, SCN 4-18, SCN 10-4
data servers
changing password to, OID 5-30
data structures
new for 8.0, OCI 2-5
data subsetting, REP A-6
data transfer, maximizing, NET 5-8
data views in Oracle Trace, STU 14-6
Average Elapsed Time, STU 14-11
CPU Statistics, STU 14-12
Disk Reads, STU 14-9
Disk Reads/Execution Ratio, STU 14-9
Disk Reads/Logical Reads Ratio, STU 14-10
Disk Reads/Rows Fetched Ratio, STU 14-9
Execute Elapsed Time, STU 14-11
Fetch Elapsed Time, STU 14-11
Logical Reads, STU 14-9
Logical Reads/Rows Fetched Ratio, STU 14-9
Number of Rows Processed, STU 14-12
Parse Elapsed Time, STU 14-11
Parse/Execution Ratio, STU 14-10
Re-Parse Frequency, STU 14-10
Rows Fetched/Fetch Count Ratio, STU 14-12
Rows Sorted, STU 14-12
Sorts in Memory, STU 14-12
Sorts on Disk, STU 14-12
Total Elapsed Time, STU 14-11
Waits by Average Wait Time, STU 14-13
Waits by Event Frequency, STU 14-13
Waits by Total Wait Time, STU 14-13
data warehouses, DWG 8-2
definition of, DWG 20-2
differences from data marts, DWG 20-2
dimension tables
(lookup tables), DWG 8-7
dimensions, DWG 16-2
fact tables (detail tables), DWG 8-7
partitioned tables, DWG 5-6
refresh tips, DWG 14-22
refreshing, DWG 14-2
star queries, DWG 16-2
data warehousing, GTK 3-21 to GTK 3-30, PSC 8-5
bitmap indexes, SCN 10-34
Database Resource Manager, GTK 3-48, SAD 25-2
dimension schema objects, SCN 1-28, SCN 10-20
dimensions, STU 4-62
DISABLE VALIDATE state, GTK 3-28
function-based indexes, GTK 3-24
hierarchies, SCN 1-28, SCN 10-20
materialized views, GTK 3-21, SCN 10-18
refreshing table data, SCN 194
related features, GTK 3-30
SAMPLE function, GTK 3-24
star queries, STU 4-62
statistics gathering
COMPUTE STATISTICS clause of CREATE and ALTER INDEX statements, GTK 3-27
DBMS_STATS package, GTK 3-26
summaries, SCN 10-18
transportable tablespaces, GTK 3-23
Data Warehousing database, PSG 1-10
data()
function of UTL_SMTP, SPR 65-8
database
accounts
creating, SQL 7-451
allowing generation of redo logs, SQL 7-12
allowing reuse of control files, SQL 7-269
allowing unlimited resources to users, SQL 7-361
application administrator, ADG 11-8
applications and security, ADG 11-5
archiving mode, PSA 3-2, PSA 3-8
backup, PSC 1-5
buffers, STU 19-31
cancel-based recovery, SQL 7-13
terminating, SQL 7-14
change-based recovery, SQL 7-14
changing characteristics of, SQL 7-263
changing global name, SQL 7-15
changing the name of, SQL 7-263, SQL 7-264
character set
specifying, SQL 7-271
connect strings, SQL 2-80
converting from Oracle7 data dictionary, SQL 7-11
creating, SQL 7-268
design techniques for Oracle Parallel Server, PSA 6-2
designing, PSA A-2
designing media recovery, SQL 7-12
enabling automatic extension of, SQL 7-271
erasing all data from, SQL 7-268
export and import, PSC B-2
global name in a distributed system, ADG 2-38
granting system privileges on, SQL 7-521
limiting resources for users, SQL 7-360
managed recovery of, SQL 7-8
modifying, SQL 7-10
mounted but not open, PSA 3-8
mounting, SQL 7-11, SQL 7-268
naming, SQL 7-11
number of archived log files, PSA 13-7, PSC 7-5
number of instances, PSA 3-3, PSC 7-21
opening, SQL 7-11, SQL 7-268
after media recovery, SQL 7-12
recovering, SQL 7-13
with backup control file, SQL 7-14
re-creating control file for, SQL 7-263
redo log files
specifying, SQL 7-265
remote
accessing, SQL 5-26
authenticating users to, SQL 7-275
connecting to, SQL 7-274
inserting into, SQL 7-542
service name of, SQL 7-275
table locks on, SQL 7-548
resetting
current log sequence, SQL 7-12
to an earlier version, SQL 7-15
restricting users to read-only transactions, SQL 7-12
resuming activity, SQL 7-108
rollback segments, PSA 3-4
scalability, PSC 8-12
security and schemas, ADG 11-19
specifying datafiles for, SQL 7-265
standby, PSA 14-17
starting NOMOUNT, PSA 14-11
suspending activity, SQL 7-107
time-based recovery, SQL 7-13
user and application user, ADG 11-6
database administrator
role during migration, MIG 2-7
database administrator (DBA), STU 1-8
privileges for export, SUT 1-3
database administrators, SAD 1-2
application administrator versus, SAD 21-11
initial priorities, SAD 1-17 to SAD 1-21
operating system account, SAD 1-4
password files for, SAD 1-7
responsibilities of, SAD 1-2
roles
about, SAD 1-6
for security, SAD 21-8
security and privileges of, SAD 1-4
security for, SAD 21-8
security officer versus, SAD 1-3, SAD 21-2
user accounts, SAD 1-4
utilities for, SAD 1-17
database administrators (DBAs)
authentication, SCN 291
data dictionary views, SCN 2-6
DBA role, ADO 2-11, SCN 324
password files, SCN 292
responsible for backup and recovery, SCN 342
database authentication, SAD 22-8
database block buffers parameter, OID 13-10
database block size parameter, OID 13-10
database buffers
after committing transactions, SCN 36
buffer cache, SCN 7-3, SCN 8-8
clean, SCN 8-8
committing transactions, SCN 8-10
defined, SCN 1-14, SCN 7-3
dirty, SCN 7-4, SCN 8-8
free, SCN 7-4
multiple buffer pools, SCN 7-5
pinned, SCN 7-4
size of cache, SCN 7-5
writing of, SCN 8-8
database changes
making permanent, PLS 5-43
undoing, PLS 5-44
database character set, PLS 2-20
Database Configuration Assistant, GTK 2-4, GTK 3-59
and log files, PSC 7-5
and object creation for Oracle Parallel Server, PSA 3-1
and the IFILE parameter, PSA 1-3
placement of IFILE parameter, PSA 1-3
database connection
for object applications, OCI 10-10
Database Connection event, STU 14-5
database connections, OID 2-32
concurrent, OID 13-11, OID F-5
pooling, OID 1-4
database creation during installation, PSG 3-7
database event notification, ADG 14-1, ADG 15-5
database events
and triggers, SQL 7-431
database instance registration
client load balancing, GTK 3-76, PSC 8-10
connect-time failover, PSC 8-10
database link
creating synonym for, PC_ 3-14
defining, PC_ 3-14
example using, PC_ 3-14
using in INSERT statement, PC_ F-69
where stored, PC_ 3-14
database links, NET 4-15, NET 6-68, SCN 1-28, SQL 5-26
advantages, DDS 1-13
auditing, DDS 1-31
authentication, DDS 1-25
without passwords, DDS 1-26
closing, DDS 2-18, DDS 3-2, SQL 7-84
connected user, DDS 2-12, DDS 2-36
advantages and disadvantages, DDS 1-17
definition, DDS 1-17
connection qualifiers, REP 2-14
connections
controlling, DDS 3-2
determining open, DDS 2-24
creating, DDS 2-8, RAR 2-12, RAR 2-17, RAR 5-4, SQL 2-79, SQL 7-273
connected user, DDS 2-12, DDS 2-36
connected user, shared, DDS 2-36
current user, DDS 2-12, DDS 2-37
example, DDS 1-20
fixed user, DDS 2-11, DDS 2-34
fixed user, shared, DDS 2-35
obtaining necessary privileges, DDS 2-8
private, DDS 2-9
public, DDS 2-10
scenarios, DDS 2-34
shared, DDS 2-14, DDS 2-15
specifying types, DDS 2-9
creating synonyms with, SQL 7-379
current user, DDS 1-16, DDS 2-12, SQL 7-274
advantages and disadvantages, DDS 1-19
definition, DDS 1-17
data dictionary views
ALL, DDS 5-7, DDS 5-9
DBA_DB_LINKS, DDS 5-7, DDS 5-9
USER, DDS 2-21, DDS 5-7, DDS 5-9
defined, SCN 1-28
definition, DDS 1-10
diagnosing problems with, REP B-2
distributed queries, DDS 1-34
distributed transactions, DDS 1-35
dropping, DDS 2-19
enforcing global naming, DDS 2-3
enterprise users and, DDS 1-28
fixed user, DDS 2-34
advantages and disadvantages, DDS 1-18
definition, DDS 1-17
global
definition, DDS 1-16
global database link, NET 4-15
global names, DDS 1-13
global object names, DDS 1-36
granting system privileges on, SQL 7-521
handling errors, DDS 3-3
heterogeneous systems, DDS 6-2, DDS 7-4
incomplete specifications, REP B-6
job queues and, SAD 8-8
limiting number of connections, DDS 2-20
listing, DDS 2-21, DDS 5-7, DDS 5-9
managing, DDS 2-18
minimizing network connections, DDS 2-14
name resolution, DDS 1-36
schema objects, DDS 1-38
views, synonyms, and procedures, DDS 1-41
when global database name is complete, DDS 1-37
when global database name is partial, DDS 1-37
when no global database name is specified, DDS 1-37
names for, DDS 1-15
naming, SQL 2-79
partition-extended table names, SCN 11-65
passwords
viewing, DDS 2-22
private
definition, DDS 1-16
private database, NET 4-15
public, SQL 7-274
definition, DDS 1-16
dropping, SQL 7-475
public database, NET 4-15
referential integrity in, DDS 3-3
referring to, SQL 2-81
remote queries, DDS 1-33
remote transactions, DDS 1-33, DDS 1-35
removing from the database, SQL 7-475
replication, REP 2-12
resolution, DDS 1-36, SCN 406
restrictions, DDS 1-23
roles on remote database, DDS 1-23, SCN 393
schema objects, DDS 1-21
name resolution, DDS 1-22
synonyms for, DDS 1-22
service names used within link names, DDS 2-13
shared, DDS 1-12, SQL 7-274
configuring, DDS 2-16
creating, DDS 2-14
creating links to dedicated servers, DDS 2-16
creating links to multi-threaded (MTS) servers, DDS 2-17
determining whether to use, DDS 2-14
shared SQL, DDS 1-34
snapshot sites, REP 3-32, REP 7-15
syntax of, SQL 2-80
tuning distributed queries, DDS 3-3
tuning queries with hints, DDS 3-8
tuning using collocated inline views, DDS 3-4
types of links, DDS 1-16
types of users, DDS 1-17
username and password, SQL 2-80
users
specifying, DDS 2-11
using cost-based optimization, DDS 3-5
using in DELETE statement, PCO F-32
using in INSERT statement, PCO F-56
using in UPDATE statement, PCO F-88
viewing, DDS 2-21
database management system (DBMS), SCN 1-2
object-relational DBMS, SCN 13-2
Oracle server, SCN 1-4
principles, SCN 1-20
database mount locks, PSA 7-19
database objects
dropping, SQL 7-510
export privileges, SUT 1-4
exporting LONG columns, SUT 1-57
nonschema, SQL 2-69
schema, SQL 2-68
transferring across a network
Import, SUT 2-47
Database Resource Manager, GTK 3-48, SAD 25-1 to SAD 25-22, STU 18-4, STU 18-7, STU 23-4, STU 23-5
administering system privilege, SAD 25-3 to SAD 25-5
DBMS_RESOURCE_MANAGER package, GTK 3-49
DBMS_RESOURCE_MANAGER_PRIVS package, GTK 3-49
enabling, SAD 25-18
ALTER SYSTEM statement, SAD 25-18
RESOURCE_MANAGER_PLAN initialization parameter, SAD 25-18
managing resource consumer groups, SAD 25-14
changing resource consumer groups, SAD 25-15
granting the switch privilege, SAD 25-15, SAD 25-16
revoking the switch privilege, SAD 25-16
setting initial resource consumer group, SAD 25-14
switching a session, SAD 25-15
switching sessions for a user, SAD 25-15
multiple level CPU resource allocation, SAD 25-13
pending area, SAD 25-7 to SAD 25-10
resource allocation methods, GTK 3-49, SAD 25-3
CPU resource, SAD 25-10
EMPHASIS, SAD 25-8, SAD 25-10
limiting degree of parallelism, SAD 25-10
PARALLEL_DEGREE_LIMIT_ABSOLUTE, SAD 25-10
ROUND-ROBIN, SAD 25-11
resource consumer groups, GTK 3-49, SAD 25-2
creating, SAD 25-11 to SAD 25-12
DEFAULT_CONSUMER_GROUP, SAD 25-11, SAD 25-12, SAD 25-15, SAD 25-17
deleting, SAD 25-12
LOW_GROUP, SAD 25-12, SAD 25-20
managing, SAD 25-14 to SAD 25-17
OTHER_GROUPS, SAD 25-7, SAD 25-9, SAD 25-11, SAD 25-14, SAD 25-20
parameters, SAD 25-11
SYS_GROUP, SAD 25-12, SAD 25-20
updating, SAD 25-12
resource plan directives, GTK 3-49, SAD 25-3, SAD 25-8
CPU_Pn, SAD 25-12
deleting, SAD 25-14
PARALLEL_DEGREE_LIMIT_P1, SAD 25-8, SAD 25-13
parameters, SAD 25-12
specifying, SAD 25-12 to SAD 25-14
updating, SAD 25-14
resource plans, GTK 3-49, SAD 25-3
creating, SAD 25-6 to SAD 25-11
DELETE_PLAN_CASCADE, SAD 25-11
deleting, SAD 25-11
examples, SAD 25-6, SAD 25-18
parameters, SAD 25-10
plan schemas, SAD 25-7, SAD 25-11, SAD 25-13, SAD 25-18, SAD 25-22
subplans, SAD 25-6, SAD 25-7, SAD 25-11
SYSTEM_PLAN, SAD 25-10, SAD 25-12, SAD 25-20
top plan, SAD 25-7, SAD 25-8, SAD 25-18
updating, SAD 25-10
validating plan schema changes, SAD 25-8
views, SAD 25-21
database resource manager
compatibility, MIG 9-13
database schema
generating reports, RMN 4-8
database server error, OID C-2
Database Services tab in Net8 Assistant, NET 7-14
database structures
control files, SCN 1-10, SCN 362
data blocks, SCN 1-7, SCN 4-2, SCN 4-3
data dictionary, SCN 1-29, SCN 2-1
datafiles, SBR 1-6, SCN 1-8, SCN 3-1, SCN 3-16
extents, SCN 1-7, SCN 4-2, SCN 4-12
logical, SCN 1-5
memory, SCN 1-12, SCN 7-1
online redo log, SBR 1-9
overview, SBR 1-6 to SBR 1-11
physical, SBR 1-6 to SBR 1-11
processes, SCN 1-12, SCN 1-15, SCN 8-1
redo log files, SBR 1-9, SCN 1-9, SCN 347
revealing with rowids, SCN 12-18
rollback segments, SBR 1-8
schema objects, SCN 1-6, SCN 10-2
segments, SCN 1-7, SCN 4-2, SCN 4-18
tablespaces, SCN 1-5, SCN 3-1, SCN 3-6
database SUSPEND/RESUME, GTK 3-52
database tables
creating for DBMS_TRACE, SPR 53-3
database triggers, PLS 1-19, SCN 81
autonomous, PLS 5-58
See also triggers
database triggers. See triggers
database types
new, PC_ 17-35
database users
enrolling, SAD 1-20
database writer, SAD 4-11, SAD 10-13
database writer process (DBWn)
tuning, DWG 18-56, STU 18-10
database writer process (DBWn), SBR 1-7, SCN 8-8
checkpoints, SCN 8-8
defined, SCN 8-8
least recently used algorithm (LRU), SCN 8-8
media failure, SCN 346
multiple DBWn processes, SCN 8-8
overview of, SCN 1-17
trace file, SCN 346
when active, SCN 8-8
write-ahead, SCN 8-9
writing to disk at checkpoints, SCN 8-11
database writer process (DBWR)
checkpoint, SRF 1-63
database, dedicated for directory, OID 2-30
database, defined, PSG 1-2
databases
access control
overview, SCN 1-50
password encryption, SCN 285
security domains, SCN 280
administering, SAD 1-1
administration, DDS 2-1
altering availability, SAD 3-8 to SAD 3-9
altering physical structure
standby databases, effect on, SBY 1-27
attributes, OCI 6-19
auditing, SAD 24-1
available installation types, SAD 2-6
backing up, SCN 1-49, SCN 364
after creation of, SAD 1-20
full backups, SAD 2-11
using Recovery Manager, RMN 1-33
backing up for migration, MIG 4-26
block size, SRF 4-4
clone database, SCN 5-8
closing, SCN 5-10
aborting the instance, SCN 5-10, SCN 344
configuring, SCN 5-4
contain schemas, SCN 280
control files of, SAD 5-2
creating, SAD 2-1 to SAD 2-26, SAD 7-6
opening and, SAD 1-20
troubleshooting problems, SAD 2-16
creating duplicate, RMN 7-2
on a remote host, RMN 7-10
creating test, RMN 7-2
data structure changes
incremental export and, SUT 1-49
database limits, SRF 4-1
db identifier, RMN 3-10
default language, SRF 1-77
defined, SCN 1-5
describing, OCI 6-2
design of
implementing, SAD 1-20
dismounting, SCN 5-11
distributed, NET 2-2, SCN 1-34
changing global database name, SCN 7-12
nodes of, SCN 1-34
overview of, SCN 1-32, SCN 1-34
site autonomy of, DDS 1-24, SCN 394
statement optimization on, STU 4-94
table replication, SCN 1-36
two-phase commit, SCN 1-35
downgrading, MIG 13-52
dropping, SAD 2-16
full export, SUT 1-21
full import, SUT 2-22
global database name
about, SAD 2-20
global database names
in a distributed system, SAD 2-20
hardware evaluation, SAD 1-18
incremental export, SUT 1-45
layout, DWG 5-3
limitations on usage, SCN 295
listing for backups, SBR 4-2
logical structure of, SAD 1-19
media recovery procedures, SBR 5-1 to SBR 5-31
media recovery scenarios, SBR 6-1
migration of, SAD 2-4
modes of archiving, SCN 358
mounting, SCN 5-6
mounting a database, SAD 3-5
mounting to an instance, SAD 3-8
name, SRF 1-32, SRF 1-33
name stored in control file, SBR 2-3, SCN 362
names
about, SAD 2-20
conflicts in, SAD 2-20
naming, PC_ 3-8
open and closed, SCN 5-3
opening, SCN 5-8
a closed database, SAD 3-8
acquiring rollback segments, SCN 4-27
opening read-only, SCN 5-9
password encryption, SAD 21-5
physical structure, SAD 1-19, SBR 1-6 to SBR 1-11
physical structure of, SAD 1-19
planning, SAD 1-19
preparing for Export, SUT 1-9
privileges for exporting, SUT 1-3
production, SAD 21-10, SAD 21-11
read-only, opening, SAD 3-9
recovery
after control file damage, SBR 6-13
after OPEN RESETLOGS option, SBR 5-36
recovery of, SCN 1-44, SCN 342
reducing fragmentation via full export/import, SUT 2-44
registering in recovery catalog, RMN 3-9
renaming, SAD 2-20, SAD 5-5, SAD 5-7
repository for Oracle Names, NET 4-13
resource limits, SRF 1-104, SRF 1-105
restricting access, SAD 3-9
reusing existing data files
Import, SUT 2-20
scalability, SCN 6-4, SCN 158, SCN 194
security. See also security.
shutting down, SAD 3-10 to SAD 3-13, SCN 5-10
specifying control files, SAD 2-21
staging, DWG 8-2
standby, SCN 5-7, SCN 367
advantages, SBY 1-2
control files, SBY 4-12, SBY 4-15
creating, procedures for, SBY 2-8, SBY 2-12, SBY 2-13, SBY 2-14, SBY 2-32
datafiles, taking offline, SBY 4-13
direct path operations, SBY 4-13
failover to, SBY 1-12, SBY 1-14, SBY 3-20
initialization parameters, SBY 2-19
manual recovery mode, SBY 1-8, SBY 2-31, SBY 3-4
read-only mode, SBY 1-10, SBY 3-17
redo log files, altering, SBY 4-12
renaming datafiles, SBY 4-11
sustained recovery mode, SBY 1-9
transmitting archived redo logs, SBY 3-13
starting, NET 11-8
starting up, SAD 3-2 to SAD 3-7, SCN 5-2
forced, SCN 5-11
structure of
distributed database, SAD 1-19
structures
control files, SCN 1-10, SCN 362
data blocks, SCN 1-7, SCN 4-2, SCN 4-3
data dictionary, SCN 1-29, SCN 2-1
datafiles, SCN 1-8, SCN 3-1, SCN 3-16
extents, SCN 1-7, SCN 4-2, SCN 4-12
logical, SCN 1-5, SCN 4-1
memory, SCN 1-12, SCN 7-1
physical, SCN 1-8
processes, SCN 1-12, SCN 1-15, SCN 8-1
redo log files, SCN 1-9, SCN 347
revealing with rowids, SCN 12-18
schema objects, SCN 1-6, SCN 10-2
segments, SCN 1-7, SCN 4-2, SCN 4-18
tablespaces, SCN 1-5, SCN 3-1, SCN 3-6
suspending, SBR 4-9
suspending and resuming, SAD 3-13
test, SAD 21-10
test migration results, MIG 8-13
tuning
archiving large databases, SAD 7-19
responsibilities for, SAD 1-21
tuning after migration, MIG 8-14
types of, SAD 2-6
unregistering in recovery catalog, RMN 3-11
user responsibilities, SAD 1-3
valid characters for database name, SRF 1-32
viewing datafiles and redo log files, SAD 2-16
whole database backups, SBR 4-3
data-dependent routing, PSA 5-16
DATAFILE clause, STU 20-23
of ALTER DATABASE, SQL 7-8, SQL 7-16
of CREATE CONTROLFILE, SQL 7-265
of CREATE DATABASE, SQL 7-271
DATAFILE clauses
of ALTER DATABASE, SQL 7-8
DATAFILE END BACKUP clause
of ALTER DATABASE, SQL 7-17
datafile headers
importance for recovery, SBR 1-6
DATAFILE OFFLINE clause
of ALTER DATABASE, SQL 7-17
DATAFILE OFFLINE DROP clause
ALTER DATABASE statement, SBY 4-13
DATAFILE ONLINE clause
of ALTER DATABASE, SQL 7-17
DATAFILE ONLINE option
ALTER DATABASE statement, SBR 5-30
DATAFILE option
table, PSA 8-12
tablespace, PSC A-20
DATAFILE RESIZE clause
of ALTER DATABASE, SQL 7-17
datafiles, SBR 1-6
adding to a tablespace, SAD 10-5
adding to primary database, SBY 4-10, SBY 5-22, SBY 5-47
backing up, SBR 1-15, SCN 366
offline, SBR 4-12
using Recovery Manager, RMN 1-33, RMN 5-5, RMN 5-6
backup, SCN 366
backups needed, listing, RMN 4-10, RMN 4-11, RMN 4-13, RMN 5-16
backups, listing, RMN 4-2
bringing online, SQL 7-17
bringing online and offline, SAD 10-7
cataloging, RMN 3-9
checking associated tablespaces, SAD 9-41
checking backup status, SBR 4-8
compatibility, MIG 9-23
contents of, SCN 3-17
copies, listing, RMN 4-2
creating, SAD 10-5, SBY 5-22
creating new, SQL 7-16
data dictionary, SCN 3-6, SCN 366
database administrators access, SAD 1-4
datafile 1, SCN 3-6
backup, SCN 366
SYSTEM tablespace, SCN 3-6
default directory, SAD 10-5
deleting, SBY 5-25
designing media recovery, SQL 7-12
disabling automatic extension, SQL 7-17
dropping, SAD 9-22
NOARCHIVELOG mode, SAD 10-8
enabling automatic extension, SQL 7-17, SQL 7-421
fully specifying filenames, SAD 10-5
guidelines for managing, SAD 10-2 to SAD 10-4
identifying filenames, SAD 10-10
in online or offline tablespaces, SCN 3-17
listing
for backup, SBR 4-2
unrecoverable, RMN 4-5
location, SAD 10-4
losing, SBR 6-2
in ARCHIVELOG mode, SBR 6-3
in NOARCHIVELOG mode, SBR 6-2
mapping blocks to PCM locks, SRF 1-40
maximum number, SRF 1-31
minimum number of, SAD 10-2
MISSING, SAD 5-8
modifying, SQL 7-16
monitoring, SAD 10-13
named in control files, SBR 2-3, SCN 362
offline during migration, MIG 4-4
online, SAD 10-8
overview, SBR 1-6
overview of, SCN 1-5, SCN 1-8, SCN 3-16
parallel recovery, SCN 351
parameter, SRF 1-29, SRF 1-31
placement on disk, STU 20-19
preventing overwrite during import, SUT 2-20
privileges to rename, SAD 10-9
privileges to take offline, SAD 10-8
read-only, SCN 3-11
recovery, SCN 346
read-only tablespaces and, SCN 3-12
recovering, SQL 7-14
recovery
guidelines, RMN 1-61, RMN 6-18
using RMAN, RMN 6-18
without backup, SBR 5-5
re-creating, SBR 5-5
re-creating lost, SQL 7-16
relationship to tablespaces, SCN 3-2
relocating, SAD 10-9, SAD 10-11
relocating, example, SAD 10-10
renaming, SAD 10-9, SAD 10-11, SBY 5-24, SQL 7-15
after recovery, SBR 6-4
effect on standby database, SBY 4-11
renaming for single tables, SAD 10-9
resizing, SQL 7-17
restoring, RMN 1-59, RMN 6-2, RMN 6-10
to default location, SBR 5-5
reusing, SAD 10-5, SQL 7-517
reusing during import, SUT 2-20
shown in ROWIDs, ADG 3-22
shown in rowids, SCN 12-17, SCN 12-18
size of, SAD 10-4, SQL 7-517
specifying, SQL 7-516, SUT 6-4
for a tablespace, SQL 7-421
specifying buffering for SQL*Loader, SUT 5-24
specifying for SQL*Loader, SUT 5-22
specifying format for SQL*Loader, SUT 5-24
storing separately from redo log files, SAD 10-4
SYSTEM tablespace, SCN 3-6
taking offline, SCN 3-17, SQL 7-17
temporary, SCN 3-18
unavailable when database is opened, SAD 3-4
unrecoverable, SCN 358
unspecified for PCM locks, SRF 1-40
usage, SBR 1-7
verifying data blocks, SAD 10-12
viewing
backup status, SBR 4-8
files needing recovery, SBR 5-2
general status of, SAD 10-13
V$DBFILE and V$LOGFILE views, SAD 2-16
datatype
internal versus external, PCO 2-8
datatype conversion
between internal and external types, PCO 4-40
datatype equivalencing, PC_ 2-7
advantages, PCO 4-42
example, PCO 4-46
guidelines, PCO 4-48
datatypes, ADG 3-2, PLS 2-11, SCN 12-2, SCN 12-3, SQL 2-9
allowed in replicated tables, REP 7-2
allowed in snapshots, REP 3-22
ANSI, SCN 12-23
ANSI/ISO, ADG 3-24
ANSI-supported, SQL 2-12
array types, ADO 1-8, SCN 13-11
associating statistics with, SQL 7-212
BFILE, OCI 3-20, PLS 2-22, SQL 2-14, SQL 2-25
Export, SUT 1-58
BINARY_INTEGER, PLS 2-12
binding and defining, OCI 12-6
BLOB, OCI 3-20, PLS 2-23, SQL 2-14, SQL 2-25
BOOLEAN, PLS 2-23, SCN 12-2
built-in, SQL 2-13
syntax, SQL 2-11
BYTEINT, SUT 5-60
CHAR, ADG 3-2, ADG 3-5, PLS 2-15, SCN 12-5, SQL 2-13, SQL 2-15, SUT 5-64
character, SCN 12-5, SCN 12-14, SQL 2-14
choosing a character datatype, ADG 3-5
CLOB, OCI 3-21, PLS 2-23, SQL 2-14, SQL 2-25
COBOL, PCO 4-13
codes used in descriptors, PC_ 15-15
coercing NUMBER to VARCHAR2, PC_ 15-15, PCO 11-19
collection, DCI 1-8
collections, SCN 13-11
column lengths for character types, ADG 3-6
comparison rules, SQL 2-32
compatibility, MIG 9-26
conflicting character datatype fields, SUT 5-73
constrained, PLS 7-4
conversion
table of, SQL 2-37
conversions, OCI 3-21, PC_ 5-11, PC_ 5-12, PCO 4-39
conversions of
by program interface, SCN 8-27
non-Oracle types, SCN 12-23
Oracle to another Oracle type, SCN 12-24
converting SQL*Loader, SUT 3-8, SUT 5-69
converting to LOBs FAQ, ADL 6-3
data conversion, ADG 3-25
DATE, ADG 3-8, ADG 3-10, PLS 2-24, SCN 12-10, SQL 2-13, SQL 2-21, SUT 5-65
DB2, ADG 3-24, SCN 12-23
DBMS_DESCRIBE, SPR 12-5
dealing with ORACLE internal, PC_ 15-15
dealing with Oracle internal, PCO 11-19
DECIMAL, SUT 5-61
default in SQL*Loader, SUT 5-48
DESC_TAB, SPR 51-30
descriptor codes, PCO 11-19
determining character field lengths for SQL*Loader, SUT 5-73
determining DATE length, SUT 5-74
direct path loading, OCI 9-41, OCI A-48
DOUBLE, SUT 5-60
equivalencing, PC_ 5-12
description, PCO 4-42
example, PCO 4-45
equivalencing, purpose of, PC_ 2-7
extensibility, DCI 1-7
external, OCI 3-4, OCI 3-7, SQL 2-10
families, PLS 2-11
FILE, OCI 3-20
FLOAT, SUT 5-59
for piecewise operations, OCI 5-38
GRAPHIC, SUT 5-66
GRAPHIC EXTERNAL, SUT 5-66
how they relate to tables, SCN 10-3
implicit conversion, PLS 2-28
in PL/SQL, SCN 12-2
INTEGER, SUT 5-59
internal, OCI 3-3, OCI 3-5, PC_ 4-2, PCO 11-16
new in Oracle8i, MIG E-2
internal codes, OCI 3-5
internal versus external, PC_ 2-6
list of available, SCN 12-2
list of internal, PC_ 15-13
LOB datatypes, SCN 12-12
BFILE, SCN 12-14
BLOB, SCN 12-13
CLOB and NCLOB, SCN 12-14
default logging mode, SCN 152
LONG, ADG 3-18, PLS 2-16, SCN 12-7, SQL 2-13, SQL 2-19
Export, SUT 1-57
Import, SUT 2-59
storage of, SCN 10-8
LONG RAW, ADG 3-18, ADG 3-20, PLS 2-16, SQL 2-13, SQL 2-22
manipulating with OCI, OCI 11-5
mapping, DDS 6-4
ODBC, DDS D-2
ODBC to Oracle, DDS D-2
OLE DB, DDS D-3
OLE DB to Oracle, DDS D-3
mapping and manipulation functions
server roundtrips, OCI C-6
mapping from Oracle to C, OCI 11-2
mapping, Oracle methodology, OCI 11-4
mapping, OTT, OCI 14-9
multimedia, SCN 13-3
national character, PLS 2-20
native
conflicting length specifications in SQL*Loader, SUT 5-68
SQL*Loader, SUT 5-59
NCHAR, ADG 3-2, ADG 3-5, PLS 2-20, SQL 2-14, SQL 2-15
NCHAR and NVARCHAR2, SCN 12-7
NCLOB, OCI 3-21, SPR 18-3, PLS 2-23, SQL 2-14, SQL 2-26
need to coerce, PC_ 15-15, PCO 11-19
nested tables, ADO 1-9, SCN 10-10, SCN 13-12
nonscalar, SUT 5-93
NUMBER, ADG 3-7, PLS 2-13, SCN 12-8, SQL 2-17
SQL*Loader, SUT 5-70
NUMER, SQL 2-13
numeric EXTERNAL, SUT 5-67
NVARCHAR2, ADG 3-2, ADG 3-5, PLS 2-21, SQL 2-13, SQL 2-16
object type, DCI 1-8
object types, ADO 1-2, SCN 1-21, SCN 13-4
of columns, SCN 1-22
Oracle, OCI 3-2, PC_ 2-6
OTT mappings, PC_ 19-10
PLS_INTEGER, PLS 2-14
PL/SQL
numeric codes for, SPR 12-9
PL/SQL equivalents, PCO 11-18
RAW, ADG 3-20, PLS 2-16, SQL 2-13, SQL 2-22, SUT 5-67
RAW and LONG RAW, SCN 12-15
RECORD, PLS 4-42
REF (relationship), DCI 1-8
REF CURSOR, PLS 5-16
restrictions on using, PC_ 17-38
ROWID, ADG 3-21, SPR 45-1, PLS 2-17, SCN 12-15, SCN 12-16, SQL 2-13, SQL 2-26
scalar versus composite, PLS 2-11
SMALLINT, SUT 5-59
specifying the SQL*Loader datatype of a data field, SUT 5-48
SQL/DS, ADG 3-24, SCN 12-23
summary, SCN 12-3
summary of datatypes, ADG 3-2
support for, REP A-7
TABLE, PLS 4-2
UROWID, PLS 2-17, SQL 2-13, SQL 2-27
user-defined, SCN 13-1, SCN 13-3
statistics, SCN 141, STU 4-33
user-defined type equivalencing, PC_ F-110
VARCHAR, ADG 3-5, SCN 12-6, SQL 2-17, SUT 5-62
VARCHAR2, ADG 3-2, ADG 3-5, PLS 2-19, SCN 12-6, SQL 2-13, SQL 2-16
SQL*Loader, SUT 5-70
VARGRAPHIC, SUT 5-61
VARRAY, PLS 4-4
when to reset, PC_ 15-15, PCO 11-19
ZONED, SUT 5-60
Datatypes, Specifying, DCI 4-7
DATE
external datatype, OCI 3-14
date arithmetic, ADG 3-27
date constraints
checking for bad, MIG 8-4
DATE datatype, ADG 3-8, PC_ 4-8, PLS 2-24, SCN 12-10, SQL 2-21
arithmetic with, SCN 12-11
centuries, ADG 3-10
changing default format of, SCN 12-10
converting, PCO 4-41
converting from character or numeric value, SQL 2-21
data conversion, ADG 3-25
default format, PCO 4-41
delimited form and SQL*Loader, SUT 5-70
determining length, SUT 5-74
Julian dates, SCN 12-11
mask
SQL*Loader, SUT 5-74
midnight, SCN 12-11
partition pruning, SCN 11-21
partitioning, SCN 11-12, SCN 11-21
SQL*Loader, SUT 5-65
DATE datatypes
external, PCO 4-6
internal format, PCO 4-6
date folding
with query rewrite, DWG 19-24
date format elements, SQL 2-45
and NLS, SQL 2-48
capitalization, SQL 2-45
ISO standard, SQL 2-49
RR, SQL 2-49
suffixes, SQL 2-50
date format models, SQL 2-45
punctuation in, SQL 2-45
text in, SQL 2-45
date format strings, GTK 7-2
date formats, NLS 2-14, NLS 4-10
and partition bound expressions, NLS 2-15
Heterogeneous Services, DDS A-7
date functions, SQL 4-5
date mask, SUT 5-16
date parameters, NLS 2-13
DATE String Format
explicit control over, PCO 4-41
DATE_FORMAT precompiler option, PCO 14-16
DATE_OF_INSERT column
TKPROF_TABLE table, STU 6-18
dates
arithmetic using, SQL 2-21
comparison rules, SQL 2-32
converting, PLS 2-29
ISO standard, NLS 2-18, NLS 4-11
Julian, SQL 2-22
language used for, SRF 1-76
NLS_DATE_LANGUAGE parameter, NLS 2-16
setting SYSDATE, SRF 1-39
specifying in RMAN commands, RMN 2-3
TO_CHAR and TO_DATE functions, SRF 1-75
TO_CHAR default format, PLS 2-29
DAY date format element, SQL 2-48
days
format element, NLS 2-17
language of names, NLS 2-17
db block gets statistic, STU 19-28, STU 21-4, STU 21-21
db identifier, RMN 3-10
obtaining, RMN 6-35
problems registering copied database, RMN 3-10
DB_BLOCK_BUFFERS, OID 13-8
DB_BLOCK_BUFFERS initialization parameter, SRF 1-24
setting before database creation, SAD 2-22
DB_BLOCK_BUFFERS parameter, PSC 5-32, STU 19-31, STU 19-36, STU 20-45
buffer cache and, SCN 7-5
ensuring LM lock capacity, PSA 10-3
GC_RELEASABLE_LOCKS, PSA 9-8
system global area size and, SCN 7-13
DB_BLOCK_CHECKING initialization parameter, SAD 20-4, SAD 20-5, SRF 1-25
DB_BLOCK_CHECKING parameter
of ALTER SESSION, SQL 7-87
of ALTER SYSTEM, SQL 7-109
DB_BLOCK_CHECKPOINT_BATCH initialization parameter: obsolete
DB_BLOCK_CHECKSUM initialization parameter, SAD 10-12, SRF 1-26
DB_BLOCK_CHECKSUM parameter
of ALTER SYSTEM, SQL 7-109
DB_BLOCK_LRU_EXTENDED_STATISTICS initialization parameter: obsolete
DB_BLOCK_LRU_LATCHES parameter, STU 19-36, STU 19-40
DB_BLOCK_LRU_STATISTICS initialization parameter: obsolete
DB_BLOCK_MAX_DIRTY_TARGET initialization parameter, SRF 1-27
DB_BLOCK_MAX_DIRTY_TARGET parameter
of ALTER SYSTEM, SQL 7-109
DB_BLOCK_SIZE initialization parameter, SRF 1-28
database buffer cache size and, SAD 2-22
migration, MIG 4-6, MIG 5-5
setting before creation, SAD 2-22
DB_BLOCK_SIZE parameter, DWG 18-25, PSA 1-8
and parallel query, DWG 18-25
buffer cache and, SCN 7-5
same for all instances, PSA 1-8
system global area size and, SCN 7-13
tuning backups, STU 20-63
DB_DOMAIN attribute, USERENV, ADG 11-44
DB_DOMAIN initialization parameter, MIG F-15, SRF 1-28
compatibility, MIG B-9
setting before database creation, SAD 2-20
DB_DOMAIN parameter, PSA 1-8, PSG 4-8
DB_FILE_DIRECT_IO_COUNT
parameter, STU 20-63
DB_FILE_DIRECT_IO_COUNT initialization parameter, SRF 1-29
DB_FILE_DIRECT_IO_COUNT parameter
of ALTER SYSTEM, SQL 7-110
DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, SRF 1-30
DB_FILE_MULTIBLOCK_READ_COUNT parameter, DWG 18-26, STU 4-26, STU 4-29, STU 20-38
cost-based optimization, STU 4-59
of ALTER SESSION, SQL 7-87
of ALTER SYSTEM, SQL 7-110
DB_FILE_NAME_CONVERT initialization parameter, RMN 1-65, RMN 8-8, SBY 2-20, SBY 2-21, SBY 5-2, SBY 5-9, SRF 1-31
for primary and standby databases, SBY 2-19
using with RMAN duplicate command, RMN 7-7
DB_FILE_SIMULTANEOUS_WRITES initialization parameter: obsolete
DB_FILES initialization parameter, SBY 5-9, SRF 1-31
DB_FILES parameter, PSA 1-8, SCN 7-17
ensuring LM lock capacity, PSA 10-3
same for all instances, PSA 1-8
DB_NAME initialization parameter, MIG F-15, RMN 8-8, SBY 5-9, SRF 1-32
setting before database creation, SAD 2-20
DB_NAME parameter, PSA 1-8, PSA 1-9, PSG 1-15, PSG 4-4, PSG 4-7, SCN 363
same for all instances, PSA 1-8
db_name.conf file
creating, PSG B-2
environ parameter, PSG B-5
inst_init_ora parameter, PSG B-5, PSG B-7
inst_oracle_sid parameter, PSG B-4, PSG B-6
inst_sid_list parameter, PSG C-4
instance parameters, PSG B-6
listener configuration, PSG B-8
lsnr_listener_name parameter, PSG B-5, PSG B-9, PSG C-4
node#inst_init_ora parameter, PSG B-5
node#tns_admin parameter, PSG B-5
node_list parameter, PSG B-4, PSG C-3
oracle_home parameter, PSG B-5
overview, PSG B-2, PSG B-10
parameter expansion, PSG B-3
parameter syntax, PSG B-3
parameters, PSG B-4
parameters node overrides, PSG B-6
sample, PSG B-10
service discovery, PSG C-3
tns_admin parameter, PSG B-5, PSG B-8
DB_VERIFY utility, SAD 20-4, SAD 20-5
DB_WRITER_PROCESSES initialization parameter, SRF 1-33, STU 20-43, STU 20-44
DB_WRITER_PROCESSES parameter, SCN 1-17
DB2 compatibility features, PCO A-4
DB2 datatypes, SQL 2-28
conversion to Oracle datatypes, SQL 2-29
restrictions on, SQL 2-30
DB2 load utility, SUT B-1
placement of statements
DISCARDDDN, SUT B-3
DISCARDS, SUT B-3
restricted capabilities of SQL*Loader, SUT B-3
RESUME keyword, SUT 5-32
SQL*Loader compatibility
ignored statements, SUT B-2
DBA Management Pack, GTK 2-3
DBA role, SAD 1-6, SAD 23-5, SCN 324, SQL 7-530
EXP_FULL_DATABASE role, SUT 1-9
user-defined types, ADO 2-11
DBA. See database administrators.
DBA Studio
defined, PSG 2-3
limitations, PSG 6-34
DBA_ views, SCN 2-6
DBA_2PC_NEIGHBORS view, DDS 5-9, SRF 2-95
using to trace session tree, DDS 5-9
DBA_2PC_PENDING view, DDS 5-7, DDS 5-15, DDS 5-25, SQL 7-84, SRF 2-95
using to list in-doubt transactions, DDS 5-7
DBA_ALL_TABLES view, SRF 2-3, SRF 2-96
DBA_ANALYZE_OBJECTS view, SRF 2-96
DBA_ASSOCIATIONS view, SRF 2-7, SRF 2-96
DBA_AUDIT_EXISTS view, SRF 2-96
DBA_AUDIT_OBJECT view, SRF 2-97
DBA_AUDIT_SESSION view, SRF 2-99
DBA_AUDIT_STATEMENT view, SRF 2-99
DBA_AUDIT_TRAIL view, SRF 2-101
DBA_BLOCKERS view, SRF 2-103
DBA_CATALOG view, SRF 2-103
DBA_CLU_COLUMNS view, SRF 2-103
DBA_CLUSTER_HASH_EXPRESSIONS view, SRF 2-103
DBA_CLUSTERS view, SRF 2-103
DBA_COL_COMMENTS view, SQL 7-228, SRF 2-104
DBA_COL_PRIVS view, SRF 2-104
DBA_COLL_TYPES view, SRF 2-104
DBA_CONS_COLUMNS view, SRF 2-104
DBA_CONSTRAINTS view, SRF 2-104
DBA_CONTEXT view, SRF 2-104
DBA_DATA_FILES view, DWG 18-71, SAD 9-40, SBR 4-6, SBR 4-7, SBR 4-12, SRF 1-40, SRF 2-104, SRF 2-146
DBA_DB_LINKS view, DDS 2-21, DDS 5-7, DDS 5-9, SRF 2-105
DBA_DDL_LOCKS view, SRF 2-105
DBA_DEPENDENCIES view, SRF 2-106
DBA_DIM_ATTRIBUTES view, SRF 2-106
DBA_DIM_CHILD_OF view, SRF 2-106
DBA_DIM_HIERARCHIES view, SRF 2-106
DBA_DIM_JOIN_KEY view, SRF 2-106
DBA_DIM_LEVEL_KEY view, SRF 2-107
DBA_DIM_LEVELS view, SRF 2-107
DBA_DIMENSIONS view, SRF 2-106
DBA_DIRECTORIES view, SRF 2-107
DBA_DML_LOCKS view, SRF 2-107
DBA_ERRORS view, SRF 2-108
debugging stored procedures, ADG 9-43
DBA_EXP_FILES view, SRF 2-108
DBA_EXP_OBJECTS view, SRF 2-108
DBA_EXP_VERSION view, SRF 2-109
DBA_EXTENTS view, DWG 18-71, SRF 2-109
DBA_FREE_SPACE view, SRF 2-110
DBA_FREE_SPACE_COALESCED view, SRF 2-110
DBA_IND_COLUMNS view, SRF 2-111
DBA_IND_EXPRESSIONS view, SRF 2-111
DBA_IND_PARTITIONS view, SRF 2-111
DBA_IND_SUBPARTITIONS view, SRF 2-25, SRF 2-111
DBA_INDEXES view, SRF 2-111, STU 12-17
collecting statistics for, SRF 2-111
filling with data, SAD 19-7
DBA_INDEXTYPE_OPERATORS view, SRF 2-112
DBA_INDEXTYPES view, SRF 2-112
DBA_INTERNAL_TRIGGERS view, SRF 2-112
DBA_JOBS view, SRF 2-112
jobs in system, viewing, SAD 8-14
DBA_JOBS_RUNNING
running jobs, viewing, SAD 8-14
DBA_JOBS_RUNNING view, SRF 2-112
DBA_KGLLOCK view, SRF 2-113
DBA_LIBRARIES view, SRF 2-113
DBA_LOB_PARTITIONS view, SRF 2-113
DBA_LOB_SUBPARTITIONS view, SRF 2-113
DBA_LOBS view, SRF 2-113
DBA_LOCK_INTERNAL view, SRF 2-114
DBA_LOCKS view, SRF 2-114
DBA_METHOD_PARAMS view, SRF 2-114
DBA_METHOD_RESULTS view, SRF 2-115
DBA_MVIEW_AGGREGATES view, SRF 2-115
DBA_MVIEW_ANALYSIS view, SRF 2-115
DBA_MVIEW_DETAIL_RELATIONS view, SRF 2-115
DBA_MVIEW_JOINS view, SRF 2-115
DBA_MVIEW_KEYS view, SRF 2-116
DBA_MVIEWS view, SRF 2-43, SRF 2-116
DBA_NESTED_TABLES view, SRF 2-116
DBA_OBJ_AUDIT_OPTS view, SRF 2-117
DBA_OBJECT_SIZE view, SRF 2-116
DBA_OBJECT_TABLES view, SRF 2-117
DBA_OBJECTS view, SRF 2-117, STU 19-34
DBA_OPANCILLARY view, SRF 2-118
DBA_OPARGUMENTS view, SRF 2-118
DBA_OPBINDINGS view, SRF 2-118
DBA_OPERATORS view, SRF 2-118
DBA_OUTLINE_HINTS view, SRF 2-119
DBA_OUTLINES view, SRF 2-119
DBA_PART_COL_STATISTICS view, SRF 2-119
DBA_PART_HISTOGRAMS view, SRF 2-120
DBA_PART_INDEXES view, SRF 2-120
DBA_PART_KEY_COLUMNS view, SRF 2-120
DBA_PART_LOBS view, SRF 2-120
DBA_PART_TABLES view, SRF 2-120
DBA_PARTIAL_DROP_TABS view, SRF 2-120
DBA_PENDING_TRANSACTIONS view, SRF 2-121
DBA_POLICIES view, SRF 2-121
DBA_PRIV_AUDIT_OPTS view, SRF 2-121
DBA_PROFILES view, SRF 2-121
DBA_QUEUE_SCHEDULES view, SCN 76, SRF 2-122
DBA_QUEUE_TABLES, ADQ 10-5, ADQ 10-8, ADQ 10-26
DBA_QUEUE_TABLES view, SRF 2-123
DBA_QUEUES, ADQ 10-11
DBA_QUEUES view, SRF 2-124
DBA_RCHILD view, SRF 2-124
DBA_REFRESH view, RAR 9-60, SRF 2-124
DBA_REFRESH_CHILDREN view, RAR 9-60, SRF 2-124
DBA_REFS view, SRF 2-124
DBA_REGISTERED_SNAPSHOT_GROUPS view, RAR 9-61, SRF 2-125
DBA_REGISTERED_SNAPSHOTS view, RAR 9-61, REP 3-16, SRF 2-125
DBA_REPAIR_TABLE view, SRF 2-125
DBA_REPCAT_REFRESH_TEMPLATES view, RAR 9-35, SRF 2-2
DBA_REPCAT_TEMPLATE_OBJECTS view, RAR 9-35, SRF 2-2
DBA_REPCAT_TEMPLATE_PARMS view, RAR 9-35, SRF 2-2
DBA_REPCAT_TEMPLATE_SITES view, RAR 9-36, SRF 2-2
DBA_REPCAT_USER_AUTHORIZATIONS view, RAR 9-36, SRF 2-2
DBA_REPCAT_USER_PARM_VALUES view, RAR 9-36, SRF 2-2
DBA_REPCATLOG view, RAR 9-35, REP 2-22, SRF 2-2
purging, SPR 37-69, RAR 8-135
DBA_REPCOLUMN view, RAR 9-36, SRF 2-2
updating, RAR 7-45
DBA_REPCOLUMN_GROUP view, RAR 9-36, SRF 2-2
updating, SPR 37-26, RAR 8-92
DBA_REPCONFLICT view, RAR 9-37, SRF 2-2
DBA_REPDDL view, RAR 9-37, SRF 2-2
DBA_REPGENERATED view, SRF 2-2
DBA_REPGENOBJECTS view, RAR 9-37, SRF 2-2
DBA_REPGROUP view, RAR 9-37, SRF 2-2
updating, SPR 37-28, RAR 8-94
DBA_REPGROUP_PRIVILEGES view, RAR 9-37
DBA_REPGROUPED_COLUMN view, RAR 9-37, SRF 2-2
DBA_REPKEY_COLUMNS view, RAR 9-37, SRF 2-2
DBA_REPOBJECT view, RAR 9-38, SRF 2-2
updating, SPR 37-29, RAR 8-95
DBA_REPPARAMETER_COLUMN view, RAR 9-38, SRF 2-2
DBA_REPPRIORITY view, RAR 9-38, SRF 2-2
DBA_REPPRIORITY_GROUP view, RAR 9-38, SRF 2-2
updating, SPR 37-27, RAR 7-45, RAR 8-93
DBA_REPPROP view, RAR 9-38, SRF 2-2
DBA_REPRESOL_STATS_CONTROL view, RAR 9-39, SRF 2-2
DBA_REPRESOLUTION view, RAR 9-39, SRF 2-2
updating, SPR 37-33, RAR 7-45, RAR 8-99
DBA_REPRESOLUTION_METHOD view, RAR 9-39, SRF 2-2
DBA_REPRESOLUTION_STATISTICS view, RAR 9-39
purging, SPR 37-70, RAR 6-30, RAR 8-136
DBA_REPSCHEMA view
updating, RAR 7-45
DBA_REPSITES view, RAR 9-40, SRF 2-2
updating, SPR 37-31, RAR 8-97
DBA_RGROUP view, SRF 2-126
DBA_ROLE_PRIVS view, ADG 11-9, SRF 2-127
DBA_ROLES view, SRF 2-127
DBA_ROLLBACK_SEGS view, PSA 3-6, PSC 7-7, SAD 11-13, SAD 11-14, SQL 7-496, SRF 2-127
public rollback segments, PSA 3-5
DBA_RSRC_CONSUMER_GROUP_PRIVS view, SRF 2-128
DBA_RSRC_CONSUMER_GROUPS view, SRF 2-129
DBA_RSRC_MANAGER_SYSTEM_PRIVS view, SRF 2-129
DBA_RSRC_PLAN_DIRECTIVES view, SRF 2-130
DBA_RSRC_PLANS view, SRF 2-129
DBA_RULESETS view, SRF 2-131
DBA_SEGMENTS view, PSA 3-6, SAD 9-39, SRF 2-132
DBA_SEQUENCES view, SRF 2-133
DBA_SNAPSHOT_LOG_FILTER_COLS view, RAR 9-61, SRF 2-133
DBA_SNAPSHOT_LOGS view, RAR 9-61, REP 3-16, SRF 2-133
DBA_SNAPSHOT_REFRESH_TIMES view, RAR 9-61, SRF 2-133
DBA_SNAPSHOTS view, RAR 9-62, SRF 2-134
DBA_SOURCE view, ADG 9-43, SRF 2-134
DBA_STMT_AUDIT_OPTS view, SRF 2-134
DBA_SUBPART_COL_STATISTICS view, SRF 2-134
DBA_SUBPART_HISTOGRAMS view, SRF 2-134
DBA_SUBPART_KEY_COLUMNS view, SRF 2-135
DBA_SYNONYMS view, SRF 2-135
DBA_SYNONYMS.SQL script
using, SCN 2-7
DBA_SYS_PRIVS view, SRF 2-135
DBA_TAB_COL_STATISTICS view, SRF 2-135
DBA_TAB_COLUMNS view, SRF 2-136
filling with data, SAD 19-7
DBA_TAB_COMMENTS view, SQL 7-228, SRF 2-136
DBA_TAB_HISTOGRAMS view, SRF 2-136
DBA_TAB_PARTITIONS view, SRF 2-136
DBA_TAB_PRIVS view, SRF 2-136
DBA_TAB_SUBPARTITIONS view, SRF 2-137
DBA_TABLES table, PSA 10-4
DBA_TABLES view, SRF 2-137
filling with data, SAD 19-7
DBA_TABLESPACES view, SAD 9-23, SRF 2-137
DBA_TEMP_FILES view, SAD 9-40, SRF 2-138
DBA_TRIGGER_COLS view, SRF 2-138
DBA_TRIGGERS view, SRF 2-138
DBA_TS_QUOTAS view, SAD 9-40, SRF 2-139
DBA_TYPE_ATTRS view, SRF 2-139
DBA_TYPE_METHODS view, SRF 2-139
DBA_TYPES view, SRF 2-139
DBA_UPDATABLE_COLUMNS view, SCN 10-16, SRF 2-140
DBA_USERS view, SAD 9-40, SRF 2-140
DBA_USTATS view, SRF 2-141
DBA_VARRAYS view, SRF 2-141
DBA_VIEWS view, SRF 2-141
DBA_WAITERS view, SRF 2-141
DBAccess Interface, NET 3-13
DBCA. See Oracle Database Configuration Assistant
DBCA_RAW_CONFIG environment variable, PSG 2-9
DBCS (DB2 double-byte character set)
not supported by Oracle, SUT B-4
DBLINK_ENCRYPT_LOGIN initialization parameter, SRF 1-34
DBMS, SCN 1-2
general requirements, SCN 1-50
object-relational DBMS, SCN 13-2
precompiler command line option, MIG 9-21
DBMS interaction with MODE, PC_ 10-17
DBMS interfaces, DCI 1-14
DBMS option, PC_ 5-15
DBMS precompiler option, PC_ 10-16, PCO 14-17
DBMS_ALERT package, SPR 2-1, PLS 8-17
DBMS_ALERT_INFO view, SRF 2-141
DBMS_APPLICATION_INFO package, SPR 3-2, STU 3-7
SET_SESSION_LONGOPS procedure
syntax change, MIG 9-33
DBMS_AQ package, SPR 4-1, SCN 70
DBMS_AQADM package, SPR 5-1, SCN 70, SCN 73
DBMS_AQADM.DROP_QUEUE, ADQ 9-18
DBMS_BACKUP_RESTORE package, SPR 6-1
DBMS_DDL package, SPR 7-1
ANALYZE_OBJECT procedure
used for computing statistics, SAD 19-9
DBMS_DEBUG package, SPR 8-1
DBMS_DEFER package, SPR 9-1, SPR 9-2, RAR 8-4
CALL procedure, SPR 9-3, RAR 8-4
CHAR_ARG procedure, SPR 9-5, RAR 8-7
COMMIT_WORK procedure, SPR 9-4, RAR 8-6
datatype_ARG procedure, SPR 9-5, RAR 8-7
DATE_ARG procedure, SPR 9-5, RAR 8-7
NUMBER_ARG procedure, SPR 9-5, RAR 8-7
RAW_ARG procedure, SPR 9-5, RAR 8-7
ROWID_ARG procedure, SPR 9-5, RAR 8-7
TRANSACTION procedure, SPR 9-7, RAR 8-9
VARCHAR2_ARG procedure, SPR 9-5, RAR 8-7
DBMS_DEFER_QUERY package, SPR 10-1, SPR 10-2, RAR 8-10
GET_ARG_FORM function, SPR 10-3, RAR 8-11
GET_ARG_TYPE function, SPR 10-4, RAR 8-12
GET_CALL_ARGS procedure, SPR 10-6, RAR 8-14
GET_CHAR_ARG procedure, SPR 10-7, RAR 8-15
GET_datatype_ARG function, SPR 10-7, RAR 8-15
GET_NUMBER_ARG procedure, SPR 10-7, RAR 8-15
GET_RAW_ARG procedure, SPR 10-7, RAR 8-15
GET_ROWID_ARG procedure, SPR 10-7, RAR 8-15
GET_VARCHAR2_ARG procedure, SPR 10-7, RAR 8-15
DBMS_DEFER_SYS package, SPR 11-1, SPR 11-2, RAR 8-17
ADD_DEFAULT_DEST procedure, SPR 11-4, RAR 8-19
DELETE_DEF_DESTINATION procedure, SPR 11-5, RAR 8-20
DELETE_DEFAULT_DEST procedure, SPR 11-4, RAR 8-19
DELETE_ERROR procedure, SPR 11-5, RAR 8-20
DELETE_TRAN procedure, SPR 11-6, SPR 11-7, SPR 11-9, RAR 8-21, RAR 8-22, RAR 8-24
DISABLED function, SPR 11-7, RAR 8-22
EXCLUDE_PUSH function, SPR 11-8, RAR 8-23
EXECUTE_ERROR procedure, SPR 11-9, RAR 7-26, RAR 7-30, RAR 8-24
EXECUTE_ERROR_AS_USER procedure, SPR 11-10, RAR 7-27, RAR 8-25
PURGE function, SPR 11-11, RAR 7-25, RAR 8-26
PUSH function, SPR 11-13, RAR 7-25, RAR 8-28
REGISTER_PROPAGATOR procedure, SPR 11-16, RAR 2-5, RAR 2-16, RAR 8-31
SCHEDULE_EXECUTION procedure, SPR 11-19, RAR 8-34
SCHEDULE_PURGE procedure, SPR 11-17, RAR 2-6, RAR 2-18, RAR 8-32
SCHEDULE_PUSH procedure, SPR 11-19, RAR 2-13, RAR 2-19, RAR 8-34
SET_DISABLED procedure, SPR 11-21, RAR 8-36
UNREGISTER_PROPAGATOR procedure, SPR 11-22, RAR 8-37
UNSCHEDULE_PURGE procedure, SPR 11-23, RAR 8-38
UNSCHEDULE_PUSH procedure, SPR 11-23, RAR 8-38
DBMS_DESCRIBE package, SPR 12-1
DBMS_DISTRIBUTED_TRUST_ADMIN package, SPR 13-1
DBMS_HS package, SPR 14-1
specifying HS parameters, DDS 7-17
DBMS_HS_PASSTHROUGH package, DDS 9-2, SPR 15-1
list of functions and procedures, DDS 9-3
DBMS_IOT package, SPR 16-1
DBMS_JOB
using, PSA 5-17
DBMS_JOB package, SPR 17-1, SAD 8-3, SCN 8-14
and instance affinity, SPR 17-12
Oracle supplied packages, SCN 59
DBMS_LOB
WRITE()
passing hexadecimal string to, ADL 9-202
DBMS_LOB package, DCI 6-10, SPR 18-1
available LOB procedures/functions, ADL 3-3
client procedures cannot call DBMS_LOB, ADL 3-6
compared with OCI, DCI 6-7
CREATETEMPORARY(), ADL 10-16
for temporary LOBs, ADL 3-8
functions/procedures to modify BLOB, CLOB, and NCLOB, ADL 3-8
functions/procedures to read/examine internal and external LOBs, ADL 3-8
LOADFROMFILE(), ADL 11-47
multi-threaded server (MTS), ADL 11-12
NOCOPY syntax and compatibility, MIG 9-33
offset and amount parameter rules, ADL 3-7
opening/closing internal and external LOBs, ADL 3-9
provide LOB locator before invoking, ADL 3-6
read-only functions/procedures for BFILEs, ADL 3-9
to work with LOBs, using, ADL 3-6
WRITE()
guidelines, ADL 9-202
guidelines for temporary LOBs, ADL 10-152
passing hexadecimal string to, ADL 10-152
DBMS_LOB()
READ, ADL 9-102
DBMS_LOCK package, ADG 7-20, SPR 19-1, SCN 250
Oracle supplied packages, SCN 59
DBMS_LOCK_ALLOCATED view, SRF 2-142
DBMS_LOGMNR package, SPR 20-1
ADD_LOGFILE procedure, SAD 7-30
START_LOGMNR procedure, SAD 7-31
DBMS_LOGMNR_D package, SPR 21-1
BUILD procedure, SAD 7-28, SAD 7-29
DBMS_MVIEW package, SPR 22-1, DWG 14-18
DBMS_SNAPSHOT package, SPR 22-1, SPR 48-1
DBMS_MVIEW.REFRESH procedure, DWG 14-17, DWG 14-19
DBMS_MVIEW.REFRESH_ALL_MVIEWS procedure, DWG 14-17
DBMS_MVIEW.REFRESH_DEPENDENT procedure, DWG 14-17
DBMS_OBFUSCATION_TOOLKIT package, ADG 11-72, SPR 23-1
DBMS_OFFLINE_OG package, SPR 24-1, SPR 24-2, RAR 8-39
BEGIN_INSTANTIATION procedure, SPR 24-3, RAR 7-31, RAR 8-40
BEGIN_LOAD procedure, SPR 24-4, RAR 7-33, RAR 8-41
END_INSTANTIATION procedure, SPR 24-5, RAR 7-34, RAR 8-42
END_LOAD procedure, SPR 24-7, RAR 7-33, RAR 8-44
RESUME_SUBSET_OF_MASTERS procedure, SPR 24-8, RAR 7-32, RAR 8-45
DBMS_OFFLINE_SNAPSHOT package, SPR 25-1, SPR 25-2, RAR 8-47
BEGIN_LOAD procedure, SPR 25-3, RAR 7-37, RAR 7-38, RAR 8-48
END_LOAD procedure, SPR 25-5, RAR 7-39, RAR 8-50
DBMS_OLAP package, SPR 26-1, DWG 8-35, DWG 15-2, DWG 15-3, DWG 15-5
DBMS_OLAP.RECOMMEND_MV procedure, DWG 8-35
DBMS_ORACLE_TRACE_AGENT package, SPR 27-1
DBMS_ORACLE_TRACE_USER package, SPR 28-1
DBMS_OUTPUT package, SPR 29-1, PLS 8-17, SQL 7-184
DBMS_PCLXUTIL package, SPR 30-1, SCN 11-29
DBMS_PIPE package, SPR 31-1, PLS 8-18
DBMS_PROFILER package, SPR 32-1
DBMS_RANDOM package, SPR 33-1
DBMS_RECTIFIER_DIFF package, SPR 34-1, SPR 34-2, RAR 7-41, RAR 8-52
DIFFERENCES procedure, SPR 34-3, RAR 7-41, RAR 8-53
RECTIFY procedure, SPR 34-6, RAR 7-41, RAR 8-56
DBMS_REFRESH package, SPR 35-1, SPR 35-2, RAR 8-59
ADD procedure, SPR 35-3, RAR 5-8, RAR 8-60
CHANGE procedure, SPR 35-4, RAR 8-61
DESTROY procedure, SPR 35-6, RAR 8-63
MAKE procedure, SPR 35-7, RAR 5-6, RAR 8-64
REFRESH procedure, SPR 35-9, RAR 8-66
REFRESH_CHANGE procedure, REP 4-21
SUBTRACT procedure, SPR 35-10, RAR 8-67
DBMS_REPAIR package, SPR 36-1, SAD 20-2 to SAD 20-14
compatibility, MIG 9-13, MIG 9-33
downgrading, MIG 13-42
examples, SAD 20-8 to SAD 20-14
limitations, SAD 20-3
procedures, SAD 20-2
using, SAD 20-3 to SAD 20-8
DBMS_REPCAT package, SPR 37-2, RAR 8-68, REP 2-22, REP 2-24
ADD_DELETE_RESOLUTION procedure, SPR 37-12, RAR 8-78
ADD_GROUPED_COLUMN procedure, SPR 37-6, RAR 8-72
ADD_MASTER_DATABASE procedure, SPR 37-7, RAR 3-7, RAR 7-4, RAR 8-73
ADD_PRIORITY_CHAR procedure, SPR 37-9, RAR 8-75
ADD_PRIORITY_datatype procedure, SPR 37-9, RAR 8-75
ADD_PRIORITY_DATE procedure, SPR 37-9, RAR 8-75
ADD_PRIORITY_NUMBER procedure, SPR 37-9, RAR 8-75
ADD_PRIORITY_VARCHAR2 procedure, SPR 37-9, RAR 8-75
ADD_SITE_PRIORITY_SITE procedure, SPR 37-10, RAR 6-18, RAR 8-76
ADD_UNIQUENESS_RESOLUTION procedure, SPR 37-12, RAR 8-78
ADD_UPDATE_RESOLUTION procedure, SPR 37-12, RAR 6-4, RAR 6-6, RAR 6-10, RAR 6-12, RAR 6-15, RAR 6-18, RAR 8-78
ALTER_MASTER_PROPAGATION procedure, SPR 37-16, RAR 8-82
ALTER_MASTER_REPOBJECT procedure, SPR 37-17, RAR 6-8, RAR 6-16, RAR 6-20, RAR 6-26, RAR 7-27, RAR 8-83
ALTER_PRIORITY procedure, SPR 37-19, RAR 8-85
ALTER_PRIORITY_CHAR procedure, SPR 37-20, RAR 8-86
ALTER_PRIORITY_datatype procedure, SPR 37-20, RAR 8-86
ALTER_PRIORITY_DATE procedure, SPR 37-20, RAR 8-86
ALTER_PRIORITY_NUMBER procedure, SPR 37-20, RAR 8-86
ALTER_PRIORITY_RAW procedure, SPR 37-20, RAR 8-86
ALTER_SITE_PRIORITY procedure, SPR 37-22, RAR 8-88
ALTER_SITE_PRIORITY_SITE procedure, SPR 37-23, RAR 8-89
ALTER_SNAPSHOT_PROPAGATION procedure, SPR 37-24, RAR 8-90
CANCEL_STATISTICS procedure, SPR 37-25, RAR 6-30, RAR 8-91
comment procedures, RAR 7-45
COMMENT_ON_COLUMN_GROUP procedure, SPR 37-26, RAR 7-45, RAR 8-92
COMMENT_ON_DELETE_RESOLUTION procedure, SPR 37-33, RAR 7-45, RAR 8-99
COMMENT_ON_PRIORITY_GROUP procedure, SPR 37-27, RAR 7-45, RAR 8-93
COMMENT_ON_REPGROUP procedure, SPR 37-28, RAR 7-45, RAR 8-94
COMMENT_ON_REPOBJECT procedure, SPR 37-29, RAR 8-95
COMMENT_ON_REPSCHEMA procedure, RAR 7-45
COMMENT_ON_REPSITES procedure, SPR 37-31, RAR 8-97
COMMENT_ON_SITE_PRIORITY procedure, SPR 37-27, RAR 8-93
COMMENT_ON_SNAPSHOT_REPSITES procedure, SPR 37-32, RAR 8-98
COMMENT_ON_UNIQUE_RESOLUTION procedure, SPR 37-33, RAR 7-45, RAR 8-99
COMMENT_ON_UPDATE_RESOLUTION procedure, SPR 37-33, RAR 7-45, RAR 8-99
COMPARE_OLD_VALUES procedure, SPR 37-35, RAR 8-101
conflict resolution, REP 5-27
CREATE_MASTER_REPGROUP procedure, SPR 37-37, RAR 3-5, RAR 8-103
CREATE_MASTER_REPOBJECT procedure, SPR 37-38, RAR 6-9, RAR 8-104
CREATE_SNAPSHOT_REPGROUP procedure, SPR 37-41, RAR 5-5, RAR 7-6, RAR 7-37, RAR 8-107
CREATE_SNAPSHOT_REPOBJECT procedure, SPR 37-42, RAR 5-6, RAR 7-7, RAR 8-108
DEFINE_COLUMN_GROUP procedure, SPR 37-44, RAR 8-110
DEFINE_PRIORITY_GROUP procedure, SPR 37-45, RAR 8-111
DEFINE_SITE_PRIORITY procedure, SPR 37-47, RAR 6-17, RAR 8-113
DO_DEFERRED_REPCAT_ADMIN procedure, SPR 37-48, RAR 7-31, RAR 8-114, REP 2-22, REP 2-23
DROP_COLUMN_GROUP procedure, SPR 37-49, RAR 8-115
DROP_DELETE_RESOLUTION procedure, SPR 37-61, RAR 8-127
DROP_GROUPED_COLUMN procedure, SPR 37-50, RAR 8-116
DROP_MASTER_REPGROUP procedure, SPR 37-51, RAR 8-117
DROP_MASTER_REPOBJECT procedure, SPR 37-52, RAR 8-118
DROP_PRIORITY procedure, SPR 37-53, RAR 8-119
DROP_PRIORITY_CHAR procedure, SPR 37-55, RAR 8-121
DROP_PRIORITY_datatype procedure, SPR 37-55, RAR 8-121
DROP_PRIORITY_DATE procedure, SPR 37-55, RAR 8-121
DROP_PRIORITY_GROUP procedure, SPR 37-54, RAR 8-120
DROP_PRIORITY_NUMBER procedure, SPR 37-55, RAR 8-121
DROP_PRIORITY_VARCHAR2 procedure, SPR 37-55, RAR 8-121
DROP_SITE_PRIORITY procedure, SPR 37-57, RAR 8-123
DROP_SITE_PRIORITY_SITE procedure, SPR 37-58, RAR 8-124
DROP_SNAPSHOT_REPGROUP procedure, SPR 37-59, RAR 7-13, RAR 8-125
DROP_SNAPSHOT_REPOBJECT procedure, SPR 37-60, RAR 7-14, RAR 8-126
DROP_UNIQUE_RESOLUTION procedure, SPR 37-61, RAR 8-127
DROP_UPDATE_RESOLUTION procedure, SPR 37-61, RAR 8-127
EXECUTE_DDL procedure, SPR 37-63, RAR 8-129
GENERATE_REPLICATION_SUPPORT procedure, SPR 37-64, RAR 3-8, RAR 7-28, RAR 8-130
GENERATE_SNAPSHOT_SUPPORT procedure, SPR 37-66, RAR 8-132
MAKE_COLUMN_GROUP procedure, SPR 37-68, RAR 6-4, RAR 6-6, RAR 6-9, RAR 6-11, RAR 6-13, RAR 6-17, RAR 8-134
PURGE_MASTER_LOG procedure, SPR 37-69, RAR 8-135
PURGE_STATISTICS procedure, SPR 37-70, RAR 6-30, RAR 8-136
REFRESH_SNAPSHOT_REPGROUP procedure, SPR 37-71, RAR 8-137
REGISTER_SNAPSHOT_REPGROUP procedure, SPR 37-72, RAR 8-138
REGISTER_STATISTICS procedure, SPR 37-74, RAR 6-29, RAR 8-140
RELOCATE_MASTERDEF procedure, SPR 37-75, RAR 7-2, RAR 8-141
REMOVE_MASTER_DATABASE procedure, RAR 7-5
REMOVE_MASTER_DATABASES procedure, SPR 37-76, RAR 8-142
REPCAT_IMPORT_CHECK procedure, SPR 37-77, RAR 8-143, REP 6-11
RESUME_MASTER_ACTIVITY procedure, SPR 37-78, RAR 3-10, RAR 8-144
SEND_OLD_VALUES procedure, SPR 37-79, RAR 8-145
conflict resolution, REP 5-27
SET_COLUMNS procedure, SPR 37-36, SPR 37-81, RAR 8-102, RAR 8-147
SUSPEND_MASTER_ACTIVITY procedure, SPR 37-83, RAR 8-149
SWITCH_SNAPSHOT_MASTER procedure, SPR 37-83, RAR 7-9, RAR 8-149
UNREGISTER_SNAPSHOT_REPGROUP procedure, SPR 37-84, RAR 7-15, RAR 8-150
VALIDATE procedure, SPR 37-85, RAR 8-151
WAIT_MASTER_LOG procedure, RAR 8-154
DBMS_REPCAT_ADMIN package, SPR 38-2, RAR 8-155
GRANT_ADMIN_ANY_SCHEMA procedure, SPR 38-3, RAR 2-4, RAR 2-16, RAR 8-156
GRANT_ADMIN_SCHEMA procedure, SPR 38-3, RAR 8-156
REGISTER_USER_REPGROUP procedure, SPR 38-4, RAR 2-5, RAR 2-6, RAR 8-157
REVOKE_ADMIN_ANY_SCHEMA procedure, SPR 38-6, RAR 8-159
REVOKE_ADMIN_SCHEMA procedure, SPR 38-7, RAR 8-160
UNREGISTER_USER_REPGROUP procedure, SPR 38-8, RAR 8-161
DBMS_REPCAT_INSTANTIATE package, SPR 39-1, SPR 39-2, RAR 8-163
DROP_SITE_INSTANTIATION procedure, SPR 39-3, RAR 7-10, RAR 8-164
INSTANTIATE_OFFLINE function, SPR 39-3, RAR 8-164
INSTANTIATE_OFFLINE_REPAPI function, SPR 39-6, RAR 8-167, REP C-14
INSTANTIATE_ONLINE function, SPR 39-9, RAR 8-170
DBMS_REPCAT_RGT package, SPR 40-2, RAR 8-172
ALTER_REFRESH_TEMPLATE procedure, SPR 40-4, RAR 8-174
ALTER_TEMPLATE_OBJECT procedure, SPR 40-6, RAR 8-176
ALTER_TEMPLATE_PARM procedure, SPR 40-9, RAR 4-8, RAR 8-179
ALTER_USER_AUTHORIZATION procedure, SPR 40-11, RAR 8-181
ALTER_USER_PARM_VALUE procedure, SPR 40-12, RAR 8-182
COMPARE_TEMPLATES function, SPR 40-15, RAR 8-185
COPY_TEMPLATE function, SPR 40-16, RAR 8-186
CREATE_OBJECT_FROM_EXISTING function, SPR 40-18, RAR 8-188
CREATE_REFRESH_TEMPLATE function, SPR 40-20, RAR 8-190
CREATE_REFRESH_TEMPLATE procedure, RAR 4-4
CREATE_TEMPLATE_OBJECT function, SPR 40-22, RAR 8-192
CREATE_TEMPLATE_OBJECT procedure, RAR 4-5
CREATE_TEMPLATE_PARM function, SPR 40-26, RAR 8-196
CREATE_USER_AUTHORIZATION function, SPR 40-28, RAR 8-198
CREATE_USER_AUTHORIZATION procedure, RAR 4-10
CREATE_USER_PARM_VALUE function, SPR 40-29, RAR 8-199
CREATE_USER_PARM_VALUE procedure, RAR 4-9
DELETE_RUNTIME_PARMS procedure, SPR 40-32, RAR 8-202
DROP_ALL_OBJECTS procedure, SPR 40-33, RAR 8-203
DROP_ALL_TEMPLATE_PARMS procedure, SPR 40-34, RAR 8-204
DROP_ALL_TEMPLATE_SITES procedure, SPR 40-35, RAR 8-205
DROP_ALL_TEMPLATES procedure, SPR 40-36, RAR 8-206
DROP_ALL_USER_AUTHORIZATIONS procedure, SPR 40-36, RAR 8-206
DROP_ALL_USER_PARM_VALUES procedure, SPR 40-37, RAR 8-207
DROP_REFRESH_TEMPLATE procedure, SPR 40-39, RAR 8-209
DROP_SITE_INSTANTIATION procedure, SPR 40-40, RAR 7-12, RAR 8-210
DROP_TEMPLATE_OBJECT procedure, SPR 40-41, RAR 8-211
DROP_TEMPLATE_PARM procedure, SPR 40-43, RAR 8-213
DROP_USER_AUTHORIZATION procedure, SPR 40-44, RAR 8-214
DROP_USER_PARM_VALUE procedure, SPR 40-45, RAR 8-215
GET_RUNTIME_PARM_ID function, SPR 40-46, RAR 8-216
INSERT_RUNTIME_PARMS procedure, SPR 40-47, RAR 8-217
INSTANTIATE_OFFLINE function, SPR 40-49, RAR 8-219
INSTANTIATE_OFFLINE procedure, RAR 4-14
INSTANTIATE_OFFLINE_REPAPI function, SPR 40-51, RAR 8-221
INSTANTIATE_ONLINE function, SPR 40-54, RAR 8-224
INSTANTIATE_ONLINE procedure, RAR 4-15
LOCK_TEMPLATE_EXCLUSIVE procedure, SPR 40-57, RAR 8-227
LOCK_TEMPLATE_SHARED procedure, SPR 40-57, RAR 8-227
DBMS_REPUTIL package, SPR 41-2, RAR 8-228
FROM_REMOTE function, SPR 41-4, RAR 8-230
GLOBAL_NAME function, SPR 41-5, RAR 8-231
MAKE_INTERNAL_PKG procedure, SPR 41-5, RAR 8-231
REPLICATION_IS_ON function, SPR 41-4, RAR 8-230
REPLICATION_OFF procedure, SPR 41-3, RAR 8-229, REP 6-4, REP 6-18
REPLICATION_ON procedure, SPR 41-3, RAR 8-229, REP 6-4, REP 6-19
SYNC_UP_REP procedure, SPR 41-6, RAR 8-232
DBMS_RESOURCE_MANAGER package, SPR 42-1, SAD 25-5, SAD 25-6, SAD 25-14, SAD 25-15
procedures (table of), SAD 25-3
DBMS_RESOURCE_MANAGER_PRIVS package, SPR 43-1, SAD 25-5, SAD 25-14
procedures (table of), SAD 25-4
DBMS_RLS package, ADG 11-38, ADG 11-46, SPR 44-1
security policies, SCN 325
uses definer rights, SCN 311
DBMS_ROWID package, MIG 12-3, SPR 45-1
and extended rowids, SQL 2-27
DBMS_SESSION package, SPR 46-1, SAD 25-17
SET_CONTEXT procedure, ADG 11-52
SET_ROLE procedure, ADG 11-10
DBMS_SHARED_POOL package, SPR 47-1, STU 13-4, STU 19-13, STU 19-26
DBMS_SNAPSHOT package, SPR 48-2, RAR 8-233
and DBMS_MVIEW as synonym for, SPR 22-1
BEGIN_TABLE_REORGANIZATION procedure, SPR 48-3, RAR 7-20, RAR 8-234
DBMS_MVIEW package, SPR 48-1
END_TABLE_REORGANIZATION procedure, SPR 48-3, RAR 7-20, RAR 8-234
I_AM_A_REFRESH function, SPR 48-4, RAR 8-235
PURGE_DIRECT_LOAD_LOG procedure, SPR 48-4, RAR 8-235
PURGE_LOG procedure, SPR 48-5, RAR 7-19, RAR 8-236
PURGE_SNAPSHOT_FROM_LOG procedure, SPR 48-6, RAR 7-15, RAR 7-16, RAR 8-237
REFRESH procedure, SPR 48-8, RAR 7-40, RAR 8-239
REFRESH_ALL_MVIEWS procedure, SPR 48-11, RAR 8-242
REFRESH_DEPENDENT procedure, SPR 48-12, RAR 8-243
REGISTER_SNAPSHOT procedure, SPR 48-14, RAR 8-245, REP 3-17
UNREGISTER_SNAPSHOT procedure, SPR 48-16, RAR 7-16, RAR 8-247, REP 3-17
DBMS_SPACE package, SPR 49-1, PSA 8-14, SAD 12-15
DBMS_SPACE_ADMIN package, SPR 50-1, SAD 9-23 to SAD 9-26
DBMS_SQL package, SCN 28
advantages of, ADG 8-17
bulk SQL, ADG 8-17
client-side programs, ADG 8-17
DESCRIBE, ADG 8-17
differences with native dynamic SQL, ADG 8-12
locating errors, SPR 51-31
multiple row updates and deletes, ADG 8-18
Oracle supplied packages, SCN 59
parsing DDL statements, SCN 28
RETURNING clause, ADG 8-18
See Also dynamic SQL
SET_ROLE procedure, ADG 11-11
DBMS_STATISTICS package, DWG 19-3
DBMS_STATS package, OID 13-3, SPR 52-1, DWG 15-3, SCN 135, STU 8-5, STU 8-6
creating histograms, SCN 134, STU 8-18
estimated statistics, SCN 137
partition statistics, SCN 11-13
upgrading statistics tables, MIG 7-37
used for computing statistics, SAD 19-8
DBMS_TRACE package, SPR 53-1
DBMS_TRANSACTION package, SPR 54-1
PURGE_LOST_DB_ENTRY procedure, DDS 5-16
DBMS_TTS package, SPR 55-1
DBMS_UTILITY package, SPR 56-1
ANALYZE_SCHEMA procedure
used for computing statistics, SAD 19-9
DBMSIOTC.SQL script, SRF 5-4
DBMSLOB.SQL script
compatibility, MIG 9-33
DBMSOTRC.SQL script, SRF 5-4
DBMSPOOL.SQL script, SRF 5-4, STU 13-4, STU 19-13
DBMSSTDX.SQL script, SQL 7-285, SQL 7-344, SQL 7-348, SQL 7-355
and triggers, SQL 7-427
DBMSUTIL.SQL script, PSA 8-14
DBNAME
Migration utility option, MIG 4-17
/dbs directory, PSG A-3
DBSNMP START command, PSG 6-10
DBSNMP_START command, NET A-5
DBSNMP_STATUS command, NET A-5
DBSNMP_STOP command, NET A-6
DBVERIFY utility, SBR 4-16, SUT 9-1
output, SUT 9-3
restrictions, SUT 9-1
syntax, SUT 9-2
DBWn background process, SCN 8-8
See also database writer process
DBWR_IO_SLAVES initialization parameter, SRF 1-34
dc attribute, NET 2-40
DCE
address parameters in listener.ora and tnsnames.ora files, OAS 14-2
address parameters in protocol.ora file, OAS 14-12
backward compatibility, OAS 12-2
CDS naming adapter components, OAS 12-4
communication and security, OAS 12-3
components, OAS 12-3
configuration files required, OAS 14-4
configuring a server, OAS 14-4
configuring clients for DCE integration, OAS 14-12
configuring clients to use DCE CDS naming, OAS 14-15
configuring to use DCE Integration, OAS 13-2
connecting clients without access to DCE and CDS, OAS 16-2
connecting to an Oracle server, OAS 15-3
externally-authenticated accounts, OAS 14-5
limitations, OAS 12-5
overview, OAS 12-2
sample address in tnsnames.ora file, OAS 14-16
sample listener.ora file, OAS 16-2
sample parameter files, OAS 16-2
sample tnsnames.ora file, OAS 16-2
SERVER_PRINCIPALparameter, OAS 14-17
SERVICE parameter, OAS 14-17
setting up external roles,, OAS 14-7
starting the listener, OAS 15-2
syntax for mapping groups to Oracle roles, OAS 14-7
verifying DCE groups are mapped to OS roles, OAS 14-9
DCE GSSAPI authentication
configuring, OAS 9-2
connecting to an Oracle server, OAS 9-4
creating the DCE principal, OAS 9-2
when to use, OAS 9-1
with Oracle DCE integration, OAS 9-1
DCE Integration, described, NET 4-27
DCE principal
for DCE GSSAPI authentication, OAS 9-2
DCE Secure Core services, OAS 12-5
dce_service_name, verifying, OAS 15-2
DCE.AUTHENTICATION parameter, OAS 14-12
DCE.LOCAL_CELL_USERNAMES parameter, OAS 14-12
DCE.PROTECTION parameter, OAS 14-12
DCE.TNS_ADDRESS_OID parameter, OAS 14-12
DCE.TNS_ADDRESS.OID parameter
modifying in protocol.ora file, OAS 14-16
DD date format element, SQL 2-46
DDD date format element, SQL 2-46
data definition language
See also Data Definition Language
DDL, PCO 14-32, SCN 12
commands, PSA 10-3
for LOBs, DCI 6-2
DDL (Data Definition Language), PCO 5-2
DDL. See data definition language
DDL. See data definition language
DDL. See data definition language
DDL statements
package state and, ADG 9-17
requiring exclusive access, SQL 6-2
dead connection detection
described, NET 2-6
limitations, NET 8-23
SQLNET.EXPIRE_TIME parameter, NET C-18
dead transactions, SCN 344
block-level recovery, SCN 355
deadlock, PCO 3-12
definition of, PC_ 3-16
effect on transactions, PC_ 3-22, PCO 3-17
how broken, PC_ 3-22, PCO 3-17
deadlock detection, PSC 3-5
deadlocks, PLS 5-42
artificial, SCN 8-20
avoiding, SCN 229
defined, SCN 227
detection of, SCN 228
distributed transactions and, SCN 229
effect on transactions, PLS 5-44
how broken, PLS 5-44
resolving
in synchronous propagation, REP 2-33
DEALLOCATE DESCRIPTOR statement, PC_ 14-14, PC_ F-34, PCO F-23
DEALLOCATE UNUSED clause, SAD 12-15
of ALTER CLUSTER, SQL 7-3, SQL 7-5
of ALTER INDEX, SQL 7-30
of ALTER TABLE, SQL 7-150
deallocating extents, SCN 4-15
deallocating unused space, PSA 8-14, SAD 12-14
DBMS_SPACE package, SAD 12-15
DEALLOCATE UNUSED clause, SAD 12-15
examples, SAD 12-16
high water mark, SAD 12-15
DEBUG clause
of ALTER FUNCTION, SQL 7-28
of ALTER PACKAGE, SQL 7-65
of ALTER PROCEDURE, SQL 7-68
of ALTER TRIGGER, SQL 7-184
of ALTER TYPE, SQL 7-188
debug command (RMAN), RMN 9-8, RMN 10-68
debug level, OID F-5
debug logging levels, OID 5-23
for replication server, OID 10-12
setting, OID 5-23
DEBUG_EXPTOC package, SPR 57-1
DEBUG_EXTPROC package, ADG 10-48
DEBUG_EXTPROC, Using, DCI 4-14
debugging
C code in DLLs, DCI 4-15
common errors, DCI 5-9
PL/SQL, DCI 5-8
stored procedures, ADG 9-47
triggers, ADG 13-30
Debugging External Procedures, DCI 4-14
debugging RMAN, RMN 9-8
DEC keyword
behavior in Oracle7 and Oracle8i, MIG 9-23
DEC subtype, PLS 2-14
decimal character
default, NLS 2-10
NLS_NUMERIC_CHARACTERS parameter, NLS 2-21
when not a period (.), NLS 2-22
decimal characters, SQL 2-4
specifying, SQL 2-42
DECIMAL datatype, PCO 4-7, SUT 5-61
(packed), SUT 5-59
ANSI, SQL 2-28
DB2, SQL 2-29
EXTERNAL format
SQL*Loader, SUT 5-67
length and precision, SUT 5-16
SQL/DS, SQL 2-29
DECIMAL subtype, PLS 2-14
Decimal-Point is Comma, PCO A-3
decision support, STU 3-4
processes, DWG 18-35
systems (DSS), STU 1-2
tuning, STU 9-15
with OLTP, STU 3-6
decision support systems
bitmap indexes, DWG 6-3
decision support systems (DSS), SCN 11-6
bitmap indexes, SCN 10-35
disk striping, SCN 205
materialized views, SCN 10-18
parallel DML, SCN 194
parallel SQL, SCN 158, SCN 188, SCN 194
partitions, SCN 11-6
performance, SCN 11-9, SCN 194
scoring tables, SCN 195
Decision Support Systems. See DSS
declaration
cursor, PCO 5-12
host variable, PCO 2-8
of cursors, PC_ 6-12
of host arrays, PC_ 8-2
of pointer variables, PC_ 4-46
of SQLCA, PC_ 9-16
declarations
collection, PLS 4-7
constant, PLS 2-31
cursor, PLS 5-7
cursor variable, PLS 5-17
exception, PLS 6-7
forward, PLS 7-10
object, PLS 9-22
record, PLS 4-43
subprogram, PLS 7-10
variable, PLS 2-30
declarative part
of function, PLS 7-7
of PL/SQL block, PLS 1-3
of procedure, PLS 7-4
declarative referential integrity constraints, DDS 3-3
declarative SQL statement, PCO 2-4
using in transactions, PCO 3-13
declarative SQL statements
in transactions, PC_ 3-17
uses for, PC_ 2-3
where allowed, PC_ 2-3
declarative statements
also known as directives, PCO 2-4
DECLARE CURSOR directive, PCO F-24
example, PCO 5-12
examples, PCO F-25
DECLARE CURSOR directives
examples, PC_ F-37
DECLARE CURSOR statement, PC_ 14-25
AT clause, PCO 3-7
AT clause in, PC_ 3-10
in dynamic SQL method 4, PCO 11-29
use in dynamic SQL method 4, PC_ 15-25
where to place, PCO 5-13
DECLARE DATABASE directive, PCO F-26
DECLARE DATABASE SQL directives, PC_ F-37
Declare Section
allowable statements, PC_ 2-11, PCO 2-20
example, PCO 2-20
form, PC_ 2-10
purpose, PC_ 2-10, PCO 2-19
required when MODE=ANSI, PC_ 10-31
requirements, PC_ 2-10, PCO 2-19
rules for defining, PC_ 2-11, PCO 2-20
using more than one, PCO 2-21
when MODE=ANSI, PC_ 5-15
when required, PC_ 2-10, PC_ 4-12
declare section
COBOL datatypes supported, PCO 4-13
defining usernames and passwords, PCO 3-2
DECLARE SECTION is optional, PCO A-4
DECLARE statement, PC_ 6-13
example of, PC_ 6-12
purpose of, PC_ 6-11
required placement of, PC_ 6-12
scope of, PC_ F-40
use in dynamic SQL method 3, PC_ 13-20
using in dynamic SQL method 3, PCO 9-20
DECLARE STATEMENT directive, PC_ F-39, PCO F-27
examples, PCO F-28
scope of, PCO F-28
DECLARE STATEMENT statement
AT clause, PCO 3-8
AT clause in, PC_ 3-12
example, PCO 9-28
example of using, PC_ 13-28
using in dynamic SQL, PCO 9-28
using with dynamic SQL, PC_ 13-28
when required, PC_ 13-28, PCO 9-28
DECLARE statements
examples, PC_ F-40
DECLARE TABLE directive, PCO F-29
examples, PC_ F-41, PCO F-30
using with the SQLCHECK option, PC_ D-5
DECLARE TABLE directives
using with the SQLCHECK option, PCO E-4
DECLARE TABLE SQL directive, PC_ F-40
DECLARE TABLE statement
need for with AT clause, PC_ 3-10, PCO 3-7
DECLARE TYPE directive, PC_ F-42
DECLARE_SECTION precompiler option, PCO 14-17
declaring
cursor variables, PCO 6-31
host tables, PCO 7-2
host variables, PCO 4-13
indicator variables, PCO 4-24
ORACA, PCO 8-24
SQLCA, PCO 8-8
SQLDA, PCO 11-7
VARCHAR variables, PCO 4-26
DECODE expressions, SQL 5-12
DECODE function
treatment of nulls, PLS 2-51
decomposition of SQL statements, STU 9-32
dedicated server
and Primary/Secondary Instance, PSC 9-18
dedicated server processes, SAD 4-2
trace files for, SAD 4-15
dedicated servers, SCN 8-23
bequeathed sessions, NET 2-19
defined, SCN 1-16
described, NET 2-13
examples of use, SCN 8-25
multi-threaded servers contrasted with, NET 9-2
multi-threaded servers versus, SCN 8-16
prespawned dedicated servers, NET 2-16
routing connections, NET 8-21
DEF_SQLCODE precompiler option, PC_ 10-17
default
audit options, SAD 24-10
disabling, SAD 24-13
column values, ADG 4-4, ADG 9-57
error handling, PCO 8-15
maximum savepoints, ADG 7-6
parameters in stored functions, ADG 9-59
PCTFREE option, ADG 2-4
PCTUSED option, ADG 2-6
role, ADG 11-24
setting of LITDELIM option, PCO 2-14, PCO 14-26
setting of ORACA option, PCO 8-25
DEFAULT - oracle.xml.parser.v2.AttrDecl.DEFAULT, JPR 4-6
default ACP, modifying, OID 9-16
default cache, STU 19-33
DEFAULT clause
of CREATE TABLE, SQL 7-392
DEFAULT column values
Oracle Version 6 export files, SUT 2-62
default connection, PCO 3-5
default connections, PC_ 3-8
DEFAULT COST clause
of ASSOCIATE STATISTICS, SQL 7-211, SQL 7-212
default database, PC_ 3-7
Default Domain field, NET 6-63
default file name extensions, PC_ 19-38
OTT, OCI 14-36
DEFAULT keyword, PLS 2-31
default name mapping
OTT, OCI 14-36
default network domains, NET 8-17
in Oracle Names, NET 4-17
default parameter values, PLS 7-20
default port, OID 4-3
default port number, OID 3-5, OID 3-8
DEFAULT profile
assigning to users, SQL 7-494
DEFAULT ROLE clause
of ALTER USER, SQL 7-195
default roles, SAD 23-18
DEFAULT SELECTIVITY clause
of ASSOCIATE STATISTICS, SQL 7-211, SQL 7-212
DEFAULT storage clause
of ALTER TABLESPACE, SQL 7-180
of CREATE TABLESPACE, SQL 7-422
DEFAULT TABLESPACE clause
of ALTER USER. See CREATE USER
of CREATE USER, SQL 7-453
default values, SCN 10-9
constraints effect on, SCN 10-9, SCN 274
user-defined types, ADO 2-3
DEFAULT_ADMIN_CONTEXT parameter, NET C-79
DEFAULT_CONSUMER_GROUP for Database Resource Manager, SAD 25-11, SAD 25-12, SAD 25-15, SAD 25-17
DEFAULTIF keyword
SQL*Loader, SUT 5-44, SUT 5-80
defaults
profile, SAD 22-22
role, SAD 22-20
tablespace quota, SAD 22-17
user tablespaces, SAD 22-16
DefaultXMLDocumentHandler - oracle.xml.parser.v2.DefaultXMLDocumentHandler, JPR 4-9
DefaultXMLDocumentHandler() - oracle.xml.parser.v2.DefaultXMLDocumentHandler.DefaultXMLDocumentHandler(), JPR 4-11
DEFCALL view, RAR 9-48, SRF 2-2, SRF 2-142
DEFCALLDEST view, RAR 9-48, SRF 2-2, SRF 2-142
DEFDEFAULTDEST view, RAR 9-48, SRF 2-2, SRF 2-142
adding destinations to, SPR 11-4, RAR 8-19
removing destinations from, SPR 11-4, SPR 11-5, RAR 8-19, RAR 8-20
DEFERRABLE clause
of constraint_clause, SQL 7-243
deferrable constraints, SQL 7-598
DEFERRCOUNT view, RAR 9-49, SRF 2-2, SRF 2-142
DEFERRED clause
of SET CONSTRAINTS, SQL 7-598
deferred constraints
deferrable or nondeferrable, SCN 274
initially deferred or immediate, SCN 274
deferred constraints and updatable snapshots, REP A-8
deferred destination state, SAD 7-13
deferred rollback segment, PSC A-21
deferred transaction queue, RAR 7-24
managing, RAR 7-24
purging propagated transactions, RAR 7-25
push, REP 2-20
scheduled purge, REP 3-34
scheduled push, REP 3-34
deferred transactions, REP 2-19
DefDefaultDest table
removing destinations from, SPR 11-5, RAR 8-20
DEFDEFAULTDEST view
adding destination to, SPR 11-4, RAR 8-19
removing destinations from, SPR 11-4, RAR 8-19
deferred remote procedure calls (RPCs)
argument types, SPR 10-4, RAR 8-12
argument values, SPR 10-7, RAR 8-15
arguments to, SPR 9-5, RAR 8-7
building, SPR 9-3, RAR 8-4
executing immediately, SPR 11-13, RAR 8-28
deleting from queue, SPR 11-6, RAR 8-21
diagnosing problems with, REP B-6
re-executing, SPR 11-9, RAR 8-24
scheduling execution, SPR 11-19, RAR 8-34
starting, SPR 9-7, RAR 8-9
views, RAR 9-47
DEFERROR view, RAR 7-26, RAR 9-49, SRF 2-2, SRF 2-142
deleting transactions from, SPR 11-5, RAR 8-20
define
arrays, OCI 12-6
return and error codes, OCI 2-29
define functions, OCI 15-43
define handle
attributes, OCI A-23
description, OCI 2-10
define operation, OCI 4-14, OCI 5-18, OCI 12-4
example, OCI 5-19
LOBs, OCI 5-21
named datatypes, OCI 5-21, OCI 12-4
piecewise fetch, OCI 5-22
PL/SQL output variables, OCI 5-21
REFs, OCI 5-21, OCI 12-4
static arrays, OCI 5-22
steps used, OCI 5-19
define phase of query processing, SCN 21
DEFINE precompiler option, PC_ 10-18, PCO 14-18
used in application migration, PC_ 5-35
define variable, PLS 10-3
DefinedNodes registry value, PSG 3-26
definer rights, PLS 7-29, SCN 49
name resolution, SCN 62
procedure security, SCN 310
versus invoker rights, PLS 7-29
defining
OCINumber, OCI 12-8
defining object classes, OID 2-7
defining symbols, PC_ 2-15
defining users
in multi-cell environment, OAS 14-6
definitions. See terminology
DEFLOB view, RAR 9-50, SRF 2-2, SRF 2-142
DEFPROPAGATOR view, RAR 9-50, SRF 2-2, SRF 2-142
DEFSCHEDULE view, RAR 9-51, SRF 2-2, SRF 2-142
DEFTRAN view, RAR 9-52, SRF 2-2, SRF 2-142
DEFTRANDEST view, RAR 9-52, SRF 2-2, SRF 2-142
DEGREE keyword
in PARALLEL clause, MIG 9-35
degree of parallelism, SCN 171, SCN 176, SCN 179
adaptive multi-user feature, PSA 2-6
and adaptive multi-user, DWG 18-5
between query operations, SCN 169
parallel SQL, SCN 163, SCN 172
setting, DWG 18-5, PSA 2-2
deinstalling, MIG 1-13
delay, ADQ 2-6
Delay Interval, Retry With, ADQ 8-84
DELAY parameter, NET 8-13, NET C-44, PSG 5-3
Delay, Time Specification, ADQ 8-46, ADQ 12-62
DELAYED_LOGGING_BLOCK_CLEANOUTS initialization parameter: obsolete
DELAYED_LOGGING_BLOCK_CLEANOUTS parameter, PSC A-11, PSC A-16
DELEGATE_DOMAIN command, NET 6-73, NET A-28
delegated administrative regions
below root, NET 4-21
diagram, NET 4-20
domains to, NET 6-73
in Oracle Names, NET 4-19
DELETE
block access during, PSA 6-9
object privilege, SQL 7-535
statement, SQL 7-464
DELETE ANY TABLE privilege
SQL*Loader, SUT 5-33
DELETE ANY TABLE system privilege, SQL 7-526
DELETE CASCADE, PC_ 9-21
SQL*Loader, SUT 5-33
delete cascade constraint, SCN 267
DELETE collection method, PLS 4-26, PLS 11-20
DELETE command
column values and triggers, ADG 13-16
data consistency, ADG 7-11
triggers for referential integrity, ADG 13-43, ADG 13-44
delete expired backup command (RMAN), RMN 3-21, RMN 10-69
DELETE privilege, ADG 11-22
SQL*Loader, SUT 5-33
DELETE privilege for object tables, ADO 2-12, ADO 2-13
delete script command (RMAN), RMN 10-71, RMN 10-72
DELETE SQL statement, PC_ F-43
DELETE statement, PCO F-31, SCN 12
embedded SQL examples, PC_ F-46, PCO F-34
example, PCO 5-11
example of, PC_ 6-10
foreign key references, SCN 266
freeing space in data blocks, SCN 4-10
no-logging mode, SCN 152
LOBs, SCN 151
parallel DELETE, SCN 178
purpose of, PC_ 6-10
restrictions with tables, PCO 7-15
RETURNING clause, PLS 5-64
syntax, PLS 11-52
triggers, SCN 82, SCN 87
triggers on, SQL 7-429
using host arrays in, PC_ 8-13
using host tables, PCO 7-14
WHERE clause, PCO 5-11
WHERE clause in, PC_ 6-10
DELETE STATISTICS clause
of ANALYZE, SQL 7-206
DELETE_CATALOG_ROLE role, SQL 7-530
DELETE_CATALOG_ROLE roll, SAD 23-3
deletes
positioned, OCI 2-34
deleting
attributes, OID 6-19
guidelines for, OID 6-19
using ldapmodify, OID A-13
audit log events, OID 5-27
backups and image copies, RMN 3-20
base schema attributes, OID 6-19
configuration set entries, OID 5-2
using Oracle Directory Manager, OID 5-4
datafiles, SBY 5-25
entries, OID 4-14
using command line tools, OID 7-25
using ldapdelete, OID A-16
using ldapmodify, OID A-14
object classes
from base schema, OID 6-4
not in base schema, OID 6-4
using Oracle Directory Manager, OID 6-17
obsolete backups and copies, RMN 3-21
row containing LOB
internal persistent LOBs, ADL 9-271
tablespaces, SBY 5-25
values from attributes, using ldapmodify, OID A-13
deleting table statistics, SAD 19-4
delimited data
maximum length for SQL*Loader, SUT 5-73
delimited fields
field length, SUT 5-73
delimited files
exporting, SUT 1-3
delimited LOBs, SUT 5-103
delimiter_spec, SUT 5-16
delimiters, PLS 2-3
C versus SQL, PC_ 2-11
control files, SUT 5-16
initial and trailing example, SUT 4-28
loading trailing blanks, SUT 5-73
marks in data and SQL*Loader, SUT 5-72
optional SQL*Loader enclosure, SUT 5-83
specifying for SQL*Loader, SUT 5-42, SUT 5-70
SQL*Loader enclosure, SUT 5-83
SQL*Loader field specifications, SUT 5-83
termination, SUT 5-83
demand rate, STU 1-5
demo directory (PL/SQL), DCI 4-10
demo file (extdemo1.sql)
extensible indexing in power demand example, DCI 11-15
DEMO_DIM package, DWG 9-12
demonstration programs, ADL 1-5, OCI B-1
list, OCI B-1
denormalized
star schemas, DWG 2-4
denormalized tables, SCN 1-28, SCN 10-20
dense collections, PLS 4-3
DENSE_RANK function, DWG 17-24, SQL 4-29
departmental partitioning method, PSA 5-13
departmentalized applications, PSC 8-7
dependencies, SCN 107
among PL/SQL library objects, ADG 9-28
between schema objects, SCN 108
displaying, SAD 19-31
function-based indexes, SCN 10-28, SCN 113
in stored triggers, ADG 13-28
local, SCN 116
managing, SCN 107
non-existent referenced objects and, SCN 114
object type definitions, ADO 2-14, ADO 2-15
on non-existence of other objects, SCN 115
Oracle Forms triggers and, SCN 119
privileges and, SCN 112
remote objects and, SCN 116
schema objects
trigger management, ADG 13-20
shared pool and, SCN 116
the timestamp model, ADG 9-29
dependency
ordering
replicated transactions, REP 6-21
tracking
parallel propagation, REP 6-21
dependent data marts, DWG 20-2
DEPENDING ON clause, PCO 7-3
deployment
techniques for application development, PSA 5-2
deployment examples, OID 14-9
Deployment Template Wizard, REP 8-22
deployment templates, REP 1-11, REP 4-1, SCN 431
adding objects to, RAR 4-5
adding snapshots to, REP 4-14
alter object, SPR 40-6, RAR 8-176
alter parameters, SPR 40-9, RAR 8-179
alter template, SPR 40-4, RAR 8-174
alter user authorization, SPR 40-11, RAR 8-181
alter user parameter values, SPR 40-12, RAR 8-182
architecture, REP 4-14
authorize users, RAR 4-10
column subsetting, REP 4-22
compare templates, SPR 40-15, RAR 8-185
concepts, RAR 4-2, REP 4-3
copy template, SPR 40-16, RAR 8-186
create object from existing, SPR 40-18, RAR 8-188
create template, SPR 40-20, RAR 8-190
creating, RAR 4-2, RAR 4-4
data dictionary views for, RAR 9-8
data sets, REP 4-27
definitions, REP 4-14
design, REP 4-22
distributing files, RAR 4-16
drop site instantiation, SPR 39-3, RAR 8-164
dropping, SPR 40-39, RAR 8-209
dropping all, SPR 40-36, RAR 8-206
dropping snapshot group, RAR 7-10
elements, REP 4-4
flowchart for creating, RAR 4-3
general template information, REP 4-4
horizontal partitioning, REP 4-24
instantiating, RAR 4-17
instantiation, REP 1-11, REP 4-9, SCN 431
offline, REP 4-10, REP 4-18, REP A-3
online, REP 4-9, REP 4-17
process, REP 4-16
scenarios, REP 4-11
instantiation script, RAR 4-15
lock template, SPR 40-57, RAR 8-227
object definitions, REP 4-6, REP 4-14
objects
creating, SPR 40-22, RAR 8-192
dropping, SPR 40-41, RAR 8-211
dropping all, SPR 40-33, RAR 8-203
offline instantiation, SPR 39-3, SPR 39-6, SPR 40-49, SPR 40-51, RAR 4-11, RAR 8-164, RAR 8-167, RAR 8-219, RAR 8-221
online instantiation, SPR 39-9, SPR 40-54, RAR 8-170, RAR 8-224
packaging, RAR 4-11, RAR 4-13, REP 4-9
for offline instantiation, RAR 4-13, REP 4-16
for offline instantiation (Oracle8i Lite), REP C-14
for online instantiation, RAR 4-14, REP 4-16
procedures, REP 4-13
process, REP 4-16
parameters, REP A-2
creating, SPR 40-26, RAR 4-7, RAR 8-196
dropping, SPR 40-43, RAR 8-213
dropping all, SPR 40-34, RAR 8-204
user values, RAR 4-9
preparing snapshot sites for, REP 7-13
refresh groups, REP 4-21
runtime parameters
creating, SPR 40-47, RAR 8-217
deleting, SPR 40-32, RAR 8-202
get ID, SPR 40-46, RAR 8-216
inserting, SPR 40-47, RAR 8-217
sites
dropping, SPR 40-40, RAR 8-210
dropping all, SPR 40-35, RAR 8-205
snapshot groups, REP 4-21
snapshot logs, REP 4-13
snapshot sites, REP 4-9
template parameters, REP 4-7
security, REP 4-8
user authorization, REP 4-8
user authorizations
creating, SPR 40-28, RAR 8-198
dropping, SPR 40-44, RAR 8-214
dropping all, SPR 40-36, RAR 8-206
user parameter values
creating, SPR 40-29, RAR 8-199
dropping, SPR 40-45, RAR 8-215
dropping all, SPR 40-37, RAR 8-207
vertical partitioning, REP 4-22
DEPT database table, PLS xiii
DEPT table, PC_ 2-17, PCO 2-28
DEPTH column
TKPROF_TABLE table, STU 6-18
DEPTREE view, SRF 2-142
Dequeue a Message, ADQ 11-45
Dequeue failed - error, ADQ D-4
DEQUEUE Features, ADQ 8-55
Dequeue Methods, ADQ 8-56
dequeue mode, ADQ 2-6
dequeue of messages after preview, ADQ A-33
DEQUEUE request, SCN 74
Dequeue, Message Navigation in, ADQ 8-65
DequeueOption must be specified - error, ADQ D-12
Dequeuing of the Same Message, Multiple-Consumer, ADQ 7-6
Dequeuing, Modes of, ADQ 8-69
DEREF function, PLS 9-33, SQL 4-30
dereference, PLS 9-33
dereferencing, ADO 1-7, ADO 9-22, SCN 13-10
implicit, ADO 1-7, ADO 9-22, SCN 13-10
DES, OAS 1-5
DES (Data Encryption Standard), SPR 23-1
DES encryption algorithm, OAS 2-3
DES40 encryption, OID 2-26
DES40 encryption algorithm, OAS 2-3
DESC clause
of CREATE INDEX, SQL 7-299
DESC function, ADG 5-8
DESC_TAB datatype, SPR 51-30
descending indexes, SQL 7-299
describe
explicit, OCI 4-13
explicit and implicit, OCI 6-5
implicit, OCI 4-12
of collections, OCI 6-2
of databases, OCI 6-2
of packages, OCI 6-2
of schemas, OCI 6-2
of sequences, OCI 6-2
of stored functions, OCI 6-2
of stored procedures, OCI 6-2
of synonyms, OCI 6-2
of tables, OCI 6-2
of types, OCI 6-2
of views, OCI 6-2
select-list, OCI 4-11
DESCRIBE BIND VARIABLES statement
in dynamic SQL method 4, PCO 11-29
use in dynamic SQL method 4, PC_ 15-25
describe cache high water mark
definition, DDS A-3
DESCRIBE command
use with PREPARE command, PC_ F-47
DESCRIBE DESCRIPTOR statement, PC_ F-49, PCO F-36
describe functions, OCI 15-43
describe handle
attributes, OCI A-25
description, OCI 2-11
DESCRIBE INPUT statement, PC_ 14-22
describe operation
server roundtrips, OCI C-6
DESCRIBE OUTPUT statement, PC_ 14-22
describe phase of query processing, SCN 21
DESCRIBE SELECT LIST statement
in dynamic SQL method 4, PCO 11-34
use in dynamic SQL method 4, PC_ 15-30
DESCRIBE SQL statement, PC_ F-47
DESCRIBE statement, PCO F-34
example, PCO F-35
examples, PC_ F-48
use in dynamic SQL Method 4, PC_ 13-26
use with PREPARE statement, PCO F-34
using in dynamic SQL method 4, PCO 9-25
DESCRIPTION parameter, NET 6-5, NET C-37, NET C-49
DESCRIPTION_LIST feature, PSC A-15
DESCRIPTION_LIST parameter, NET C-37
descriptions of collection attributes, PC_ 18-15
descriptions of object classes, OID 6-7
descriptor, OCI 2-14
allocating, OCI 2-22
complex object retrieval, OCI 2-17
naming, PCO F-35
objects, OCI 11-23
parameter, OCI 2-16
ROWID, OCI 2-16
snapshot, OCI 2-15
descriptor functions, OCI 15-27
descriptor objects, OCI 11-23
descriptors, PC_ 15-4
bind descriptor, PC_ 13-26, PCO 11-4
definition of, PC_ 13-25
need for, PC_ 15-4
purpose, PCO 11-4
select descriptor, PC_ 13-26, PCO 11-4
SQLADR subroutine, PCO 11-3
using the sqlald() function to allocate, PC_ 15-5
using the sqlclu() function to deallocate, PC_ 15-37
DESDecrypt procedure, SPR 23-3
DESEncrypt procedure, SPR 23-2
Design and Modeling, ADQ x, ADQ 7-1
design dictionary, STU 11-5
designing
databases for Oracle Parallel Server, PSA 6-2
destination
archiving redo log files, SRF 1-55
overriding default, SRF 1-55
USER_DUMP_DEST, SRF 1-121
Destination Level Access Control, ADQ 12-15
Destination must be specified - error, ADQ D-15
destination states for archived redo logs, SAD 7-12, SBY 2-18
DestinationProperty must be specified - error, ADQ D-4
destinations
archived redo logs
sample scenarios, SAD 7-17
DESTROY
Import parameter, SUT 2-20
destroyed server, LEG 5-3
detaching branches, OCI 8-7
detail report in Oracle Trace, STU 14-6
detail tables, DWG 8-7
details property sheet in Oracle Trace, STU 14-15
determining current value of precompiler options, PC_ 10-4
DETERMINISTIC clause
of CREATE FUNCTION, SQL 7-288
DETERMINISTIC functions, STU 4-70
function-based indexes, SCN 114
deterministic functions, STU 4-70
DETERMINISTIC hint, PLS 7-6
DETERMINISTIC keyword, ADG 9-63
Developer/2000 Applications
upgrading, MIG 10-12
developers, application, SAD 21-10
device bandwidth, STU 16-6
evaluating, STU 20-11
device latency, STU 16-6
device resources, LEG 3-2
df command, LEG 5-7
DHCP, LEG B-10
diagnosing
client problems, NET 12-4
errors, see troubleshooting
performance problems, PSA 11-18
diagnosing tuning problems, STU 16-1
DICT synonym for DICTIONARY, SRF 2-142
DICT_COLUMNS view, SRF 2-143
dictionary
See data dictionary
dictionary cache, PSC 4-2
lock, PSA 7-19
locks, PSC 4-7
dictionary cache locks, PSC 4-7, SCN 241
dictionary files
LogMiner and the, SAD 7-28
dictionary protection mechanism, SAD 23-2
DICTIONARY view, SRF 2-143
DICT synonym, SRF 2-142
dictionary_obj_owner event attribute, ADG 14-3
dictionary_obj_owner_list event attribute, ADG 14-3
dictionary_obj_type event attribute, ADG 14-3
dictionary-managed tablespaces, SAD 9-5 to SAD 9-6, SCN 3-8
dictionary-mapped tablespaces, STU 20-29
differences
between tables, SPR 34-3, RAR 8-53
rectifying, SPR 34-6, RAR 8-56
differential incremental backups, RMN 1-51
different-row writers block writers, SCN 221
Diffie-Hellman key negotiation algorithm, OAS 2-6
Digital's POLYCENTER Manager on NetView, DDS 1-32, SCN 403
digits of precision, PLS 2-13
dimension of host tables, PCO 7-3
dimension tables, DWG 8-8, DWG 16-2
normalized, DWG 9-10
dimension wizard, DWG 9-11
dimensions, DWG 2-5, DWG 9-2, DWG 9-13, SCN 1-28, SCN 10-20
altering, DWG 9-14
attributes, SCN 1-28, SCN 10-20
adding, SQL 7-27
changing, SQL 7-26
defining, SQL 7-280
dropping, SQL 7-27
changing hierarchical relationships, SQL 7-26
compiling invalidated, SQL 7-27
creating, DWG 9-6, SQL 7-278
definition, DWG 9-2
dimension tables (lookup tables), DWG 8-7
downgrading, MIG 13-21
dropping, DWG 9-15
examples, SQL 7-280
granting
system privileges on, SQL 7-522
hierarchies, DWG 2-6, SCN 1-28, SCN 10-20
adding, SQL 7-27
defining, SQL 7-279
dropping, SQL 7-27
join key, SCN 1-28, SCN 10-20
hierarchies overview, DWG 2-6
levels
adding, SQL 7-27
defining, SQL 7-279
dropping, SQL 7-27
multiple, DWG 17-2
normalized or denormalized tables, SCN 1-28, SCN 10-20
removing from the database, SQL 7-476
star joins, DWG 16-3, STU 4-62
star queries, DWG 16-2, STU 4-62
validating, DWG 9-14
with query rewrite, DWG 19-29
DIRECT
Export parameter, SUT 1-19, SUT 1-44
SQL*Loader command-line parameter, SUT 6-5
direct hand-off, NET xviii
described, NET 2-9
events in listener.log, NET 12-28
direct path export, SUT 1-42
BUFFER parameter, SUT 1-44
character set and, SUT 1-54
invoking, SUT 1-44
RECORDLENGTH parameter, SUT 1-44
direct path handles, OCI 2-12
direct path load, SUT 8-11
advantages, SUT 8-6
choosing sort order
SQL*Loader, SUT 8-18
compared to conventional path load, SUT 8-7
concurrent, SUT 8-26
conditions for use, SUT 8-8
data saves, SUT 8-12, SUT 8-18
DIRECT command-line parameter
SQL*Loader, SUT 6-5, SUT 8-10
DISABLED_CONSTRAINTS keyword, SUT 8-21
disabling media protection
SQL*Loader, SUT 8-19
dropping indexes, SUT 8-20
dropping indexes to continue an interrupted load, SUT 5-34
effect of PRIMARY KEY constraints, SUT 8-29
effect of UNIQUE KEY constraints, SUT 8-29
example, SUT 4-25
EXCEPTIONS keyword, SUT 8-21
field defaults, SUT 8-9
improper sorting
SQL*Loader, SUT 8-17
indexes, SUT 8-10
instance recovery, SUT 8-13
intersegment concurrency, SUT 8-26
intrasegment concurrency, SUT 8-26
loading into synonyms, SUT 8-9
LONG data, SUT 8-14
media recovery, SUT 8-14
partitioned load
SQL*Loader, SUT 8-25
performance, SUT 8-10, SUT 8-16
preallocating storage, SUT 8-16
presorting data, SUT 8-16
recovery, SUT 8-13
REENABLE keyword, SUT 8-21
referential integrity constraints, SUT 8-21
ROWS command-line parameter, SUT 8-13
setting up, SUT 8-10
specifying, SUT 8-10
specifying number of rows to be read, SUT 6-7
SQL*Loader data loading method, SUT 3-14
table insert triggers, SUT 8-22
temporary segment storage requirements, SUT 8-11
triggers, SUT 8-20
using, SUT 8-7, SUT 8-10
version requirements, SUT 8-9
direct path load API, GTK 3-23
direct path loading, OCI 9-39
column array handle attributes, OCI A-43
column parameter attributes, OCI A-45
context handle attributes, OCI A-40
datatypes of columns, OCI 9-41, OCI A-48
direct path column array handle, OCI 9-42
direct path context handle, OCI 9-41
direct path stream handle, OCI 9-42
example, OCI 9-44
functions, OCI 9-43
handle attributes, OCI A-40
handles, OCI 9-41
limitations, OCI 9-40
stream handle attributes, OCI A-44
direct path loading functions, OCI 15-74
direct path operations
standby databases, SBY 4-13
directives, PC_ 2-3
also known as declarative statements, PCO 2-4
direct-load INSERT, SCN 146
logging mode, SCN 149
parallel INSERT, SCN 147
parallel load vs. parallel INSERT, SCN 147
restrictions, SCN 154, SCN 200
serial INSERT, SCN 147
space management, SCN 153
direct-load inserts
external fragmentation, DWG 18-44
directories
catalog views, ADL 11-10
conceptual overview, OAS 17-3, OID 1-2
distributed, OID 2-10
guidelines for usage, ADL 11-11
installation, DCI 2-6
location-independent, OID 1-2
ownership and privileges, ADL 11-9
partitioned, OID 2-18
read-focused, OID 1-2
directories. See directory objects
directory access configuration, NET 6-17
directory access control, OID 1-5, OID 9-1
Directory Access Protocol (DAP), OID 1-3
vs. LDAP, OID 1-3
directory aliases
exporting, SUT 1-58
importing, SUT 2-57
directory database listener, OID 10-6
Directory Information Tree (DIT), OAS 17-3, OID 2-2
audit log entries in, OID 5-26
Directory Information Tree (DIT), defined, NET 2-40
directory instance registry, OID 2-30
DIRECTORY name specification, ADL 11-8
directory naming
administrative context, NET 2-41
advantages and disadvantages, NET 5-3
architecture, NET 2-40
authentication methods
native, NET 2-51
simple, NET 2-51
SSL, NET 2-51
strong, NET 2-51
configuring, NET 6-16 to NET 6-46
connecting to database services, NET 2-44
connecting with, NET 6-29
connections
using an entry's absolute name, NET 2-46
using an entry's relative name, NET 2-45
default configuration, NET 6-17
described, NET 2-35
directory access configuration, NET 6-17
establishing a connection with, NET 6-29
exporting
net service names from a tnsnames.ora file, NET 6-32
objects from Oracle Names, NET 6-35 to NET 6-46, NET A-30
JDBC clients, NET 3-15
ldapmodify tool, NET 6-31
ldap.ora file
creating, NET 6-18
described, NET 2-44
parameters, NET C-78
listener configuration for, NET 6-28
object classes, NET 2-54
Oracle Context, NET 2-41
Oracle Database Configuration Assistant, NET 6-22
Oracle schema, NET 2-54
OracleDBCreators group, NET 2-43, NET 2-44, NET 2-53, NET 6-22
OracleNetAdmins group, NET 2-44, NET 2-52, NET 6-22, NET 6-23, NET 6-31
OracleSecurityAdmins group, NET 2-53, NET 6-22
overview, NET 2-38
recommended for, NET 5-3
security, NET 2-51
directory naming contexts, OID 5-16
DIRECTORY object, ADL 11-5
catalog views, ADL 11-10
getting the alias and filename, ADL 11-172
guidelines for usage, ADL 11-11
names on WindowsNT, ADL 11-8
naming convention, ADL 11-8
OS file must exist before locator use, and, ADL 11-25
READ permission on object not individual files, ADL 11-9
directory objects, ADL 11-5
as aliases for OS directories, SQL 7-282
auditing, SQL 7-222
creating, SQL 7-282
granting system privileges on, SQL 7-522
redefining, SQL 7-283
removing from the database, SQL 7-477
directory password, changing, OID 5-19
directory path
INCLUDE files, PCO 2-22
Directory Replication Groups (DRGs), OID 2-14, OID 10-2
establishing, OID 10-2
installing and configuring, OID 10-2
directory schema, OID 2-10
managing, OID 6-1
Directory Server Migration Wizard, NET 6-32
directory servers, OID 1-4
as both suppliers and consumers, OID 2-17
changing parameters in an active instance, OID 5-4
configuration set entries, OID 5-2
connecting to, OID 4-3, OID 4-4, OID 4-12, OID 4-17
using Oracle Directory Manager, OID 4-10, OID 4-11
debug level, OID F-5
Directory Information Tree (DIT), NET 2-40
disconnecting, using Oracle Directory Manager, OID 4-10, OID 4-13
Distinguished Name (DN), NET 2-40
in multi-master replication, OID 2-17
in normal mode, OID F-5
in replicated environment, OID 2-17
in secure mode, OID F-5
ldapmodify tool, NET 6-31
Microsoft's Active Directory, NET 2-39
modifying configuration set entries, OID 5-14
multi-master replication between, OID 1-4
multithreaded, OID 1-4
Novell Directory Services external naming, NET 2-39
Oracle Internet Directory, NET 2-39
performance, NET 2-50
processes, OID F-5
restarting, OID 3-9, OID 5-4
running, OID 3-3
security, NET 2-51
start failure, OID 3-10
starting, OID 3-4, OID 4-17, OID 4-18
with default configuration, OID 3-10
without configuration sets, OID 3-10
stopping, OID 3-4
terminating, OID 4-17, OID 4-18
using different configuration set entries, OID 5-2
directory service
See also enterprise directory service.
directory structure, PSG A-1 to PSG A-4
UNIX, PSG A-3
Windows NT, PSG A-4
directory tree, browsing, OID 7-5
directory usage patterns, learning, OID 12-3
directory vs. relational database, OID 1-2
directory_alias parameter, ADL 11-26
DIRECTORY_SERVER_TYPE parameter, NET C-78
DIRECTORY_SERVERS parameter, NET C-78
DirectoryReplicationGroupDSAs, OID 10-14
dirty buffer, SCN 7-4
fast-start checkpointing, SCN 354
incremental checkpoint, SCN 8-8
dirty read, SCN 213, SCN 221
dirty write, SCN 221
DISABLE [constraint] clause
of CREATE TABLE, SQL 7-406
Disable a Propagation Schedule, ADQ 9-82
DISABLE ALL TRIGGERS clause
of ALTER TABLE, SQL 7-165
disable buffering, See LOB buffering
DISABLE clause
of ALTER INDEX, SQL 7-40
of ALTER TRIGGER, SQL 7-184
of constraint_clause, SQL 7-245
of CREATE TABLE, SQL 7-405
DISABLE constraints, SCN 276
DISABLE DISTRIBUTED RECOVERY clause
of ALTER SYSTEM, SQL 7-106
DISABLE NOVALIDATE constraint state, SQL 7-407
Disable Out-of-Band Break option in Net8 Assistant, NET 8-24
DISABLE PARALLEL DML clause
of ALTER SESSION, SQL 7-84
DISABLE QUERY REWRITE clause
of ALTER MATERIALIZED VIEW, SQL 7-54
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-327
DISABLE RESTRICTED SESSION clause
of ALTER SYSTEM, SQL 7-106
DISABLE ROW MOVEMENT clause, SAD 15-8
of ALTER TABLE, SQL 7-164
of CREATE TABLE, SQL 7-383, SQL 7-404
DISABLE STORAGE IN ROW clause
of ALTER TABLE, SQL 7-141
of CREATE TABLE, SQL 7-398
DISABLE TABLE LOCK clause, PSA 10-4
of ALTER TABLE, SQL 7-165
DISABLE THREAD clause, PSA 3-8
of ALTER DATABASE, SQL 7-16
DISABLE VALIDATE constraint state, SQL 7-406
DISABLE VALIDATE constraints
compatibility, MIG 9-13
downgrading, MIG 13-42
DISABLE_OOB parameter, NET 8-24, NET C-6
disabled constraints, STU 12-11
disabled destination state
for archived redo logs, SAD 7-13
DISABLED indexes, SCN 114
DISABLED_CONSTRAINTS keyword
SQL*Loader, SUT 8-21
disablePropagationSchedule(Session, String) - oracle.jms.AQjmsDestination.disablePropagationSchedule(javax.jms.Session, java.lang.String), JPR 2-66
disabling
integrity constraints, ADG 4-20
propagation, SPR 11-21, RAR 8-36
replication, REP 6-17
roles, ADG 11-16
triggers, ADG 13-31
disabling audit options, SAD 24-11, SAD 24-12
disabling auditing, SAD 24-13
disabling recoverer process
distributed transactions, DDS 5-28
disabling resource limits, SAD 22-21
disabling SSL, OID F-5
disabling the archive history, PSA 3-3
disabling threads, PSA 3-8
DISASSOCIATE STATISTICS statement, SQL 7-470
disaster recovery, PSA 14-10, PSA 14-13, SCN 367, SCN 368
procedures overview, LEG 5-8
recovering Oracle data
overview, LEG 5-26
types, LEG 5-1, LEG 5-2, LEG 5-3
disaster recovery on UNIX
configuration files directory, renaming, LEG 5-15
mmrecov command, LEG 5-12
nsrwatch or nwadmin to watch recovery, LEG 5-14
recovering LSM indexes and configuration files, LEG 5-11
recovering LSM to a new machine, LEG 5-16
recovering OS and LSM software, LEG 5-10
restoring Oracle8 data on UNIX, LEG 5-15
disaster recovery on Windows NT
configuration files directory, renaming, LEG 5-22
mmrecov command, LEG 5-21
recovering LSM indexes and configuration files, LEG 5-20
recovering LSM to a new machine, LEG 5-25
recovering OS and LSM software, LEG 5-19
recovery requirements
hardware requirements, LEG 5-18
LSM requirements, LEG 5-18
operating system requirements, LEG 5-18
restoring Oracle Data
overview, LEG 5-24
disaster recovery preparation
bootstrap save set ID
finding the bootstrap for UNIX, LEG 5-5
overview, LEG 5-5
scanner -B command, LEG 5-5
disk information
on UNIX, LEG 5-7, LEG 5-8
overview, LEG 5-6
finding the bootstrap for Windows NT, LEG 5-6
overview, LEG 5-4
discard conflict resolution method, REP 5-17, REP 5-25
discard files
basics, SUT 3-13
DISCARDDN keyword
placement in control file for DB2, SUT B-3
DISCARDS control file clause
placement in control file for DB2, SUT B-3
example, SUT 4-15
SQL*Loader, SUT 5-27
SQL*Loader DISCARDDN keyword, SUT 5-28
SQL*Loader DISCARDMAX keyword, SUT 5-29, SUT 5-30
SQL*Loader DISCARDS keyword, SUT 5-29
discarded records
causes, SUT 5-29
limiting, SUT 5-29
SQL*Loader, SUT 3-11
discarded SQL*Loader records
discard file, SUT 5-27
DISCARDFILE
SQL*Loader command-line parameter, SUT 6-5
DISCARDMAX keyword
SQL*Loader command-line, SUT 6-5
SQL*Loader discarded records, SUT 5-30
Disconnect
button, in Oracle Directory Manager, OID 4-10
menu item, in Oracle Directory Manager, OID 4-10
DISCONNECT command, PSA 4-5
DISCONNECT SESSION clause
of ALTER SYSTEM, SQL 7-106
disconnecting
abnormal termination, NET 2-6
additional connect request, NET 2-6
from Recovery Manager, RMN 2-13
from servers, NET 2-6
user initiated, NET 2-6
disconnecting from an instance, PSA 4-5
multiple sessions, PSA 4-6
user process, PSA 4-5
disconnecting from directory servers, OID 4-13
using Oracle Directory Manager, OID 4-10
disconnections
auditing, SAD 24-8
discontinued loads
continuing with SQL*Loader, SUT 5-34
discovering nodes, PSG 6-15
discovering Oracle Names servers
described, NET 4-24
procedure, NET 6-59
discovery
See service discovery
Discovery Wizard, PSG 6-15
discrete transaction management
summary, SCN 39
discrete transactions
example, STU 17-4
processing, STU 17-3
when to use, STU 17-2
DISCRETE_TRANSACTIONS_ENABLED initialization parameter: obsolete
discretionary access control, SCN 1-38, SCN 280
disjoint data
applications with, PSC 8-6
data files, PSC 7-2
disk
affinity, PSA 2-3, PSA 2-7
contention, PSC 7-7
contention, avoiding, PSA 2-6
reading blocks, PSC 1-4
rollback segments, PSC 7-7
saving information, LEG 5-6
writing blocks, PSC 1-4
disk affinities
and parallel query, DWG 18-47
disabling with MPP, DWG 4-4
with MPP, DWG 18-52
disk affinity
parallel DML, SCN 206
partitions, SCN 205
disk API, RMN 9-19
disk buffers
tuning for RMAN backups. See Oracle8i Tuning, RMN 1-35
disk column
SQL trace, STU 6-12
disk drives
archiving destination, SRF 1-55
writing blocks, SRF 1-42
disk failures, SBR 1-13, SCN 1-45, SCN 345
Disk Reads data view, STU 14-9
Disk Reads/Execution Ratio data view, STU 14-9
Disk Reads/Logical Reads Ratio data view, STU 14-10
Disk Reads/Rows Fetched Ratio data view, STU 14-9
disk space
controlling allocation for tables, SCN 10-4
datafiles used to allocate, SCN 3-16
disk space requirements, estimating, OID 12-7
disk striping
affinity, SCN 205
partitions, SCN 11-9
disk striping of LOB files, ADL 8-3
disk subsystems, PSC 3-7
disk tuning, OID 13-8
DISK_ASYNCH_IO initialization parameter, SRF 1-35
DISK_ASYNCH_IO parameter, DWG 18-26
DISKRATIO parameter
to distribute backup I/O, STU 20-61
diskratio parameter
backup command (RMAN), RMN 10-29
disks
contention, PSC 7-2, STU 20-18, STU 20-19
distributing I/O, STU 20-19
I/O requirements, STU 20-4
layout options, STU 20-10
monitoring OS file activity, STU 20-15
number required, STU 20-4
placement of datafiles, STU 20-19
placement of redo logs, STU 20-19
reducing contention, STU 20-18
speed characteristics, STU 20-3
testing performance, STU 20-5
writing blocks, PSC 5-22
dispatcher processes, SAD 4-6, SAD 4-10, SAD 4-13
creating additional, SQL 7-114
maximum number, SRF 1-71
terminating, SQL 7-114
dispatcher processes (Dnnn), STU 21-8
dispatcher processes (Dnnn)
defined, SCN 1-18
described, SCN 8-14
limiting SGA space per session, SCN 297
listener process and, SCN 8-14
network protocols and, SCN 8-14
prevent startup and shutdown, SCN 8-21
response queue and, SCN 8-17
user processes connect via Net8, SCN 8-14, SCN 8-16
dispatchers, NET 2-7
described, NET 2-7
number to start, NET 9-7
setting the number of, NET 9-7
DISPATCHERS (DIS or DISP) attribute, NET 9-5
DISPLAY datatype, PCO 4-7
displaying
LOB data for internal persistent LOBs, ADL 9-90
temporary LOB data, ADL 10-47
displaying a directory entry, OID 7-3
displaying a subtree, OID 7-3
DISTINCT clause
of SELECT, SQL 7-573
DISTINCT operator, PLS 5-3
optimizing views, STU 4-78
distinct queries, SQL 7-573
DISTINCT row operator, PLS 5-3, PLS 5-6
Distinguished Name, ADG 11-20
distinguished name, SRF 1-100
Distinguished Name (DN), defined, NET 2-40
distinguished names, OAS 17-3, OID 2-2
as attributes, OID 7-11
components of, OID 2-3
format, OID 2-3
in LDIF files, OID A-2
modifying, OID 4-14
using command line tools, OID 7-25
using ldapmoddn, OID 4-14
of parents, locating, OID 7-13
distributed applications
distributing data, DDS 3-2
Distributed Computing Environment
overview, OAS 12-2
distributed databases, NET 2-2, STU 3-8
administration
overview, DDS 1-23
application development
analyzing execution plan, DDS 3-10
controlling connections, DDS 3-2
handling errors, DDS 3-3
handling RPC errors, DDS 3-12
managing distribution of data, DDS 3-2
managing referential integrity, DDS 3-3
tuning distributed queries, DDS 3-3
tuning using collocated inline views, DDS 3-4
using cost-based optimization, DDS 3-5
using hints to tune queries, DDS 3-8
auditing and, SCN 334
backups, SBR 3-9
change-based recovery, SBR 6-17
client/server architectures, DDS 1-7
client/server architectures and, SCN 6-2
commit point strength, DDS 4-9
coordinated time-based recovery, SBR 6-17
cost-based optimization, DDS 1-47
deadlocks and, SCN 229
dependent schema objects and, SCN 116
distributed processing, DDS 1-3
distributed queries, DDS 1-34, SCN 404
distributed updates, DDS 1-34, SCN 404
distributing an application's data, DDS 3-2
global database names
how they are formed, DDS 2-2
global object names, DDS 1-22, DDS 2-2, SCN 392
global users
schema-dependent, DDS 1-27
schema-independent, DDS 1-28
job queue processes (SNPn), SCN 1-19, SCN 8-13
location transparency, DDS 1-44
creating, DDS 2-26
creating using procedures, DDS 2-30
creating using synonyms, DDS 2-28
creating using views, DDS 2-26
restrictions, DDS 2-33
management tools, DDS 1-31, SCN 401
managing read consistency, DDS 5-28
media recovery and snapshots, SBR 6-18
message propagation, SCN 76
NLS support, DDS 1-47
nodes of, DDS 1-7, SCN 376
overview, DDS 1-2
overview of, SCN 1-34, SCN 372
parameter file location in, SAD 3-16
recoverer process (RECO) and, SCN 8-12
recovery, SBR 6-16
referential integrity
application development, DDS 3-3
referential integrity and, ADG 4-14
remote dependencies, SCN 117
remote object security, DDS 2-28
remote queries and updates, DDS 1-33, SCN 404
remote stored procedures, ADG 9-53, ADG 9-54
replicated databases and, DDS 1-4
running in ARCHIVELOG mode, SAD 7-5
running in NOARCHIVELOG mode, SAD 7-5
scenarios, DDS 2-34
security, DDS 1-25
server can also be client in, SCN 6-2
site autonomy, DDS 1-24
site autonomy of, SCN 394
SQL transparency, DDS 1-45
starting a remote instance, SAD 3-7
statement optimization on, STU 4-94
table replication, SCN 1-36
taking backups, SBR 3-9
testing features, DDS 5-26
transaction processing, DDS 1-33
transparency, DDS 1-44
queries, DDS 2-32
updates, DDS 2-32
transparency of, SCN 414
triggers and, ADG 13-20
two-phase commit, SCN 1-35
distributed directories, OID 2-10, OID 2-18
naming contexts and, OAS 17-4, OID 2-10
partitioned, OID 2-11
replicated, OID 2-11
distributed lock
exclusive, SRF 1-41, SRF 1-42
rollback segment, SRF 1-42
sequence, PSC 8-13
Distributed Lock Manager, PSC A-9
distributed architecture, PSC 3-5
fault tolerant, PSC 3-5
features, PSC 3-4
group-based locking, PSC 5-33
handling lock requests, PSC 5-28
LCKn process, PSC 5-22
LMON, PSC 9-14
minimizing use, PSC 4-9
non-PCM lock capacity, PSC 4-13
queues, PSC 5-27
resource sharing, PSC 5-22
Distributed Lock Manager (DLM)
described, PSC 3-4
distributed lock manager (DLM), GTK 3-62
distributed locks
rollback segment, PSC 7-7
row cache, PSC 4-2
total number, PSC 4-2
distributed processing, NET 2-2, PCO 3-4
distributed databases, DDS 1-3
support for, PC_ 3-7
using Net8 for, PC_ 3-7
distributed processing environment
client/server architecture in, SCN 1-32, SCN 6-2
data manipulation statements, SCN 19
described, SCN 1-32, SCN 6-2
materialized views (snapshots), SCN 10-18
distributed queries, DDS 1-34, SQL 5-26
analyzing tables, DDS 3-7
application development issues, DDS 3-3
cost-based optimization, DDS 3-5
disabling, SRF 1-82
enabling, SRF 1-82
handling errors, ADG 9-46
links for, SRF 1-82
optimizing, DDS 1-47
restrictions on, SQL 5-26
distributed query, STU 9-30, STU 9-40
distributed query optimization, SCN 417
distributed schema management, REP 1-14
replication
distributed schema management, SCN 434
distributed systems, GTK 3-64 to GTK 3-68
data encryption, DDS 1-30
distributed transaction processing architecture, ADG 16-2
distributed transactions, DDS 1-35, PC_ F-101, PLS 5-42
case study, DDS 4-20
commit point site, DDS 4-7
commit point strength, DDS 4-9
committing, DDS 4-9
database server role, DDS 4-6
decreasing limit for, DDS 5-3
defined, DDS 4-2, SCN 405
disabling processing of, DDS 5-3
distributed statements, STU 4-48
DML and DDL, DDS 4-3
failure during, DDS 5-4
forcing to fail, DDS 5-26
global coordinator, DDS 4-7
increasing limit for, DDS 5-3
initialization parameters influencing, DDS 5-2
limiting number, DDS 5-2
limiting number of, SRF 1-35
local coordinator, DDS 4-7
lock timeout interval, DDS 5-4
locked resources, DDS 5-4
locks for in-doubt, DDS 5-5
management, DDS 4-1, DDS 5-1
manually overriding in-doubt, DDS 5-12
optimizing, STU 4-94
parallel DDL restrictions, SCN 184
parallel DML restrictions, SCN 184, SCN 203
problems with, REP B-6
recovery in single-process systems, DDS 5-28
routing statements to nodes, SCN 20
sample table scan not supported, STU 4-21
session trees, DDS 4-4, DDS 4-5, DDS 4-6
clients, DDS 4-6
commit point site, DDS 4-7, DDS 4-9
database servers, DDS 4-6
global coordinators, DDS 4-7
local coordinators, DDS 4-6
setting advice, DDS 5-13
specifying
commit point strength, DDS 5-5
interval for open connections, DDS 5-5
tracing session tree, DDS 5-9
transaction control statements, DDS 4-4
transaction timeouts, DDS 5-4
two-phase commit, DDS 4-4
discovering problems, DDS 5-11
example, DDS 4-20
two-phase commit and, SCN 1-35, SCN 38
viewing information about, DDS 5-7
distributed updates, DDS 1-34
DISTRIBUTED_LOCK_TIMEOUT initialization parameter
controlling time-outs with, DDS 5-4
DISTRIBUTED_LOCK_TIMEOUT initialization parameter: obsolete
DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME initialization parameter, DDS 5-5
DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME initialization parameter: obsolete
DISTRIBUTED_TRANSACTIONS initialization parameter, SRF 1-35
recoverer process (RECO), DDS 5-3
setting, DDS 5-2
when to alter, DDS 5-3
DISTRIBUTED_TRANSACTIONS parameter, SCN 8-12
distributing I/O, SAD 2-26, STU 20-19, STU 20-23
distribution
hints for, STU 7-26
DISTRIBUTION column
PLAN_TABLE table, STU 5-6
DIT. See Directory Information Tree (DIT)
DIUTIL package, STU 13-4
DLCR.RDBMS.OMD record, NET 11-14, NET A-42
DLL
debugging, DCI 4-15
naming conventions, DCI 2-7
DLM, PSC 5-1
interacting with CM, PSC 3-6
lock statistics, analyzing, PSA 12-18
message statistics, analyzing, PSA 12-20
parameters, PSA 1-14
recovery steps, PSA 14-5
resources, analyzing, PSA 12-18
statistics, for monitoring contention, PSA 11-18
workloads, affect on performance, PSA 12-18
DL.RDBMS.OMD record, NET 11-14, NET A-42
DM, Database Mount, PSA 7-19, PSC 4-8
data manipulation language
See also Data Manipulation Language
DML, SCN 12
DML (Data Manipulation Language), PCO 5-7
DML locks, PSC 4-4, PSC 4-5
DML Returning Clause, PC_ A-5
DML returning clause, PCO 5-9, PCO A-3
DML returning clauses, PC_ 6-11
DML. See data manipulation language
DML. See data manipulation language
DML statements
allowed in distributed transactions, SCN 404
DML subpartition locks, SCN 11-46
DML with RETURNING clause
See RETURNING clause
DML_LOCKS initialization parameter, SRF 1-36
compatibility, MIG B-9
DML_LOCKS parameter, ADG 7-11, DWG 18-23, DWG 18-25, PSA 1-8, PSA 1-10, PSA 7-17, PSC 4-13
and performance, PSA 10-4
ensuring IDLM lock capacity, PSA 10-3
Dnnn background processes, SCN 8-14
See also dispatcher processes
DNs. See distinguished names.
DNS, described, NET Glossary-9
DNSTIAR subprogram, PCO A-6
DO action
in the WHENEVER statement, PC_ 9-25
of WHENEVER directive, PC_ F-119
result of, PC_ 9-25
DO CALL, PCO A-3
DO CALL action
of WHENEVER directive, PCO 8-17, PCO 8-18, PCO F-93
DO PERFORM action
of WHENEVER directive, PCO 8-16, PCO F-93
document conventions, LEG viii
documentation
conventions, MIG xii, RAR viii, REP xv
online, GTK 6-2
roadmap for Migration utility, MIG 4-2
roadmap for Oracle Data Migration Assistant, MIG 5-2
domain index, SCN 10-47
creating, DCI 11-15
domain indexes, SQL 7-295, SQL 7-304, SQL 7-309
and EXPLAIN PLAN, STU 5-22
associating statistics with, SQL 7-212
determining user-defined CPU and I/O costs, SQL 7-512
dropping, MIG 13-20
extensible optimization, SCN 140, STU 4-32
invoking drop routines for, SQL 7-501
removing from the database, SQL 7-480
specifying alter string for, SQL 7-40
user-defined statistics, SCN 141, STU 4-33
using, STU 12-24
Domain Name Services, described, NET Glossary-9
domain of data cartridge, DCI 1-4
DOMAIN_HINT command, NET A-29
domains
default network, NET 4-17
delegating, NET 6-73
described, NET 4-12, NET 6-47
multiple hierarchically, NET 6-53, NET 6-58
multiple hierarchically related, NET 4-18
required by root administrative regions, NET 4-19
with a single domain naming structure, diagram, NET 4-16
DOMParser() - oracle.xml.parser.v2.DOMParser.DOMParser(), JPR 4-17
dot notation, ADO 1-3, PLS 1-6, PLS 1-7
for collection methods, PLS 4-21
for global variables, PLS 3-13
for object attributes, PLS 9-24
for object methods, PLS 9-26
for package contents, PLS 8-7
for record fields, PLS 2-34
dots, PC_ xvi
DOUBLE datatype, SUT 5-59, SUT 5-60
DOUBLE PRECISION datatype
ANSI, SQL 2-28
DOUBLE PRECISION subtype, PLS 2-14
downgrading
Advanced Queuing, MIG 13-6, MIG 13-35
CATALOG.SQL, MIG 13-60
CATPROC.SQL, MIG 13-60
definition, MIG 1-3
locally managed tablespaces, MIG 13-7, MIG 13-12
Oracle Parallel Server, MIG 13-60, MIG 13-61
ORADIM, MIG 13-57
procedure for, MIG 13-52
queue tables, MIG 13-39
removing incompatibilities, MIG 13-2
application context, MIG 13-45
associations, MIG 13-43
bitmap index invalidation, MIG 13-19
cache reads for LOBs, MIG 13-3, MIG 13-26
chained row tables, MIG 13-25
DBMS_REPAIR package, MIG 13-42
dimensions, MIG 13-21
DISABLE VALIDATE constraints, MIG 13-42
domain indexes, MIG 13-20
exception tables, MIG 13-25
extensible indexing, MIG 13-20
fine-grained access control, MIG 13-45
function-based indexes, MIG 13-20
global users, MIG 13-5, MIG 13-45
indextypes, MIG 13-20
Java, MIG 13-34
key compression on indexes and index-organized tables, MIG 13-13
LOBs, MIG 13-26
LOBs in index-organized tables, MIG 13-14
locally managed tablespaces, MIG 13-12
materialized views, MIG 13-16
migrated tablespaces, MIG 13-6, MIG 13-10
mutually referencing types, MIG 13-32
mutually referencing views, MIG 13-18
nested tables, MIG 13-31
Net8 service naming, MIG 13-50
operators, MIG 13-21
optimizer, MIG 13-43
partially dropped columns, MIG 13-15
partitioning, MIG 13-22
plan stability, MIG 13-44
referential constraints on REF columns, MIG 13-31
replication, MIG 13-47
secondary indexes on index-organized tables, MIG 13-15
security policies, MIG 13-45
SET_SESSION_LONGOPS syntax change, MIG 13-41
single-table hash clusters, MIG 13-16
SQL and PL/SQL, MIG 13-33
stored outlines, MIG 13-44
temporary tables, MIG 13-13
transient segments, MIG 13-7, MIG 13-11
transported tablespaces, MIG 13-10
triggers, MIG 13-5, MIG 13-43
triggers on nested table view columns, MIG 13-43
unused columns, MIG 13-15
UROWIDs, MIG 13-25
user-defined datatypes, MIG 13-29
user-defined object identifiers, MIG 13-30
UTL_REF package, MIG 13-41
varrays, MIG 13-32
replication, MIG 13-60
regenerating, MIG 13-62
resetting database compatibility, MIG 13-51
revoking CONNECT THROUGH privileges, MIG 13-46
scripts, MIG 13-54
errors while running, MIG 1-11
rerunning, MIG 13-55
to 8.0 release, MIG 13-8
to an older version 8 release, MIG 13-1
to Oracle7, MIG 14-1
alternative methods, MIG 14-4
CATEXP7.SQL script, MIG 14-3
to previous 8.1 release, MIG 13-3
triggers, MIG 13-5
downgrading to 8.0 or 8.1.5, using CACHE READS LOBs, ADL 4-16
downtime
planned, PSC 9-3
unplanned, PSC 9-3
DRG, SMS 50-1
drilldown data views in Oracle Trace, STU 14-17
Basic Statistics for Parse/Execute/Fetch, STU 14-19
CPU Statistics for Parse/Execute/Fetch, STU 14-19
Parse Statistics, STU 14-19
Row Statistics for Execute/Fetch, STU 14-20
drilling across, DWG 9-5
drilling down, DWG 9-3
hierarchies, DWG 9-3
Driver (string) not supported - error, ADQ D-6
drivers, SCN 8-28
JDBC, NLS 6-2
ODBC, DDS 8-12
OLEFS, DDS 8-15
OLESQL, DDS 8-14
DRIVING_SITE hint, DDS 3-9, SQL 2-66
Drop a Queue Table, ADQ 9-17
DROP ANY CLUSTER system privilege, SQL 7-521
DROP ANY CONTEXT system privilege, SQL 7-521
DROP ANY DIMENSION system privilege, SQL 7-522
DROP ANY DIRECTORY system privilege, SQL 7-522
DROP ANY INDEX system privilege, SQL 7-522
DROP ANY INDEXTYPE system privilege, SQL 7-522
DROP ANY LIBRARY system privilege, SQL 7-523
DROP ANY MATERIALIZED VIEW system privilege, SQL 7-523
DROP ANY OPERATOR system privilege, SQL 7-524
DROP ANY OUTLINE system privilege, SQL 7-524
DROP ANY PROCEDURE system privilege, SQL 7-524
DROP ANY ROLE system privilege, SQL 7-525
DROP ANY SEQUENCE system privilege, SQL 7-525
DROP ANY SNAPSHOT system privilege, SQL 7-526
DROP ANY SYNONYM system privilege, SQL 7-526
DROP ANY TABLE system privilege, SQL 7-527
DROP ANY TRIGGER system privilege, SQL 7-527
DROP ANY TYPE privilege, ADO 2-11
See also privileges
DROP ANY TYPE system privilege, SQL 7-528
DROP ANY VIEW system privilege, SQL 7-529
drop catalog command (RMAN), RMN 10-74
DROP clause
of ALTER DIMENSION, SQL 7-27
DROP CLUSTER command, ADG 5-18, ADG 5-20
DROP CLUSTER statement, SQL 7-472
CASCADE CONSTRAINTS option, SAD 16-11
dropping cluster, SAD 16-10
dropping cluster index, SAD 16-10
dropping hash cluster, SAD 17-9
INCLUDING TABLES option, SAD 16-10
drop column, GTK 3-41
compatibility, MIG 9-10
DROP COLUMN clause, SAD 13-14, SCN 10-7
of ALTER TABLE, SQL 7-147
DROP CONSTRAINT clause
of ALTER TABLE, SQL 7-146
DROP CONTEXT statement, SQL 7-474
DROP DATABASE LINK statement, SQL 7-475
DROP DIMENSION statement, SQL 7-476
DROP DIRECTORY statement, SQL 7-477
DROP FUNCTION statement, SQL 7-478
DROP INDEX command, ADG 5-6
privileges required, ADG 5-6
DROP INDEX statement, SQL 7-480
DROP INDEXTYPE statement, SQL 7-482
DROP JAVA statement, SQL 7-483
DROP LIBRARY
statement, SQL 7-484
system privilege, SQL 7-523
DROP LOGFILE clause
of ALTER DATABASE, SQL 7-9, SQL 7-19
DROP LOGFILE MEMBER clause
of ALTER DATABASE, SQL 7-9, SQL 7-19
DROP LOGFILE MEMBER option
ALTER DATABASE statement, SAD 6-16
DROP LOGFILE option
ALTER DATABASE statement, SAD 6-15
DROP MATERIALIZED VIEW / SNAPSHOT statement, SQL 7-485
DROP MATERIALIZED VIEW LOG / SNAPSHOT LOG statement, SQL 7-487
DROP MATERIALIZED VIEW statement, DWG 8-17
prebuilt tables, DWG 8-30
DROP OPERATOR statement, SQL 7-489
DROP OUTLINE statement, SQL 7-490
DROP PACKAGE BODY statement, SQL 7-491
DROP PACKAGE statement, SQL 7-491
DROP PARTITION clause, SAD 15-16
of ALTER INDEX, SQL 7-41
of ALTER TABLE, SQL 7-160
DROP PRIMARY constraint clause
of ALTER TABLE, SQL 7-146
DROP PROCEDURE statement, SQL 7-493
DROP PROFILE
statement, SQL 7-494
system privilege, SQL 7-525
DROP PROFILE statement, SAD 22-25
DROP PUBLIC DATABASE LINK system privilege, SQL 7-522
DROP PUBLIC SYNONYM system privilege, SQL 7-526
DROP ROLE statement, ADG 11-27, SAD 23-10, SQL 7-495
DROP ROLLBACK SEGMENT
statement, SQL 7-496
system privilege, SQL 7-525
DROP ROLLBACK SEGMENT statement, SAD 11-13
DROP SEQUENCE statement, SQL 7-497
DROP SNAPSHOT LOG statement, RAR 7-24
DROP statement, SCN 12
triggers on, SQL 7-430
DROP STORAGE clause
of TRUNCATE, SQL 7-613
DROP SYNONYM statement, SAD 18-15, SQL 7-500
DROP TABLE command, ADG 2-10
DROP TABLE statement, PSC 4-8, SQL 7-501
about, SAD 13-16
auditing, SCN 335
CASCADE CONSTRAINTS option, SAD 13-16
for clustered tables, SAD 16-11
triggers, SCN 87
DROP TABLESPACE
statement, SQL 7-503
system privilege, SQL 7-527
DROP TABLESPACE statement, PSC A-20, SAD 9-23
DROP TRIGGER command, ADG 13-30
DROP TRIGGER statement, SQL 7-505
DROP TYPE BODY statement, SQL 7-508
DROP TYPE statement, SQL 7-506
FORCE option, ADO 2-15
DROP UNIQUE constraint clause
of ALTER TABLE, SQL 7-146
DROP UNUSED COLUMNS clause, SAD 13-15
DROP USER
statement, SQL 7-509
system privilege, SQL 7-528
DROP USER privilege, SAD 22-20
DROP USER statement, SAD 22-20
DROP VIEW statement, SQL 7-511
drop(Session) - oracle.jms.AQjmsDestination.drop(javax.jms.Session), JPR 2-66
DROP_POLICY procedure, ADG 11-38
DROPCAT5.SQL script, SRF 5-7
DROPCAT6.SQL script, SRF 5-7
dropped snapshots
Import, SUT 2-49
dropping
clusters, ADG 5-17
dimensions, DWG 9-15
hash clusters, ADG 5-20
indexes, ADG 5-5
to continue a direct path load, SUT 5-34
integrity constraints, ADG 4-24
materialized views, DWG 8-36
packages, ADG 9-12
procedures, ADG 9-11
roles, ADG 11-27
sequences, ADG 2-34
synonyms, ADG 2-36
tables, ADG 2-10
triggers, ADG 13-30
views, ADG 2-20
dropping a database object
tablespace, PSC A-20
dropping a redo log file, PSC A-20
log switch, PSA 13-15
manual archiving, PSA 3-8
restrictions, PSA 3-8
dropping an audit trail, SAD 24-4
dropping AQ objects, ADQ A-67
dropping columns from tables, SAD 13-14 to SAD 13-15
dropping database links, DDS 2-19
dropping database objects
tablespace, PSA 9-2
dropping indexes from attributes, OID 5-26, OID 6-31
dropping profiles, SAD 22-25
dropping the recovery catalog, RMN 3-44
dropping users, SAD 22-20
DRSYS tablespace
raw device, PSG 2-6
DRSYS tablespace, description, PSG 1-12
DSA, environment setting, OID B-3
DSE modification event, OID 5-27
DSNTIAR
DB2 compatible feature, PCO 8-14
DSNTIAR routine, PCO 8-14
DSS applications, PSC 8-6, PSC 8-7
DSS database
disk striping, SCN 205
parallel DML, SCN 194
partitioning indexes, SCN 11-36
partitions, SCN 11-6
performance, SCN 11-9
scoring tables, SCN 195
DST parameter, NET 8-36, NET C-76
DTD - oracle.xml.parser.v2.DTD, JPR 4-22
DTDName - oracle.xml.parser.v2.XMLToken.DTDName, JPR 4-136
DTP model, PC_ 5-55
DTYCHR type, MIG 12-8
DUAL dummy table, SQL 2-73, SQL 5-26
dual ported controllers, PSC 8-11
DUAL table, SCN 2-7
dummy API, RMN 9-19
dummy host variables
placeholders, PC_ 13-3
dump files, SRF 1-67
Export and Import, ADO 2-16
maximum size, SUT 1-20
DUMP function, SQL 4-31
DUMP_LDAP command, NET A-30
DUMP_ORPHAN_KEYS procedure, SAD 20-3, SAD 20-6, SAD 20-7
example, SAD 20-12
DUMP_TNSNAMES command, MIG F-20, NET A-33
DUP_VAL_ON_INDEX exception, PLS 6-5
duplex parameter (RMAN)
set command, RMN 5-24
duplexing backup sets, RMN 1-44, RMN 5-23
duplicate command (RMAN), RMN 1-64, RMN 10-76
duplicate databases
creating, RMN 1-64, RMN 7-2
non-current, RMN 7-19
on a remote host with same filesystem, RMN 7-11
on local host, RMN 7-17
on remote host with different filesystem, RMN 7-12
DB_FILE_NAME_CONVERT initialization parameter, RMN 7-5
failed creation, RMN 9-33
generating filenames, RMN 7-3
nofilenamecheck option, RMN 7-6
restrictions, RMN 7-3
set auxname command (RMAN), RMN 7-5
set newname command (RMAN), RMN 7-5
skipping offline normal tablespaces, RMN 7-6
skipping read-only tablespaces, RMN 7-5
duplicating a database, RMN 1-64
troubleshooting, RMN 9-33
Durable Subscriber, ADQ 12-48
duration
example, OCI 13-14
of objects, OCI 13-14
duration events in Oracle Trace, STU 14-5
duration of a search, specifying, OID 7-6
DURATION precompiler option, PC_ 10-20, PC_ 17-20
DY date format element, SQL 2-46, SQL 2-48
dynamic (connection) load balancing, Net8, GTK 3-77
dynamic allocation, PSA 6-6
Dynamic Discovery Option, NET 4-22
Dynamic Discovery Option for Oracle Names
migrating issues, MIG F-20
dynamic extension, STU 20-27
avoiding, STU 20-29
dynamic FOR-loop range, PLS 3-12
DYNAMIC option
effect on functionality, PCO 10-12
dynamic ownership
conflict avoidance and, REP 6-11
locating owner of a row, REP 6-15
obtaining ownership, REP 6-15
workflow partitioning, REP 6-11
dynamic partitioning, SCN 162
dynamic performance tables
CATALOG.SQL script, SRF 3-1
public synonyms (V$), SRF 3-2
views (V_$), SRF 3-2
dynamic performance tables (V$ tables), SCN 2-7
dynamic performance view
creating, PSA 12-9
dynamic performance views
added in Oracle8i, MIG D-2
changed in Oracle8i
added columns, MIG D-8
renamed columns, MIG D-12
date columns
compatibility, MIG D-13
enabling statistics, STU 6-4
for tuning, STU 15-1
Heterogeneous Services, DDS 7-15
determining open sessions, DDS 7-16
determining which agents are on host, DDS 7-15
obsolete in Oracle8i, MIG D-13
renamed in Oracle8i, MIG D-7
with dropped columns in Oracle8i, MIG D-11
dynamic PL/SQL, PCO 9-29
rules for, PC_ 13-29
versus dynamic SQL, PC_ 13-29
dynamic predicates
in security policies, SCN 326
dynamic sites
ownership, REP 5-7
dynamic SQL, ADG 11-14, ADG 11-37, ADG 11-39, PLS 10-2
advantages and disadvantages, PCO 9-3
advantages and disadvantages of, PC_ 13-2
anonymous blocks and, SPR 51-2
application development languages, ADG 8-24
cannot use cursor variables with, PC_ 4-32
choosing the right method, PC_ 13-6, PCO 9-7
DBMS_SQL functions, using, SPR 51-2
DBMS_SQL package, SCN 28
definition of, PC_ 2-5
DML statements, ADG 8-3
embedded, SCN 28
errors, locating, SPR 51-31
execution flow in, SPR 51-4
guidelines, PCO 9-7
guidelines for, PC_ 13-6
invoker-rights, ADG 8-8
invoking PL/SQL blocks, ADG 8-7
name resolution, SCN 63
optimization, ADG 8-6
overview, PCO 2-6, PCO 9-3
overview of, PC_ 13-2
queries, ADG 8-4
restriction on, PC_ 6-18
restrictions, PCO 14-32
restrictions on use of datatypes, PC_ 17-38
restrictions on using datatypes in, PC_ 17-38
scenario, ADG 8-9
See Also DBMS_SQL package
See Also native dynamic SQL
tips and traps, PLS 10-11
usage, ADG 8-3
use of PL/SQL with, PC_ 7-33
uses for, PC_ 13-2
using EXECUTE IMMEDIATE statement, PLS 10-3
using OPEN-FOR-USING statement, PLS 10-7
using PL/SQL, PCO 6-24
using the AT clause, PCO 3-8
using the AT clause in, PC_ 3-11
when to use, PC_ 13-2
when useful, PCO 9-3
dynamic SQL (ANSI)
ALLOCATE DESCRIPTOR statement, PCO 10-13
basics, PC_ 14-2, PCO 10-2
bulk operations, PC_ 14-8, PCO 10-9
CLOSE CURSOR statement, PCO 10-27
compared to Oracle dynamic SQL method 4, PCO 10-1
DEALLOCATE DESCRIPTOR statement, PCO 10-14
DESCRIBE DESCRIPTOR statement, PCO 10-21
differences from Oracle dynamic, PC_ 14-28
differences from Oracle dynamic SQL, PCO 10-27
EXECUTE statement, PCO 10-23
FETCH statement, PCO 10-26
GET DESCRIPTOR statement, PCO 10-15
OPEN statement, PCO 10-25
Oracle extensions, PC_ 14-7, PCO 10-7
Overview, PC_ 14-3
overview, PCO 10-3
Precompiler Options, PC_ 14-2
precompiler options, PC_ 14-11, PCO 10-2, PCO 10-12
reference semantics, PC_ 14-7, PCO 10-8
restrictions, PCO 10-28
sample program, PC_ 14-37
sample programs, PC_ 14-29, PCO 10-28
SAMPLE12.PCO, PCO 10-28
SET DESCRIPTOR statement, PCO 10-18
use of DECLARE CURSOR, PCO 10-24
use of EXECUTE IMMEDIATE statement, PCO 10-24
use of PREPARE statement, PCO 10-20
when to use, PCO 10-1
dynamic SQL method 1
commands, PCO 9-5
commands used with, PC_ 13-5
description, PCO 9-9
description of, PC_ 13-9
example, PCO 9-9
example of, PC_ 13-9
how to use, PC_ 13-8
requirements, PCO 9-5
requirements for, PC_ 13-5
use of EXECUTE IMMEDIATE with, PC_ 13-9
use of PL/SQL with, PC_ 13-30
using EXECUTE IMMEDIATE, PCO 9-9
using PL/SQL, PCO 9-30
dynamic SQL method 2
commands, PCO 9-6
commands used with, PC_ 13-5
description, PCO 9-13
description of, PC_ 13-13
example of, PC_ 13-15
requirements, PCO 9-6
requirements for, PC_ 13-5
use of DECLARE STATEMENT with, PC_ 13-28
use of EXECUTE with, PC_ 13-13
use of PL/SQL with, PC_ 13-30
use of PREPARE with, PC_ 13-13
using PL/SQL, PCO 9-30
using the DECLARE STATEMENT statement, PCO 9-28
using the EXECUTE statement, PCO 9-13
using the PREPARE statement, PCO 9-13
dynamic SQL method 3
commands, PCO 9-6
commands used with, PC_ 13-5
compared to method 2, PC_ 13-19, PCO 9-18
example program, PC_ 13-21
requirements, PCO 9-6
requirements for, PC_ 13-5
sequence of statements used with, PC_ 13-19
use of DECLARE STATEMENT with, PC_ 13-28
use of DECLARE with, PC_ 13-20
use of FETCH with, PC_ 13-20
use of OPEN with, PC_ 13-20
use of PL/SQL with, PC_ 13-30
use of PREPARE with, PC_ 13-19
using PL/SQL, PCO 9-30
using the DECLARE statement, PCO 9-20
using the DECLARE STATEMENT statement, PCO 9-28
using the FETCH statement, PCO 9-20
using the OPEN statement, PCO 9-20
using the PREPARE statement, PCO 9-19
dynamic SQL method 4
CLOSE statement, PCO 11-38
DECLARE CURSOR statement, PCO 11-29
DESCRIBE statement, PCO 11-29, PCO 11-34
external datatypes, PCO 11-16
FETCH statement, PCO 11-37
internal datatypes, PCO 11-15
need for descriptors with, PC_ 15-4
OPEN statement, PCO 11-34
overview of, PC_ 13-25, PC_ 13-26
PREPARE statement, PCO 11-29
prerequisites, PCO 11-14
prerequisites for using, PC_ 15-12
purpose of descriptors, PCO 11-4
requirements, PCO 9-6, PCO 11-2
requirements for, PC_ 13-6
requirements of, PC_ 15-2
sample program, PC_ 15-40
sequence of statements used, PCO 11-23
sequence of statements used with, PC_ 13-27, PC_ 15-20
SQLDA, PCO 11-4
steps for, PC_ 15-19, PCO 11-22
use of CLOSE statement in, PC_ 15-37
use of DECLARE CURSOR statement in, PC_ 15-25
use of DECLARE STATEMENT with, PC_ 13-28
use of DESCRIBE in, PC_ 13-26
use of DESCRIBE statement in, PC_ 15-25, PC_ 15-30
use of descriptors with, PC_ 13-25
use of FETCH statement in, PC_ 15-35
use of OPEN statement in, PC_ 15-30
use of PL/SQL with, PC_ 13-30
use of PREPARE statement in, PC_ 15-25
use of the SQLDA in, PC_ 13-26, PC_ 15-4
using descriptors, PCO 9-25
using host arrays with, PC_ 15-37
using PL/SQL, PCO 9-30
using the DECLARE STATEMENT statement, PCO 9-28
using the DESCRIBE statement, PCO 9-25
using the FOR clause, PCO 9-29
using the FOR clause with, PC_ 13-29, PC_ 15-37
using the SQLDA, PCO 9-25
when needed, PC_ 13-25, PCO 9-25
dynamic SQL methods
overview of, PC_ 13-4
dynamic SQL statement, PCO 9-3
binding of host variables, PCO 9-4
how processed, PCO 9-4
requirements, PCO 9-4
using host tables, PCO 9-29
versus static SQL statement, PCO 9-3
dynamic SQL statements
binding of host variables in, PC_ 13-4
definition of, PC_ 13-2
how processed, PC_ 13-4
parsing of, PC_ 13-4
requirements for, PC_ 13-3
use of placeholders in, PC_ 13-3
using host arrays in, PC_ 13-29
versus static SQL statements, PC_ 13-2
dynamic string, PLS 10-3
dynamic web pages, ADG 12-2
dynamically allocating blocks, PSC 7-25

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents