Oracle8i Generic Documentation Master Index

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

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

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

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

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

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

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

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