Oracle8i Generic Documentation Master Index

DATA

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

data

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

loading LONG

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

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

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 manipulation language

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

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

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

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

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

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

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

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

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

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

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

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

EXTERNAL format

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

declarations

cursor variable, PLS 5-17

declarative part

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

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

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

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

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

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

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

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

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

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

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

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