---

D

D date format element, SQL 2-41

D number format element, SQL 2-36

DAEMON.TRACE_DIRECTORY parameter, NET C-7

DAEMON.TRACE_LEVEL parameter, NET C-7

DAEMON.TRACE_MASK parameter, NET C-8

dangling ref, PLS 9-33

dangling REFs, SCN 13-9, SCN 13-10

DATA

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

data

access to, SCN 1-51

control of, SCN 29-2

fine-grained access control, SCN 30-22

message queues, SCN 19-7

security domains, SCN 29-2

authentication, OAS 1-5

authorization, OAS 1-9

comparative, STU 12-5

concurrent access to, SCN 27-2

consistency of

defined, SCN 1-55

examples of lock behavior, SCN 27-32

locks, SCN 27-3

manual locking, SCN 27-31

read consistency, SCN 1-31

repeatable reads, SCN 27-6

transaction level, SCN 27-6

underlying principles, SCN 27-15

convergence, REP 6-7

guaranteeing, REP 6-38

conversion, NLS 4-4

CONVERT function, NLS 4-5

delimiter marks in data and SQL*Loader, SUT 5-72

design, tuning, STU 2-7

distinguishing different input formats for SQL*Loader, SUT 5-51

distributed manipulation of, SCN 1-35

exporting, SUT 1-23

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

inconsistencies

removing after deleting master sites, REP 2-34

integrity, OAS 1-3

ensuring with multiple column groups, REP 6-7

parallel propagation, REP 2-43

serial propagation, REP 2-43

integrity checking on input, SQL 2-13

integrity of, SCN 1-30, SCN 10-4, SCN 28-2

CHECK constraints, SCN 28-17

enforcing, SCN 28-4, SCN 28-5

overview, SCN 1-57

parallel DML restrictions, SCN 26-45

referential, SCN 28-3

two-phase commit, SCN 1-35

types, SCN 28-3

loading data contained in the SQL*Loader control file, SUT 5-54

loading in sections

SQL*Loader, SUT 8-14

loading into more than one table

SQL*Loader, SUT 5-51

loading LONG

SQL*Loader, SUT 5-64

locks on, SCN 27-20

maximum length of delimited data for SQL*Loader, SUT 5-73

moving between operating systems using SQL*Loader, SUT 5-74

partitioning, STU 26-45

privacy, OAS 1-4

replicating, SCN 1-36

retrieving, SQL 5-18

saving in a direct path load, SUT 8-12

saving rows

SQL*Loader, SUT 8-18

security of, SAD 22-3

sources for tuning, STU 12-1

SQL*Loader methods of loading into tables, SUT 5-32

undo

storing, SQL 7-345

unsorted

SQL*Loader, SUT 8-17

values optimized for SQL*Loader performance, SUT 5-54

volume, STU 12-2

data abstraction, PLS 9-2

data block, SPS 5-5

data block size, STU 20-15

data blocks, SCN 1-10, SCN 4-2

allocating for extents, SCN 4-13

altering size of, SAD 2-11

block-level recovery, SCN 32-14

cached in memory, SCN 8-8

clustered, SCN 10-49

coalescing extents, SCN 4-13

coalescing free space in blocks, SCN 4-9

controlling free space in, SCN 4-5

factors affecting size of, ADG 3 - 6

format, SCN 4-3

free lists and, SCN 4-9

hash keys and, SCN 10-55

how rows stored in, SCN 10-5

managing space usage of, SAD 12-2

managing space use of, SAD 12-2

operating system blocks versus, SAD 2-11

overview, SCN 4-2

PCTFREE storage parameter, SAD 12-3

PCTUSED storage parameter, SAD 12-5

reading multiple, SRF 1-30

read-only transactions and, SCN 27-32

row directory, SCN 10-5

shared in clusters, SAD 17-2, SCN 10-46

shown in ROWIDs, ADG 4 - 20

shown in rowids, SCN 12-17, SCN 12-18

size of, SAD 2-11, SRF 1-27, SRF 1-28

space available for inserted rows, SCN 4-9

stored in the buffer cache, SCN 7-3

verifying, SAD 10-12

writing to disk, SCN 8-8

data blocks consistent reads - undo records applied statistic, SRF C-8

data cache, STU 24-2

data cartridge

definition, DCI 1-2

development process, DCI 2-2

domains, DCI 1-4

external procedures (guidelines), DCI 4-15

installation, DCI 2-4

interfaces, DCI 1-14

method, DCI 1-8

naming conventions, DCI 2-8

suggested development approach, DCI 2-14

data cartridges

OCI functions, OCI 2-3

data control in OO4O, ADG 1 - 19

data conversion, ADG 4 - 25, SQL 2-31

ANSI datatypes, ADG 4 - 24, SCN 12-22

assignments, ADG 4 - 25

expression evaluation, ADG 4 - 27

implicit versus explicit, SQL 2-33

program interface, SCN 8-25

SQL*Loader, SUT 3-9

SQL/DS and DB2 datatypes, ADG 4 - 24, SCN 12-22

Trusted Oracle labels, ADG 4 - 28

when performed implicitly, SQL 2-31

when specified explicitly, SQL 2-32

data definition conversion

Import utility, MIG 2-13

data definition language

BEGINDATA keyword, SUT 5-21

BLANKS keyword, SUT 5-45

column_name, SUT 5-16

CONCATENATE keyword, SUT 5-36

CONSTANT keyword, SUT 5-46, SUT 5-55

CONTINUEIF keyword, SUT 5-36

date mask, SUT 5-16

DEFAULTIF keyword, SUT 5-81

delimiter_spec, SUT 5-16

DISABLED_CONSTRAINTS keyword

SQL*Loader, SUT 8-22

DISCARDDN keyword, SUT 5-28

EXCEPTIONS keyword

SQL*Loader, SUT 8-22

expanded syntax diagrams, SUT 5-15

EXTERNAL keyword, SUT 5-67

field_condition, SUT 5-15

FILE keyword

SQL*Loader, SUT 8-29

FLOAT keyword, SUT 5-67

INFILE keyword, SUT 5-22

length, SUT 5-16

loading data in sections

SQL*Loader, SUT 8-14

NULLIF keyword, SUT 5-81

parallel keyword

SQL*Loader, SUT 8-27

pos_spec, SUT 5-15

POSITION keyword, SUT 5-48

precision, SUT 5-16

RECNUM keyword, SUT 5-46

REENABLE keyword

SQL*Loader, SUT 8-22

SEQUENCE keyword, SUT 5-56

SQL statements, OCI 1-7

SQL*Loader CHARACTERSET keyword, SUT 5-31

SQL*Loader DISCARDMAX keyword, SUT 5-30

syntax diagrams

high-level, SUT 5-4

SYSDATE keyword, SUT 5-56

TERMINATED keyword, SUT 5-70

UNRECOVERABLE keyword

SQL*Loader, SUT 8-19

WHITESPACE keyword, SUT 5-70

Data Definition Language (DDL)

auditing, SCN 31-7

commit implied by, SCN 17-4

defined, SCN 1-52

described, SCN 16-4

description, PCO 5-2

distributed transactions, DDS 2-26

embedding in PL/SQL, SCN 16-19

locks, SCN 27-28

parallel DDL, SCN 26-3

parsing with DBMS_SQL, SCN 16-19

processing statements, SCN 16-14

roles and privileges, SCN 30-20

data definition language (DDL)

embedded, PCO 2-17

supplying asynchronous, SPR 34 - 57, RAR 8-138

data definition language. See DDL.

data definition statements

in transactions, PC_ 3-17

data dependent routing, SPS 12-7, SPS 19-6

Data Dictionary

installing for Heterogeneous Services, DDS 6-2

data dictionary, SPS 5-5, SRF 2-2, STU 12-2

access to, SCN 2-2

adding comments to, SQL 7-212

adding objects to, SCN 2-4

ALL prefixed views, SCN 2-6

audit trail (SYS.AUD$), SCN 2-5

backups, SCN 32-25

cache, SCN 7-10, SRF 3-70, SRF 3-89, SRF 3-90, SRF 3-91, SRF 3-92

location of, SCN 7-6

changing storage parameters, SAD 20-29

compile-time errors, ADG 10 - 43

conflicts with control files, SAD 5-8

content of, SCN 2-2, SCN 7-10

procedures, SCN 18-18

datafile 1, SCN 3-6, SCN 32-25

datafiles, SRF 1-45

DBA prefixed views, SCN 2-6

DBA_REGISTERED_SNAPSHOTS view, REP 7-37

defined, SCN 1-30, SCN 2-2

dependencies tracked by, SCN 21-3

DICTIONARY view, SRF 2-175

dictionary-managed tablespaces, SCN 3-7

dropped tables and, ADG 3 - 10, SAD 14-12

DUAL table, SCN 2-7

dynamic performance tables, SCN 2-7

integrity constraints in, ADG 5 - 32

locks, SCN 27-28

objects, SPS 6-6

owner of, SCN 2-3

prefixes to views of, SCN 2-5

procedure source code, ADG 10 - 43

protection, MIG 8-24

public synonyms for, SCN 2-4

querying views, SPS 20-12

rollback segments, SRF 1-110

row cache, SPS 6-6

row cache and, SCN 7-10

schema object views, ADG 3 - 50, SAD 20-29

scripts, SRF 5-3

segments in the, SAD 20-27

sequence cache, SPS 6-7

setting storage parameters of, SAD 20-26

SQL scripts, SRF 5-2

statistics in, SCN 22-14, SCN 23-32

partition statistics, SCN 11-14

structure of, SCN 2-2

SYSTEM tablespace, SCN 2-2, SCN 2-5, SCN 3-6

tables, SRF 2-1

updates of, SCN 2-5

USER prefixed views, SCN 2-6

uses of, SCN 2-3

table and column definitions, SCN 16-11

V$DBFILE view, SAD 2-8

V$DISPATCHER view, SAD 4-7

V$LOGFILE view, SAD 2-8

V$QUEUE view, SAD 4-7

validity of procedures, SCN 18-18

views, SBR 13-6, SBR 13-10, SPS 14-6, SRF 1-45

ALL, DDS 2-20

DBA_DB_LINKS, DDS 2-20

overview, SRF 2-1, SRF 2-2

USER, DDS 2-20

user views, SRF 2-2

views used in optimization, SCN 22-14

data dictionary cache, STU 2-10, STU 19-20

data dictionary tables, DDS 5-3

data dictionary view

TRUSTED_SERVERS, DDS D-1

Data Dictionary Views, DDS 6-7

data dictionary views, RAR 9-2

DEFCALL, RAR 9-27

DEFCALLDEST, RAR 9-28

DEFDEFAULTDEST, RAR 9-28

DEFERRCOUNT, RAR 9-28

deferred transactions, RAR 9-27

DEFERROR, RAR 9-29

DEFLOB, RAR 9-29

DEFPROPAGATOR, RAR 9-30

DEFSCHEDULE, RAR 9-30

DEFTRAN, RAR 9-31

DEFTRANDEST, RAR 9-31

REFRESH, RAR 9-36

REFRESH_CHILDREN, RAR 9-37

REGISTERED_SNAPSHOTS, RAR 9-34

REPCATLOG, RAR 9-5, RAR 9-6, RAR 9-12, RAR 9-13

REPCOLUMN, RAR 9-15

REPCOLUMN_GROUP, RAR 9-16

REPCONFLICT, RAR 9-16

REPDDL, RAR 9-17

REPGENOBJECTS, RAR 9-26

REPGROUP, RAR 9-3

REPGROUP_PRIVILEGES, RAR 9-17

REPGROUPED_COLUMN, RAR 9-18

REPKEY_COLUMNS, RAR 9-18

REPOBJECT, RAR 9-19

REPPARAMETER_COLUMN, RAR 9-20

REPPRIORITY, RAR 9-21

REPPRIORITY_GROUP, RAR 9-22

REPPROP, RAR 9-22

REPRESOL_STATS_CONTROL, RAR 9-24

REPRESOLUTION, RAR 9-23

REPRESOLUTION_METHOD, RAR 9-24

REPRESOLUTION_STATISTICS, RAR 9-25

REPSITES, RAR 9-26

SNAPSHOT_LOGS, RAR 9-34

SNAPSHOT_REFRESH_TIMES, RAR 9-35

SNAPSHOTS, RAR 9-32

snapshots, RAR 9-32

data encapsulation, PLS 1-16

Data Encryption Standard

see Oracle Advanced Security

data field

specifying the SQL*Loader datatype, SUT 5-47

data files, PSC 1-10, PSC 1-11, PSC 1-14

data integrity, OAS 1-3, PC_ 3-13, PCO 3-18, PLS 5-40, SAD 20-19

definition of, PC_ 3-16

integrity constraints, SAD 20-19

data lock, PCO 3-19, PLS 5-41

data locks, PC_ 3-16

conversion, SCN 27-16

duration of, SCN 27-15

escalation, SCN 27-16

data manipulation language

SQL statements, OCI 1-8

Data Manipulation Language (DML), PCO 5-7

auditing, SCN 31-7

defined, SCN 1-52

described, SCN 16-3

distributed transactions, SCN 33-11

locks acquired by, SCN 27-25

parallel DML, SCN 26-3, SCN 26-35

partition locks, SCN 11-45

privileges controlling, SCN 30-5

processing statements, SCN 16-10

serializable isolation for subqueries, SCN 27-14

transaction model for parallel DML, SCN 26-39

triggers and, SCN 20-3, SCN 20-23

data manipulation language (DML)

minimizing propagation, REP 6-42

data manipulation language (DML) statements, SQL 6-4

data manipulation language. See DML.

Data manipulation statements (DML)

allowed in distributed transactions, DDS 1-11

Data Mart Builder, STU 28-9

Data Mart Designer, STU 28-9

data marts, STU 28-1

Data Migration Assistant, GTK 2-60

data mining, GTK 2-24

data models, SCN 1-22

data modification attack, OAS 2-5

data object number

extended ROWID, ADG 4 - 19, ADG 4 - 20

extended rowid, SCN 12-17

in extended rowids, SQL 2-22

data operations

asynchronous, NET 2-4

synchronous, NET 2-4

data path loads

direct and conventional, SUT 8-2

data privacy, OAS 1-4

data privacy and integrity, components of, OAS 11-3

data propagation

and dependency maintenance, REP 2-43

minimizing, REP 2-37

minimizing for update conflict resolution, REP 6-42

mode of

altering in a master site, REP 8-10

reduced, REP A-2

synchronous, REP 8-6

data recovery

direct path load

SQL*Loader, SUT 8-13

data replication

real-time, REP 8-6

data requirements

evaluating and understanding, REP 6-2

data segments, SCN 1-11, SCN 4-16, SCN 10-4

data structures

new for 8.0, OCI 2-5

data subsetting, REP A-3

data sufficiency check, STU 31-13

data transfer, maximizing, NET 3-13

data views in Oracle Trace, STU 15-6

Average Elapsed Time, STU 15-10

CPU Statistics, STU 15-11

Disk Reads, STU 15-9

Disk Reads/Execution Ratio, STU 15-9

Disk Reads/Logical Reads Ratio, STU 15-9

Disk Reads/Rows Fetched Ratio, STU 15-9

Execute Elapsed Time, STU 15-10

Fetch Elapsed Time, STU 15-11

Logical Reads, STU 15-9

Logical Reads/Rows Fetched Ratio, STU 15-9

Number of Rows Processed, STU 15-11

Parse Elapsed Time, STU 15-10

Parse/Execution Ratio, STU 15-10

Re-Parse Frequency, STU 15-10

Rows Fetched/Fetch Count Ratio, STU 15-11

Rows Sorted, STU 15-11

Sorts in Memory, STU 15-11

Sorts on Disk, STU 15-11

Total Elapsed Time, STU 15-10

Waits by Average Wait Time, STU 15-12

Waits by Event Frequency, STU 15-12

Waits by Total Wait Time, STU 15-12

data warehouse, STU 28-1

ANALYZE statement, STU 11-4

backup, STU 11-9

basic replication for, REP 1-11

bitmap index, STU 11-7

data mart, STU 28-1

dimension tables

(lookup tables), STU 28-5

fact tables (detail tables), STU 28-6

features, STU 11-1

hierarchies

rolling up and drilling down, STU 30-2

introduction, STU 11-1

Oracle Parallel Server, STU 11-6

parallel aware optimizer, STU 11-6

parallel index creation, STU 11-3

parallel load, STU 11-4

partition, STU 11-4

partitioned table, STU 26-47

recovery, STU 11-9

star schema, STU 11-8

Data warehousing

DISABLE VALIDATE state, GTK 2-28

data warehousing, GTK 2-21 to GTK 2-30, SPS 2-7

basic replication for, SCN 34-12

bitmap indexes, SCN 10-32

database resource manager, GTK 2-48

dimension schema objects, SCN 1-29, SCN 10-18

dimensions, SCN 24-14

function-based indexes, GTK 2-24

hierarchies, SCN 1-29, SCN 10-18

materialized views, GTK 2-22, SCN 10-17

refreshing table data, SCN 26-37

related features, GTK 2-30

SAMPLE function, GTK 2-24

star queries, SCN 24-14

statistics gathering

COMPUTE STATISTICS option of CREATE and ALTER INDEX statements, GTK 2-27

DBMS_STATS package, GTK 2-27

summaries, SCN 10-17

transportable tablespaces, GTK 2-23

Database, NET 2-29, SCN 5-3

database

administrator

application administrator vs., ADG 12 - 3

allowing generation of redo logs, SQL 7-12

allowing reuse of control files, SQL 7-251

allowing unlimited resources to users, SQL 7-339

archiving mode, SPS 14-2, SPS 14-9

as a repository for Oracle Names, NET 2-34

backup, SPS 4-6, SPS 21-1

buffers, STU 19-29

cancel-based recovery, SQL 7-13

terminating, SQL 7-14

change-based recovery, SQL 7-13

changing characteristics of, SQL 7-245

changing global name, SQL 7-15

changing the name of, SQL 7-245, SQL 7-246

character set

specifying, SQL 7-252

closing, SPS 18-26

conversion to multi-instance, SPS 23-1, SPS 23-4

converting from Oracle7 data dictionary, SQL 7-11

creating, PSC 3-5, PSC 3-6, PSC 4-3, SQL 7-250

creating a job on, PSC 6-31

creation, SPS 14-3

designing, SPS 1-15, SPS 13-1

designing media recovery, SQL 7-12

disconnecting, PSC 6-22

dismounting, SPS 18-26

displaying objects in Console, PSC 6-14

distributed, NET 2-5

enabling automatic extension of, SQL 7-253

erasing all data from, SQL 7-250

export and import, SPS B-1

global name in a distributed system, ADG 3 - 46

layout, STU 26-36

limiting resources for users, SQL 7-338

links

using different paths, REP 2-20

managed recovery of, SQL 7-8

migrating to multi-instance, SPS 23-3

modifying, SQL 7-10

mounted but not open, SPS 14-9

mounting, PSC 6-19, SQL 7-11, SQL 7-250

naming, SQL 7-11

number of archived log files, SPS 6-5, SPS 21-6

number of instances, SPS 11-15, SPS 14-3

opening, SQL 7-11, SQL 7-250

after media recovery, SQL 7-12

preparing for multimaster replication, REP 2-7

recovering, SQL 7-13

with backup control file, SQL 7-13

re-creating control file for, SQL 7-245

redo log files

specifying, SQL 7-246

remote

accessing, SQL 5-25

authenticating users to, SQL 7-257

connecting to, SQL 7-256

service name of, SQL 7-257

table locks on, SQL 7-521

resetting

current log sequence, SQL 7-12

to an earlier version, SQL 7-15

restricting users to read-only transactions, SQL 7-11

resuming activity, SQL 7-100

rollback segments, SPS 14-5

scalability, SPS 2-5

security

applications and, ADG 12 - 3

schemas and, ADG 12 - 9

specifying datafiles for, SQL 7-247

staging database, STU 28-1

standby, SPS 18-33, SPS 22-16

starting NOMOUNT, SPS 22-11

statistics, gathering, STU 7-16

suspending activity, SQL 7-100

time-based recovery, SQL 7-13

database accounts

creating, SQL 7-425

database administrator, SAD 1-2

application administrator versus, SAD 22-11

initial priorities, SAD 1-17

operating-system account, SAD 1-4

password files for, SAD 1-7

responsibilities of, SAD 1-2

role during migration, MIG 1-10

roles

about, SAD 1-6

for security, SAD 22-8

security and privileges of, SAD 1-4

security for, SAD 22-7

security officer versus, SAD 1-3, SAD 22-2

usernames, SAD 1-5

utilities for, SAD 1-17

database administrator (DBA), STU 1-8

distributed database, SPS 1-19

privileges for export, SUT 1-4

database administrators (DBAs)

authentication, SCN 29-12

data dictionary views, SCN 2-6

DBA role, SCN 14-13, SCN 30-22

password files, SCN 29-13

responsible for backup and recovery, SCN 32-2

database block size, SRF 4-3

database buffers

after committing transactions, SCN 17-6

buffer cache, SCN 7-3, SCN 8-8

clean, SCN 8-8

committing transactions, SCN 8-10

defined, SCN 1-16, SCN 7-3

dirty, SCN 7-3, SCN 8-8

free, SCN 7-3

multiple buffer pools, SCN 7-5

pinned, SCN 7-3

size of cache, SCN 7-5

writing of, SCN 8-8

database changes

making permanent, PLS 5-42

undoing, PLS 5-43

database character set, PLS 2-19

Database Configuration Assistant, GTK 2-59

database connect strings, SQL 2-75

database connection

for object applications, OCI 10-10

Database Connection event, STU 15-5

database creation, PSC 3-5, PSC 3-6, PSC 4-3

database creation failure, PSC C-2

database event notification, ADG 14 - 1, ADG 15 - 5

database events

and triggers, SQL 7-405

Database Information property sheet

Replication Manager, REP 2-18

database instance registration

benefits, NET 2-27

client load balancing, NET 2-30

connection load balancing, NET 2-30

connect-time failover, NET 2-29

described, NET 2-27, NET 4-2

load balancing, NET 2-30

MTS dispatcher registration, NET 2-27

service registration, NET 2-27, NET 6-2

Database link

for a foreign system, DDS 6-4

database link, RAR 2-12, RAR 2-17, RAR 5-3

connected user, DDS 2-11

creating synonym for, PC_ 3-14

defining, PC_ 3-14

example using, PC_ 3-14

fixed user, DDS 2-10

granting

system privileges on, SQL 7-495

using in INSERT statement, PC_ F-70

where stored, PC_ 3-14

Database Link setting

Create Scheduled Link property sheet, REP 2-12

database link specifications

incomplete, REP 7-33

database links, NET 2-36, NET 6-22, NET 6-44, REP 7-29, SCN 1-29, SQL 5-25

and Heterogeneous Services, DDS 5-4

closing, DDS 4-2, SQL 7-79

controlling connections, DDS 4-2

creating, SQL 2-74, SQL 7-255

creating a synonym, PCO 3-15

creating shared, DDS 2-8

creating synonyms with, SQL 7-356

current user, SQL 7-256

data dictionary views

ALL, DDS 2-20

DBA_DB_LINKS, DDS 2-20

USER, DDS 2-20

defined, SCN 1-29

defining, PCO 3-15

dropping, DDS 2-19

global database link, NET 2-36, NET 6-22

job queues and, SAD 8-9

listing, DDS 2-20

minimizing network connections, DDS 2-6

naming, SQL 2-74

overview of, DDS 1-6, SCN 33-6

partition-extended table names, SCN 11-65

private database, NET 2-36, NET 6-22

public, SQL 7-256

dropping, SQL 7-449

public database, NET 2-36, NET 6-22

referring to, SQL 2-76

removing from the database, SQL 7-449

resolution, DDS 2-14

shared, DDS 2-6, SQL 7-256

configurations, DDS 2-8

to multi-threaded (MTS) servers, DDS 2-10

snapshot sites, for, REP 3-26

syntax of, SQL 2-75

username and password, SQL 2-75

using in DELETE statement, PCO F-32

using in INSERT statement, PCO F-55

using in UPDATE statement, PCO F-87

database management system (DBMS), SCN 1-2

object-relational DBMS, SCN 13-2

Oracle server, SCN 1-4

principles, SCN 1-22

database mount enqueue, SRF B-2

database objects

dropping, SQL 7-483

export privileges, SUT 1-4

exporting LONG columns, SUT 1-55

nonschema, SQL 2-64

schema, SQL 2-63

transferring across a network

Import, SUT 2-50

database resource management, GTK 2-48

database resource manager, GTK 2-48

DBMS_RESOURCE_MANAGER package, GTK 2-49

DBMS_RESOURCE_MANAGER_PRIVS package, GTK 2-49

resource allocation methods, GTK 2-49

resource consumer groups, GTK 2-49

resource plan directives, GTK 2-49

resource plans, GTK 2-49

Database Resource Manager, SAD 11-1

database resource manager

compatibility, MIG 8-14

database schema

generating reports, SBR 7-8

database structures

control files, SCN 1-13, SCN 32-21

data blocks, SCN 1-10, SCN 4-2, SCN 4-3

data dictionary, SCN 1-30, SCN 2-1

datafiles, SBR 1-6, SCN 1-11, SCN 3-1, SCN 3-16

extents, SCN 1-10, SCN 4-2, SCN 4-11

logical, SCN 1-5, SCN 1-9

memory, SCN 1-14, SCN 7-1

online redo log, SBR 1-8

overview, SBR 1-6 to SBR 1-11

physical, SBR 1-6 to SBR 1-11, SCN 1-5

processes, SCN 1-14, SCN 1-17, SCN 8-1

redo log files, SBR 1-8, SCN 1-12, SCN 32-7

revealing with rowids, SCN 12-18

rollback segment, SBR 1-8

schema objects, SCN 1-10, SCN 10-2

segments, SCN 1-10, SCN 4-2, SCN 4-16

tablespaces, SCN 1-9, SCN 3-1, SCN 3-6

database SUSPEND/RESUME, GTK 2-52

database triggers, SCN 1-59, SCN 20-1

See also triggers

database triggers. See triggers.

database types

new, PC_ 17-35

database writer process (DBWn)

behavior on checkpoints, STU 20-39

tuning, STU 18-8, STU 26-76

database writer process (DBWn), SCN 8-8

checkpoints, SCN 8-8

defined, SCN 8-8

least recently used algorithm (LRU), SCN 8-8

media failure, SCN 32-6

multiple DBWn processes, SCN 8-8

overview of, SCN 1-18

trace file, SCN 32-6

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

database, defined, PSC 1-9

databases

access control

overview, SCN 1-51

password encryption, SCN 29-7

security domains, SCN 29-2

administering, SAD 1-1

administration, DDS 2-1

altering physical structure

standby databases, impact on, SBR 16-22

attributes, OCI 6-19

auditing, SAD 25-1

availability, SAD 3-7

backing up, SCN 1-50, SCN 32-23

after creation of, SAD 1-20

full backups, SAD 2-7

using Recovery Manager, SBR 4-29

backing up for migration, MIG 3-20

clone database, SCN 5-7

closing, SCN 5-10

aborting the instance, SCN 5-10, SCN 32-4

configuring, SCN 5-4

contain schemas, SCN 29-2

control files of, SAD 5-2

CREATE DATABASE command, SAD 2-7

creating

opening and, SAD 1-19

trouble-shooting problems, SAD 2-8

creating duplicate

on a remote host, SBR 10-10

creating duplicate using RMAN, SBR 10-2

creating test, SBR 10-2

data structure changes

incremental export and, SUT 1-48

database limits, SRF 4-2

db identifier, SBR 6-5

default language, SRF 1-80

defined, SCN 1-8, SCN 1-9

describing, OCI 6-2

design of

implementing, SAD 1-20

disaster recovery planning, SBR 16-1 to SBR 16-29

dismounting, SCN 5-10

distributed, SCN 1-35, SCN 33-1

changing global database name, SCN 7-11

nodes of, SCN 1-35

overview of, SCN 1-33, SCN 1-34, SCN 33-1

site autonomy of, DDS 1-16, SCN 33-16

statement optimization on, SCN 23-30

table replication, SCN 1-36

two-phase commit, SCN 1-35

downgrading, MIG 12-43

dropping, SAD 2-8

exclusive mode, SAD 3-6

full export, SUT 1-20

full import, SUT 2-23

global database name

about, SAD 2-9

global database names, SCN 33-4

in a distributed system, SAD 2-9

granting

system privileges on, SQL 7-495

hardware evaluation, SAD 1-18

incremental export, SUT 1-44

limitations on usage, SCN 29-15

listing for backups, SBR 13-2

logical structure of, SAD 1-19

managing

Enterprise Manager, SCN 33-19

Server Manager, DDS 1-19

size of, SAD 10-1

media recovery procedures, SBR 14-1 to SBR 14-32

media recovery scenarios, SBR 15-1 to SBR 15-15

migration of, SAD 2-3

modes of archiving, SCN 32-18

mounting, SCN 5-6

mounting a database, SAD 3-4

mounting to an instance, SAD 3-7

name, SRF 1-32, SRF 1-33

name stored in control file, SBR 2-3, SCN 32-21

names

about, SAD 2-9

conflicts in, SAD 2-9

naming, PC_ 3-8

open and closed, SCN 5-2

opening, SCN 5-7

a closed database, SAD 3-7

acquiring rollback segments, SCN 4-26

opening read-only, SCN 5-9

parallel mode, SAD 3-6

physical structure, SBR 1-6 to SBR 1-11

physical structure of, SAD 1-19

planning, SAD 1-18

preparing for Export, SUT 1-9

privileges for exporting, SUT 1-4

production, SAD 22-9, SAD 22-11

recovery

after control file damage, SBR 15-12

recovery after OPEN RESETLOGS option, SBR 14-35

recovery of, SCN 1-45, SCN 32-2

reducing fragmentation via full export/import, SUT 2-46

registering in recovery catalog, SBR 6-4, SBR 6-5

remote

inserting into, SQL 7-515

renaming, SAD 5-5

resource limits, SRF 1-108, SRF 1-109

restricting access to, SAD 3-4, SAD 3-8

reusing existing data files

Import, SUT 2-21

scalability, SCN 6-4, SCN 26-2, SCN 26-37

shutting down, SCN 5-9

size of

how determined, SCN 3-4

specifying control files, SAD 2-10

standby, SBR 16-2 to SBR 16-29, SCN 5-7, SCN 32-26

advantages, SBR 16-2

control files, SBR 16-25, SBR 16-29

creating, SBR 16-2

creating, procedures for, SBR 16-3

datafiles, taking offline, SBR 16-27

definition, SBR 16-2

direct path operations, SBR 16-27

initialization parameters, SBR 16-25

maintaining, SBR 16-6

manual recovery mode, SBR 16-5, SBR 16-6

modes, SBR 16-5

read-only mode, SBR 16-5, SBR 16-19

redo log files, altering, SBR 16-24

renaming datafiles, SBR 16-24

sustained recovery mode, SBR 16-5

transmitting archived redo logs, SBR 16-7

starting up, SCN 5-2

before database creation, SAD 2-6

forced, SCN 5-10

general procedures for, SAD 3-2

restricting access, SAD 3-4

structure of

distributed database, SAD 1-19

structures

control files, SCN 1-13, SCN 32-21

data blocks, SCN 1-10, SCN 4-2, SCN 4-3

data dictionary, SCN 1-30, SCN 2-1

datafiles, SCN 1-11, SCN 3-1, SCN 3-16

extents, SCN 1-10, SCN 4-2, SCN 4-11

logical, SCN 1-5, SCN 1-9, SCN 4-1

memory, SCN 1-14, SCN 7-1

physical, SCN 1-5, SCN 1-11

processes, SCN 1-14, SCN 1-17, SCN 8-1

redo log files, SCN 1-12, SCN 32-7

revealing with rowids, SCN 12-18

schema objects, SCN 1-10, SCN 10-2

segments, SCN 1-10, SCN 4-2, SCN 4-16

tablespaces, SCN 1-9, SCN 3-1, SCN 3-6

suspending, SBR 13-9

test, SAD 22-9

test migration results, MIG 6-6

tuning

archiving large databases, SAD 7-20

responsibilities for, SAD 1-20

tuning after migration, MIG 6-6

unregistering in recovery catalog, SBR 6-6

user responsibilities, SAD 1-3

valid characters for database name, SRF 1-33

viewing datafiles and redo log files, SAD 2-8

whole database backups, SBR 13-3 to SBR 13-5

data-dependent routing, SPS 3-8

datafile

accessibility, SPS 5-9

adding, SPS 15-6, SPS 15-10, SPS 15-12, SPS A-18

allocating extents, SPS 17-12

backing up, SPS 21-1

disk contention, SPS 6-2

dropping, SPS A-18

file ID, SPS 15-3

instance recovery, SPS 6-2, SPS 22-4

mapping locks to blocks, SPS 9-6

maximum number, SPS B-3

multiple files per table, SPS 11-15, SPS 17-11, SPS 17-13

number of blocks, SPS 15-3

parallel recovery, SPS 22-7

recovery, SPS 22-7, SPS A-22

renaming, SPS A-18

shared, SPS 5-4, SPS 6-2

tablespace, SPS A-18

tablespace name, SPS 15-3

taking offline or online, SPS A-18

unspecified for PCM locks, SPS 9-6

validity, SPS 15-12

datafile 1, SCN 3-16

backup, SCN 32-25

data dictionary, SCN 3-6, SCN 32-25

SYSTEM tablespace, SCN 3-6, SCN 3-16

datafile backups

using RMAN, SBR 8-4, SBR 8-5, SBR 8-6

DATAFILE clause, STU 20-24

of ALTER DATABASE, SQL 7-8, SQL 7-16

of CREATE CONTROLFILE, SQL 7-247

of CREATE DATABASE, SQL 7-253

DATAFILE clauses

of ALTER DATABASE, SQL 7-8

DATAFILE END BACKUP clause

of ALTER DATABASE, SQL 7-17

datafile enqueue, SRF B-2

DATAFILE OFFLINE clause

of ALTER DATABASE, SQL 7-16

DATAFILE ONLINE clause

of ALTER DATABASE, SQL 7-16

DATAFILE ONLINE option

ALTER DATABASE command, SBR 14-31

DATAFILE option

table, SPS 17-14

tablespace, SPS A-18

datafile placement on disk, STU 20-21

DATAFILE RESIZE clause

of ALTER DATABASE, SQL 7-17

datafiles, SBR 1-6

adding to a tablespace, SAD 10-5

adding to primary database

effect on standby database, SBR 16-23

backing up, SBR 3-8, SCN 32-25

offline, SBR 13-10

using Recovery Manager, SBR 4-29

backups needed, listing, SBR 7-10, SBR 7-11, SBR 7-12, SBR 8-15

backups, listing, SBR 7-2

bringing online, SQL 7-16

bringing online and offline, SAD 10-7

checking associated tablespaces, SAD 9-31

checking backup status, SBR 13-7

contents of, SCN 3-16

copies, listing, SBR 7-2

creating, SAD 9-3

creating new, SQL 7-16

database administrators access, SAD 1-4

datafile 1, SCN 3-6, SCN 3-16

backup, SCN 32-25

SYSTEM tablespace, SCN 3-6, SCN 3-16

default directory, SAD 10-5

designing media recovery, SQL 7-12

disabling automatic extension, SQL 7-17

dropping, SAD 9-14

NOARCHIVELOG mode, SAD 10-8

enabling automatic extension, SQL 7-17, SQL 7-395

fully specifying filenames, SAD 10-5

identifying filenames, SAD 10-11

in online or offline tablespaces, SCN 3-17

listing

for backup, SBR 13-2

unrecoverable, SBR 7-5

location, SAD 10-4

loss of, SBR 15-2

managing, SAD 10-1

mapping blocks to PCM locks, SRF 1-44

maximum number, SRF 1-32

maximum number of, SAD 10-2

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

offline during migration, MIG 3-4

online, SAD 10-8

overview, SBR 1-6

overview of, SCN 1-9, SCN 1-12, SCN 3-16

parallel recovery, SCN 32-11

parameter, SRF 1-30, SRF 1-32

physical database structure, SCN 1-5

preventing overwrite during import, SUT 2-21

privileges to rename, SAD 10-9

privileges to take offline, SAD 10-8

read-only, SCN 3-10

recovery, SCN 32-6

read-only tablespaces and, SCN 3-12

recovering, SQL 7-13

recovery

creation, SBR 14-6

guidelines, SBR 4-49, SBR 9-16

using RMAN, SBR 9-15

without backup, SBR 14-6

re-creating lost, SQL 7-16

registering, SBR 6-5

relationship to tablespaces, SCN 3-2

relocating, SAD 10-9, SAD 10-10

relocating, example, SAD 10-11

renaming, SAD 10-9, SAD 10-10, SQL 7-15

effect on standby database, SBR 16-24

renaming for single tables, SAD 10-9

resizing, SQL 7-17

restoring, SBR 4-47

restoring using RMAN, SBR 9-2

reusing, SAD 10-5, SQL 7-491

reusing during import, SUT 2-21

shown in ROWIDs, ADG 4 - 20

shown in rowids, SCN 12-17, SCN 12-18

size of, SAD 10-4, SQL 7-491

specifying, SQL 7-490, SUT 6-4

specifying buffering for SQL*Loader, SUT 5-24

specifying for a tablespace, SQL 7-395

specifying for SQL*Loader, SUT 5-22

specifying format for SQL*Loader, SUT 5-24

storing separately from redo log files, SAD 10-4

taking offline, SCN 3-17, SQL 7-16

temporary, SCN 3-17

unavailable when database is opened, SAD 3-3

unrecoverable, SCN 32-17

unspecified for PCM locks, SRF 1-45

usage, SBR 1-6

verifying data blocks, SAD 10-12

viewing

backup status, SBR 13-7

files needing recovery, SBR 14-3

general status of, SAD 10-13

V$DBFILE and V$LOGFILE views, SAD 2-8

datatype

internal versus external, PCO 2-8

datatype code

internal, OCI 3-5

datatype codes

used in descriptors, PC_ 15-15

datatype conversion

between internal and external types, PCO 4-44

table of, SQL 2-32

datatype conversions, PC_ 5-11, PC_ 5-12

datatype equivalencing, PC_ 2-7, PC_ 5-12

advantages, PCO 4-46

example, PCO 4-50

guidelines, PCO 4-52

purpose of, PC_ 2-7

datatype mapping

Oracle methodology, OCI 11-4

OTT, OCI 14-10

datatype mapping and manipulation functions

server roundtrips, OCI C-6

datatype mappings, PC_ 19-10

datatypes, ADG 4 - 2, PLS 2-10, SCN 12-2, SCN 12-3, SQL 2-5

allowed in replicated tables, REP 2-26

allowed in snapshots, REP 3-17, REP 5-26

ANSI, SCN 12-22

ANSI/ISO, ADG 4 - 24

ANSI-supported, SQL 2-8

array types, SCN 13-11

associating statistics with, SQL 7-196

BFILE, OCI 3-20, PLS 2-21, SQL 2-10, SQL 2-20

Export, SUT 1-56

BINARY_INTEGER, PLS 2-11

BLOB, OCI 3-20, PLS 2-22, SQL 2-10, SQL 2-21

BOOLEAN, PLS 2-22, SCN 12-2

built-in, SQL 2-9

syntax, SQL 2-7

BYTEINT, SUT 5-60

CHAR, ADG 4 - 2, ADG 4 - 5, PLS 2-14, SCN 12-5, SQL 2-9, SQL 2-11, SUT 5-64

character, SAD 12-17, SCN 12-5, SCN 12-13, SQL 2-10

choosing a character datatype, ADG 4 - 5

CLOB, OCI 3-20, PLS 2-22, SQL 2-10, SQL 2-21

COBOL, PCO 4-17

coercing NUMBER to VARCHAR2, PC_ 15-15, PCO 11-19

collection, DCI 1-8

collections, SCN 13-10

column lengths for character types, ADG 4 - 6

comparison rules, SQL 2-27

conflicting character datatype fields, SUT 5-73

constrained, PLS 7-4

conversions, OCI 3-21, PCO 4-43

conversions of

by program interface, SCN 8-25

non-Oracle types, SCN 12-22

Oracle to another Oracle type, SCN 12-23

converting

SQL*Loader, SUT 5-69

converting SQL*Loader, SUT 3-9

data conversion, ADG 4 - 25

DATE, ADG 4 - 8, ADG 4 - 10, PLS 2-23, SAD 12-18, SCN 12-10, SQL 2-9, SQL 2-17, SUT 5-65

DB2, ADG 4 - 24, SCN 12-22

DBMS_DESCRIBE, SPR 11 - 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-47

DESC_TAB, SPR 48 - 31

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-39, OCI A-47

DOUBLE, SUT 5-60

equivalencing

description, PCO 4-46

example, PCO 4-49

extensibility, DCI 1-7

external, OCI 3-4, OCI 3-7, SQL 2-6

families, PLS 2-10

FILE, OCI 3-20

FLOAT, SUT 5-59

for piecewise operations, OCI 5-33

GRAPHIC, SUT 5-66

GRAPHIC EXTERNAL, SUT 5-66

how they relate to tables, SCN 10-3

implicit conversion, PLS 2-27

in PL/SQL, SCN 12-2

individual type names, SAD 12-17

INTEGER, SUT 5-59

internal, OCI 3-3, OCI 3-5, PC_ 4-2, PCO 11-16

new in Oracle8i, MIG E-2

internal versus external, PC_ 2-7

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

default logging mode, SCN 25-7

LONG, ADG 4 - 15, PLS 2-15, SAD 12-18, SCN 12-7, SQL 2-9, SQL 2-15

Export, SUT 1-55

Import, SUT 2-61

storage of, SCN 10-7

LONG RAW, ADG 4 - 16, ADG 4 - 18, PLS 2-15, SQL 2-9, SQL 2-18

manipulating with OCI, OCI 11-5

mapping, DDS 5-3

mapping from Oracle to C, OCI 11-2

MLSLABEL, ADG 4 - 23

multimedia, SCN 13-3

native

conflicting length specifications

SQL*Loader, SUT 5-69

SQL*Loader, SUT 5-59

NCHAR, ADG 4 - 2, ADG 4 - 5, PLS 2-19, SQL 2-10, SQL 2-11

NCHAR and NVARCHAR2, SCN 12-6

NCLOB, SPR 17 - 3, OCI 3-21, PLS 2-22, SQL 2-10, SQL 2-21

need to coerce, PC_ 15-15, PCO 11-19

nested tables, SCN 10-9, SCN 13-12

NLS, PLS 2-19

non-scalar, SUT 5-93

NUMBER, ADG 4 - 7, PLS 2-12, SAD 12-17, SCN 12-8, SQL 2-13

SQL*Loader, SUT 5-70

NUMER, SQL 2-9

numeric EXTERNAL, SUT 5-67, SUT 5-83

NVARCHAR2, ADG 4 - 2, ADG 4 - 5, PLS 2-20, SQL 2-9, SQL 2-12

object type, DCI 1-8

object types, SCN 1-22, SCN 13-4

of columns, SCN 1-23

Oracle, OCI 3-2, PC_ 2-7

PLS_INTEGER, PLS 2-13

PL/SQL

numeric codes for, SPR 11 - 9

PL/SQL equivalents, PCO 11-18

RAW, ADG 4 - 18, PLS 2-15, SQL 2-9, SQL 2-18, SUT 5-68

RAW and LONG RAW, SCN 12-14

RECORD, PLS 4-37

REF (relationship), DCI 1-8

REF CURSOR, PLS 5-16

restrictions on using, PC_ 17-38

ROWID, ADG 4 - 18, SPR 42 - 1, PLS 2-16, SCN 12-15, SCN 12-16, SQL 2-9, SQL 2-21

scalar versus composite, PLS 2-10

SMALLINT, SUT 5-59

space use of, SAD 12-17

specifying the SQL*Loader datatype of a data field, SUT 5-47

SQL/DS, ADG 4 - 24, SCN 12-22

summarized, SAD 12-19

summary, SCN 12-3

summary of datatypes, ADG 4 - 2

support for, REP A-3

TABLE, PLS 4-2

UROWID, PLS 2-16, SQL 2-9, SQL 2-23

user-defined, SCN 13-1, SCN 13-3

statistics, SCN 22-17

user-defined type equivalencing, PC_ F-111

VARCHAR, ADG 4 - 5, SCN 12-6, SQL 2-13, SUT 5-62

VARCHAR2, ADG 4 - 2, ADG 4 - 5, PLS 2-18, SCN 12-5, SQL 2-9, SQL 2-12

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

DATE

external datatype, OCI 3-14

Date

defining format, DDS A-9

date arithmetic, ADG 4 - 27

date constraints

checking for bad, MIG 6-2, MIG 7-33

DATE datatype, ADG 4 - 8, PC_ 4-8, PLS 2-23, SAD 12-18, SCN 12-10, SQL 2-17

arithmetic with, SCN 12-11

centuries, ADG 4 - 10

changing default format of, SCN 12-10

converting, PCO 4-45

converting from character or numeric value, SQL 2-17

data conversion, ADG 4 - 25

default format, PCO 4-45

default value, PCO 4-3

delimited form and SQL*Loader, SUT 5-70

determining length, SUT 5-74

internal, PCO 4-3

Julian dates, SCN 12-11

mask

SQL*Loader, SUT 5-74

midnight, SCN 12-11

partition pruning, SCN 11-22

partitioning, SCN 11-14, SCN 11-21

SQL*Loader, SUT 5-65

trimming whitespace, SUT 5-83

DATE datatypes

external, PCO 4-10

internal format, PCO 4-10

date format elements, SQL 2-40

and NLS, SQL 2-43

capitalization, SQL 2-40

ISO standard, SQL 2-44

RR, SQL 2-44

suffixes, SQL 2-45

date format models, SQL 2-40

punctuation in, SQL 2-40

date format strings, GTK 6-2

Date formats, NLS 2-12, NLS 4-9

and partition bound expressions, NLS 2-13

date functions, SQL 4-4

date mask, SUT 5-16

date parameters, NLS 2-11

DATE String Format

explicit control over, PCO 4-45

DATE_FORMAT precompiler option, PCO 14-16

DATE_OF_INSERT column

TKPROF_TABLE, STU 14-18

dates

arithmetic using, SQL 2-17

comparison rules, SQL 2-27

converting, PLS 2-28

ISO standard, NLS 2-16, NLS 4-10

Julian, SQL 2-18

language used for, SRF 1-79

NLS_DATE_LANGUAGE parameter, NLS 2-14

NLS_TERRITORY parameter, NLS 2-8

setting SYSDATE, SRF 1-42

specifying in RMAN commands, SBR 5-2

TO_CHAR and TO_DATE functions, SRF 1-78

TO_CHAR default format, PLS 2-28

day

format element, NLS 2-14

language of names, NLS 2-14

DAY date format element, SQL 2-43

DB, PSC 2-9, PSC 4-19

db block changes statistic, SRF C-8

db block gets statistic, SRF C-8, STU 19-26, STU 21-4, STU 21-22

db file parallel read wait event, SRF A-25

db file parallel write wait event, SRF A-26

db file scattered read wait event, SRF A-26

db file sequential read wait event, SRF A-26

db file single write wait event, SRF A-27

db identifier, SBR 6-5

DB_BLOCK_BUFFERS parameter, SPS 9-18, SRF 1-25, STU 19-29, STU 19-34, STU 20-43

buffer cache and, SCN 7-5

ensuring LM lock capacity, SPS 16-6

GC_RELEASABLE_LOCKS, SPS 15-13

setting before database creation, SAD 2-11

system global area size and, SCN 7-13

DB_BLOCK_CHECKING parameter, SAD 19-3, SRF 1-26

of ALTER SESSION, SQL 7-82

of ALTER SYSTEM, SQL 7-101

DB_BLOCK_CHECKPOINT_BATCH parameter, SRF 1-25

DB_BLOCK_CHECKSUM, SAD 10-12

DB_BLOCK_CHECKSUM parameter, SRF 1-26

of ALTER SYSTEM, SQL 7-101

DB_BLOCK_LRU_EXTENDED_STATISTICS parameter, SRF 1-27

DB_BLOCK_LRU_LATCHES parameter, SCN 8-8, SRF 1-27, STU 19-34, STU 19-40

DB_BLOCK_LRU_STATISTICS parameter, SRF 1-27

DB_BLOCK_MAX_DIRTY_TARGET

parameter, STU 20-41

DB_BLOCK_MAX_DIRTY_TARGET parameter, SRF 1-27

of ALTER SYSTEM, SQL 7-101

DB_BLOCK_SIZE initialization parameter

migration, MIG 3-6, MIG 4-5

DB_BLOCK_SIZE parameter, PSC 6-11, SRF 1-28

and parallel query, STU 26-28

buffer cache and, SCN 7-5

database buffer cache size and, SAD 2-11

same for all instances, SPS 18-11

setting before creation, SAD 2-11

system global area size and, SCN 7-13

tuning backups, STU 20-53

DB_DOMAIN initialization parameter, DDS 6-14

compatibility, MIG B-9

DB_DOMAIN parameter, DDS A-3, NET 4-5, NET 5-17, PSC 6-7, PSC 6-11, SRF 1-29

setting before database creation, SAD 2-9

DB_FILE_DIRECT_IO_COUNT

parameter, STU 20-53

DB_FILE_DIRECT_IO_COUNT parameter, SRF 1-30

DB_FILE_MULTIBLOCK_READ_COUNT parameter, SCN 23-51, SRF 1-30, STU 7-21, STU 20-37, STU 26-28

cost-based optimization, SCN 24-9

of ALTER SESSION, SQL 7-82

of ALTER SYSTEM, SQL 7-101

DB_FILE_NAME_CONVERT initialization parameter, SBR 4-53

using with RMAN duplicate command, SBR 10-7

DB_FILE_NAME_CONVERT parameter, SRF 1-31

DB_FILE_SIMULTANEOUS_WRITES parameter, SRF 1-31

DB_FILE_STANDBY_NAME_CONVERT initialization parameter, SBR 16-26

for primary and standby databases, SBR 16-25

DB_FILES initialization parameter, SBR 16-26

DB_FILES parameter, PSC 6-11, SCN 7-15, SRF 1-32

calculating non-PCM resources, SPS 16-4

ensuring LM lock capacity, SPS 16-6

same for all instances, SPS 18-11

DB_INTERNAL_NAME parameter, DDS A-4

DB_NAME parameter, DDS A-5, NET 5-17, PSC 1-11, PSC 6-3, PSC 6-7, PSC 6-11, SCN 32-22, SRF 1-32

conversion to multi-instance, SPS 23-7

same for all instances, SPS 18-11

setting before database creation, SAD 2-9

DB_NAME.CONF file

auto-discovery, PSC C-4

creating, PSC B-2

environ parameter, PSC B-6

examples, PSC B-7

inst_init_ora parameter, PSC B-5, PSC B-8

inst_oracle_sid parameter, PSC B-5, PSC B-7

inst_sid_list parameter, PSC C-7

listener configuration, PSC B-9

lsnr_listener_name parameter, PSC 4-19, PSC B-5, PSC B-10, PSC C-7

node#

tns_admin parameter, PSC B-5

node#inst_init_ora parameter, PSC B-5

node_list parameter, PSC 5-12, PSC B-5, PSC C-4

oracle_home parameter, PSC B-5

overview, PSC B-2

parameter expansion, PSC B-3

parameter syntax, PSC B-3

parameters, PSC B-5

parameters node overrides, PSC B-7

sample, PSC B-11

tns_admin parameter, PSC B-5, PSC B-9

DB_NAME.TBL file, PSC 2-9

DB_VERIFY utility, SAD 19-3

DB_WRITER_PROCESSES parameter, SCN 1-18, SCN 8-8, SRF 1-33

DB2 compatibility features, PCO A-4

DB2 datatypes, SQL 2-23

conversion to Oracle datatypes, SQL 2-25

restrictions on, SQL 2-25

DB2 load utility, SUT B-1

different 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, SAD 1-2

DBA locking, PSC 1-18, STU 27-13

DBA role, SAD 1-6, SAD 24-5, SCN 30-22, SQL 7-503

EXP_FULL_DATABASE role, SUT 1-9

user-defined types, SCN 14-13

DBA shortcut

of AUDIT sql_statements, SQL 7-198

DBA_ views, SCN 2-6

DBA_2PC_NEIGHBORS view, SRF 2-70

DBA_2PC_PENDING view, DDS 3-29, SQL 7-79, SRF 2-71

DBA_ALL_TABLES view, SRF 2-72

DBA_ANALYZE_OBJECTS view, SRF 2-74

DBA_ASSOCIATIONS view, SRF 2-74

DBA_AUDIT_EXISTS view, SRF 2-74

DBA_AUDIT_OBJECT view, SRF 2-75

DBA_AUDIT_SESSION view, SRF 2-77

DBA_AUDIT_STATEMENT view, SRF 2-77

DBA_AUDIT_TRAIL view, SRF 2-79

DBA_BLOCKERS view, SRF 2-80

DBA_CATALOG view, SRF 2-80

DBA_CLU_COLUMNS view, SRF 2-81

DBA_CLUSTER_HASH_EXPRESSIONS view, SRF 2-82

DBA_CLUSTERS view, SRF 2-81

DBA_COL_COMMENTS view, SQL 7-212, SRF 2-82

DBA_COL_PRIVS view, SRF 2-83

DBA_COLL_TYPES view, SRF 2-83

DBA_CONS_COLUMNS view, SRF 2-85

DBA_CONSTRAINTS view, SRF 2-84

DBA_CONTEXT view, SRF 2-85

DBA_DATA_FILES, SAD 9-31, SAD 10-13

DBA_DATA_FILES view, SBR 13-6, SBR 13-10, SRF 1-45, SRF 2-85, SRF 2-165, STU 26-79

DBA_DB_LINKS

data dictionary view, DDS 2-20

DBA_DB_LINKS view, SRF 2-86

DBA_DDL_LOCKS view, SRF 2-86

DBA_DEPENDENCIES view, SRF 2-87

DBA_DIM_ATTRIBUTES view, SRF 2-88

DBA_DIM_CHILD_OF view, SRF 2-88

DBA_DIM_HIERARCHIES view, SRF 2-89

DBA_DIM_JOIN_KEY view, SRF 2-88

DBA_DIM_LEVEL_KEY view, SRF 2-89

DBA_DIM_LEVELS view, SRF 2-89

DBA_DIMENSIONS view, SRF 2-87

DBA_DIRECTORIES view, SRF 2-90

DBA_DML_LOCKS view, SRF 2-90

DBA_ERRORS view, SRF 2-91

debugging stored procedures, ADG 10 - 43

DBA_EXP_FILES view, SRF 2-91

DBA_EXP_OBJECTS view, SRF 2-92

DBA_EXP_VERSION view, SRF 2-92

DBA_EXTENTS, SAD 10-13

DBA_EXTENTS view, SRF 2-92, STU 26-79

DBA_FREE_SPACE, SAD 9-31, SAD 10-13

DBA_FREE_SPACE view, SRF 2-93

DBA_FREE_SPACE_COALESCED view, SAD 9-9, SRF 2-93

DBA_HISTOGRAMS view, STU 7-6

DBA_IND_COLUMNS view, SRF 2-96

DBA_IND_PARTITIONS view, SRF 2-97

DBA_IND_SUBPARTITIONS view, SRF 2-18, SRF 2-99

DBA_INDEXES view, SRF 2-94, STU 6-16

filling with data, SAD 20-5

DBA_INDEXTYPE_OPERATORS view, SRF 2-100

DBA_INDEXTYPES view, SRF 2-100

DBA_JOBS view, SRF 2-101

DBA_JOBS_RUNNING view, SRF 2-102

DBA_LIBRARIES view, SRF 2-102

DBA_LOB_PARTITIONS view, SRF 2-103

DBA_LOB_SUBPARTITIONS view, SRF 2-104

DBA_LOBS view, SRF 2-102

DBA_LOCK_INTERNAL view, SRF 2-105

DBA_LOCKS view, SRF 2-105

DBA_METHOD_PARAMS view, SRF 2-106

DBA_METHOD_RESULTS view, SRF 2-106

DBA_MVIEW_AGGREGATES view, SRF 2-107

DBA_MVIEW_ANALYSIS view, SRF 2-107

DBA_MVIEW_DETAIL_RELATIONS view, SRF 2-108

DBA_MVIEW_JOINS view, SRF 2-109

DBA_MVIEW_KEYS view, SRF 2-109

DBA_NESTED_TABLES view, SRF 2-110

DBA_OBJ_AUDIT_OPTS view, SRF 2-113

DBA_OBJECT_SIZE view, SRF 2-110

DBA_OBJECT_TABLES view, SRF 2-111

DBA_OBJECTS view, SRF 2-113, STU 19-32

DBA_OPANCILLARY view, SRF 2-114

DBA_OPARGUMENTS view, SRF 2-114

DBA_OPBINDINGS view, SRF 2-115

DBA_OPERATORS view, SRF 2-115

DBA_OUTLINE_HINTS view, SRF 2-115

DBA_OUTLINES view, SRF 2-116

DBA_PART_COL_STATISTICS view, SRF 2-116

DBA_PART_HISTOGRAMS view, SRF 2-117

DBA_PART_INDEXES view, SRF 2-117

DBA_PART_KEY_COLUMNS view, SRF 2-119

DBA_PART_LOBS view, SRF 2-119

DBA_PART_TABLES view, SRF 2-120

DBA_PARTIAL_DROP_TABS view, SRF 2-121

DBA_PENDING_TRANSACTIONS view, SRF 2-121

DBA_POLICIES view, SRF 2-122

DBA_PRIV_AUDIT_OPTS view, SRF 2-122

DBA_PROFILES view, SRF 2-123

DBA_QUEUE_SCHEDULES view, SCN 19-10, SRF 2-123

DBA_QUEUE_TABLES, ADQ 5-5, ADQ 5-8, ADQ 5-26

DBA_QUEUE_TABLES view, SRF 2-125

DBA_QUEUES, ADQ 5-11

DBA_QUEUES view, SRF 2-125

DBA_RCHILD view, SRF 2-126

DBA_REFRESH view, SRF 2-126

DBA_REFRESH_CHILDREN view, SRF 2-127

DBA_REFS view, SRF 2-128

DBA_REGISTERED_SNAPSHOT_GROUPS view, SRF 2-129

DBA_REGISTERED_SNAPSHOTS view, REP 7-37, SRF 2-129

DBA_REPCAT_REFRESH_TEMPLATES view, SRF 2-130

DBA_REPCAT_TEMPLATE_OBJECTS view, SRF 2-130

DBA_REPCAT_TEMPLATE_PARMS view, SRF 2-130

DBA_REPCAT_TEMPLATE_SITES view, SRF 2-130

DBA_REPCAT_USER_AUTHORIZATIONS view, SRF 2-130

DBA_REPCAT_USER_PARM_VALUES view, SRF 2-130

DBA_REPCATLOG view, SRF 2-129

DBA_REPCOLUMN view, SRF 2-130

DBA_REPCOLUMN_GROUP view, SRF 2-130

DBA_REPCONFLICT view, SRF 2-131

DBA_REPDDL view, SRF 2-131

DBA_REPGENERATED view, SRF 2-131

DBA_REPGENOBJECTS view, SRF 2-131

DBA_REPGROUP view, SRF 2-131

DBA_REPGROUPED_COLUMN view, SRF 2-131

DBA_REPKEY_COLUMNS view, SRF 2-131

DBA_REPOBJECT view, SRF 2-131

DBA_REPPARAMETER_COLUMN view, SRF 2-132

DBA_REPPRIORITY view, SRF 2-132

DBA_REPPRIORITY_GROUP view, SRF 2-132

DBA_REPPROP view, SRF 2-132

DBA_REPRESOL_STATS_CONTROL view, SRF 2-132

DBA_REPRESOLUTION view, SRF 2-132

DBA_REPRESOLUTION_METHOD view, SRF 2-132

DBA_REPSITES view, SRF 2-132

DBA_RGROUP view, SRF 2-133

DBA_ROLE_PRIVS view, ADG 12 - 4, SRF 2-134

DBA_ROLES view, SRF 2-133

DBA_ROLLBACK_SEGS view, SAD 21-14, SPS 6-8, SPS 14-7, SQL 7-470, SRF 2-134

public rollback segments, SPS 14-6

DBA_RSRC_CONSUMER_GROUP_PRIVS view, SRF 2-135

DBA_RSRC_CONSUMER_GROUPS view, SRF 2-135

DBA_RSRC_MANAGER_SYSTEM_PRIVS view, SRF 2-135

DBA_RSRC_PLAN_DIRECTIVES view, SRF 2-136

DBA_RSRC_PLANS view, SRF 2-136

DBA_RULESETS view, SRF 2-137

DBA_SEGMENTS, SAD 9-31, SAD 10-13

DBA_SEGMENTS view, SPS 14-7, SRF 2-137

DBA_SEQUENCES view, SRF 2-138

DBA_SNAPSHOT_LOG_FILTER_COLS view, SRF 2-139

DBA_SNAPSHOT_LOGS view, REP 7-37, SRF 2-139

DBA_SNAPSHOT_REFRESH_TIMES view, SRF 2-139

DBA_SNAPSHOTS view, SRF 2-140

DBA_SOURCE view, ADG 10 - 43, SRF 2-141

DBA_STMT_AUDIT_OPTS view, SRF 2-142

DBA_SUBPART_COL_STATISTICS view, SRF 2-142

DBA_SUBPART_HISTOGRAMS view, SRF 2-143

DBA_SUBPART_KEY_COLUMNS view, SRF 2-143

DBA_SYNONYMS view, SRF 2-144

DBA_SYNONYMS.SQL script

using, SCN 2-7

DBA_SYS_PRIVS view, SRF 2-144

DBA_TAB_COL_STATISTICS view, SRF 2-144

DBA_TAB_COLUMNS view, SRF 2-145, STU 7-5, STU 7-6

filling with data, SAD 20-5

DBA_TAB_COMMENTS view, SQL 7-212, SRF 2-146

DBA_TAB_HISTOGRAMS view, SRF 2-146

DBA_TAB_PARTITIONS view, SRF 2-147

DBA_TAB_PRIVS view, SRF 2-148

DBA_TAB_SUBPARTITIONS view, SRF 2-148

DBA_TABLES table, SPS 16-7

DBA_TABLES view, SRF 2-150

filling with data, SAD 20-5

DBA_TABLESPACES, SAD 9-31, SAD 10-13

DBA_TABLESPACES view, SAD 9-15, SRF 2-152

DBA_TEMP_FILES view, SRF 2-152

DBA_TRIGGER_COLS view, SRF 2-154

DBA_TRIGGERS view, SRF 2-153

DBA_TS_QUOTAS, SAD 9-31, SAD 10-13

DBA_TS_QUOTAS view, SRF 2-154

DBA_TYPE_ATTRS view, SRF 2-154

DBA_TYPE_METHODS view, SRF 2-155

DBA_TYPES view, SRF 2-155

DBA_UPDATABLE_COLUMNS view, SCN 10-15, SRF 2-156

DBA_USERS, SAD 9-31, SAD 10-13

DBA_USERS view, SRF 2-156

DBA_USTATS view, SRF 2-157

DBA_VARRAYS view, SRF 2-158

DBA_VIEWS view, SRF 2-158

DBA_WAITERS view, SRF 2-159

DBAccess Interface, NET 2-18

DBCA, PSC 2-8, PSC 2-13, PSC 4-3

DBCA_RAW_CONFIG environment variable, PSC 2-8, PSC 2-13, PSC 4-3

DBCS (DB2 double-byte character set)

not supported by Oracle, SUT B-4

DBLINK_ENCRYPT_LOGIN parameter, SRF 1-34

DBMS, SCN 1-2

general requirements, SCN 1-51

object-relational DBMS, SCN 13-2

precompiler command line option, MIG 8-19

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

DBMS_ALERT_INFO view, SRF 2-159

DBMS_APPLICATION_INFO package, SPR 3 - 2, STU 5-2, STU 5-3

DBMS_AQ package, SPR 4 - 1, SCN 19-4

DBMS_AQADM package, SPR 5 - 1, SCN 19-4, SCN 19-7

DBMS_AQADM.DROP_QUEUE, ADQ 4-16

DBMS_AQADM.START_QUEUE, ADQ 4-28

DBMS_DDL package, SPR 6 - 1

DBMS_DEBUG package, SPR 7 - 1

DBMS_DEFER package, SPR 8 - 1

ADD_DEFAULT_DEST procedure, REP 9-6

CALL procedure, RAR 8-6

CHAR_ARG procedure, RAR 8-9, REP 9-5

COMMIT_WORK procedure, RAR 8-8

DATE_ARG procedure, RAR 8-9, REP 9-5

NUMBER_ARG procedure, RAR 8-9, REP 9-5

RAW_ARG procedure, RAR 8-9, REP 9-5

ROWID_ARG procedure, RAR 8-9, REP 9-5

TRANSACTION procedure, RAR 8-10, REP 9-4

VARCHAR2_ARG procedure, RAR 8-9, REP 9-5

DBMS_DEFER_QUERY package, SPR 9 - 1

GET_ARG_TYPE procedure, RAR 8-13

GET_CHAR_ARG procedure, RAR 8-16

GET_DATE_ARG procedure, RAR 8-16

GET_NUMBER_ARG procedure, RAR 8-16

GET_RAW_ARG procedure, RAR 8-16

GET_ROWID_ARG procedure, RAR 8-16

GET_VARCHAR2_ARG procedure, RAR 8-16

DBMS_DEFER_SYS package, SPR 10 - 1

ADD_DEFAULT_DEST procedure, RAR 8-20

DELETE_DEF_DESTINATION procedure, RAR 8-22

DELETE_DEFAULT_DEST procedure, RAR 8-21, REP 9-6

DELETE_ERROR procedure, RAR 8-23

DELETE_TRAN procedure, RAR 8-24

DISABLED function, RAR 8-25

DISABLED procedure, REP 2-15

EXCLUDE_PUSH function, RAR 8-26

EXECUTE_ERROR procedure, RAR 7-15, RAR 7-19, RAR 8-27

EXECUTE_ERROR_AS_USER procedure, RAR 7-15

PURGE procedure, RAR 8-29

PUSH procedure, RAR 8-31

REGISTER PROPAGATOR procedure, RAR 2-5, RAR 2-16, RAR 8-34

SCHEDULE_EXECUTION procedure, RAR 8-37, REP 2-13, REP 2-15, REP 2-17, REP 2-18

SCHEDULE_PURGE procedure, RAR 2-6, RAR 2-18, RAR 8-35

SCHEDULE_PUSH procedure, RAR 2-13, RAR 2-14, RAR 2-19, RAR 8-37, REP 2-13, REP 2-15, REP 2-17, REP 2-18

SET_DISABLED procedure, RAR 8-39, REP 2-15, REP 2-17, REP 2-18

UNSCHEDULE_PURGE procedure, RAR 8-41

UNSCHEDULE_PUSH procedure, RAR 8-42, REP 2-16

DBMS_DESCRIBE package, SPR 11 - 1

DBMS_DISTRIBUTED_TRUST_ADMIN package, SPR 12 - 1

DBMS_DISTRIBUTED_TRUST_ADMIN.ALLOW_DATABASE, DDS D-4

DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_ ALL, DDS D-2

DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_DATABASE, DDS D-5

DBMS_HS package, SPR 13 - 1, DDS 6-13

DBMS_HS_PASSTHROUGH

list of functions and procedures, DDS 7-3

DBMS_HS_PASSTHROUGH package, SPR 14 - 1, DDS 7-2

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, DDS C-15

DBMS_IOT package, SPR 15 - 1

DBMS_JOB package, SPR 16 - 1, SCN 8-13

altering a job, SAD 8-11

and instance affinity, SPS 4-9

forcing jobs to execute, SAD 8-14

job queues and, SAD 8-3

Oracle supplied packages, SCN 18-16

REMOVE procedure and, SAD 8-11

submitting jobs, SAD 8-4

DBMS_LOB package, SPR 17 - 1, DCI 6-10

compared with OCI, DCI 6-7

multi-threaded server (MTS), ADL 5-10

NOCOPY syntax and compatibility, MIG 8-33

DBMS_LOCK package, ADG 8 - 21, SPR 18 - 1, SCN 27-39

Oracle supplied packages, SCN 18-16

DBMS_LOCK_ALLOCATED view, SRF 2-159

DBMS_LOGMNR package, SPR 19 - 1

DBMS_LOGMNR_D package, SPR 20 - 1

DBMS_LOGMNR_D.BUILD package, SAD 7-28

DBMS_LOGMNR.ADD_LOGFILE package

LogMiner, SAD 7-29

DBMS_LOGMNR.START_LOGMNR package

LogMiner, SAD 7-30

DBMS_MVIEW package, STU 32-6

DBMS_SNAPSHOT package, SPR 45 - 1

DBMS_MVIEW.REFRESH procedure, STU 32-3

DBMS_MVIEW.REFRESH_ALL_MVIEWS procedure, STU 32-3

DBMS_MVIEW.REFRESH_DEPENDENT procedure, STU 32-3

DBMS_OFFLINE_OG package, SPR 21 - 1

BEGIN_INSTANTIATION procedure, RAR 7-19, RAR 8-44, REP 8-16

BEGIN_LOAD procedure, RAR 7-21, RAR 8-46, REP 8-17

END_INSTANTIATION procedure, RAR 7-22, RAR 8-48, REP 8-17

END_LOAD procedure, RAR 7-21, RAR 8-50, REP 8-17

RESUME_SUBSET_OF_MASTERS procedure, RAR 7-20, RAR 8-52, REP 8-16

DBMS_OFFLINE_SNAPSHOT package, SPR 22 - 1

BEGIN_LOAD procedure, RAR 7-25, RAR 7-26, RAR 8-55

END_LOAD procedure, RAR 7-27, RAR 8-57

DBMS_OLAP package, SPR 23 - 1, STU 29-22, STU 32-15, STU 32-17

DBMS_OLAP.RECOMMEND_MV procedure, STU 29-22

DBMS_ORACLE_TRACE_AGENT package, SPR 24 - 1

DBMS_ORACLE_TRACE_USER package, SPR 25 - 1

DBMS_OUTPUT package, SPR 26 - 1, PLS 8-16, SQL 7-172

DBMS_PCLXUTIL package, SPR 27 - 1, SCN 11-30

DBMS_PIPE package, SPR 28 - 1, PLS 8-17

DBMS_PROFILER package, SPR 29 - 1

DBMS_RANDOM package, SPR 30 - 1

DBMS_RECTIFIER_DIFF package, SPR 31 - 1, REP 2-34, REP 7-19

DIFFERENCES procedure, RAR 8-60

RECTIFY procedure, RAR 8-63

DBMS_REFRESH package, SPR 32 - 1

ADD procedure, RAR 5-6, RAR 5-7, RAR 8-66

CHANGE procedure, RAR 8-67

DESTROY procedure, RAR 8-69

MAKE procedure, RAR 5-4, RAR 8-70

REFRESH procedure, RAR 8-73

SUBTRACT procedure, RAR 8-74

DBMS_REPAIR package, SPR 33 - 1, SAD 19-1

compatibility, MIG 8-14, MIG 8-33

DBMS_REPCAT package, SPR 34 - 1, REP 7-6

ADD_DELETE_RESOLUTION procedure, RAR 8-85

ADD_GROUPED_COLUMN procedure, RAR 8-79

ADD_MASTER_DATABASE procedure, RAR 3-7, RAR 3-8, RAR 7-4, RAR 8-80, REP 2-33

ADD_PRIORITY_CHAR procedure, RAR 8-82, REP 6-25

ADD_PRIORITY_DATE procedure, RAR 8-82, REP 6-25

ADD_PRIORITY_NUMBER procedure, RAR 8-82, REP 6-25

ADD_PRIORITY_RAW procedure, RAR 8-82, REP 6-25

ADD_PRIORITY_VARCHAR2 procedure, RAR 8-82, REP 6-25

ADD_SITE_PRIORITY_SITE procedure, RAR 8-84, REP 6-30

ADD_UNIQUE_RESOLUTION procedure, RAR 8-85

ADD_UPDATE_RESOLUTION procedure, RAR 6-4, RAR 6-6, RAR 6-10, RAR 6-11, RAR 6-14, RAR 6-18, RAR 8-85

ALTER_MASTER_PROPAGATION procedure, RAR 8-89

ALTER_MASTER_REPOBJECT procedure, RAR 6-8, RAR 6-16, RAR 6-19, RAR 6-25, RAR 7-16, RAR 8-91, REP 2-29

ALTER_PRIORITY procedure, RAR 8-93, REP 6-27

ALTER_PRIORITY_CHAR procedure, RAR 8-94, REP 6-26

ALTER_PRIORITY_DATE procedure, RAR 8-94, REP 6-26

ALTER_PRIORITY_NUMBER procedure, RAR 8-94, REP 6-26

ALTER_PRIORITY_RAW procedure, RAR 8-94, REP 6-26

ALTER_PRIORITY_VARCHAR2 procedure, RAR 8-94, REP 6-26

ALTER_SITE_PRIORITY procedure, RAR 8-96, REP 6-30

ALTER_SITE_PRIORITY_SITE procedure, RAR 8-97, REP 6-31

ALTER_SNAPSHOT_PROPAGATION procedure, RAR 8-98

CANCEL_STATISTICS procedure, RAR 8-99, REP 7-18

COMMENT_ON_COLUMN_GROUP procedure, RAR 8-100, REP 7-38

COMMENT_ON_DELETE resolution package, REP 7-38

COMMENT_ON_DELETE_RESOLUTION procedure, RAR 8-105

COMMENT_ON_PRIORITY_GROUP procedure, RAR 8-101, REP 7-38

COMMENT_ON_REPCAT procedure, REP 7-38

COMMENT_ON_REPGROUP procedure, RAR 8-102

COMMENT_ON_REPOBJECT procedure, RAR 8-104, REP 7-38

COMMENT_ON_REPSCHEMA procedure, REP 7-38

COMMENT_ON_REPSITES procedure, RAR 8-103

COMMENT_ON_SITE_PRIORITY procedure, RAR 8-101

COMMENT_ON_UNIQUE resolution package, REP 7-38

COMMENT_ON_UNIQUE_RESOLUTION procedure, RAR 8-105

COMMENT_ON_UPDATE resolution package, REP 7-38

COMMENT_ON_UPDATE_RESOLUTION procedure, RAR 8-105

COMPARE_OLD_VALUES procedure, RAR 8-107

CREATE_MASTER_REPGROUP procedure, RAR 3-5, RAR 8-109, REP 2-20

CREATE_MASTER_REPOBJECT procedure, RAR 3-6, RAR 3-7, RAR 6-9, RAR 8-110

CREATE_SNAPSHOT_REPGROUP procedure, RAR 5-4, RAR 7-6, RAR 7-25, RAR 8-114

CREATE_SNAPSHOT_REPOBJECT procedure, RAR 5-5, RAR 5-6, RAR 7-6, RAR 7-7, RAR 8-116

DEFINE_COLUMN_GROUP procedure, RAR 8-118

DEFINE_PRIORITY_GROUP procedure, RAR 8-119, REP 6-25

DEFINE_SITE_PRIORITY procedure, RAR 8-121, REP 6-30

DO_DEFERRED_REPCAT_ADMIN procedure, RAR 7-19, RAR 8-122, REP 7-6, REP 7-6 to REP 7-7

DROP_COLUMN_GROUP procedure, RAR 8-123

DROP_GROUPED_COLUMN procedure, RAR 8-124

DROP_MASTER_REPGROUP procedure, RAR 8-125, REP 2-21

DROP_MASTER_REPOBJECT procedure, RAR 8-127, REP 2-31

DROP_PRIORITY procedure, RAR 8-128, REP 6-28

DROP_PRIORITY_CHAR procedure, RAR 8-130, REP 6-27

DROP_PRIORITY_DATE procedure, RAR 8-130, REP 6-27

DROP_PRIORITY_GROUP procedure, RAR 8-129, REP 6-28

DROP_PRIORITY_NUMBER procedure, RAR 8-130, REP 6-27

DROP_PRIORITY_RAW procedure, RAR 8-130, REP 6-27

DROP_PRIORITY_VARCHAR2 procedure, RAR 8-130, REP 6-27

DROP_SITE_PRIORITY procedure, RAR 8-132, REP 6-32

DROP_SITE_PRIORITY_SITE procedure, RAR 8-133, REP 6-31

DROP_SNAPSHOT_REPGROUP procedure, RAR 8-134

DROP_SNAPSHOT_REPOBJECT procedure, RAR 8-135

EXECUTE_DDL procedure, RAR 8-138, REP 7-2

GENERATE_REPLICATION_SUPPORT procedure, RAR 3-8, RAR 3-9, RAR 7-17, RAR 8-140, REP 2-37

GENERATE_SNAPSHOT_SUPPORT, RAR 8-142

MAKE_COLUMN_GROUP procedure, RAR 6-4, RAR 6-6, RAR 6-9, RAR 6-11, RAR 6-13, RAR 6-16, RAR 8-144

PURGE_MASTER_LOG procedure, RAR 8-146

PURGE_STATISTICS procedure, RAR 8-147, REP 7-19

REFRESH_SNAPSHOT_REPGROUP procedure, RAR 8-148

REGISTER_STATISTICS procedure, RAR 8-150, REP 7-18

RELOCATE_MASTERDEF procedure, RAR 7-2, RAR 7-3, RAR 8-151, REP 7-3

REMOVE_MASTER_DATABASES procedure, RAR 8-153, REP 2-34

REPCAT_IMPORT_CHECK procedure, RAR 8-154, REP 7-17

RESUME_MASTER_ACTIVITY procedure, RAR 3-9, RAR 8-155, REP 2-24

SEND_OLD_VALUES procedure, RAR 8-156

SET_COLUMNS procedure, RAR 8-108, RAR 8-157, REP 2-25

SUSPEND_MASTER_ACTIVITY procedure, RAR 8-160, REP 2-23

SWITCH_SNAPSHOT_MASTER procedure, RAR 8-161, REP 7-3

VALIDATE procedure, RAR 8-163

WAIT_MASTER_LOG procedure, RAR 8-166

DBMS_REPCAT_ADMIN package, SPR 35 - 1

GRANT_ADMIN_ANY_SCHEMA procedure, RAR 2-4, RAR 2-16, RAR 8-168

GRANT_ADMIN_SCHEMA procedure, RAR 8-169

REGISTER_USER_REPGROUP procedure, RAR 2-5, RAR 2-6, RAR 8-170

REVOKE_ADMIN_ANY_SCHEMA procedure, RAR 8-172

REVOKE_ADMIN_SCHEMA procedure, RAR 8-173

UNREGISTER_USER_REPGROUP procedure, RAR 8-174

DBMS_REPCAT_INSTANTIATE package, SPR 36 - 1

DROP_SITE_INSTANTIATION procedure, RAR 8-177

INSTANTIATE_OFFLINE procedure, RAR 8-178

INSTANTIATE_ONLINE procedure, RAR 8-180

DBMS_REPCAT_RGT package, SPR 37 - 1

ALTER_REFRESH_TEMPLATE procedure, RAR 8-185

ALTER_TEMPLATE_OBJECT procedure, RAR 8-187

ALTER_TEMPLATE_PARM procedure, RAR 4-8, RAR 8-190

ALTER_USER_AUTHORIZATION procedure, RAR 8-192

ALTER_USER_PARM_VALUE procedure, RAR 8-194

COMPARE_TEMPLATES procedure, RAR 8-196

COPY_TEMPLATE procedure, RAR 8-198

CREATE_DEPLOYMENT_TEMPLATE procedure, RAR 4-4

CREATE_OBJECT_FROM_EXISTING procedure, RAR 8-200

CREATE_REFRESH_TEMPLATE procedure, RAR 8-203

CREATE_TEMPLATE_OBJECT procedure, RAR 4-5, RAR 4-6, RAR 4-7, RAR 8-206

CREATE_TEMPlATE_OBJECT procedure, RAR 4-5

CREATE_TEMPLATE_PARM procedure, RAR 8-209

CREATE_USER_AUTHORIZATION procedure, RAR 4-10, RAR 8-212

CREATE_USER_PARM_VALUE procedure, RAR 4-9, RAR 4-10, RAR 8-214

DELETE_RUNTIME_PARMS procedure, RAR 8-217

DROP_ALL_OBJECTS procedure, RAR 8-218

DROP_ALL_TEMPLATE_PARMS procedure, RAR 8-219

DROP_ALL_TEMPLATE_SITES procedure, RAR 8-220

DROP_ALL_TEMPLATES procedure, RAR 8-221

DROP_ALL_USER_AUTHORIZATIONS procedure, RAR 8-222

DROP_ALL_USER_PARM_VALUES procedure, RAR 8-223

DROP_REFRESH_TEMPLATE procedure, RAR 8-225

DROP_SITE_INSTANTIATION procedure, RAR 8-226

DROP_TEMPLATE_OBJECT procedure, RAR 8-227

DROP_TEMPLATE_PARM procedure, RAR 8-229

DROP_USER_AUTHORIZATION procedure, RAR 8-230

DROP_USER_PARM_VALUE procedure, RAR 8-231

GET_RUNTIME_PARM_ID function, RAR 8-232

INSERT_RUNTIME_PARMS procedure, RAR 8-233

INSTANTIATE_OFFLINE procedure, RAR 4-12

INSTANTIATE_ONLINE procedure, RAR 4-13, RAR 8-238

INSTANTIATE_SITE_OFFLINE procedure, RAR 8-235

LOCK_TEMPLATE_EXCLUSIVE procedure, RAR 8-241

LOCK_TEMPLATE_SHARED procedure, RAR 8-242

DBMS_REPUTIL package, SPR 38 - 1

FROM_REMOTE procedure, RAR 8-247

GLOBAL_NAME procedure, RAR 8-248

MAKE_INTERNAL_PKG procedure, RAR 8-249

REPLICATION_IS_ON procedure, RAR 8-246

REPLICATION_OFF procedure, RAR 8-244, REP 8-35

REPLICATION_ON procedure, RAR 8-245, REP 8-36

SYNC_UP_REP procedure, RAR 8-250

DBMS_RESOURCE_MANAGER package, SPR 39 - 1, SAD 11-3

DBMS_RESOURCE_MANAGER_PRIVS package, SPR 40 - 1, SAD 11-10

DBMS_RLS package, SPR 41 - 1

security policies, SCN 30-23

uses definer rights, SCN 30-8

DBMS_ROWID package, SPR 42 - 1, MIG 11-3

and extended rowids, SQL 2-22

DBMS_SESSION package, SPR 43 - 1, SAD 11-11

DBMS_SHARED_POOL package, SPR 44 - 1, STU 10-3, STU 19-12, STU 19-24

DBMS_SNAPSHOT package

BEGIN_TABLE_REORGANIZATION procedure, RAR 8-252, REP 7-25

DBMS_MVIEW package, SPR 45 - 1

END_TABLE_REORGANIZATION procedure, RAR 8-253, REP 7-25

I_AM_A_REFRESH function, RAR 8-254

PURGE_DIRECT_LOAD_LOG procedure, RAR 8-255

PURGE_LOG procedure, RAR 8-256, REP 7-24

PURGE_SNAPSHOT_FROM_LOG procedure, RAR 8-257

REFRESH procedure, RAR 8-259

REFRESH_ALL_MVIEWS procedure, RAR 8-261

REFRESH_DEPENDENT procedure, RAR 8-263

REGISTER_SNAPSHOT procedure, REP 7-37

UNREGISTER_SNAPSHOT, RAR 8-267

UNREGISTER_SNAPSHOT procedure, REP 7-37

DBMS_SPACE package, SPR 46 - 1, SPS 17-16

DBMS_SPACE_ADMIN package, SPR 47 - 1

DBMS_SQL package, SCN 16-19

advantages of, ADG 9 - 17

bulk SQL, ADG 9 - 17

client-side programs, ADG 9 - 17

DESCRIBE, ADG 9 - 17

differences with native dynamic SQL, ADG 9 - 12

locating errors, SPR 48 - 33

multiple row updates and deletes, ADG 9 - 18

Oracle supplied packages, SCN 18-16

parsing DDL statements, SCN 16-19

RETURNING clause, ADG 9 - 18

See Also dynamic SQL

DBMS_STANDARD package, PLS 8-16

DBMS_STATISTICS package, STU 31-3

DBMS_STATS package, SPR 49 - 1, SCN 22-12, STU 7-9, STU 32-16

creating histograms, SCN 22-11

estimated statistics, SCN 22-14

partition statistics, SCN 11-14

DBMS_TRACE package, SPR 50 - 1

DBMS_TRANSACTION package, SPR 51 - 1

DBMS_TTS package, SPR 52 - 1

DBMS_UTILITY package, SPR 53 - 1

DBMS_UTILITY.ANALYZE_SCHEMA()

running, SAD 20-8

DBMSIOTC.SQL script, SRF 5-3

DBMSLOB.SQL script

compatibility, MIG 8-33

DBMSOTRC.SQL script, SRF 5-4

DBMSPOOL.SQL script, SRF 5-4, STU 10-3, STU 19-12

DBMSSTDX.SQL script, SQL 7-267, SQL 7-324, SQL 7-327, SQL 7-333

and triggers, SQL 7-402

DBMSUTIL.SQL script, SPS 17-16

DBMSUTL.SQL, STU 5-2

DBNAME

Migration utility option, MIG 3-14

/dbs directory, PSC A-2

DBSNMP_START command, NET A-5

DBSNMP_STATUS command, NET A-5

DBSNMP_STOP command, NET A-6

DBVERIFY, SUT 9-1

DBVERIFY output, SUT 9-3

DBVERIFY restrictions, SUT 9-2

DBVERIFY utility, SBR 13-5

DBWn background process, SCN 8-8

See also database writer process

DBWR buffers scanned statistic, SRF C-3

DBWR checkpoint buffers written statistic, SRF C-3

DBWR checkpoints statistic, SRF C-3

DBWR forced writes statistic, SRF C-3

DBWR free buffers found statistic, SRF C-3

DBWR lru scans statistic, SRF C-3

DBWR make free requests statistic, SRF C-4

DBWR process, PSC 1-10, SPS 5-5, SPS 7-6

in parallel server, SPS 5-2

DBWR revisited being-written buffer statistic, SRF C-4

DBWR skip hot writes statistic, SRF C-4

DBWR summed scan depth statistic, SRF C-4

DBWR undo block writes statistic, SRF C-4

DBWR_IO_SLAVES parameter, SRF 1-34

DCE address

sample for LISTENER.ORA, OAS 13-4

DCE address, parameters, OAS 13-2

DCE external roles, setting up, OAS 13-6

DCE groups to Oracle roles

syntax for mapping, OAS 13-6

DCE GSSAPI authentication adapter, OAS 8-1

when to use, OAS 8-1

DCE Integration, described, NET 4-32

DCE parameter SERVICE, OAS 13-15

DCE principal, for DCE GSSAPI authentication, OAS 8-2

DCE Secure Core services, OAS 11-5

dce_service_name, verifying, OAS 20

DCE.TNS_ADDRESS_OID parameter, OAS 13-12

DCE.TNS_ADDRESS.OID

parameter in PROTOCOL.ORA, OAS 13-14

DD date format element, SQL 2-41

DDD date format element, SQL 2-41

DDL, PCO 2-17, SCN 1-52, SCN 16-4

changes not propagated to master site, REP 7-30

commands, SPS 16-6

executing within a master group, REP 7-2

for LOBs, DCI 6-2

lock, SPS 7-5

propagating statements to master sites, REP 7-2

See also Data Definition Language

DDL (Data Definition Language), PCO 5-2

DDL events

and triggers, SQL 7-405

DDL in transactions, PC_ 3-17

DDL. See data definition language

DDL statements, SQL 6-1

and implicit commit, SQL 6-2

causing recompilation, SQL 6-2

package state and, ADG 10 - 15

PL/SQL support of, SQL 6-2

requiring exclusive access, SQL 6-2

DDL statements parallelized statistic, SRF C-4

DDO

see Dynamic Discovery Option

dead connection detection

described, NET 2-3

limitations, NET 7-23

SQLNET.EXPIRE_TIME, NET C-20

dead transactions, SCN 32-4

block-level recovery, SCN 32-14

deadlock, PCO 3-19, PLS 5-41

definition of, PC_ 3-16

effect on transactions, PC_ 3-22, PCO 3-24, PLS 5-43

how broken, PC_ 3-22, PCO 3-24, PLS 5-43

deadlock detection, SPS 8-9

deadlocks

artificial, SCN 8-19

avoiding, SCN 27-19

defined, SCN 27-17

detection of, SCN 27-18

distributed transactions and, SCN 27-18

resolving

in synchronous propagation, REP 8-8

DEALLOCATE DESCRIPTOR statement, PC_ 14-14, PC_ F-34, PCO F-23

DEALLOCATE UNUSED clause

of ALTER CLUSTER, SQL 7-3, SQL 7-5

of ALTER INDEX, SQL 7-29

of ALTER TABLE, SQL 7-141

deallocating extents, SCN 4-14

deallocating unused space, SPS 17-16

DEBUG clause

of ALTER FUNCTION, SQL 7-27

of ALTER PACKAGE, SQL 7-60

of ALTER PROCEDURE, SQL 7-63

of ALTER TRIGGER, SQL 7-172

of ALTER TYPE, SQL 7-174

debug command (RMAN), SBR 11-62

DEBUG_EXPTOC package, SPR 54 - 1

DEBUG_EXTPROC package, ADG 11 - 48

debugging

C code in DLLs, DCI 4-15

common errors, DCI 5-9

PL/SQL, DCI 5-8

stored procedures, ADG 10 - 49

triggers, ADG 13 - 29

DEC keyword

behavior in Oracle7 and Oracle8i, MIG 8-22

DEC subtype, PLS 2-13

decimal character, SQL 2-4

default, NLS 2-8

NLS_NUMERIC_CHARACTERS parameter, NLS 2-19

specifying, SQL 2-37

when not a period (.), NLS 2-19

DECIMAL datatype, PCO 4-10, SUT 5-61

(packed), SUT 5-59

ANSI, SQL 2-24

DB2, SQL 2-25

EXTERNAL format

SQL*Loader, SUT 5-67

length and precision, SUT 5-16

SQL/DS, SQL 2-25

DECIMAL subtype, PLS 2-13

Decimal-Point is Comma, PCO A-3

decision support, STU 3-3

processes, STU 27-3

query characteristics, STU 26-20

systems (DSS), STU 1-2

tuning, STU 26-3

with OLTP, STU 3-5

decision support application

basic replication for, REP 1-10, SCN 34-11

decision support systems (DSS), SCN 11-6

bitmap indexes, SCN 10-33

dimensions, STU 30-1

disk striping, SCN 26-48

materialized views, SCN 10-17

parallel DML, SCN 26-37

parallel SQL, SCN 26-2, SCN 26-31, SCN 26-37

partitions, SCN 11-6

performance, SCN 11-9, SCN 26-37

scoring tables, SCN 26-38

declaration

collection, PLS 4-7

constant, PLS 2-30

cursor, PCO 5-12, PLS 5-7

cursor variable, PLS 5-17

exception, PLS 6-7

forward, PLS 7-9

host variable, PCO 2-8

object, PLS 9-22

of cursors, PC_ 6-12

of host arrays, PC_ 8-2

of pointer variables, PC_ 4-46

of SQLCA, PC_ 9-16

record, PLS 4-39

subprogram, PLS 7-9

variable, PLS 2-29

declarative part

function, PLS 7-6

PL/SQL block, PLS 1-3

procedure, PLS 7-4

declarative referential integrity constraints, DDS 4-3

declarative SQL statement, PCO 2-4

using in transactions, PCO 3-20

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-12, PCO 2-20

example, PCO 2-21

form, PC_ 2-11

purpose, PC_ 2-11, PCO 2-20

required when MODE=ANSI, PC_ 10-31

requirements, PC_ 2-11, PCO 2-20

rules for defining, PC_ 2-12, PCO 2-20

using more than one, PCO 2-22

when MODE=ANSI, PC_ 5-15

when required, PC_ 2-11, PC_ 4-12

declare section

COBOL datatypes supported, PCO 4-17

defining usernames and passwords, PCO 3-3

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

declaring

cursor variables, PCO 6-33

host tables, PCO 7-2

host variables, PCO 4-17

indicator variables, PCO 4-26

ORACA, PCO 8-37

SQLCA, PCO 8-21

SQLDA, PCO 11-7

VARCHAR variables, PCO 4-29

DECODE expressions, SQL 5-12

DECODE function

treatment of nulls, PLS 2-50

decomposition of SQL statements, STU 8-3

decryption, definition, OAS Glossary-3

dedicated server processes

configuring, SAD 4-2

connecting with, SAD 4-2

trace files for, SAD 4-10

dedicated servers, SCN 8-22

bequeathed sessions, NET 2-25

defined, SCN 1-18

described, NET 2-23

examples of use, SCN 8-24

multi-threaded servers contrasted with, NET 9-2, SAD 4-3

multi-threaded servers vs., SCN 8-16

prespawned dedicated servers, NET 2-23

routing connections, NET 7-26

with multi-threaded servers, NET 9-10

DEF_SQLCODE precompiler option, PC_ 10-17

default

audit options, SAD 25-11

disabling, SAD 25-13

column values, ADG 5 - 4, ADG 10 - 57

connection, PCO 3-4

error handling, PCO 8-28

maximum savepoints, ADG 8 - 6

parameters in stored functions, ADG 10 - 60

PCTFREE option, ADG 3 - 4

PCTUSED option, ADG 3 - 6

profile, SAD 23-18

role, ADG 12 - 13, SAD 23-16

setting of LITDELIM option, PCO 2-14, PCO 14-27

setting of ORACA option, PCO 8-38

tablespace quota, SAD 23-13

temporary tablespace, SAD 23-13

user tablespaces, SAD 23-12

default cache, STU 19-31

DEFAULT clause

of CREATE TABLE, SQL 7-368

DEFAULT column values

Oracle Version 6 export files, SUT 2-65

default connections, PC_ 3-8

DEFAULT COST clause

of ASSOCIATE STATISTICS, SQL 7-195, SQL 7-196

default database, PC_ 3-7

default domain

in Oracle Names, NET 2-38

null, NET 7-16

Default Domain option, NET 6-39

default file name extensions, PC_ 19-38

OTT, OCI 14-36

default instance, SPS 18-17, SPS 18-20

DEFAULT keyword, PLS 2-30

default name mapping

OTT, OCI 14-36

default parameter value, PLS 7-19

DEFAULT profile

assigning to users, SQL 7-468

DEFAULT ROLE clause

of ALTER USER, SQL 7-181

of CREATE USER, SQL 7-427

DEFAULT SELECTIVITY clause

of ASSOCIATE STATISTICS, SQL 7-195, SQL 7-196

DEFAULT storage clause

of ALTER TABLESPACE, SQL 7-168

of CREATE TABLESPACE, SQL 7-396

DEFAULT TABLESPACE clause

of ALTER USER. See CREATE USER.

of CREATE USER, SQL 7-427

default values, SCN 10-8

constraints effect on, SCN 10-8, SCN 28-20

user-defined types, SCN 14-4

DEFAULT_CONSUMER_GROUP, SAD 11-9

DEFAULTIF keyword

SQL*Loader, SUT 5-44, SUT 5-81

defaults, encryption and checksumming, OAS A-3

DEFCALL view, RAR 9-27, SRF 2-160

DEFCALLDEST view, SRF 2-160

DefDefaultDest table

adding destinations to, SPR 10 - 3, RAR 8-20, REP 9-6

removing destinations from, SPR 10 - 3, SPR 10 - 4, RAR 8-21, RAR 8-22, REP 9-6

DEFDEFAULTDEST view, RAR 9-28, SRF 2-160

DEFERRABLE clause

of constraint_clause, SQL 7-226

deferrable constraints, SQL 7-568

DEFERRCOUNT view, RAR 9-28, SRF 2-160

deferred (CURRENT) block cleanout applications statistic, SRF C-8

DEFERRED clause

of SET CONSTRAINTS, SQL 7-568

deferred constraints

deferrable or nondeferrable, SCN 28-21

initially deferred or immediate, SCN 28-21

deferred constraints and updatable snapshots, REP A-4

deferred destination state, SAD 7-14

deferred rollback segment, SPS A-19

deferred RPCs, REP 9-2

deferred transaction queue, RAR 7-8

deferred transactions, REP 2-4

creating, REP 9-2

DefCall table, REP 9-5

DefCallDest table, REP 9-5

DEFCALLDEST view, RAR 9-28

DefDefaultDest table

adding destination to, SPR 10 - 3, RAR 8-20, REP 9-6

removing destinations from, SPR 10 - 3, SPR 10 - 4, RAR 8-21, RAR 8-22, REP 9-6

DEFDEFAULTDEST view, RAR 9-28

deferred remote procedure calls (RPCs)

argument types, SPR 9 - 3, RAR 8-13

argument values, SPR 9 - 6, RAR 8-16

arguments to, SPR 8 - 4, RAR 8-9, REP 9-5

building, SPR 8 - 2, RAR 8-6, REP 9-5

executing immediately, SPR 10 - 11, RAR 8-31

DEFERROR view, RAR 9-29

DefTran table, REP 9-4

DEFTRAN view, RAR 9-31

DEFTRANDEST view, RAR 9-31

deleting, REP 7-11

diagnosing problems with, REP 7-33

displaying, REP 7-9

executing, REP 7-10

managing, REP 7-9

purging, REP 2-16

queue

clearing after deleting master sites, REP 2-34

purging, REP 2-5, REP 2-18

push, REP 2-4

re-executing, SPR 10 - 7, RAR 8-27

removing from queue, SPR 10 - 5, RAR 8-24

scheduling execution, SPR 10 - 15, RAR 8-37

starting, SPR 8 - 5, RAR 8-10, REP 9-4

views for, RAR 9-27 to RAR 9-31

Deferred Transactions by Dest folder, REP 7-9, REP 7-11

DefError table

deleting transactions from, SPR 10 - 4, RAR 8-23

DEFERROR view, RAR 9-29, SRF 2-160

define

arrays, OCI 12-6

return and error codes, OCI 2-28

define functions, OCI 15-42

define handle

attributes, OCI A-22

description, OCI 2-10

define operation, OCI 4-14, OCI 5-13, OCI 12-4

example, OCI 5-14

LOBs, OCI 5-17

named datatypes, OCI 5-16, OCI 12-4

piecewise fetch, OCI 5-17

PL/SQL output variables, OCI 5-17

REFs, OCI 5-16, OCI 12-4

static arrays, OCI 5-17

steps used, OCI 5-14

define phase of query processing, SCN 16-12

DEFINE precompiler option, PC_ 10-18, PCO 14-19

used in application migration, PC_ 5-35

DefinedNodes registry value, PSC 4-6

definer rights, PLS 7-29, SCN 18-9

name resolution, SCN 18-19

procedure security, SCN 30-7

versus invoker rights, PLS 7-29

defining

OCINumber, OCI 12-8

defining autonomous transactions, ADG 8 - 41

defining symbols, PC_ 2-16

defining users, in multi-cell environment, OAS 13-5

definition sites

relocating for a master group, REP 7-3

definitions. See terminology

DEFLOB, RAR 9-29

DEFLOB view, SRF 2-160

DEFPROPAGATOR view, SRF 2-160

DEFSCHEDULE, RAR 9-30

DEFSCHEDULE view, SRF 2-160

DEFTRAN, RAR 9-31

DEFTRAN view, SRF 2-161

DEFTRANDEST view, RAR 9-31, SRF 2-161

DEGREE keyword

in PARALLEL clause, MIG 8-35

degree of parallelism, SCN 26-20, SCN 26-23

and adaptive multi-user, STU 26-7

between query operations, SCN 26-13

parallel SQL, SCN 26-7, SCN 26-16

setting, STU 26-7

deinstalling, MIG 1-6

delay seconds

setup wizard, REP 2-17

Delay Seconds setting

Create New Scheduled Link property sheet, REP 2-13

DELAYED_LOGGING_BLOCK_CLEANOUTS parameter, SPS 18-10, SPS A-9, SPS A-14, SRF 1-35

DELAYED_LOGGING_BLOCK_
CLEANOUTS parameter, PSC 6-10

delegate, NET 6-50

DELEGATE_DOMAIN command, NET 6-50, NET A-34

delegated administrative regions

below root, NET 2-42

diagram, NET 2-41

in Oracle Names, NET 2-40

delegated administration regions

domains to, NET 6-50

DELETE

object privilege, SQL 7-508

statement, SQL 7-438

DELETE ANY TABLE privilege

SQL*Loader, SUT 5-33

DELETE ANY TABLE system privilege, SQL 7-500

DELETE CASCADE, PC_ 9-21

SQL*Loader, SUT 5-33

delete cascade constraint, SCN 28-17

DELETE collection method, PLS 4-26

DELETE command, SCN 16-4

column values and triggers, ADG 13 - 16

data consistency, ADG 8 - 11

foreign key references and, SCN 28-16

freeing space in data blocks, SCN 4-9

no-logging mode, SCN 25-7

LOBs, SCN 25-7

parallel DELETE, SCN 26-21

triggers and, SCN 20-2, SCN 20-6

triggers for referential integrity, ADG 13 - 43, ADG 13 - 44

delete conflicts, REP 6-3

avoiding, REP 6-5, REP 8-28

resolution, REP 6-8

configuring, REP 6-37

methods, assigning, REP 6-37

resolution methods

removing, REP 6-37

resolving, REP 6-50

delete expired backupset command (RMAN), SBR 11-63

delete no action constraint, SCN 28-16

DELETE privilege

SQL*Loader, SUT 5-33

DELETE privilege for object tables, SCN 14-15, SCN 14-16

delete script command (RMAN), SBR 11-65, SBR 11-66

DELETE SQL statement, PC_ F-43

DELETE statement, PCO F-31

embedded SQL examples, PC_ F-46, PCO F-34

example, PCO 5-11

example of, PC_ 6-10

purpose of, PC_ 6-10

restrictions with tables, PCO 7-15

RETURNING clause, PLS 5-63

syntax, PLS 11-49

triggers on, SQL 7-404

using host arrays in, PC_ 8-13

using host tables, PCO 7-15

WHERE clause, PCO 5-11

WHERE clause in, PC_ 6-10

DELETE STATISTICS clause

of ANALYZE, SQL 7-190

DELETE_CATALOG_ROLE role, SQL 7-503

deletes

positioned, OCI 2-34

deleting

master groups, REP 2-21

scheduled links, REP 2-16

snapshots, REP 5-28

table statistics, SAD 20-4

deleting internal LOBs, ADL 2-14

deleting LOBs, ADL 2-14

delimited data

maximum length for SQL*Loader, SUT 5-73

delimited fields

field length, SUT 5-74

delimited files

exporting, SUT 1-4

delimited LOBs, SUT 5-104

delimiter, PLS 2-3

delimiter_spec, SUT 5-16

delimiters

C versus SQL, PC_ 2-12

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

SQL*Loader, SUT 5-41

specifying for SQL*Loader, SUT 5-70

SQL*Loader enclosure, SUT 5-83

SQL*Loader field specifications, SUT 5-83

termination, SUT 5-84

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

demonstration programs, OCI B-1

list, OCI B-1

denormalized tables, SCN 1-29, SCN 10-19

denormalized views

star schemas, SCN 24-15

dense collection, PLS 4-3

departmentalized applications, SPS 2-8

dependencies, SCN 21-1

among PL/SQL library objects, ADG 10 - 28

between schema objects, SCN 21-2

dimensions, STU 29-21

displaying, SAD 20-32

function-based indexes, SCN 10-26, SCN 21-7

in stored triggers, ADG 13 - 27

local, SCN 21-10

managing, SCN 21-1

materialized views, STU 29-21

non-existent referenced objects and, SCN 21-8

object type definitions, SCN 14-16, SCN 14-17

on non-existence of other objects, SCN 21-8

Oracle Forms triggers and, SCN 21-13

privileges and, SCN 21-6

remote objects and, SCN 21-10

schema objects

trigger management, ADG 13 - 20

shared pool and, SCN 21-10

the timestamp model, ADG 10 - 29

dependency

ordering

replicated transactions, REP 2-43

tracking

parallel propagation, REP 2-43

DEPENDING ON clause, PCO 7-3

deployment template

add object, RAR 4-5

alter object, RAR 8-187

alter parameter, RAR 8-190

alter template, RAR 8-185

alter user authorization, RAR 8-192

alter user parameter value, RAR 8-194

authorize users, RAR 4-10

compare templates, RAR 8-196

concepts, RAR 4-2

copy template, RAR 8-198

create, RAR 4-4

create object, RAR 8-206

create object from existing, RAR 8-200

create parameter, RAR 4-7, RAR 8-209

create runtime parameters, RAR 8-233

create template, RAR 8-203

create user authorization, RAR 8-212

create user parameter value, RAR 4-9, RAR 8-214

data dictionary views for, RAR 9-6 to RAR 9-14

delete runtime parameters, RAR 8-217

drop all objects, RAR 8-218

drop all template parameters, RAR 8-219

drop all template sites, RAR 8-220

drop all templates, RAR 8-221

drop all user authorizations, RAR 8-222

drop all user parameter values, RAR 8-223

drop parameter, RAR 8-229

drop site instantiation, RAR 8-177, RAR 8-226

drop template, RAR 8-225

drop template object, RAR 8-227

drop user authorization, RAR 8-230

drop user parameter value, RAR 8-231

get runtime parameter ID, RAR 8-232

insert runtime parameters, RAR 8-233

instantiation, RAR 4-11, RAR 4-12

lock template, RAR 8-241, RAR 8-242

offline instantiation, RAR 4-11, RAR 8-178, RAR 8-235

online instantiation, RAR 4-12, RAR 8-180, RAR 8-238

deployment templates, REP 4-1

add existing object, REP 4-26

add new object, REP 4-30

architecture, REP 4-10

concepts, REP 4-3

creating, REP 4-24

data sets, REP 4-21

deployment sites, REP 4-8

design, REP 4-17

elements, REP 4-3

general template information, REP 4-4

horizontal partitioning, REP 4-17

instantiation, REP 4-9, REP 4-13, REP 4-50

modify, REP 4-34

object definitions, REP 4-5

offline instantiation, REP 4-10, REP 4-12, REP 4-15, REP 4-45

online instantiation, REP 4-9, REP 4-12, REP 4-14, REP 4-45

package, REP 4-45

package template, REP 4-8, REP 4-12

refresh groups, REP 4-16

snapshot groups, REP 4-16

template parameters, REP 4-6

user authorization, REP 4-7

vertical partitioning, REP 4-20

DEPT table, PC_ 2-18, PCO 2-29

DEPTH column

TKPROF_TABLE, STU 14-19

DEPTREE view, SRF 2-161

dequeue of messages after preview, ADQ 8-25

DEREF function, SQL 4-13

DEREF operator, PLS 9-33

dereference, PLS 9-33

dereferencing, ADG 16 - 24, SCN 13-10

implicit, ADG 16 - 24, SCN 13-10

derived parameters, SRF 1-10

DES, OAS 1-4, OAS Glossary-3, NET 4-31

DESC clause

of CREATE INDEX, SQL 7-281

DESC function, ADG 6 - 8

DESC_TAB datatype, SPR 48 - 31

descending indexes, SQL 7-281

describe

explicit, OCI 4-13

explicit and implicit, OCI 6-5

implicit, OCI 4-11

of collections, OCI 6-2

of databases, OCI 6-2

of packages, OCI 6-2

of schemas, OCI 6-2

of sequences, OCI 6-2

of stored functions, OCI 6-2

of stored procedures, OCI 6-2

of synonyms, OCI 6-2

of tables, OCI 6-2

of types, OCI 6-2

of views, OCI 6-2

select-list, OCI 4-10

DESCRIBE BIND VARIABLES statement

in dynamic SQL Method 4, PCO 11-29

use in dynamic SQL method 4, PC_ 15-25

DESCRIBE command

use with PREPARE command, PC_ F-47

DESCRIBE DESCRIPTOR statement, PC_ F-49, PCO F-36

describe functions, OCI 15-42

describe handle

attributes, OCI A-24

description, OCI 2-11

DESCRIBE INPUT statement, PC_ 14-22

describe operation

server roundtrips, OCI C-5

DESCRIBE OUTPUT statement, PC_ 14-22

describe phase of query processing, SCN 16-12

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-12, NET C-38, NET C-51

DESCRIPTION_LIST feature, SPS A-13

DESCRIPTION_LIST parameter, NET C-38, NET C-52

descriptions of collection attributes, PC_ 18-15

descriptor, OCI 2-14

allocating, OCI 2-22

complex object retrieval, OCI 2-16

naming, PCO F-35

objects, OCI 11-23

parameter, OCI 2-16

ROWID, OCI 2-16

snapshot, OCI 2-15

descriptor functions, OCI 15-27

descriptor objects, OCI 11-23

descriptors, PC_ 15-4

bind descriptor, PC_ 13-26, PCO 11-4

definition of, PC_ 13-25

need for, PC_ 15-4

purpose, PCO 11-4

select descriptor, PC_ 13-26, PCO 11-4

SQLADR subroutine, PCO 11-3

using the sqlald() function to allocate, PC_ 15-5

using the sqlclu() function to deallocate, PC_ 15-37

design dictionary, STU 12-4

designing and tuning, STU 2-10

destination

archiving redo log files, SRF 1-60

overriding default, SRF 1-60

USER_DUMP_DEST, SRF 1-126

destination maps

displaying for master groups, REP 2-39

destination master sites

adding to master groups, REP 2-19, REP 2-32

destination states for archived redo logs, SAD 7-13, SBR 16-11

destinations

archived redo logs

sample scenarios, SAD 7-18

Destinations page

Create New Master Group property sheet, REP 2-19

DESTROY

Import parameter, SUT 2-21

destroyed server, LEG 5-3

detaching branches, OCI 8-7

detail report in Oracle Trace, STU 15-6

detail tables, STU 28-6

same as fact tables, STU 28-6

details property sheet in Oracle Trace, STU 15-14

detecting conflicts, REP 6-5, REP 6-6

determining current value of precompiler options, PC_ 10-4

DETERMINISTIC clause

of CREATE FUNCTION, SQL 7-270

DETERMINISTIC functions, SCN 23-9

function-based indexes, SCN 21-8

deterministic functions, SCN 23-9

DETERMINISTIC keyword, ADG 10 - 63

Developer/2000 Applications

upgrading, MIG 9-6

developers, application, SAD 22-9

device bandwidth, STU 17-4

evaluating, STU 20-16

device latency, STU 17-5

device resources, LEG 3-2

df command, LEG 5-7

DFS db file lock wait event, SRF A-15

DFS lock handle wait event, SRF A-16

DHCP, LEG B-10

diagnosing

client, NET 11-4

errors, see troubleshooting

server, NET 11-3

diagnosing problems with, REP 7-29

diagnosing tuning problems, STU 17-1

DICT synonym for DICTIONARY, SRF 2-161

DICT_COLUMNS view, SRF 2-162

dictionary

See data dictionary

dictionary cache, SPS 4-12, SPS 5-5, SPS 6-6

lock, SPS 10-5

dictionary cache lock, SPS 10-5

dictionary cache locks, SCN 27-30

dictionary files

LogMiner and the, SAD 7-27

DICTIONARY view, SRF 2-161

DICT synonym, SRF 2-161

dictionary-managed tablespaces, SCN 3-7

dictionary-mapped tablespaces, STU 20-28

DIFFERENCES

procedure, REP 7-19

differences

between tables, SPR 31 - 2, RAR 8-60

rectifying, SPR 31 - 5, RAR 8-63

differential incremental backups, SBR 4-40

different-row writers block writers, SCN 27-10

digital signature, OAS Glossary-3

Digital's POLYCENTER Manager on Net View, SCN 33-20

DigitalsPOLYCENTERManageronNetView', DDS 1-20

digits of precision, PLS 2-12

dimension of host tables, PCO 7-3

dimension tables, STU 11-8, STU 28-6

(lookup tables), STU 28-5

normalized, STU 30-7

dimensions, SCN 1-29, SCN 10-18, STU 30-1, STU 30-10, STU 31-22

altering, STU 30-11

attributes, SCN 1-29, SCN 10-19

adding, SQL 7-26

changing, SQL 7-25

defining, SQL 7-262

dropping, SQL 7-26

changing hierarchical relationships, SQL 7-25

compiling invalidated, SQL 7-26

creating, SQL 7-260, STU 30-3

creating on unspecified tables, SQL 7-260

dependencies, STU 29-21

dimension tables (lookup tables), STU 28-5

downgrading, MIG 12-14

dropping, STU 30-12

examples, SQL 7-262

granting

system privileges on, SQL 7-496

hierarchies, SCN 1-29, SCN 10-18

adding, SQL 7-26

defining, SQL 7-261

dropping, SQL 7-26

join key, SCN 1-29, SCN 10-19

rolling up and drilling down, STU 30-2

in a decision support system, STU 30-1

levels

adding, SQL 7-26

defining, SQL 7-260

dropping, SQL 7-26

normalized or denormalized tables, SCN 1-29, SCN 10-19

removing from the database, SQL 7-450

star joins, SCN 24-14

star queries, SCN 24-14

using, STU 30-1

validating, STU 30-10

DIRECT

Export parameter, SUT 1-18, SUT 1-43

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

direct loader index creation enqueue, SRF B-2

direct path export, SUT 1-41

BUFFER parameter, SUT 1-43

character set and, SUT 1-53

invoking, SUT 1-43

RECORDLENGTH parameter, SUT 1-43

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

conditions for use, SUT 8-8

data saves, SUT 8-12, SUT 8-18

DIRECT command line parameter

SQL*Loader, SUT 8-10

DIRECT command-line parameter, SUT 6-5

DISABLED_CONSTRAINTS keyword, SUT 8-22

disabling media protection

SQL*Loader, SUT 8-19

dropping indexes, SUT 8-20

dropping indexes to continue an interrupted load, SUT 5-34

example, SUT 4-25

EXCEPTIONS keyword, SUT 8-22

field defaults, SUT 8-9

improper sorting

SQL*Loader, SUT 8-17

indexes, SUT 8-10

instance recovery, SUT 8-13

loading into synonyms, SUT 8-9

LONG data, SUT 8-14

media recovery, SUT 8-14

partitioned load

SQL*Loader, SUT 8-26

performance, SUT 8-16

performance issues, SUT 8-10

preallocating storage, SUT 8-16

presorting data, SUT 8-16

recovery, SUT 8-13

REENABLE keyword, SUT 8-22

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

table insert triggers, SUT 8-22

temporary segment storage requirements, SUT 8-11

triggers, SUT 8-21

using, SUT 8-7, SUT 8-10

version requirements, SUT 8-9

direct path load API, GTK 2-24

direct path loading, OCI 9-37

column array handle attributes, OCI A-42

column parameter attributes, OCI A-44

context handle attributes, OCI A-39

datatypes of columns, OCI 9-39, OCI A-47

direct path column array handle, OCI 9-40

direct path context handle, OCI 9-39

direct path stream handle, OCI 9-40

example, OCI 9-42

functions, OCI 9-41

handle attributes, OCI A-39

handles, OCI 9-39

limitations, OCI 9-38

stream handle attributes, OCI A-43

direct path loading functions, OCI 15-72

direct path operations

standby databases, SBR 16-27

direct path read wait event, SRF A-27

direct path write wait event, SRF A-28

directives, PC_ 2-3

also known as declarative statements, PCO 2-4

direct-load INSERT, SCN 25-2

logging mode, SCN 25-5

parallel INSERT, SCN 25-3

parallel load vs. parallel INSERT, SCN 25-2

restrictions, SCN 25-11, SCN 26-43

serial INSERT, SCN 25-3

space management, SCN 25-8

direct-load insert, STU 26-76

external fragmentation, STU 27-13

directories

catalog views, ADL 5-9

granting

system privileges on, SQL 7-496

guidelines for usage, ADL 5-9

installation, DCI 2-6

ownership and privileges, ADL 5-7

directories. See directory objects.

directory aliases

exporting, SUT 1-56

importing, SUT 2-60

DIRECTORY name specification, ADL 5-7

directory objects, ADL 5-5

as aliases for OS directories, SQL 7-264

auditing, SQL 7-206

creating, SQL 7-264

redefining, SQL 7-265

removing from the database, SQL 7-451

directory path

INCLUDE files, PCO 2-23

directory structure, PSC A-1 to PSC A-3

UNIX, PSC A-2

Windows NT, PSC A-3

Directory-enabled Oracle Security Manager, SCN 29-5

dirty buffer, SCN 7-3

Fast-Start Checkpointing, SCN 32-13

incremental checkpoint, SCN 8-8

dirty buffers inspected statistic, SRF C-8

dirty read, SCN 27-2, SCN 27-10

dirty write, SCN 27-10

DISABLE ALL TRIGGERS clause

of ALTER TABLE, SQL 7-154

DISABLE clause

of ALTER INDEX, SQL 7-39

of ALTER TRIGGER, SQL 7-172

of constraint_clause, SQL 7-227

of CREATE TABLE, SQL 7-381

DISABLE constraints, SCN 28-22

DISABLE DISTRIBUTED RECOVERY clause

of ALTER SYSTEM, SQL 7-99

DISABLE NOVALIDATE constraint state, SQL 7-382

Disable Out-of-Band Break option, NET 7-24

DISABLE PARALLEL DML clause

of ALTER SESSION, SQL 7-79

DISABLE QUERY REWRITE clause

of ALTER MATERIALIZED VIEW, SQL 7-50

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-307

DISABLE RESTRICTED SESSION clause

of ALTER SYSTEM, SQL 7-99

DISABLE ROW MOVEMENT clause

of ALTER TABLE, SQL 7-153

of CREATE TABLE, SQL 7-360, SQL 7-380

DISABLE STORAGE IN ROW clause

of ALTER TABLE, SQL 7-132

of CREATE TABLE, SQL 7-374

DISABLE TABLE LOCK clause

of ALTER TABLE, SQL 7-154

DISABLE TABLE LOCK option, SPS 16-7

DISABLE THREAD clause, SPS 14-9

of ALTER DATABASE, SQL 7-15

DISABLE VALIDATE constraint state, SQL 7-382

DISABLE VALIDATE constraints

compatibility, MIG 8-14

downgrading, MIG 12-34

DISABLE_OOB parameter, NET 7-24

disabled constraint, STU 6-10

disabled destination state

for archived redo logs, SAD 7-13

DISABLED indexes, SCN 21-8

DISABLED procedure

DBMS_DEFER_SYS package, REP 2-15

DISABLED_CONSTRAINTS keyword

SQL*Loader, SUT 8-22

disabling

archiving, SAD 7-7, SAD 7-9

audit options, SAD 25-11, SAD 25-12

auditing, SAD 25-13

integrity constraints, ADG 5 - 22, SAD 20-18

effects on indexes, SAD 16-7

propagation, SPR 10 - 17, RAR 8-39

recoverer process, DDS 3-34

resource limits, SAD 23-21

triggers, ADG 13 - 30, SAD 20-12

disabling replication, REP 8-34

disabling the archive history, SPS 14-4

disabling UNIX signal handler, NET 9-15

DISASSOCIATE STATISTICS statement, SQL 7-444

disaster recovery, SCN 32-26, SPS 22-10, SPS 22-13

procedures overview, LEG 5-8

recovering Oracle data

overview, LEG 5-26

types, LEG 5-1, LEG 5-2, LEG 5-3

using a standby database for, SBR 16-1 to SBR 16-29

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

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

discard

conflict resolution method, RAR 6-3, REP 6-21

use of, REP 6-39

discard file

basics, SUT 3-14

DISCARDDN keyword

different placement from DB2, SUT B-3

DISCARDS control file clause

different placement from 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

SQL*Loader DISCARDS keyword, SUT 5-29

SQL*Loader DISCRDMAX keyword, SUT 5-30

discard uniqueness

conflict resolution method, REP 6-37

discarded records

causes, SUT 5-29

limiting, SUT 5-29

SQL*Loader, SUT 3-12

discarded SQL*Loader records

discard file, SUT 5-27

DISCARDMAX

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

DISCARDMAX keyword

SQL*Loader discarded records, SUT 5-30

DISCONNECT command, SPS 18-21

DISCONNECT SESSION clause

of ALTER SYSTEM, SQL 7-99

disconnected environments

as in advanced replication, REP 1-11, SCN 34-12

disconnecting

abnormal termination, NET 2-3

additional connect request, NET 2-3

from Recovery Manager, SBR 5-12

from servers, NET 2-3

user initiated, NET 2-3

disconnecting from an instance, SPS 18-20, SPS 18-21

multiple sessions, SPS 18-27

user process, SPS 18-26

disconnections

auditing, SAD 25-8

discontinued loads

continuing with SQL*Loader, SUT 5-34

Discoverer, STU 28-9

discovering nodes, PSC 5-18

discovering Oracle Names servers, NET 2-45, NET 6-36

discovery

See auto-discovery

discrete transaction management

summary, SCN 17-8

discrete transactions

example, STU 9-4

processing, STU 9-2, STU 9-3

when to use, STU 9-1

DISCRETE_TRANSACTIONS_ENABLED parameter, SRF 1-36

discretionary access control, SCN 1-39, SCN 29-2

disjoint data

applications with, SPS 1-17, SPS 2-7

data files, SPS 6-2

disk

access, SPS 3-2, SPS 3-3

affinity, SPS 4-8, SPS 18-23

contention, SPS 6-2, SPS 6-9

I/O statistics, SPS 19-3, SPS 19-6

media failure, SPS 22-1

reading blocks, SPS 4-5

rollback segments, SPS 6-9

saving information, LEG 5-6

writing blocks, SPS 4-5, SPS 9-8

disk affinity

and parallel query, STU 27-16

disabling with MPP, STU 26-39

parallel DML, SCN 26-49

partitions, SCN 26-48

with MPP, STU 26-71

disk column, SQL trace, STU 14-13

disk drives

archiving destination, SRF 1-60

writing blocks, SRF 1-46

disk failures, SBR 1-13, SCN 1-46, SCN 32-5

Disk Reads data view, STU 15-9

Disk Reads/Execution Ratio data view, STU 15-9

Disk Reads/Logical Reads Ratio data view, STU 15-9

Disk Reads/Rows Fetched Ratio data view, STU 15-9

disk space

controlling allocation for tables, SCN 10-4

datafiles used to allocate, SCN 3-16

disk striping

affinity, SCN 26-48

partitions, SCN 11-9

DISK_ASYNCH_IO parameter, SRF 1-36, STU 26-29

DISKRATIO

to distribute backup I/O, STU 20-52

disks

contention, STU 20-20, STU 20-21

distributing I/O, STU 20-20

I/O requirements, STU 20-4

layout options, STU 20-15

monitoring OS file activity, STU 20-17

number required, STU 20-4

placement of datafiles, STU 20-21

placement of redo log files, STU 20-21

reducing contention, STU 20-20

speed characteristics, STU 20-3

testing performance, STU 20-5

dispatcher processes

creating additional, SQL 7-105

maximum number, SRF 1-75

number to start, SAD 4-5

privileges to change number of, SAD 4-7

removing, SAD 4-7

setting the number of, SAD 4-7

spawning new, SAD 4-7

terminating, SQL 7-105

dispatcher processes (Dnnn), STU 21-9

dispatcher processes (Dnnn)

defined, SCN 1-20

described, SCN 8-14

limiting SGA space per session, SCN 29-18

listener process and, SCN 8-14

network protocols and, SCN 8-14

prevent startup and shutdown, SCN 8-20

response queue and, SCN 8-17

user processes connect via Net8, SCN 8-14, SCN 8-16

dispatcher shutdown wait event, SRF A-28

dispatcher timer wait event, SRF A-28

dispatchers

described, NET 2-20

number to start, NET 9-8

setting the number of, NET 9-8

DISPATCHERS (DIS or DISP) attribute, NET 7-49, NET 7-63, NET 9-5

dispatcher-to-connection

recommended ratio, STU 23-3

dispatchers

connections for IIOP clients, NET 7-53, NET 7-63

DISPLAY datatype, PCO 4-11

DISTINCT clause

of SELECT, SQL 7-545

DISTINCT operator

optimizing views, SCN 23-17

DISTINCT option, PLS 5-3

distinct queries, SQL 7-545

DISTINCT row operator, PLS 5-6

distinguished name, SRF 1-104

distributed applications

distributing data, DDS 4-2

Distributed Computing Environment

overview, OAS 11-2

Distributed Computing Environment (DCE) Integration

described, NET 7-29

distributed database systems

distributing an application's data, DDS 4-2

location transparency, DDS 2-20

location transparency using synonyms, DDS 2-22

referential integrity

application development, DDS 4-3

transparency

queries, DDS 2-25

updates, DDS 2-25

distributed databases, NET 2-5, SCN 33-1, STU 3-7

auditing and, SCN 31-6

backups, SBR 3-22

change-based recovery, SBR 15-16

client/server architectures and, SCN 6-2

commit point strength, DDS 3-9

coordinated time-based recovery, SBR 15-16

database links, DDS 1-6, SCN 33-6

deadlocks and, SCN 27-18

dependent schema objects and, SCN 21-10

diagrammed, DDS 1-2, SCN 33-2

different Oracle versions, SCN 33-7

distributed queries, DDS 1-11, SCN 33-11

distributed updates, DDS 1-11, SCN 33-11

global object names, DDS 1-6, SCN 33-6

heterogeneous, SCN 33-8

job queue processes (SNPn), SCN 1-20, SCN 8-13

management tools, DDS 1-19, SCN 33-19

media recovery and snapshots, SBR 15-17

message propagation, SCN 19-9

nodes of, DDS 1-2, SCN 33-2

overview of, DDS 1-2, SCN 1-34, SCN 33-2

recoverer process (RECO) and, SCN 8-12

recovery, SBR 15-15

referential integrity and, ADG 5 - 14

remote dependencies, SCN 21-11

remote queries and updates, DDS 1-11, SCN 33-11

remote stored procedures, ADG 10 - 54, ADG 10 - 55

running in ARCHIVELOG mode, SAD 7-6

running in NOARCHIVELOG mode, SAD 7-6

server can also be client in, SCN 6-2

site autonomy of, DDS 1-16, SCN 33-16

starting a remote instance, SAD 3-6

statement optimization on, SCN 23-30

table replication, SCN 1-36

taking backups, SBR 3-22

testing features, DDS 3-33

transparency of, DDS 1-14, SCN 33-14

triggers and, ADG 13 - 20

two-phase commit, SCN 1-35, SCN 33-13

distributed external procedure

process architecture, DDS 5-6

Distributed external procedures

installation, DDS 6-5

distributed external procedures, DDS 5-4

distributed lock

exclusive, SRF 1-46

memory area, SPS 5-5

rollback segment, SPS 6-9, SRF 1-46

row cache, SPS 6-6

sequence, SPS 6-6

total number, SPS 6-6

Distributed Lock Manager, SPS A-8

distributed lock manager (DLM), GTK 2-62

Distributed Lock Manager, described, PSC 1-10

distributed processing, NET 2-5, PCO 3-14

parameter file location in, SAD 3-15

support for, PC_ 3-7

using Net8 for, PC_ 3-7

distributed processing environment

client/server architecture in, SCN 1-33, SCN 6-2

data manipulation statements, SCN 16-10

described, SCN 1-33, SCN 6-2

distributed databases vs., SCN 33-7

materialized views (snapshots), SCN 10-17

distributed queries, DDS 4-3, SQL 5-25

analyze tables, DDS 4-6

application development issues, DDS 4-3

collocated inline views, DDS 4-4

cost based optimization, DDS 4-5

disabling, SRF 1-85

enabling, SRF 1-85

handling errors, ADG 10 - 47

links for, SRF 1-85

tuning, DDS 4-4

distributed query, STU 8-1, STU 8-10

distributed query optimization, DDS 1-10, SCN 33-10

distributed recovery enqueue, SRF B-2

distributed systems, GTK 2-64 to GTK 2-68

remote object security, DDS 2-22

distributed transaction, PLS 5-41

distributed transactions, PC_ F-102

clients role, DDS 3-6

commit point site, DDS 3-8

commit point strength, DDS 3-9

database server role, DDS 3-6

defined, DDS 1-12, SCN 33-12

distributed statements, SCN 23-4

failure during, DDS 3-19, DDS 3-20

forcing to fail, DDS 3-33

global coordinator, DDS 3-7

hold time, DDS 3-32

limiting number, DDS 3-18

limiting number of, DDS 3-32, SRF 1-37

local coordinator, DDS 3-7

locked resources, DDS 3-20

management, DDS 3-1

manually overriding in-doubt, DDS 3-21

optimizing, SCN 23-30

parallel DDL restrictions, SCN 26-28

parallel DML restrictions, SCN 26-28, SCN 26-46

problems with, REP 7-33

read-only, DDS 3-17

recovery in single-process systems, DDS 3-35

restrictions, DDS 2-26

routing statements to nodes, SCN 16-11

sample table scan not supported, SCN 23-34

session tree, DDS 3-5

setting advice, DDS 3-22

troubleshooting, DDS 3-19

two-phase commit

example, DDS 3-11

two-phase commit and, SCN 1-35, SCN 17-7

when committed, DDS 3-8

distributed TX enqueue, SRF B-2

DISTRIBUTED_LOCK_TIMEOUT parameter, SRF 1-36

controlling time-outs with, DDS 3-20

DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME parameter, SRF 1-36

setting, DDS 3-32

DISTRIBUTED_TRANSACTIONS parameter, SCN 8-12, SRF 1-37

recoverer process (RECO), DDS 3-18

setting, DDS 3-18, DDS 3-32

when to alter, DDS 3-18

distributing application loads

as in advanced replication, REP 1-6, SCN 34-7

distributing I/O, SAD 2-15, STU 20-20, STU 20-24

distribution

hints for, STU 7-58

DIUTIL package, STU 10-4

DLCR.RDBMS.OMD record, NET 8-17, NET A-45

DLL

debugging, DCI 4-15

naming conventions, DCI 2-7

DLM, described, PSC 1-10

DL.RDBMS.OMD record, NET 8-17, NET A-45

DM, Database Mount, SPS 10-5

DML, SCN 1-52, SCN 16-3

changes not propagated to other sites, REP 7-31

See also Data Manipulation Language

DML (Data Manipulation Language), PCO 5-7

DML enqueue, SRF B-2

DML lock, SPS 7-3, SPS 7-5

DML operations

and triggers, SQL 7-404

during index creation, SQL 7-283

during index rebuild, SQL 7-134

DML Returning Clause, PC_ A-5

DML returning clause, PCO 5-9, PCO A-2

DML returning clauses, PC_ 6-11

DML. See data manipulation language

DML statements, SQL 6-4

PL/SQL support of, SQL 6-4

DML statements parallelized statistic, SRF C-4

DML subpartition locks, SCN 11-46

DML with RETURNING clause

See RETURNING clause

DML_LOCKS initialization parameter

compatibility, MIG B-8

DML_LOCKS parameter, ADG 8 - 11, PSC 6-10, PSC 6-11, SPS 7-6, SPS 10-3, SPS 18-10, SPS 18-11, SRF 1-37, STU 26-26, STU 26-28

and performance, SPS 16-7

calculating non-PCM resources, SPS 16-4

ensuring IDLM lock capacity, SPS 16-6

PDML restrictions, SRF 1-38

Dnnn background processes, SCN 8-14

See also dispatcher processes

DNS, described, NET Glossary-7

DNSTIAR subprogram, PCO A-6

DO action

in the WHENEVER statement, PC_ 9-25

of WHENEVER directive, PC_ F-120

result of, PC_ 9-25

DO CALL, PCO A-3

DO CALL action

of WHENEVER directive, PCO 8-30, PCO 8-31, PCO F-92

DO PERFORM action

of WHENEVER directive, PCO 8-29, PCO F-92

DO_DEFERRED_REPCAT_ADMIN package, REP 7-6

DO_DEFERRED_REPCAT_ADMIN procedure

DBMS_REPCAT package, REP 7-6, REP 7-6 to REP 7-7

documentation

online, GTK 5-2

printed part numbers, GTK 5-5

roadmap for Migration utility, MIG 3-2

roadmap for Oracle Data Migration Assistant, MIG 4-2

domain, NET 4-5

DOMAIN INDEX

and EXPLAIN PLAN, STU 13-24

domain index, SCN 10-43

creating, DCI 11-15

domain indexes, SQL 7-277, SQL 7-285, SQL 7-290

associating statistics with, SQL 7-196

determining user-defined CPU and I/O costs, SQL 7-486

dropping, MIG 12-13

extensible optimization, SCN 22-16

invoking drop routines for, SQL 7-475

removing from the database, SQL 7-454

specifying alter string for, SQL 7-38

user-defined statistics, SCN 22-17

using, STU 6-23

Domain Name Services, described, NET Glossary-7

domain of data cartridge, DCI 1-4

DOMAIN_HINT command, NET A-35

domains

default, NET 2-38

delegating, NET 6-50

described, NET 2-33, NET 6-23

multiple hierarchically related, NET 2-39, NET 6-29, NET 6-34

naming considerations, NET 2-33

required by root administrative regions, NET 2-40

with a single domain naming structure, diagram, NET 2-37

dot notation, 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-6

for record fields, PLS 2-33

Double, NET 6-29, NET 6-34

DOUBLE datatype, SUT 5-59, SUT 5-60

DOUBLE PRECISION datatype

ANSI, SQL 2-24

DOUBLE PRECISION subtype, PLS 2-13

downgrading

Advanced Replication

regenerating, MIG 12-51

advanced replication, MIG 12-49

CATALOG.SQL, MIG 12-49

CATPROC.SQL, MIG 12-49

definition, MIG 1-3

Oracle Parallel Server, MIG 12-49

procedure for, MIG 12-43

queue tables, MIG 12-31

removing incompatibilities, MIG 12-2

Advanced Replication, MIG 12-38

application context, MIG 12-36

associations, MIG 12-35

bitmap index invalidation, MIG 12-12

chained row tables, MIG 12-18

dimensions, MIG 12-14

DISABLE VALIDATE constraints, MIG 12-34

domain indexes, MIG 12-13

exception tables, MIG 12-18

extensible indexing, MIG 12-13

fine-grained access control, MIG 12-37

function-based indexes, MIG 12-13

indextypes, MIG 12-13

Java, MIG 12-26

key compression on indexes and index-organized tables, MIG 12-6

LOBs, MIG 12-19

LOBs in index-organized tables, MIG 12-7

locally managed tablespaces, MIG 12-5

materialized views, MIG 12-9

mutually referencing types, MIG 12-24

mutually referencing views, MIG 12-10

nested tables, MIG 12-23

Net8 service naming, MIG 12-41

operators, MIG 12-14

optimizer, MIG 12-35

partially dropped columns, MIG 12-8

partitioning, MIG 12-14

plan stability, MIG 12-36

secondary indexes on index-organized tables, MIG 12-8

security policies, MIG 12-37

SET_SESSION_LONGOPS syntax change, MIG 12-33

single-table hash clusters, MIG 12-9

SQL and PL/SQL, MIG 12-25

stored outlines, MIG 12-36

temporary tables, MIG 12-6

transported tablespaces, MIG 12-5

triggers, MIG 12-35

triggers on nested table view columns, MIG 12-34

unused columns, MIG 12-8

UROWIDs, MIG 12-17

user-defined datatypes, MIG 12-21

user-defined object identifiers, MIG 12-22

UTL_REF package, MIG 12-33

VARRAYs, MIG 12-24

resetting database compatibility, MIG 12-42

scripts, MIG 12-45

errors while running, MIG 1-3

rerunning, MIG 12-46

to an older Oracle8i release, MIG 12-1

to Oracle7, MIG 13-1

alternative methods, MIG 13-4

CATEXP7.SQL script, MIG 13-3

DR tablespace raw device, PSC 2-6

DRG, SMS 50-1

drilldown data views in Oracle Trace, STU 15-16

Basic Statistics for Parse/Execute/Fetch, STU 15-18

CPU Statistics for Parse/Execute/Fetch, STU 15-18

Parse Statistics, STU 15-18

Row Statistics for Execute/Fetch, STU 15-19

drilling down, STU 30-2

hierarchies, STU 30-2

drivers, SCN 8-26

driving_site, DDS 4-8

DRIVING_SITE hint, SQL 2-61

DROP ANY CLUSTER system privilege, SQL 7-495

DROP ANY CONTEXT system privilege, SQL 7-495

DROP ANY DIMENSION system privilege, SQL 7-496

DROP ANY DIRECTORY system privilege, SQL 7-496

DROP ANY INDEX system privilege, SQL 7-496

DROP ANY INDEXTYPE system privilege, SQL 7-496

DROP ANY LIBRARY system privilege, SQL 7-497

DROP ANY MATERIALIZED VIEW system privilege, SQL 7-497

DROP ANY OPERATOR system privilege, SQL 7-497

DROP ANY OUTLINE system privilege, SQL 7-498

DROP ANY PROCEDURE system privilege, SQL 7-498

DROP ANY ROLE system privilege, SQL 7-498

DROP ANY SEQUENCE system privilege, SQL 7-499

DROP ANY SNAPSHOT system privilege, SQL 7-499

DROP ANY SYNONYM system privilege, SQL 7-499

DROP ANY TABLE system privilege, SQL 7-500

DROP ANY TRIGGER system privilege, SQL 7-501

DROP ANY TYPE privilege, SCN 14-13

See also privileges

DROP ANY TYPE system privilege, SQL 7-501

DROP ANY VIEW system privilege, SQL 7-502

drop catalog command (RMAN), SBR 11-68

DROP clause

of ALTER DIMENSION, SQL 7-26

DROP CLUSTER command, ADG 6 - 18, ADG 6 - 21

CASCADE CONSTRAINTS option, SAD 17-11

dropping

cluster with no tables, SAD 17-11

hash cluster, SAD 18-9

INCLUDING TABLES option, SAD 17-11

DROP CLUSTER statement, SQL 7-446

drop column, GTK 2-41

compatibility, MIG 8-10

DROP COLUMN clause, SCN 10-6

of ALTER TABLE, SQL 7-137

DROP command, SCN 16-4

DROP CONSTRAINT clause

of ALTER TABLE, SQL 7-137

DROP CONTEXT statement, SQL 7-448

DROP DATABASE LINK statement, SQL 7-449

DROP DIMENSION statement, SQL 7-450

DROP DIRECTORY statement, SQL 7-451

DROP FUNCTION statement, SQL 7-452

DROP INDEX command, ADG 6 - 6

privileges required, ADG 6 - 6

DROP INDEX statement, SQL 7-454

DROP INDEXTYPE statement, SQL 7-456

DROP JAVA statement, SQL 7-457

DROP LIBRARY

statement, SQL 7-458

system privilege, SQL 7-497

DROP LOGFILE clause

of ALTER DATABASE, SQL 7-9, SQL 7-18

DROP LOGFILE MEMBER clause

of ALTER DATABASE, SQL 7-9, SQL 7-18

DROP LOGFILE MEMBER option

ALTER DATABASE command, SAD 6-15

DROP LOGFILE option

ALTER DATABASE command, SAD 6-14

drop master site, RAR 7-4

DROP MATERIALIZED VIEW / SNAPSHOT statement, SQL 7-459

DROP MATERIALIZED VIEW LOG / SNAPSHOT LOG statement, SQL 7-461

DROP MATERIALIZED VIEW statement, STU 29-4

prebuilt tables, STU 29-17

DROP OPERATOR statement, SQL 7-463

DROP OUTLINE statement, SQL 7-464

DROP PACKAGE BODY statement, SQL 7-465

DROP PACKAGE statement, SQL 7-465

DROP PARTITION clause

ALTER TABLE command, SAD 13-12

of ALTER INDEX, SQL 7-40

of ALTER TABLE, SQL 7-149

DROP PRIMARY constraint clause

of ALTER TABLE, SQL 7-137

DROP PROCEDURE statement, SQL 7-467

DROP PROFILE

statement, SQL 7-468

system privilege, SQL 7-498

DROP PROFILE command, SAD 23-21

DROP PUBLIC DATABASE LINK system privilege, SQL 7-496

DROP PUBLIC SYNONYM system privilege, SQL 7-500

DROP ROLE command, ADG 12 - 16, SAD 24-8, SAD 24-9

DROP ROLE statement, SQL 7-469

DROP ROLLBACK SEGMENT

statement, SQL 7-470

system privilege, SQL 7-498

DROP ROLLBACK SEGMENT command, SAD 21-14

DROP SEQUENCE statement, SQL 7-471

DROP SNAPSHOT LOG command, REP 7-28

drop snapshot site, RAR 7-9

DROP statement

triggers on, SQL 7-405

DROP STORAGE clause

of TRUNCATE, SQL 7-583

DROP SYNONYM command, SAD 15-12

DROP SYNONYM statement, SQL 7-474

DROP TABLE command, ADG 3 - 10, SPS 4-16

about, SAD 14-12

auditing, SCN 31-7

CASCADE CONSTRAINTS option, SAD 14-12

for clustered tables, SAD 17-10

triggers and, SCN 20-6

DROP TABLE statement, SQL 7-475

DROP TABLESPACE

statement, SQL 7-477

system privilege, SQL 7-500

DROP TABLESPACE command, SAD 9-15

DROP TABLESPACE statement, SPS A-18

DROP TRIGGER command, ADG 13 - 29

DROP TRIGGER statement, SQL 7-479

DROP TYPE BODY statement, SQL 7-482

DROP TYPE command

dependencies and, SCN 14-17

FORCE option, SCN 14-17

DROP TYPE statement, SQL 7-480

DROP UNIQUE constraint clause

of ALTER TABLE, SQL 7-137

DROP USER

statement, SQL 7-483

system privilege, SQL 7-502

DROP USER command, SAD 23-17

DROP USER privilege, SAD 23-17

DROP VIEW statement, SQL 7-485

DROP_BY_CAT

procedure of OUTLN_PKG, STU 7-30

DROP_MASTER_REPGROUP procedure

DBMS_REPCAT package, REP 2-21

DROP_MASTER_REPOBJECT procedure

DBMS_REPCAT package, REP 2-31

DROP_UNUSED

procedure of OUTLN_PKG, STU 7-30

DROPCAT5.SQL script, SRF 5-7

DROPCAT6.SQL script, SRF 5-7

dropped snapshots

Import, SUT 2-51

dropped tables

recovery, SBR 15-15

dropping

audit trail, SAD 25-4

cluster indexes, SAD 17-10

clusters, ADG 6 - 17, SAD 17-10

column groups, REP 6-15

syntax, SPR 34 - 44, RAR 8-123

control files, SAD 5-9

database links, DDS 2-19

databases, SAD 2-8

datafiles, SAD 9-14

hash clusters, ADG 6 - 21, SAD 18-9

index partition, SAD 13-14

indexes, ADG 6 - 6, SAD 16-15

to continue a direct path load, SUT 5-34

integrity constraints, ADG 5 - 29

about, SAD 20-21

effects on indexes, SAD 16-7

master sites, SPR 34 - 69, RAR 8-153

online redo log groups, SAD 6-14

online redo log members, SAD 6-14

packages, ADG 10 - 11

priority group members

by priority, REP 6-28

by value, REP 6-27

priority groups, SPR 34 - 49, RAR 8-129, REP 6-28

procedures, ADG 10 - 11

profiles, SAD 23-21

replicated objects

from master sites, SPR 34 - 48, RAR 8-127

from snapshot sites, SPR 34 - 54, RAR 8-135

groups of, SPR 34 - 46, RAR 8-125

roles, ADG 12 - 16, SAD 24-8

rollback segments, SAD 21-11, SAD 21-13

sequences, ADG 3 - 41, SAD 15-11

site priority groups, SPR 34 - 52, RAR 8-132, REP 6-32

members of, REP 6-31

sites

by priority level, REP 6-32

snapshot logs, REP 7-28

snapshot sites, SPR 34 - 53, RAR 8-134

synonyms, ADG 3 - 44, SAD 15-12

table partitions, SAD 13-12

tables, ADG 3 - 10, SAD 14-12

tablespaces

about, SAD 9-14

required privileges, SAD 9-15

triggers, ADG 13 - 29

users, SAD 23-16

views, ADG 3 - 27, SAD 15-9

dropping a database object

tablespace, SPS 15-6, SPS A-18

dropping a redo log file, SPS A-18

log switch, SPS 21-10

manual archiving, SPS 14-9

restrictions, SPS 14-9

dropping AQ objects, ADQ 8-52

dropping the recovery catalog, SBR 6-35

DSNTIAR

DB2 compatible feature, PCO 8-27

DSNTIAR routine, PCO 8-27

DSS applications, SPS 1-5, SPS 1-12, SPS 1-13, SPS 1-21, SPS 2-7, SPS 3-2

DSS database

dimensions, STU 30-1

disk striping, SCN 26-48

parallel DML, SCN 26-37

partitioning indexes, SCN 11-37

partitions, SCN 11-6

performance, SCN 11-9

scoring tables, SCN 26-38

DSS memory, STU 26-20

DST parameter, NET 7-39, NET C-80

DTP model, PC_ 5-55, PCO 3-32

DTYCHR type, MIG 11-8

DUAL dummy table, SQL 2-68, SQL 5-24

dual ported controllers, SPS 2-3

DUAL table, SCN 2-7

dummy host variables

placeholders, PC_ 13-3

dump files, SRF 1-71

Export and Import, SCN 14-20

DUMP function, SQL 4-14

dump_orphan_keys procedure, SAD 19-6, SAD 19-9

DUMP_TNSNAMES command, NET 5-24, NET A-36

DUP_VAL_ON_INDEX exception, PLS 6-5

duplex parameter (RMAN)

set command, SBR 8-22

duplexing backup sets, SBR 4-33, SBR 8-22

duplicate cluster key wait event, SRF A-29

duplicate command (RMAN), SBR 4-52, SBR 11-69

duplicate databases

creating, SBR 4-52, SBR 10-2

creating non-current, SBR 10-19

creating on a remote host with same filesystem, SBR 10-10

creating on local host, SBR 10-17

creating on remote host with different filesystem, SBR 10-12

DB_FILE_NAME_CONVERT parameter, SBR 10-5

generating filenames, SBR 10-3

nofilenamecheck option, SBR 10-6

preparing for duplication, SBR 10-7

restrictions, SBR 10-3

set auxname command (RMAN), SBR 10-5

set newname command (RMAN), SBR 10-5

skipping tablespaces, SBR 10-5

duplicating a database, SBR 4-52

duration

example, OCI 13-14

of objects, OCI 13-14

duration events in Oracle Trace, STU 15-5

DURATION precompiler option, PC_ 10-20, PC_ 17-20

DY date format element, SQL 2-41, SQL 2-43

dynamic (connection) load balancing, Net8, GTK 2-76

Dynamic Discovery Option, NET 2-43

migrating issues, NET 5-24

dynamic extension, STU 20-26

avoiding, STU 20-28

dynamic FOR-loop range, PLS 3-12

dynamic initialization parameters, SRF 1-6

dynamic linked libraries, DDS 5-6

DYNAMIC option

effect on functionality, PCO 10-12

dynamic ownership

conflict avoidance and, REP 8-30

workflow partitioning, REP 8-30

dynamic partitioning, SCN 26-6

dynamic performance tables

CATALOG.SQL script, SRF 3-2

public synonyms (V$), SRF 3-2

using, SAD 4-9

views (V_$), SRF 3-2

dynamic performance tables (V$ tables), SCN 2-7

dynamic performance view

creating, SPS 20-12

dynamic performance views

added in Oracle8i, MIG D-2

changed in Oracle8i

added columns, MIG D-8

date columns

compatibility, MIG D-11

enabling statistics, STU 14-4

for tuning, STU 16-1

obsolete in Oracle8i, MIG D-11

renamed in Oracle8i, MIG D-7

dynamic PL/SQL, PCO 9-30

rules for, PC_ 13-29

versus dynamic SQL, PC_ 13-29

dynamic predicates

in security policies, SCN 30-23

dynamic sites

ownership, REP 6-4

dynamic SQL, PLS 10-2

advantages and disadvantages, PCO 9-3

advantages and disadvantages of, PC_ 13-2

anonymous blocks and, SPR 48 - 2

application development languages, ADG 9 - 24

cannot use cursor variables with, PC_ 4-32

choosing the right method, PC_ 13-6, PCO 9-7

DBMS_SQL functions, using, SPR 48 - 2

DBMS_SQL package, SCN 16-19

definition of, PC_ 2-6

DML statements, ADG 9 - 3

embedded, SCN 16-19

errors, locating, SPR 48 - 33

execution flow in, SPR 48 - 4

guidelines, PCO 9-6

guidelines for, PC_ 13-6

handling nulls, PLS 10-12

invoker-rights, ADG 9 - 8

invoking PL/SQL blocks, ADG 9 - 7

name resolution, SCN 18-20

optimization, ADG 9 - 6

overview, PCO 2-6, PCO 9-3

overview of, PC_ 13-2

queries, ADG 9 - 4

restriction on, PC_ 6-18

restrictions, PCO 2-17

restrictions on use of datatypes, PC_ 17-38

restrictions on using datatypes in, PC_ 17-38

scenario, ADG 9 - 9

See Also DBMS_SQL package

See Also native dynamic SQL

usage, ADG 9 - 3

use of PL/SQL with, PC_ 7-33

uses for, PC_ 13-2

using duplicate placeholders, PLS 10-10

using EXECUTE IMMEDIATE statement, PLS 10-3

using OPEN-FOR-USING statement, PLS 10-5

using PL/SQL, PCO 6-32

using the AT clause, PCO 3-8

using the AT clause in, PC_ 3-11

using the names of schema objects, PLS 10-10

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

description, PCO 9-9

example, PCO 9-10

requirements, PCO 9-5

using EXECUTE IMMEDIATE, PCO 9-9

using PL/SQL, PCO 9-30

dynamic SQL method 1

commands used with, PC_ 13-5

description of, PC_ 13-9

example of, PC_ 13-9

how to use, PC_ 13-8

requirements for, PC_ 13-5

use of EXECUTE IMMEDIATE with, PC_ 13-9

use of PL/SQL with, PC_ 13-30

dynamic SQL Method 2

commands, PCO 9-6

description, PCO 9-13

requirements, PCO 9-6

use of DECLARE STATEMENT with, PC_ 13-28

use of PL/SQL with, PC_ 13-30

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 2

commands used with, PC_ 13-5

description of, PC_ 13-13

example of, PC_ 13-15

requirements for, PC_ 13-5

use of EXECUTE with, PC_ 13-13

use of PREPARE with, PC_ 13-13

dynamic SQL Method 3

commands, PCO 9-6

compared to Method 2, PCO 9-19

requirements, PCO 9-6

use of DECLARE STATEMENT with, PC_ 13-28

use of PL/SQL with, PC_ 13-30

using PL/SQL, PCO 9-30

using the DECLARE statement, PCO 9-20

using the DECLARE STATEMENT statement, PCO 9-28

using the FETCH statement, PCO 9-21

using the OPEN statement, PCO 9-20

using the PREPARE statement, PCO 9-19

dynamic SQL method 3

commands used with, PC_ 13-5

compared to method 2, PC_ 13-19

example program, PC_ 13-21

requirements for, PC_ 13-5

sequence of statements used with, PC_ 13-19

use of DECLARE with, PC_ 13-20

use of FETCH with, PC_ 13-20

use of OPEN with, PC_ 13-20

use of PREPARE with, PC_ 13-19

dynamic SQL Method 4

CLOSE statement, PCO 11-38

DECLARE CURSOR statement, PCO 11-29

DESCRIBE statement, PCO 11-29, PCO 11-34

external datatypes, PCO 11-16

FETCH statement, PCO 11-37

internal datatypes, PCO 11-15

OPEN statement, PCO 11-34

overview of, PC_ 13-25, PC_ 13-26

PREPARE statement, PCO 11-29

prerequisites, PCO 11-14

purpose of descriptors, PCO 11-4

requirements, PCO 9-6, PCO 11-2

sequence of statements used, PCO 11-23

sequence of statements used with, PC_ 13-27

SQLDA, PCO 11-4

steps for, PCO 11-22

use of DECLARE STATEMENT with, PC_ 13-28

use of DESCRIBE in, PC_ 13-26

use of descriptors with, PC_ 13-25

use of the SQLDA in, PC_ 13-26

using descriptors, PCO 9-25

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

using the SQLDA, PCO 9-25

when needed, PC_ 13-25, PCO 9-25

dynamic SQL method 4

need for descriptors with, PC_ 15-4

prerequisites for using, PC_ 15-12

requirements for, PC_ 13-6

requirements of, PC_ 15-2

sequence of statements used with, PC_ 15-20

steps for, PC_ 15-19

use of CLOSE statement in, PC_ 15-37

use of DECLARE CURSOR statement in, PC_ 15-25

use of DESCRIBE statement in, PC_ 15-25, PC_ 15-30

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_ 15-4

using host arrays with, PC_ 15-37

using the FOR clause with, PC_ 15-37

dynamic SQL Method 4 sample program, PC_ 15-40

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 SQL, native, PLS 10-1

dynamically allocating blocks, SPS 11-17

dynamically modified statement, ADG 12 - 27

---