Oracle8i Generic Documentation Master Index
Release 8.1.5

A68826-01

Library

Product

Contents

Index

Prev Top Next


A

A, PSC 5-29
abbreviations
AM/PM, NLS 2-14
BC/AD, NLS 2-14
Languages, NLS A-2
abbreviations permitted, PCO 2-11
abnormal termination
automatic rollback, PC_ F-26, PCO F-17
abort
shutting down an instance, SAD 3-12
abort message, DDS 3-4
abort mode, warning notice, PSC 6-22
ABORT option
SHUTDOWN command, SBR 3-3, SBR 14-17, SBR 14-18, SBR 14-26, SBR 15-12
aborted save set, LEG 2-8
ABORTED_REQUEST_THRESHOLD procedure, STU 19-24
aborting an instance, SCN 5-10, SCN 32-4
aborting OCI calls, OCI 2-33
ABS function, SQL 4-5
ABSI
standards, SQL B - 1
absolute file number, SPS 6-3
abstract data type
representing in C applications, OCI 10-8
abstraction, PLS 7-3, PLS 9-2
access
data
managing, SAD 24-1
system privileges, SAD 24-2
database
controlling, SAD 23-1
database administrator account, SAD 1-4
granting privileges, ADG 12 - 16, SAD 24-9
restricting, SAD 3-4
revoking privileges, ADG 12 - 18, SAD 24-12
object
granting privileges, SAD 24-10
privilege types, SAD 24-3
revoking privileges, SAD 24-13
objects
sequences, ADG 3 - 37
remote integrity constraints and objects, DDS 4-3
schema objects
granting privileges, ADG 12 - 17
remote integrity constraints, ADG 5 - 14
revoking privileges, ADG 12 - 19
triggers, ADG 13 - 3, ADG 13 - 48
access control, SCN 30-2
discretionary, SCN 1-39
fine-grained access control, SCN 30-22
password encryption, SCN 29-7
privileges, SCN 30-2
roles, SCN 30-16
access methods, SCN 23-34
cluster scans, SCN 23-34
execution plans, SCN 22-2
hash scans, SCN 23-35
index scans, SCN 23-35
table scans, SCN 23-34
access path, STU 2-10
access paths
cluster join, SCN 23-40
composite index, SCN 23-42
defined, SCN 22-4
hash cluster key, SCN 23-41
indexed cluster key, SCN 23-41
list of, SCN 23-36
optimization, SCN 23-33
single row by cluster join, SCN 23-38
single row by hash cluster key (with unique key), SCN 23-39
single row by rowid, SCN 23-38
single row by unique or primary key, SCN 23-40
access privileges, SUT 2-11
Export, SUT 1-4
ACCESS_INTO_NULL exception, PLS 6-5
ACCOUNT LOCK clause
of ALTER USER. See CREATE USER
of CREATE USER, SQL 7-427
ACCOUNT UNLOCK clause
of ALTER USER. See CREATE USER.
of CREATE USER, SQL 7-427
accounting, RADIUS, OAS 3-26
accounts
creating for snapshots, REP 3-25
operating-system
database administrator, SAD 1-4
role identification, SAD 24-17
user
SYS and SYSTEM, SAD 1-5
ACOS function, SQL 4-6
acquiring rollback segments, SPS 14-5
distributed locks, SRF 1-46
initialization parameters, SPS 6-9
acquisition AST, SPS 8-2, SPS 8-4
ACT parameter, NET 7-39, NET C-80
ACTIVATE STANDBY DATABASE clause
of ALTER DATABASE, SQL 7-11
activating checksumming and encryption, OAS 2-6
active destination state
for archived redo logs, SAD 7-14
active online redo log
loss of group, SBR 15-9, SBR 15-10
active set, PCO 5-12
changing, PC_ 6-13, PC_ 6-14, PCO 5-14, PCO 5-15
cursor movement through, PC_ 6-14
definition, PCO 5-12
definition of, PC_ 2-8
how identified, PC_ 6-12
if empty, PC_ 6-14
when empty, PCO 5-15
when fetched from, PC_ 6-14
when no longer defined, PC_ 6-12
active transactions
read-only tablespaces, MIG 8-23
ACTIVE_DELAYS, NET A-91
actual parameter, PLS 5-8
AD (A.D.) date format element, SQL 2-41, SQL 2-43
Ada. See SQL*Module for Ada
adapters, authentication, OAS 1-10
adaptive multi-user
algorithm for, STU 26-7
definition, STU 26-7
ADD clause
of ALTER DIMENSION, SQL 7-26
of ALTER TABLE, SQL 7-131
ADD DATAFILE clause
of ALTER TABLESPACE, SQL 7-167
ADD LOGFILE clause
of ALTER DATABASE, SQL 7-9
THREAD clause, SPS 6-3
thread required, SPS 14-8
ADD LOGFILE GROUP clause
of ALTER DATABASE, SQL 7-18
ADD LOGFILE MEMBER clause
of ALTER DATABASE, SQL 7-9, SQL 7-18
ADD LOGFILE MEMBER option
ALTER DATABASE command, SAD 6-12
ADD LOGFILE option
ALTER DATABASE command, SAD 6-11
ADD LOGFILE THREAD clause
of ALTER DATABASE, SQL 7-18
add master site, RAR 3-7, RAR 7-3
add object to refresh group, RAR 5-6
ADD OVERFLOW clause
of ALTER TABLE, SQL 7-144
ADD PARTITION, SQL 7-149
ADD PARTITION clause
ALTER TABLE command, SAD 13-11
of ALTER TABLE, SQL 7-148, SQL 7-149
ADD PRIMARY KEY clause
of ALTER MATERIALIZED VIEW LOG, SQL 7-56
ADD ROWID clause
of ALTER MATERIALIZED VIEW, SQL 7-56
of ALTER MATERIALIZED VIEW LOG, SQL 7-56
ADD TEMPFILE clause
of ALTER TABLESPACE, SQL 7-167
add template object, RAR 4-5
ADD_MASTER_DATABASE procedure
DBMS_REPCAT package, REP 2-33
ADD_MONTHS function, SQL 4-6
ADDED_EXTENTS, SPS A-10
adding
columns in column groups, REP 6-14
priority group members, REP 6-25
site priority group members, REP 6-30
sites
to an advanced replication environment, REP 8-8
adding a file, SPS 14-9, SPS 15-10, SPS A-18
additive prebuilt conflict resolution method, RAR 6-10, REP 6-18
address, PLS 5-16
ADDRESS (ADD or ADDR) attribute, NET 7-63, NET 9-4
ADDRESS parameter, NET 6-12, NET 6-76, NET 7-55, NET C-5, NET C-39, NET C-52
ADDRESS_LIST parameter, NET 4-11, NET 6-77, NET C-6, NET C-39, NET C-53
addresses, configuring, NET 6-64
ADMIN OPTION
about, SAD 24-10
revoking, SAD 24-13
roles, SCN 30-19
system privileges, SCN 30-3
with EXECUTE ANY TYPE, SCN 14-14
admin_tables procedure, SAD 19-3, SAD 19-12
ADMINISTER ANY TRIGGER system privilege, SQL 7-501
administering instances, PSC 6-1 to PSC 6-39
with initialization files, PSC 6-2
with Oracle Parallel Server Management, PSC 6-13
administration
distributed databases, DDS 2-1
administration requests, REP 1-13, REP 7-4 to REP 7-8
applying, REP 7-5
deleting, REP 7-6
diagnosing problems with, REP 7-8
displaying, REP 7-5
administrative procedures
new after migration, MIG 6-7
administrative regions
defined, NET 6-23
delegated, NET 2-40
delegated, below root, NET 2-42
delegating domains, NET 6-50
described, NET 2-33
in Oracle Names, NET 2-33
root, NET 2-40
administrator accounts
master sites, REP 2-8
Administrator GUI, LSM
Clients Window on UNIX, LEG 2-20
Devices Window on UNIX, LEG 3-4
Devices Window on Windows NT, LEG 3-6
Edit Client Dialog Box on Windows, LEG 2-22
Edit Group Dialog Box on Windows, LEG 4-6, LEG 4-8
Groups Window on UNIX, LEG 4-6
labeling a volume on UNIX, LEG 3-14
labeling a volume on Windows, LEG 3-15
Messages display on UNIX, LEG 4-10
mounting a volume on UNIX, LEG 3-16
mounting a volume on Windows, LEG 3-17
overview, LEG 2-10
Pending Messages Window, LEG 3-21
Server Window on UNIX, LEG 2-23
Sessions display on UNIX, LEG 4-10
Set Up Server Dialog Box on Windows, LEG 2-24
UNIX, LEG 2-11
unmounting a volume on UNIX, LEG 3-18
unmounting a volume on Windows, LEG 3-18
Windows NT, LEG 2-13
administrator privileges, SCN 5-3
connections audited, SCN 31-5
OUTLN schema, SCN 22-6
statement execution not audited, SCN 31-5
administrators, LSM
acceptable names, LEG 2-27
administrator server attribute, LEG 2-25, LEG 2-26
modifying on UNIX, LEG 2-28
modifying on Windows NT, LEG 2-28
server resource attributes, LEG 2-25, LEG 2-26
specifying, LEG 2-26
using wildcard to grant privileges, LEG 2-27
ADO. See attribute descriptor object
ADT, See object type
ADT. See abstract data type
Advanced Networking Option, GTK 2-70
Advanced Program-to-Program Communication (APPC), NET 4-26
advanced queue (AQ) tables
exporting, SUT 1-57
importing, SUT 2-61
advanced queueing
dequeue function, OCI 15-5
description, OCI 9-25
enqueue function, OCI 15-7
examples, OCI 15-8
OCI and, OCI 9-25
OCI descriptors for, OCI 9-25
OCI functions for, OCI 9-25
OCI vs. PL/SQL, OCI 9-26
Advanced Queuing, GTK 2-37 to GTK 2-40, GTK 3-6
administrative interface, SPR 4 - 11
privileges and access control, ADQ 3-10
compatibility, MIG 8-14, MIG 8-32
message streaming, MIG 8-32
privileges, MIG 8-32
rule based subscriptions, MIG 8-32
creation of queue tables and queues, ADQ 8-4
database event publication, GTK 2-39
DBMS_AQADM package, ADQ 3-9, SPR 5 - 1
downgrading queue tables, MIG 12-31
extended address field, MIG 7-26
features
correlation identifier, ADQ 1-8
exception handling, ADQ 1-12
integrated database level support, ADQ 1-5
integrated transactions, ADQ 1-6
local and remote recipients, ADQ 1-11
message grouping, ADQ 1-9
modes of dequeuing, ADQ 1-11
multiple recipients, ADQ 1-11
navigation of messages in dequeuing, ADQ 1-11
optimization of waiting for messages, ADQ 1-12
optional transaction protection, ADQ 1-12
priority and ordering of messages in enqueuing, ADQ 1-9
propagation, ADQ 1-10
retention and message history, ADQ 1-6
retries with delays, ADQ 1-12
sender identification, ADQ 1-10
structured payload, ADQ 1-5
subscription & recipient list, ADQ 1-8
time specification, ADQ 1-10
tracking and event journals, ADQ 1-6
interoperability, MIG 8-32
sender's ID column, MIG 8-32
message properties, ADQ 3-5
multiple consumer queues, GTK 2-39
nonpersistent queues, GTK 2-40
object level and system level privileges, GTK 2-40
parallel server mode, GTK 2-40
propagation, enhanced, GTK 2-39
addition of a sender's ID column, GTK 2-39
history management information, GTK 2-39
single view, GTK 2-39
statistics, GTK 2-39
removing propagation, MIG 12-32
revoking object and system level privileges, MIG 12-30
revoking roles and privelieges, ADQ 8-53
rules engine, GTK 2-38
scripts
CATNOQUEUE.SQL, MIG 7-28
CATQUEUE.SQL, MIG 7-28
upgrading, MIG 7-26
see also publish/subscribe
Advanced Queuing (Oracle AQ), SCN 19-1
exception handling, SCN 19-11
exporting queue tables, SCN 19-12
message queuing, SCN 19-2
publish/subscribe support, SCN 19-10
event publication, SCN 20-18
queue monitor process, SCN 1-20, SCN 8-13, SCN 19-6
interval statistics, SCN 19-11
window of execution, SCN 19-7
queue tables, SCN 19-4
recipients, SCN 19-5
rule-based subscriptions, SCN 19-5, SCN 19-6
subscription lists, SCN 19-5
remote databases, SCN 19-9
advanced queuing functions, OCI 15-4
Advanced Queuing, basics, ADQ 1-19
Advanced Queuing, multiple-consumer dequeuing of one message, ADQ 1-23
advanced replication, GTK 2-64 to GTK 2-66, REP 2-1 to REP 8-37
asynchronous propagation, REP 2-3
column level snapshot subsetting, GTK 2-65
compatibility, MIG 8-13, MIG 8-45
deferred transactions and, REP 2-4
disabling, REP 8-35
downgrading, MIG 12-49
preparing environment for, MIG 12-38
regenerating after, MIG 12-51
hybrid configurations, REP 1-12, SCN 34-13
internal apply packages, GTK 2-64
job queues and, REP 2-4
mass deployment support, GTK 2-65
migration, MIG 3-7
multimaster, REP 2-1 to REP 2-44
multimaster configuration, REP 1-5, SCN 34-6
offline snapshot instantiation, GTK 2-65
Oracle Lite integration, improved, GTK 2-66
procedural replication, REP 1-14, SCN 34-15
Replication Manager, GTK 2-66
row-level replication, REP 2-2
RPCs and, REP 2-4
security, improved, GTK 2-66
snapshot deployment templates, parameterized, GTK 2-65
snapshot refresh, GTK 2-64
snapshot sites
offline instantiation of, REP 8-17
replication, REP 5-1 to REP 5-32
synchronous propagation, REP 1-15, REP 8-6, SCN 34-16
techniques, REP 8-1 to REP 8-37
transaction propagation protection, REP 2-42 to REP 2-44
upgrading, MIG 7-21
uses for, REP 1-5, REP 1-11, SCN 34-6, SCN 34-12
advanced replication systems
monitoring, REP 7-4
Advanced Security option, SCN 33-18
Advanced Security option. See Oracle Advanced Security.
advantages
object views, ADG 17 - 3
OCI, ADG 1 - 8, OCI 1-3
ADVISE clause
of ALTER SESSION, SQL 7-79
affinity
awareness, SPS 21-14
disk, SPS 4-8, SPS 18-23
parallel DML, SCN 26-49
parallel processor, SPS A-15
partitions, SCN 26-48
AFTER clause
of CREATE TRIGGER, SQL 7-403
AFTER triggers, SCN 20-9, SQL 7-403
auditing and, ADG 13 - 35, ADG 13 - 38, SAD 25-21
correlation names and, ADG 13 - 16
defined, SCN 20-9
specifying, ADG 13 - 7
when fired, SCN 20-21
agent self-registration, DDS 6-14
compatibility, MIG 8-13
Agents, DDS 5-5
agents for queuing, SCN 19-4
agents, definition, ADQ 1-15
Agent-specific initialization parameters, DDS 6-4
aggregate assignment, PLS 2-33
aggregate computability check, STU 31-17
aggregate distinct queries, parallelization of, GTK 2-26
aggregate function
AVG, PLS 5-3
COUNT, PLS 5-3
GROUPING, PLS 5-3
MAX, PLS 5-3
MIN, PLS 5-3
STDDEV, PLS 5-3
SUM, PLS 5-3
treatment of nulls, PLS 5-3
VARIANCE, PLS 5-3
aggregate functions, SQL 4-5
aggregates, DDS 2-25, STU 27-18, STU 28-6, STU 29-10, STU 31-23
ALERT file, SPS 6-2, SPS 22-4, SRF 1-17
about, SAD 4-10
location of, SAD 4-11
session high water mark in, SAD 23-7
size of, SAD 4-11
using, SAD 4-10
when written, SAD 4-12
ALERT files, SBR 15-16, SCN 8-14
ARCn processes, SCN 8-12
checking after RESETLOGS, SBR 14-34
redo log, SCN 8-9
alert log, PSC C-12, STU 12-3
alias library, DCI 4-2
aliases
directory
exporting, SUT 1-56
importing, SUT 2-60
for columns, SQL 5-18
for expressions in view query, SQL 7-432
qualifying column names, SCN 14-8, SCN 14-9
qualifying subqueries (inline views), SCN 10-16
specifying in queries and subqueries, SQL 7-547
aliasing, PLS 7-21
ALL, SCN 23-6
data dictionary view, DDS 2-20
ALL clause
of SELECT, SQL 7-545
of SET CONSTRAINTS, SQL 7-568
of SET ROLE, SQL 7-571
ALL comparison operator, PLS 5-5
ALL EXCEPT clause
of SET ROLE, SQL 7-571
ALL operator, SQL 3-6
ALL option, PLS 5-3, SPS 21-4
ALL PRIVILEGES clause
of GRANT object_privileges, SQL 7-506
of REVOKE schema_object_privileges, SQL 7-533
of REVOKE schema_objects_privileges, SQL 7-533
ALL PRIVILEGES shortcut
of AUDIT sql_statements, SQL 7-199
ALL row operator, PLS 5-6
ALL shortcut
of AUDIT sql_statements, SQL 7-199
ALL_ views, SCN 2-6
ALL_ALL_TABLES view, SRF 2-2
ALL_ARGUMENTS view, SRF 2-4
ALL_ASSOCIATIONS view, SRF 2-5
ALL_CATALOG view, SRF 2-5
ALL_CLUSTER_HASH_EXPRESSIONS view, SRF 2-7
ALL_CLUSTERS view, SRF 2-6
ALL_COL_COMMENTS view, SQL 7-212, SRF 2-7
ALL_COL_PRIVS view, SRF 2-7
ALL_COL_PRIVS_MADE view, SRF 2-8
ALL_COL_PRIVS_RECD view, SRF 2-8
ALL_COLL_TYPES view, SRF 2-8
ALL_CONS_COLUMNS view, SRF 2-9
ALL_CONSTRAINTS view, SRF 2-10
ALL_CONTEXT view, SRF 2-11
ALL_DB_LINKS view, SRF 2-11
ALL_DEF_AUDIT_OPTS view, SRF 2-11
ALL_DEPENDENCIES view, SRF 2-12
ALL_DIM_ATTRIBUTES view, SRF 2-13
ALL_DIM_CHILD_OF view, SRF 2-13
ALL_DIM_HIERARCHIES view, SRF 2-14
ALL_DIM_JOIN_KEY view, SRF 2-14
ALL_DIM_LEVEL_KEY view, SRF 2-15
ALL_DIM_LEVELS view, SRF 2-14
ALL_DIMENSIONS view, SRF 2-12
ALL_DIRECTORIES view, SRF 2-15
ALL_ERRORS view, SRF 2-15
debugging stored procedures, ADG 10 - 43
ALL_HISTOGRAMS view, STU 7-6
ALL_IND_COLUMNS view, SRF 2-16
ALL_IND_PARTITIONS view, SRF 2-16
ALL_IND_SUBPARTITIONS view, SRF 2-18
ALL_INDEXES view, SRF 2-19, STU 6-16
filling with data, SAD 20-5
ALL_INDEXTYPE_OPERATORS view, SRF 2-22
ALL_INDEXTYPES view, SRF 2-22
ALL_JOBS view, SRF 2-22
ALL_LABELS view, SRF 2-23
ALL_LIBRARIES view, SRF 2-23
ALL_LOB_PARTITIONS view, SRF 2-24
ALL_LOB_SUBPARTITIONS view, SRF 2-25
ALL_LOBS view, SRF 2-24
ALL_METHOD_PARAMS view, SRF 2-26
ALL_METHOD_RESULTS view, SRF 2-27
ALL_MVIEW_AGGREGATES view, SRF 2-27
ALL_MVIEW_ANALYSIS view, SRF 2-28
ALL_MVIEW_DETAIL_RELATIONS view, SRF 2-29
ALL_MVIEW_JOINS view, SRF 2-29
ALL_MVIEW_KEYS view, SRF 2-30
ALL_NESTED_TABLES view, SRF 2-30
ALL_OBJECT_TABLES view, SRF 2-31
ALL_OBJECTS view, SRF 2-33, STU 19-32
ALL_OPANCILLARY view, SRF 2-34
ALL_OPARGUMENTS view, SRF 2-34
ALL_OPBINDINGS view, SRF 2-34
ALL_OPERATORS view, SRF 2-35
ALL_OUTLINE_HINTS view, SRF 2-35
ALL_OUTLINES view, SRF 2-35
ALL_PART_COL_STATISTICS view, SRF 2-36
ALL_PART_HISTOGRAMS view, SRF 2-37
ALL_PART_INDEXES view, SRF 2-37
ALL_PART_KEY_COLUMNS view, SRF 2-38
ALL_PART_LOBS view, SRF 2-39
ALL_PART_TABLES view, SRF 2-40
ALL_PARTIAL_DROP_TABS view, SRF 2-41
ALL_POLICIES view, SRF 2-41
ALL_QUEUES view, SRF 2-42
ALL_REFRESH_CHILDREN view, SRF 2-43
ALL_REFRESH_DEPENDENCIES view, SRF 2-44
ALL_REFRESHS view, SRF 2-42
ALL_REGISTERED_SNAPSHOTS view, SRF 2-45
ALL_REPCATLOG view, SRF 2-46
ALL_REPCOLUMN view, SRF 2-46
ALL_REPCOLUMN_GROUP view, SRF 2-46
ALL_REPCONFLICT view, SRF 2-46
ALL_REPDDL view, SRF 2-46
ALL_REPGENERATED view, SRF 2-46
ALL_REPGENOBJECTS view, SRF 2-46
ALL_REPGROUP view, SRF 2-46
ALL_REPGROUPED_COLUMN view, SRF 2-47
ALL_REPKEY_COLUMNS view, SRF 2-47
ALL_REPOBJECT view, SRF 2-47
ALL_REPPARAMETER_COLUMN view, SRF 2-47
ALL_REPPRIORITY view, SRF 2-47
ALL_REPPRIORITY_GROUP view, SRF 2-47
ALL_REPPROP view, SRF 2-47
ALL_REPRESOL_STATS_CONTROL view, SRF 2-48
ALL_REPRESOLUTION view, SRF 2-47
ALL_REPRESOLUTION_METHOD view, SRF 2-48
ALL_REPRESOLUTION_STATISTICS view, SRF 2-48
ALL_REPSITES view, SRF 2-48
ALL_ROWS hint, SCN 23-33, SQL 2-59, STU 7-38
ALL_SEQUENCES view, SRF 2-48
ALL_SNAPSHOT_LOGS view, SRF 2-49
ALL_SNAPSHOT_REFRESH_TIMES view, SRF 2-49
ALL_SNAPSHOTS view, SRF 2-49
ALL_SOURCE view, ADG 10 - 43, SRF 2-51
ALL_SUBPART_COL_STATISTICS view, SRF 2-51
ALL_SUBPART_HISTOGRAMS view, SRF 2-52
ALL_SUBPART_KEY_COLUMNS view, SRF 2-52
ALL_SUMDELTA view, SRF 2-53
ALL_SUMMARIES view, SRF 2-53
ALL_SYNONYMS view, SRF 2-54
ALL_TAB_COL_STATISTICS view, SRF 2-54
ALL_TAB_COLUMNS view, SRF 2-55, STU 7-5, STU 7-6
filling with data, SAD 20-5
ALL_TAB_COMMENTS view, SQL 7-212, SRF 2-56
ALL_TAB_HISTOGRAMS view, SRF 2-56
ALL_TAB_PARTITIONS view, SRF 2-57
ALL_TAB_PRIVS view, SRF 2-58
ALL_TAB_PRIVS_MADE view, SRF 2-58
ALL_TAB_PRIVS_RECD view, SRF 2-59
ALL_TAB_SUBPARTITIONS view, SRF 2-59
ALL_TABLES table, SPS 16-7
ALL_TABLES view, SRF 2-60
filling with data, SAD 20-5
ALL_TRIGGER_COLS view, SRF 2-64
ALL_TRIGGERS view, SRF 2-63
ALL_TYPE_ATTRS view, SRF 2-64
ALL_TYPE_METHODS view, SRF 2-65
ALL_TYPES view, SRF 2-65
ALL_UPDATABLE_COLUMNS view, SCN 10-15, SRF 2-65, SRF 2-66, SRF 2-156, SRF 2-260
ALL_USERS view, SRF 2-66
ALL_USTATS view, SRF 2-66
ALL_VARRAYS view, SRF 2-67
ALL_VIEWS view, SRF 2-67
ALLOCATE
allocating a cursor variable, PC_ 4-27
allocate channel command (RMAN), SBR 11-9
for delete option, SBR 8-26, SBR 11-13
for maintenance option, SBR 11-13
ALLOCATE DESCRIPTOR statement, PC_ 14-13, PC_ F-14, PCO F-12
ALLOCATE EXTENT clause
of ALTER CLUSTER, SQL 7-3, SQL 7-4
of ALTER INDEX, SQL 7-30, SQL 7-34
of ALTER TABLE, SQL 7-140
ALLOCATE EXTENT option
DATAFILE option, SPS 11-11, SPS 17-12
in exclusive mode, SPS 17-11
instance number, SPS 11-15, SPS 17-13, SRF 1-52
INSTANCE option, SPS 11-11, SPS 17-12
not available, SPS A-20
pre-allocating extents, SPS 17-14
SIZE option, SPS 11-11, SPS 17-11
ALLOCATE SQL statement, PC_ 17-5
ALLOCATE SQL statements, PC_ F-12
ALLOCATE statement, PCO F-10
use with ROWID, PCO 4-37
allocating
cursor variables, PC_ 4-27
cursors, PC_ F-12, PCO F-10
thread context, PC_ 11-8, PC_ F-28, PCO F-19
allocating cursor variables, PCO 6-33
allocation
automatic, SPS 11-17, SPS 17-13, SPS 17-14
extents, ADG 6 - 17, SAD 14-11, SPS 17-14, SPS 17-15, SPS 18-16
extents for clusters, SAD 17-9
free space, SPS 11-6, SPS 11-11
minimizing extents for rollback segments, SAD 21-13
multi-threaded server, STU 19-21
of channels, SPS 21-8
of memory, STU 19-1
PCM locks, SPS 9-6, SPS 9-26, SPS 11-15, SPS 17-11, SRF 1-44
rollback segments, SPS 14-5, SRF 1-110
sequence numbers, SPS 6-6
temporary space, SAD 14-6
allocation duration
example, OCI 13-14
of objects, OCI 13-14
ALLOW_PARTIAL_SN_RESULTS parameter, SRF 1-13
obsolete for 8.1, SPS A-5
alphanumeric datatypes, SAD 12-17
ALTER ANY CLUSTER system privilege, SQL 7-495
ALTER ANY DIMENSION system privilege, SQL 7-496
ALTER ANY INDEX system privilege, SQL 7-496
ALTER ANY MATERIALIZED VIEW system privilege, SQL 7-497
ALTER ANY OUTLINE system privilege, SQL 7-498
ALTER ANY PROCEDURE system privilege, SQL 7-498
ALTER ANY ROLE system privilege, SQL 7-498
ALTER ANY SEQUENCE system privilege, SQL 7-499
ALTER ANY SNAPSHOT system privilege, SQL 7-499
ALTER ANY TABLE system privilege, SQL 7-500
ALTER ANY TRIGGER system privilege, SQL 7-501
ALTER ANY TYPE privilege, SCN 14-13
See also privileges
ALTER ANY TYPE system privilege, SQL 7-501
ALTER AUTHORIZATION
changing password, PCO 3-11
ALTER CLUSTER command, ADG 3 - 6
ALLOCATE EXTENT option, ADG 6 - 17, SAD 17-9
MAXTRANS option, SAD 12-9
using for hash clusters, SAD 18-8
using for index clusters, SAD 17-9
ALTER CLUSTER statement, SPS A-20, SQL 7-2
ALLOCATE EXTENT option, SPS 17-11
allocating extents, SPS 17-14
ALTER command, SCN 16-4
auditing partitions, SCN 11-63
ALTER DATABASE
statement, SQL 7-6
system privilege, SQL 7-495
ALTER DATABASE ADD LOGFILE, PSC 8-2
ALTER DATABASE command
ADD LOGFILE, SRF 1-123
ADD LOGFILE MEMBER option, SAD 6-12
ADD LOGFILE option, SAD 6-11
ARCHIVELOG option, SAD 7-7
BACKUP CONTROLFILE option, SBR 3-6
BACKUP CONTROLFILE TO TRACE option, SBR 13-12
CLEAR LOGFILE GROUP option, SBR 16-17
CLEAR LOGFILE option, SAD 6-17
CLEAR UNARCHIVED LOGFILE option, SAD 6-7, SBR 2-14, SBR 16-25
CREATE DATAFILE option, SBR 14-6
database name, SRF 1-33
database partially available to users, SAD 3-7
DATAFILE OFFLINE DROP clause, SBR 16-27
DATAFILE ONLINE option, SBR 14-31
DATAFILE...OFFLINE DROP option, SAD 10-8
DROP LOGFILE MEMBER option, SAD 6-15
DROP LOGFILE option, SAD 6-14
ENABLE THREAD, SRF 1-123
ENABLE THREAD option, SBR 16-24
MOUNT option, SAD 3-7
MOUNT STANDBY DATABASE option, SBR 16-6, SBR 16-29
NOARCHIVELOG option, SAD 7-7
NORESETLOGS option, SBR 13-14, SBR 14-33
OPEN option, SAD 3-7
OPEN READ ONLY option, SBR 16-19, SBR 16-20, SBR 16-21
OPEN RESETLOGS option, SBR 6-7
RECOVER ... FROM option, SBR 14-8, SBR 14-12
RECOVER AUTOMATIC LOGFILE option, SBR 14-15
RECOVER LOGFILE option, SBR 14-14
RENAME DATABASE clause, SBR 9-9
RENAME FILE option
datafiles for multiple tablespaces, SAD 10-10
RESETLOGS option, SBR 13-14, SBR 14-17, SBR 14-18, SBR 14-33
standby database, SCN 5-7
THREAD, SRF 1-123
UNRECOVERABLE DATAFILE option, SAD 6-17
alter database command (RMAN), SBR 11-15
ALTER DATABASE CONVERT command, MIG 3-4, MIG 3-26
re-running, MIG A-19
ALTER DATABASE OPEN RESETLOGS command, MIG 3-4, MIG 3-26
ALTER DATABASE OPEN RESETLOGS statement, SPS 22-14
ALTER DATABASE RESET COMPATIBILITY, MIG 8-7
ALTER DATABASE statement
ADD LOGFILE, SPS 6-3
adding or dropping log file, SPS A-18
CLOSE option, SPS 18-18
DATAFILE OFFLINE and ONLINE options, SPS A-18
DATFILE RESIZE, SPS 15-9
DISABLE, SPS 14-9
ENABLE THREAD, SPS 14-8
MOUNT option, SPS 18-13
OPEN option, SPS 18-14
RECOVER, SPS 22-7
RECOVER option, SPS 22-7
renaming a file, SPS A-18
setting the log mode, SPS 14-2, SPS 14-9, SPS B-2
THREAD, SPS 14-9
thread of redo, SPS 14-9
ALTER DIMENSION statement, SQL 7-24
ALTER FUNCTION command
COMPILE option, SAD 20-25
ALTER FUNCTION statement, SQL 7-27
ALTER INDEX COALESCE, SAD 16-7
ALTER INDEX command, ADG 3 - 6, SAD 13-18
about, SAD 16-13
MAXTRANS option, SAD 12-9
MOVE PARTITION clause, SAD 13-11
no-logging mode for SPLIT PARTITION, SCN 11-58, SCN 25-7
partition attributes, SCN 11-37
REBUILD PARTITION, SCN 11-60
REBUILD PARTITION clause, SAD 13-11, SAD 13-20
ALTER INDEX REBUILD statement, STU 6-9
ALTER INDEX statement, SQL 7-29
COMPUTE STATISTICS clause, GTK 2-27
DEALLOCATE UNUSED option, SPS 17-16
online rebuild, GTK 2-42
ALTER JAVA CLASS statement, SQL 7-43
ALTER JAVA SOURCE statement, SQL 7-43
ALTER MATERIALIZED VIEW LOG statement, SQL 7-54
ALTER MATERIALIZED VIEW statement, SQL 7-45, STU 29-4
enabling query rewrite, STU 31-4
ALTER object privilege, SQL 7-508
ALTER OUTLINE statement, SQL 7-58
ALTER PACKAGE command
COMPILE option, SAD 20-25
ALTER PACKAGE statement, SQL 7-59
ALTER PROCEDURE command
COMPILE option, SAD 20-25
ALTER PROCEDURE statement, SQL 7-62
ALTER PROFILE
statement, SQL 7-64
system privilege, SQL 7-498
ALTER PROFILE command
altering resource limits, SAD 23-19
COMPOSITE_LIMIT option, SAD 23-19
alter replicated object, RAR 7-16
alter replication object, RAR 6-8
ALTER RESOURCE COST
statement, SQL 7-68
system privilege, SQL 7-499
ALTER RESOURCE COST command, SAD 23-20
ALTER ROLE command
changing authorization method, SAD 24-8
ALTER ROLE statement, SQL 7-71
ALTER ROLLBACK SEGMENT
statement, SQL 7-73
system privilege, SQL 7-498
ALTER ROLLBACK SEGMENT command, SPS 6-10
changing storage parameters, SAD 21-9
OFFLINE option, SAD 21-12
ONLINE option, SAD 21-11, SAD 21-12
PUBLIC option, SAD 21-9
STORAGE clause, SAD 21-9
ALTER SEQUENCE command, ADG 3 - 37, SAD 15-11
ALTER SEQUENCE statement, SQL 7-76
ALTER SESSION
FORCE PARALLEL DDL, SCN 26-24, SCN 26-27
create or rebuild index, SCN 26-25, SCN 26-27
create table as select, SCN 26-26, SCN 26-27
move or split partition, SCN 26-25, SCN 26-28
FORCE PARALLEL DML
insert, SCN 26-23, SCN 26-24, SCN 26-27
update and delete, SCN 26-22, SCN 26-27
statement, SQL 7-78
system privilege, DDS 4-2, SQL 7-499
ALTER SESSION command, SCN 16-5
ADVISE option, DDS 3-22
CLOSE DATABASE LINK option, DDS 4-2
dynamic parameters, SCN 5-5
ENABLE PARALLEL DML, SCN 26-38
HASH_JOIN_ENABLED, SCN 24-7
OPTIMIZER_GOAL, SCN 23-32
SERIALIZABLE, ADG 8 - 19, ADG 8 - 26
SET CONSTRAINTS DEFERRED, SCN 28-21
SET HASH_AREA_SIZE option, SRF 1-47, SRF 1-48
SET HASH_JOIN_ENABLED option, SRF 1-47
SET NLS_CURRENCY option, NLS 2-21, NLS 2-22
SET NLS_DATE_FORMAT option, NLS 2-12
SET NLS_LANGUAGE option, NLS 2-9
SET NLS_NUMERIC_CHARACTERS option, NLS 2-20
SET NLS_TERRITORY option, NLS 2-9
SET SQL_TRACE parameter, SAD 4-10
transaction isolation level, SCN 27-7, SCN 27-31
ALTER SESSION statement
examples, STU 14-5
SET INSTANCE option, SPS 11-11, SPS 17-10
SET SESSION_CACHED_CURSORS, STU 19-18
ALTER SNAPSHOT LOG command, REP 7-23
ALTER SNAPSHOT LOG. See ALTER MATERIALIZED VIEW LOG.
ALTER SNAPSHOT. See ALTER MATERIALIZED VIEW.
ALTER statement
triggers on, SQL 7-405
ALTER SYSTEM
command, limiting instances for parallel execution, SPS 18-27
statement, SQL 7-95
system privilege, SQL 7-495
ALTER SYSTEM ARCHIVE LOG statement, SPS 18-18, SPS 21-16
CURRENT option, SPS 21-10, SPS A-19
global log switch, SPS 21-10, SPS 21-16
THREAD option, SPS 18-18, SPS 21-4
ALTER SYSTEM CHECK DATAFILES statement, SPS 6-2
instance recovery, SPS 22-4
ALTER SYSTEM CHECKPOINT statement, SPS 21-9
global versus local, SPS 18-18
specifying an instance, SPS 18-18
ALTER SYSTEM command, SCN 16-5
ARCHIVE ALL option
using to archive online redo logs, SBR 3-5
ARCHIVE LOG ALL option, SAD 7-10
ARCHIVE LOG CURRENT option, SBR 16-4, SBR 16-21
ARCHIVE LOG option, SAD 7-10
DISABLE DISTRIBUTED RECOVERY option, DDS 3-34
dynamic parameters, SCN 5-5
LOG_ARCHIVE_MAX_PROCESSES, SCN 8-12, SCN 32-20
ENABLE DISTRIBUTED RECOVERY option, DDS 3-34
ENABLE RESTRICTED SESSION option, SAD 3-9
RESUME option, SBR 13-10
SET LICENSE_MAX_SESSIONS option, SAD 23-4
SET LICENSE_MAX_USERS option, SAD 23-6
SET LICENSE_SESSIONS_WARNING option, SAD 23-4
SET MTS_DISPATCHERS option, SAD 4-7
SET MTS_SERVERS option, SAD 4-6
SET NLS_LANGUAGE option, NLS 2-9
SET RESOURCE_LIMIT option, SAD 23-21
SUSPEND option, SBR 13-9
SWITCH LOGFILE option, SAD 6-16, SCN 8-12
ALTER SYSTEM DISCONNECT SESSION, STU 25-22
ALTER SYSTEM privilege, SPS 21-10
ALTER SYSTEM RESUME, SAD 3-13
alter system set mts_dispatchers wait event, SRF A-20
ALTER SYSTEM statement
CHECKPOINT option, STU 25-6
MTS_DISPATCHERS parameter, STU 21-8
ALTER SYSTEM SUSPEND, SAD 3-8
ALTER SYSTEM SWITCH LOGFILE statement, SPS 18-18, SPS 21-10, SPS A-19
DBA privilege, SPS 21-10, SPS A-19
ALTER TABLE command, ADG 3 - 6, ADG 3 - 9
add or coalesce hash partition, SCN 11-17
ADD PARTITION clause, SAD 13-11
ALLOCATE EXTENT option, SAD 14-11
auditing, SCN 31-7
bitmap index invalidation, MIG 8-25
CACHE clause, SCN 7-4
DEALLOCATE UNUSED, SCN 4-14
defining integrity constraints, ADG 5 - 18
DISABLE ALL TRIGGERS option, ADG 13 - 31, SAD 20-13
DISABLE integrity constraint option, ADG 5 - 23, SAD 20-20
disable or enable constraints, SCN 28-22
DROP COLUMN, SCN 10-6
DROP integrity constraint option, ADG 5 - 29, SAD 20-21
DROP PARTITION clause, SAD 13-12
ENABLE ALL TRIGGERS option, ADG 13 - 30, SAD 20-12
ENABLE integrity constraint option, ADG 5 - 23, SAD 20-20
example, SAD 14-11
EXCHANGE PARTITION, SCN 11-11
INITRANS parameter, ADG 8 - 26
MAXTRANS option, SAD 12-9
MERGE PARTITIONS, SCN 11-16
MODIFY CONSTRAINT, SCN 28-23
MODIFY PARTITION clause, SAD 13-10
no-logging mode for SPLIT PARTITION, SCN 11-58, SCN 25-7
partition attributes, SCN 11-27
SPLIT PARTITION clause, SAD 13-11, SAD 13-17
triggers and, SCN 20-6
TRUNCATE PARTITION clause, SAD 13-15
UNUSED column, SCN 10-6
validate or novalidate constraints, SCN 28-22
ALTER TABLE statement, SQL 7-114
ALLOCATE EXTENT option, SPS 17-11
allocating extents, SPS 17-14, SPS 17-15, SRF 1-52
DISABLE TABLE LOCK option, SPS 7-6, SPS 10-3, SPS 16-7
drop column support, GTK 2-41
ENABLE ROW MOVEMENT, GTK 2-46
ENABLE TABLE LOCK option, SPS 7-6, SPS 10-3, SPS 16-7
MAXEXTENTS option, SPS 17-15
merging partitions, GTK 2-46
MODIFY CONSTRAINT clause, GTK 2-28
MOVE option for IOT or non-partitioned table, GTK 2-29
no longer invalidates bitmap indexes, GTK 2-25
NOLOGGING option, STU 27-23
ALTER TABLESPACE
statement, SQL 7-164
system privilege, SQL 7-500
ALTER TABLESPACE command
ADD DATAFILE parameter, SAD 10-5
BEGIN BACKUP option, SBR 13-6, SBR 13-9
BEGIN/END BACKUP option, SBR 6-28
END BACKUP option, SBR 13-9
ONLINE option
example, SAD 9-10
READ ONLY, SCN 3-10
READ ONLY option, SAD 9-12
READ WRITE, SCN 3-11
READ WRITE option, SAD 9-14
RENAME DATA FILE option, SAD 10-10
TEMPORARY or PERMANENT, SCN 3-13
ALTER TABLESPACE statement
ADD DATAFILE, SPS 15-10
ADD DATAFILE option, SPS A-18
BACKUP option, SPS 21-15
OFFLINE and ONLINE options, SPS A-18
READ ONLY option, SPS 12-2
renaming a data file, SPS A-18
ALTER TRIGGER command
DISABLE option, ADG 13 - 30, SAD 20-13
ENABLE option, ADG 13 - 30, SAD 20-12
ALTER TRIGGER statement, SQL 7-171
ALTER TYPE statement, SQL 7-173
ALTER USER
statement, SQL 7-179
system privilege, SQL 7-501
ALTER USER command
temporary segments and, SCN 4-18
ALTER USER privilege, SAD 23-15
ALTER VIEW command
COMPILE option, SAD 20-25
ALTER VIEW statement, SQL 7-183
ALTER_MASTER_REPOBJECT procedure
DBMS_REPCAT package, REP 2-29
altering
cluster indexes, SAD 17-9
clustered tables, SAD 17-9
clusters, SAD 17-8
database status, SAD 3-7
hash clusters, SAD 18-8
indexes, SAD 16-13
priority group members
priorities, REP 6-27
values, REP 6-26
priority levels, SPR 34 - 17, RAR 8-93
propagation method, SPR 34 - 14, SPR 34 - 22, RAR 8-89, RAR 8-98
public rollback segments, SAD 21-9
replicated objects, SPR 34 - 16, RAR 8-91
rollback segment storage parameters, SAD 21-9
sequences, SAD 15-10
site priority group members
priorities, REP 6-30
values, REP 6-31
snapshot definitions, REP 5-27
storage parameters, ADG 3 - 9, SAD 14-10
tables, ADG 3 - 9, SAD 14-10, SAD 14-11
tablespace storage, SAD 9-8
users, SAD 23-15
alternate character mappings, NLS 4-9
alternate keys
in replicated tables, REP 2-25
Always Use Dedicated Server option, NET 7-26
ALWAYS_ANTI_JOIN parameter, SCN 24-13, SRF 1-14, STU 7-22, STU 7-56
ALWAYS_SEMI_JOIN parameter, SCN 24-13, SRF 1-14
AM (A.M.) date format element, SQL 2-41, SQL 2-43
American National Standards Institute (ANSI)
ANSI-compatible locking, ADG 8 - 19
American National Standards Institute. See ANSI.
AM/PM abbreviation
language of, NLS 2-14
analysis dictionary, STU 12-4
ANALYZE
Import parameter, SUT 2-19
ANALYZE ANY system privilege, SQL 7-502
ANALYZE CLUSTER statement, SQL 7-185
ANALYZE command, SCN 16-4, SRF 2-19, SRF 2-55, SRF 2-60, SRF 2-94, SRF 2-145, SRF 2-150, SRF 2-206, SRF 2-249, SRF 2-254
CASCADE option, SAD 20-8
COMPUTE STATISTICS option, SAD 20-7
creating histograms, SCN 22-11
dangling REFs, GTK 2-36
distributed transactions, DDS 2-26
ESTIMATE STATISTICS SAMPLE option, SAD 20-7
estimated statistics, SCN 22-14
LIST CHAINED ROWS option, SAD 20-9
partition statistics, SCN 11-14
shared pool and, SCN 7-11
shared SQL and, SAD 20-8
STATISTICS option, SAD 20-4
VALIDATE STRUCTURE option, SAD 20-8
ANALYZE command,parallel, GTK 3-2
ANALYZE INDEX statement, SQL 7-185
ANALYZE statement, STU 11-4, STU 20-31, STU 27-20, STU 27-27, STU 32-16
ANALYZE TABLE statement, SQL 7-185
ANALYZE TABLE VALIDATE STRUCTURE, SAD 19-3
ANALYZE TABLE VALIDATE STRUCTURE command
change in release 8.1, MIG 8-17
analyze tables, DDS 4-6
analyzer statistics, SUT 2-63
analyzing archived redo logs, SAD 7-25
analyzing data
for parallel processing, STU 26-78
analyzing objects
about, SAD 20-3
privileges, SAD 20-3
ANCILLARY TO clause
of CREATE OPERATOR, SQL 7-320
AND expression
for simple subquery snapshots, REP 3-13
AND operator, SQL 3-11
AND_EQUAL hint, SQL 2-59, STU 6-7, STU 7-49
ANO. See Advanced Networking Option.
anonymous PL/SQL block, PLS 7-2
anonymous PL/SQL blocks, SCN 16-15, SCN 18-9
about, ADG 10 - 2
applications, SCN 16-17
calling a stored procedure, SCN 16-19
compared to triggers, ADG 10 - 26
contrasted with stored procedures, SCN 18-9
dynamic SQL, SCN 16-19
dynamic SQL and, SPR 48 - 2
performance, SCN 18-9
ANSI, SQL B - 1
datatypes, SQL 2-23
conversion to Oracle datatypes, SQL 2-23
standards, SQL 1-2
supported datatypes, SQL 2-8
ANSI C Support, PC_ E-2
ANSI dynamic SQL, PC_ A-4, PCO A-2
reference semantics, PC_ 14-7
See also dynamic SQL (ANSI), PC_ 14-1, PCO 10-1
ANSI format
COBOL statements, PCO 2-12
ANSI SQL standard
datatypes of, SCN 12-22
Oracle certification, SCN 1-3
ANSI SQL92
FIPS flagger, ADG 8 - 2
ANSI/ISO SQL
extensions, PCO 14-22
ANSI/ISO SQL standard, SCN 1-3
composite foreign keys, SCN 28-16
data concurrency, SCN 27-2
isolation levels, SCN 27-10
ANSWER_TIMEOUT parameter, NET C-78
anti-joins, SCN 24-13
ANY, SCN 23-6
ANY comparison operator, PLS 5-5
ANY operator, SQL 3-6
API
MM, LEG 1-11
apostrophe, PLS 2-8
APPC architecture, NET 4-26
APPEND hint, SQL 2-61, STU 7-61, STU 27-22
APPEND keyword
SQL*Loader, SUT 5-43
append sequences
conflict resolution methods, REP 6-36
append site names
conflict resolution methods, REP 6-36
APPEND to table
example, SUT 4-11
SQL*Loader, SUT 5-32
application administrator, SAD 1-3
database administrator versus, SAD 22-11
application context, ADG 12 - 22, GTK 2-69, SCN 30-24
compatibility, MIG 8-13
CREATE CONTEXT statement, GTK 2-70
downgrading, MIG 12-36
application design, STU 2-9
application designer, STU 1-8
application developer, STU 1-8
role during migration, MIG 1-10
application developers
privileges for, SAD 22-9
roles for, SAD 22-10
application development
in a distributed database environment, DDS 4-1
security for, SAD 22-10
using Heterogeneous Services, DDS 7-1
application development process, PC_ 2-9, PCO 2-2
Application development with Heterogeneous Services, DDS 7-1
application error
definition, SBR 1-12
application failover, STU 25-17, STU 25-19
callback example, OCI 9-20
callback registration, OCI 9-20
OCI callbacks, OCI 9-18
Application Generator for Microsoft Visual Studio, GTK 2-85
application level firewalls, OAS 9-11
application program interface (API), for non-Oracle data sources, NET 9-2
application roles, ADG 12 - 3
application servers
allowing to connect as a user, SQL 7-181
applications
allowing to connect as a user, SQL 7-181
analysis of, SPS 12-1
application vs. database triggers, SCN 20-3
availability, SPS 22-2
building with Net8 OPEN, NET 9-8
business functions, SPS 12-2
calling stored procedures and packages, ADG 10 - 52
can find constraint violations, SCN 28-6
client/server, STU 3-9
compatibility, MIG 8-16
compute-intensive, SPS 1-21
configuring system to use custom, NET 9-9
converting to multi-instance, SPS 23-3
data dictionary references, SCN 2-4
data warehousing, SCN 10-32
star queries, SCN 24-14
database access through, SCN 8-2
decision support, STU 3-3, STU 26-3
decision support systems (DSS), SCN 10-33
parallel SQL, SCN 26-2, SCN 26-31
departmentalized, SPS 2-8
dependencies of, SCN 21-11
designing, SPS 13-1
development
constraints, DDS 4-3
database links, controlling connections, DDS 4-2
distributing data, DDS 4-2
referential integrity, DDS 4-3
remote connections, terminating, DDS 4-2
direct-load INSERT, SCN 26-38
discrete transactions, SCN 17-8
disjoint data, SPS 1-17, SPS 2-7
distributed databases, STU 3-7
DSS, SPS 1-5, SPS 1-12, SPS 1-21, SPS 2-7
enhancing security with, SCN 1-42, SCN 28-5
errors
RAISE_APPLICATION_ERROR() procedure, DDS 4-11
failover of, SPS 4-11
index-organized tables, SCN 10-40
compatibility, MIG 8-16
information retrieval (IR), SCN 10-40
insert-intensive, SPS 11-12
interoperability, MIG 8-16
linking, OCI 2-36
network communication and, SCN 6-5
node, SPS 5-4
object dependencies and, SCN 21-13
OCI
compatibility, MIG 8-17
interoperability, MIG 8-17
OLTP, SPS 1-5, SPS 1-12, SPS 2-7, STU 3-1
online analytical processing (OLAP), SCN 10-42
online transaction processing (OLTP)
reverse key indexes, SCN 10-31
parallel DML, SCN 26-37
parallel query, STU 3-4
parallel server, STU 3-8
performance, SPS 11-12
physical ROWIDs and UROWIDs, MIG 8-16
physical ROWIDs in Oracle8i, MIG 11-2
PL/SQL
compatibility, MIG 8-20
interoperability, MIG 8-20
portability, SPS 1-5
precompiler
compatibility, MIG 8-18
interoperability, MIG 8-18
processes, SCN 8-4
profile, SPS 12-2
profiles, SPS 3-2
program interface and, SCN 8-25
query-intensive, SPS 1-17, SPS 2-7
quiescing during maintenance operations, SAD 13-21
random access, SPS 2-8
redesigning for parallel processing, SPS 1-16
registering with the database, STU 5-1, STU 12-7
roles, ADG 12 - 4
roles and, SCN 30-18
samples provided with Net8 OPEN, NET 9-11
scalability, SPS 2-2, SPS 2-6
securing, SQL 7-243
security, ADG 12 - 7
application context, SCN 30-24
sharing code, SCN 7-17
spatial applications, SCN 10-42
transaction termination and, SCN 17-5
tuning, SPS 12-1
tuning performance, SPS 1-15, SPS 11-12
Tuxedo applications
compatibility, MIG 8-17
unhandled exceptions in, ADG 10 - 46
upgrading, MIG 9-1
validating, SQL 7-243
applying log files
SQL*Plus, SBR 14-12
AQ
exporting queue tables, SCN 19-12
message queuing, SCN 19-2
publish/subscribe support, SCN 19-10
event publication, SCN 20-18
queue monitor process, SCN 1-20, SCN 8-13, SCN 19-6
interval statistics, SCN 19-11
window of execution, SCN 19-7
queue tables, SCN 19-4
recipients, SCN 19-5
rule-based subscriptions, SCN 19-5, SCN 19-6
subscription lists, SCN 19-5
remote databases, SCN 19-9
AQ (advanced queue) tables
exporting, SUT 1-57
importing, SUT 2-61
AQ. See advanced queueing.
AQ. See Advanced Queuing
AQ_ADMINISTRATOR role, SCN 19-7
AQ_ADMINISTRATOR_ROLE role, SQL 7-503
AQ_TM_PROCESS parameter, SCN 19-6, SCN 19-7
AQ_TM_PROCESSES parameter, SRF 1-15
of ALTER SYSTEM, SQL 7-100
AQ_USER_ROLE role, SQL 7-503
ARCH process, SPS 5-5, SPS 21-4, STU 21-16
multiple, STU 26-75
specifying multiple processes, SAD 7-20
ARCH_IO_SLAVES parameter, SRF 1-15
architecture, PLS 1-17
client/server, SCN 1-33
hardware, SPS 3-1
MPP, SCN 26-49
multi-instance, SPS 5-4
Net8, NET 2-5
of Oracle, SCN 1-14
OPSCTL utility on UNIX, PSC 5-4
OPSCTL utility on Windows NT, PSC 5-6
Optimal Flexible Architecture (OFA), PSC 1-2
Oracle Connection Manager, NET 2-46
Oracle database, SPS 6-1
Oracle Enterprise Manager, PSC 5-8
Oracle instance, SPS 5-1
Oracle Names, NET 2-31
Oracle Parallel Server, PSC 1-2
Oracle Parallel Server Management, PSC 5-2
SMP, SCN 26-49
architecture and CPU, STU 18-10
architecture of SSL
in an Oracle environment, OAS 9-3
with other authentication methods, OAS 9-8
architecture, LSM, LEG 2-2, LEG 2-3
archive buffer parameters, SAD 7-22
archive log
backup, SPS 21-7
ARCHIVE LOG clause
CURRENT option, SPS 21-10, SPS 21-16, SPS A-19
global log switch, SPS 21-10, SPS 21-16
manual archiving, SPS 21-4
of ALTER SYSTEM, SQL 7-96
specifying an instance, SPS 18-21
THREAD option, SPS 21-4
ARCHIVE LOG command, SPS 21-3
destination file, SRF 1-60
LIST option, SAD 6-14
START and STOP, SRF 1-66
ARCHIVE LOG CURRENT option
ALTER SYSTEM command, SBR 16-4, SBR 16-21
archive log destination parameters
new in release 8.1, MIG B-13
ARCHIVE LOG option
ALTER SYSTEM command, SAD 7-10
archived redo log, SCN 1-48
automatic archiving, SCN 32-19
automatic versus manual, SRF 1-66
enabling, SCN 32-18
manual archiving, SCN 32-20
storage device, SRF 1-60, SRF 1-64
archived redo log files
location of, SQL 7-13
storage locations, SQL 7-83
archived redo logs, SAD 7-2, SBR 2-14, SBR 2-18, SBR 2-21
ALTER SYSTEM ARCHIVE ALL command, SBR 3-5
analyzing, SAD 7-25
applying during media recovery, SBR 14-10, SBR 14-14
archiving modes, SAD 7-7
automatic archiving, SAD 7-8
backing up, SBR 8-19
copies, listing, SBR 7-2
deleting after recovery, SBR 14-8
destination states, SAD 7-13, SBR 16-11
active/inactive, SAD 7-14
bad param, SAD 7-14
deferred, SAD 7-14
enabled/disabled, SAD 7-13
valid/invalid, SAD 7-13
destinations
re-archiving to failed, SAD 7-19, SBR 16-11
sample scenarios, SAD 7-18
enabling automatic archiving, SAD 7-8
errors during recovery, SBR 14-16
failed destinations and, SAD 7-16
location during recovery, SBR 14-10
loss of, SBR 15-10
multiplexing, SAD 7-11, SBR 2-19, SBR 16-10
normal transmission of, SAD 7-14, SBR 2-21
registering, SBR 6-5
restoring to disk, SBR 14-7
restoring using RMAN, SBR 9-13
specifying destinations for, SAD 7-11, SBR 2-19
standby transmission of, SAD 7-14, SBR 2-21
status information, SAD 7-24, SBR 2-4, SBR 2-18
transmitting, SAD 7-14, SBR 2-21, SBR 16-7
tuning, SAD 7-20
archivelog backups
using RMAN, SBR 8-8
ARCHIVELOG clause
of ALTER DATABASE, SQL 7-9, SQL 7-17
of CREATE CONTROLFILE, SQL 7-248
ARCHIVELOG mode, SAD 7-4, SAD 7-6, SBR 2-16, SPS 14-9
advantages, SAD 7-5, SBR 2-17
archiver process (ARCn) and, SCN 1-19, SCN 8-12, SCN 32-18
archiving, SAD 7-4, SBR 2-15
archiving destination, SRF 1-60, SRF 1-64
automatic archiving, SPS 4-6, SPS 21-3, SRF 1-66
automatic archiving in, SAD 7-5
backup options, SBR 3-20
backup strategies when using, SBR 3-16
changing mode, SPS 14-2, SPS 14-9, SPS B-2
creating a database, SPS 14-2
datafile loss in, SBR 15-3
defined, SCN 32-18
definition of, SAD 7-4, SBR 2-16
distributed databases, SAD 7-6, SBR 3-22
enabling, SAD 7-7
manual archiving in, SAD 7-5
online and offline backups, SPS 4-6, SPS 21-3
overview, SBR 1-10, SCN 1-48
partial database backups, SCN 1-50, SCN 32-24
running in, SAD 7-4, SBR 2-16
strategies for backups in, SBR 3-16
switching to, SAD 7-7
taking datafiles offline and online in, SAD 10-8
whole database backups, SCN 32-24
archivelogRecoverSpecifier clause (RMAN), SBR 11-17
archiver process (ARCn)
automatic archiving, SCN 32-19
described, SCN 1-19, SCN 8-12
example, SCN 32-18
multiple processes, SCN 1-19, SCN 8-12
not used for manual archiving, SCN 32-21
trace file, SCN 32-20
archiving
advantages, SAD 7-4, SBR 2-15
after inconsistent closed backups, SBR 3-5
after open backups, SBR 3-5
ALTER SYSTEM ARCHIVE ALL, SBR 3-5
automatic
disabling, SAD 7-9
disabling at instance startup, SAD 7-9
enabling, SAD 7-8
enabling after instance startup, SAD 7-9
enabling at instance startup, SAD 7-9
changing archiving mode, SAD 7-7
destination states, SAD 7-13, SBR 16-11
active/inactive, SAD 7-14
enabled/disabled, SAD 7-13
valid/invalid, SAD 7-13
destinations
failure, SAD 7-16
disabling, SAD 7-7
disadvantages, SAD 7-4, SBR 2-15
enabling, SAD 7-7, SAD 7-9
error detection behavior, MIG 8-43
increasing speed of, SAD 7-23
manual, SAD 7-10
minimizing impact on system performance, SAD 7-23
multiple ARCH processes, SAD 7-20
privileges
disabling, SAD 7-9
enabling, SAD 7-8
for manual archiving, SAD 7-10
setting archive buffer parameters, SAD 7-22
setting initial mode, SAD 7-7
to failed destinations, SAD 7-19, SBR 16-11
tuning, SAD 7-20
viewing information on, SAD 7-24, SBR 2-4, SBR 2-18
archiving redo log files, SPS 21-1
automatic versus manual, SPS 21-3
conversion to multi-instance, SPS 23-3
creating a database, SPS 14-2
forcing a log switch, SPS 21-10
history, SPS 21-6
identified in control file, SPS 6-5
log sequence number, SPS 21-5
online archiving, SPS 4-6, SPS 21-3
ARCHVIELOG clause
OF CREATE DATABASE, SQL 7-252
ARCn background process, SCN 1-19, SCN 8-12
See also archiver process
ARGS parameter, NET 6-78
arguments
attributes, OCI 6-16
arguments of operators, SQL 3-1
ARGV0 parameter, NET 6-78
arithmetic operators, SQL 3-3
array interface, STU 22-2
array of structs, PC_ 8-17, PC_ A-2
array processing, SCN 16-13
ARRAYLEN statement, PC_ 7-17, PCO 6-17
arrays, ADG 16 - 28
batch fetch, PC_ 8-5
BIND_ARRAY procedure, SPR 48 - 6
binds, OCI 12-3
bulk DML using DBMS_SQL, SPR 48 - 15
bulk operations (ANSI dynamic SQL), PC_ 14-8
chapter discusses how to use, PC_ 8-1
committing after insert
Import, SUT 2-20
defines, OCI 12-6
definition of, PC_ 4-41
host arrays, PC_ 2-7
operations, PC_ 2-7
size of VARRAYs, SCN 13-11
skip parameter for, OCI 5-20
variable (VARRAYs), SCN 13-11
varying length, PC_ 18-3
arrays of structures, OCI 5-17
indicator variables, OCI 5-20
OCI calls used, OCI 5-20
skip parameters, OCI 5-18
AS 'filespec' clause
of CREATE LIBRARY, SQL 7-298
AS clause
of CREATE JAVA, SQL 7-295
AS EXTERNAL clause
of CREATE FUNCTION, SQL 7-271, SQL 7-336
of CREATE TYPE BODY, SQL 7-424
AS OBJECT clause
of CREATE TYPE, SQL 7-414
AS SELECT option
CREATE TABLE command, SBR 14-4
AS subquery
of CREATE MATERIALIZED VIEW / SNAPSHOT, SQL 7-300, SQL 7-307
of CREATE TABLE, SQL 7-384
of CREATE VIEW, SQL 7-433
AS TABLE clause
of CREATE TYPE, SQL 7-418
AS VARRAY clause
of CREATE TYPE, SQL 7-417
ASACC precompiler option, PCO 14-12
ASC clause
of CREATE INDEX, SQL 7-281
ascending indexes, SQL 7-281
ASCII
character set, SQL 2-29
fixed-format files
exporting, SUT 1-4
function, SQL 4-6
ASCII character set
Import, SUT 2-56
sorting order, NLS 2-25
ASIN function, SQL 4-7
A.SMD record, NET 6-68, NET 8-17, NET A-45
assigning
update conflict resolution methods, REP 6-17
assigning new pincode to SecurID card, OAS 6-15
assignment
aggregate, PLS 2-33
character string, PLS B-2
collection, PLS 4-11
cursor variable, PLS 5-31
field, PLS 4-42
record, PLS 4-42
semantics, PLS B-2
assignment operator, PLS 1-4
assignment statement
syntax, PLS 11-3
ASSOCIATE STATISTICS statement, SQL 7-194
association operator, PLS 7-13
associations
downgrading, MIG 12-35
associative interface, PC_ 17-4
when to use, PC_ 17-4
ASSUME_SQLCODE precompiler option, PCO 14-13
AST, SPS 8-2
asterisk (*) option, PLS 5-3
asymmetrical multiprocessing, SPS 2-5
Asynchronous, ADQ 1-10
asynchronous
DDL, SPR 34 - 57, RAR 8-138
replication, REP 2-3
RPCs, REP 9-2
asynchronous (challenge-response) authentication mode in RADIUS, OAS 3-5
asynchronous data operations, NET 2-4
asynchronous I/O, STU 26-29
parallel recovery and, SCN 32-11
asynchronous operation, PLS 8-16
asynchronous processing, SCN 19-2
asynchronous trap, SPS 8-2, SPS 8-3, SPS 8-4
AT clause
CONNECT statement, PCO 3-6
DECLARE CURSOR statement, PCO 3-7
DECLARE STATEMENT statement, PCO 3-8
EXECUTE IMMEDIATE statement, PCO 3-8
in CONNECT statement, PC_ 3-9
in DECLARE CURSOR statement, PC_ 3-10
in DECLARE STATEMENT statement, PC_ 3-12
in EXECUTE IMMEDIATE statement, PC_ 3-11
of COMMIT statement, PC_ F-25, PCO F-16
of CONNECT statement, PCO F-18
of DECLARE CURSOR directive, PC_ F-36, PCO F-24
of DECLARE STATEMENT directive, PC_ F-39, PCO F-28
of EXECUTE IMMEDIATE statement, PC_ F-57, PCO F-44
of EXECUTE statement, PC_ F-52, PCO F-39
of INSERT statement, PC_ F-70
of INSERT statements, PCO F-55
of SAVEPOINT statement, PC_ F-103, PCO F-78
of SELECT statement, PC_ F-106, PCO F-81
of UPDATE statement, PC_ F-114, PCO F-86
restriction on, PC_ 3-11
restrictions, PCO 3-7
use of, PC_ 3-10
ATAN function, SQL 4-7
ATAN2 function, SQL 4-8
atomic nullness, OCI 10-29
atomic nulls, SCN 14-3, SUT 5-94
atomically null, PLS 9-23
attack
data modification, OAS 2-5
replay, OAS 2-5
Attempts Per Names Server option, NET 6-39
ATTRIBUTE clause
of ALTER DIMENSION, SQL 7-25
of CREATE DIMENSION, SQL 7-262
attribute descriptor object, OCI 11-23
attribute indicator, PLS 1-7
attribute nulls, SUT 5-93
attributes, PLS 1-7, STU 30-4
%ROWTYPE, PLS 2-32
%TYPE, PLS 2-31
adding to a dimension, SQL 7-26
cursor, PLS 5-34
dropping from a dimension, SQL 7-26
leaf-level, SCN 14-18
leaf-level scalar, SCN 14-18
maximum number of in object type, SQL 7-368
object, PLS 9-3, PLS 9-7
of dimensions, defining, SQL 7-262
of handles, OCI 2-12
of objects, OCI 10-17
of parameter descriptors, OCI 6-5
of parameters, OCI 6-5
attributes for resources
client resource, LEG 2-20, LEG 2-21, LEG 2-22
server resource, LEG 2-25, LEG 2-26
storage device resource, LEG 3-5
volume pool resource, LEG 3-12
attributes of a collection
descriptions, PC_ 18-15
attributes of object type, DCI 1-15, DCI 11-2
referencing in method, DCI 5-5
attributes of object types, SCN 13-2, SCN 13-4
AUD, SMS 47-1
AUDIT (Schema Objects) statement, SQL 7-205
AUDIT ANY system privilege, SQL 7-502
AUDIT command, SAD 25-9, SCN 16-4
locks, SCN 27-29
schema objects, SAD 25-11
statement auditing, SAD 25-10
system privileges, SAD 25-10
AUDIT sql_statements statement, SQL 7-197
AUDIT SYSTEM system privilege, SQL 7-495
audit trail, SAD 25-14, STU 12-4
archiving, SAD 25-15
auditing changes to, SAD 25-16
controlling size of, SAD 25-14
creating and deleting, SAD 25-4
deleting data in dictionary, SCN 2-5
deleting views, SAD 25-5
described, NET 11-25
interpreting, SAD 25-17
maximum size of, SAD 25-14
protecting integrity of, SAD 25-16
purging records from, SAD 25-15
recording changes to, SAD 25-16
records in, SAD 25-7
reducing size of, SAD 25-16
script for using information, NET 11-26
table that holds, SAD 25-2
views on, SAD 25-4
AUDIT_ACTIONS table, SRF 2-68
AUDIT_FILE_DEST parameter, SRF 1-15
AUDIT_TRAIL initialization parameter
migration, MIG A-3
AUDIT_TRAIL parameter, SRF 1-15
setting, SAD 25-13
auditing, REP 7-18, SAD 25-2, SCN 1-44, SCN 31-1
AUDIT command, SAD 25-9
audit option levels, SAD 25-8
audit options, SCN 31-3
audit records, SCN 31-3
audit trail records, SAD 25-5
audit trails, SCN 31-3
database, SCN 31-3
operating system, SCN 31-5, SCN 31-6
by access, SCN 31-11
mandated for, SCN 31-12
by session, SCN 31-10
prohibited with, SCN 31-12
conflict resolution, REP 7-18
connect with administrator privileges, SCN 31-5
data dictionary used for, SCN 2-5
database and OS usernames, SCN 29-4
DDL statements, SCN 31-7
default options, SAD 25-11
described, SCN 1-44, SCN 31-2
disabling default options, SAD 25-13
disabling options, SAD 25-11, SAD 25-12, SAD 25-13
disabling options versus auditing, SAD 25-12
distributed databases and, SCN 31-6
DML statements, SCN 31-7
enabling options, SAD 25-9, SAD 25-13
enabling options versus auditing, SAD 25-10
guidelines, SAD 25-2
historical information, SAD 25-4
keeping information manageable, SAD 25-2
managing the audit trail, SAD 25-4
operating-system audit trails, SAD 25-7
partitioned tables and indexes, SCN 11-63
policies for, SAD 22-18
privilege audit options, SAD 25-9
privilege use, SCN 31-2, SCN 31-7
privileges required for object, SAD 25-11
privileges required for system, SAD 25-10
range of focus, SCN 31-3, SCN 31-9
schema object, SCN 31-2, SCN 31-8
schema objects, SAD 25-11
stopping, SQL 7-525
security and, SCN 31-6
session level, SAD 25-8
shortcuts for object, SAD 25-9
shortcuts for system, SAD 25-8
SQL statements, SQL 7-200
SQL statements, stopping, SQL 7-523
startup and shutdown, SCN 31-5
statement, SAD 25-10, SCN 31-2, SCN 31-7
statement level, SAD 25-8
successful executions, SCN 31-9
suspicious activity, SAD 25-3
system privileges, SAD 25-10
transaction independence, SCN 31-4
triggers and, ADG 13 - 34, SAD 25-20
types of, SCN 31-2
unsuccessful executions, SCN 31-9
user, SCN 31-12
using the database, SAD 25-2
viewing
active object options, SAD 25-19
active privilege options, SAD 25-18
active statement options, SAD 25-18
default object options, SAD 25-19
views, SAD 25-4
when options take effect, SCN 31-6
auditing options
for database objects, SQL 7-200
for SQL statements, SQL 7-202
AUTHENTICATED BY, DDS 2-8
AUTHENTICATED BY clause
of CREATE DATABASE LINK, SQL 7-257
authenticated RPC, protocol adapter includes, OAS 11-3
authenticating remote clients, SRF 1-107
authenticating users, SRF 1-92
authentication, OAS 1-5
biometric, OAS 7-1
centralized, OAS 1-5
database administrators, SCN 29-12
database managed, SAD 23-8
described, SCN 29-3
multi-tier, SCN 29-9
network, SCN 29-4
operating system, SAD 1-7, SCN 29-4
Oracle, SCN 29-7
password file, SAD 1-9, SPS 18-26
password policy, SAD 22-4
public key infrastructure, SCN 29-5
remote, SCN 29-6
specifying when creating a user, SAD 23-12
users, SAD 22-2, SAD 23-7, SAD 23-9
authentication adapters, OAS 1-10
authentication management, OCI 8-10
authentication modes in RADIUS, OAS 3-4
authentication, using Oracle Advanced Security, NET 7-28
AUTHENTICATION_LEVEL parameter, NET C-78
AUTHID clause, PLS 7-32
AUTHID CURRENT_USER clause
of ALTER JAVA, SQL 7-44
of CREATE FUNCTION, SQL 7-270
of CREATE JAVA, SQL 7-294
of CREATE PACKAGE, SQL 7-325
of CREATE PROCEDURE, SQL 7-335
of CREATE TYPE, SQL 7-415
AUTHID DEFINER clause
of ALTER JAVA, SQL 7-44
of CREATE FUNCTION, SQL 7-270
of CREATE JAVA, SQL 7-294
of CREATE PACKAGE, SQL 7-325
of CREATE PROCEDURE, SQL 7-335
of CREATE TYPE, SQL 7-415
authorization, OAS 1-9, OAS 9-11, OAS Glossary-1
changing for roles, SAD 24-8
omitting for roles, SAD 24-8
operating-system role management and, SAD 24-7
roles
about, SAD 24-6
multi-threaded server and, SAD 24-7
authorize functions, OCI 15-87
authorize template users, RAR 4-10
auto media management
enabled behavior, LEG 3-19
for tape devices, LEG 3-19
not enabled, LEG 3-19, LEG 3-23
AUTO_CONNECT, PC_ 10-11
precompiler option, PC_ 3-5
AUTO_CONNECT option
instead of CONNECT statement, PCO 3-11
AUTO_CONNECT precompiler option, PC_ 10-11, PCO 14-14
auto-discovery
DB_NAME.CONF file, PSC C-4
errors, PSC C-3
LISTENER.ORA file, PSC C-6
NMICONF.LOG file, PSC C-9
NMICONF.LST file, PSC C-10
on UNIX, PSC C-4
on Windows NT, PSC C-5
performing, PSC 5-18
PM\DB_NAME registry key, PSC C-5
SERVICES.ORA file, PSC C-9
SID_LIST_listener_name parameter, PSC C-6
TNSNAMES.ORA file, PSC C-7
troubleshooting, PSC C-10
understanding, PSC C-3
AUTOEXTEND, SPS 15-9, STU 20-28
AUTOEXTEND clause
for datafiles, SQL 7-17
of ALTER DATABASE, SQL 7-10
of ALTER TABLESPACE, SQL 7-165, SQL 7-167
of CREATE DATABASE, SQL 7-250
of CREATE TABLESPACE, SQL 7-393, SQL 7-395
of CREATE TEMPORARY TABLESPACE, SQL 7-398, SQL 7-399
Automated, ADQ 1-13
automated parallel query tuning, GTK 2-27
Automated Standby Database, SCN 32-26
automated standby databases, GTK 2-50
automatic archival, GTK 2-50
read-only databases, GTK 2-51
automatic archiving, SPS 21-3
archive log destination, SAD 7-8
automatic bootstrap backup, LEG 2-5, LEG 4-5
automatic conflict resolution
versus manual, REP 6-7
automatic connections, PC_ 3-4, PC_ 3-8
automatic instance registration, Net8, GTK 2-76
automatic logons, PCO 3-5, PCO 3-10
automatic recovery, SPS 21-7
automatic refreshes
refresh interval, REP 3-24
AUTOMATIC_IPC parameter, NET 4-20, NET 5-19, NET 7-26
autonomous PL/SQL blocks, GTK 2-78
autonomous routine, ADG 8 - 33
autonomous scope
versus autonomous transaction, ADG 8 - 33
autonomous transaction, PLS 5-52
advantages, PLS 5-52
controlling, PLS 5-56
autonomous transactions, ADG 8 - 33
compatibility, MIG 8-14
defining, ADG 8 - 41
AUTONOMOUS_TRANSACTION, ADG 8 - 33
AUTONOMOUS_TRANSACTION pragma, PLS 5-53
AUTORECOVERY option
SET command, SBR 14-12
auxiliary databases
for RMAN TSPITR
converted filenames, SBR A-15
using datafile copies, SBR A-14
auxiliary sets
for RMAN TSPTIR, SBR A-4
naming datafiles in tablespaces, SBR A-13
availability, SPS 12-1
and interconnect, SPS 3-3
benefit of parallel databases, SPS 1-14
data files, SPS 6-2, SPS 22-4
multiple databases, SPS 1-19
phases of recovery, SPS 22-5
shared disk systems, SPS 3-6
single-node failure, SPS 2-12, SPS 22-2
available option (RMAN)
change command, SBR 6-8
average
conflict resolution method
use of, REP 6-39
Average Elapsed Time data view, STU 15-10
average prebuilt conflict resolution method, RAR 6-10, REP 6-18
AVG aggregate function, PLS 5-3
AVG function, SQL 4-8
avoiding dangerous backup techniques, SBR 3-23
avoiding delete conflicts, RAR 6-24
AY date format element, SQL 2-41



Prev

Top

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index