Oracle8i Generic Documentation Master Index
Release 2 (8.1.6)

A76991-01

Library

Product

Contents

Prev Up Next

Oracle8i Generic Documentation Master Index


A

abbreviations
AM/PM, NLS 2-17
BC/AD, NLS 2-17
languages, NLS A-2
abbreviations permitted, PCO 2-11
abnormal termination
automatic rollback, PC_ F-26, PCO F-17
abort mode, warning notice, PSG 7-10
ABORT option
SHUTDOWN statement, SBR 1-17, SBR 5-15, SBR 5-16, SBR 5-25, SBR 6-13
abort response, DDS 4-13
two-phase commit, DDS 4-13
aborted save set, LEG 2-8
ABORTED_REQUEST_THRESHOLD procedure, STU 19-26
aborting an instance, SAD 3-13, SCN 5-10, SCN 344
aborting OCI calls, OCI 2-34
ABS function, SQL 4-12
ABSI
standards, SQL B - 1
absolute file number, PSC 7-3
abstract data type
representing in C applications, OCI 10-8
abstract object class type, OID 2-9
abstract object classes, OID 2-9
super classes of, OID 6-3
top, OID 2-8
abstraction, PLS 7-3, PLS 9-2
ACCEPT_CONNECTIONS command, NET A-81
access
data
managing, SAD 23-1
system privileges, SAD 23-2
database, ADG 11-28, ADG 11-29
granting privileges, SAD 23-10
granting
by using command line tools, OID 9-47
by using Oracle Directory Manager, OID 9-16
entry-level, by using command line tools
entry-level, by using Oracle Directory Manager, OID 9-47
to everyone, using Oracle Directory Manager, OID 9-24, OID 9-31
to specific groups, using Oracle Directory Manager, OID 9-24, OID 9-31
to subtrees, OID 9-24, OID 9-31
kinds, OID 9-9
level, required for LDAP operations, OID 9-15
object, OID 9-6
granting privileges, SAD 23-11
revoking privileges, SAD 23-14
objects
sequences, ADG 2-30
operations, OID 9-9
rights, setting by using Oracle Directory Manager, OID 9-25, OID 9-32
schema objects, ADG 11-30, ADG 11-31
remote integrity constraints, ADG 4-14
triggers, ADG 13-3, ADG 13-48
selecting, by DN, OID 9-49
subject, OID 9-8
unspecified, OID 9-36
violation event, OID 5-27
Access control, ADQ 4-5
access control, OID 1-5, OID 2-20, OID 2-25, OID 9-1, SCN 304
discretionary, SCN 1-38
fine-grained access control, SCN 325
managing
by using command line tools, OID 9-47
by using Oracle Directory Manager, OID 9-16
no authentication, OID 9-24, OID 9-30
password encryption, SCN 285
policies
conflicting, OID 9-3
inheriting, OID 9-3
prescriptive, OID 1-5
privileges, SCN 304
roles, SCN 319
setting, using wild cards, OID 9-49
simple, OID 9-24, OID 9-30
SSL no authentication, OID 9-24, OID 9-30
SSL one-way authentication, OID 9-24, OID 9-30
SSL two-way authentication, OID 9-24, OID 9-30
access control directive format. See ACI Directive format.
Access Control Information Item (ACI), OID 2-25
attributes, OID 2-25
components, OID 9-6
format, OID E-1
object of directives, OID 9-6
subject of directives, OID 9-8
syntax, OID E-1
Access Control Lists (ACLs), OID 2-25, OID 2-33
described, NET 2-51
evaluation, OID 9-10
for groups, OID 9-15
precedence rules, OID 9-11
in orclACI, OID 9-2
modification, OID 5-27
Access Control Policy Points (ACPs), OID 9-3, OID 9-17
adding
by using ldapmodify, OID 9-48
by using Oracle Directory Manager, OID 9-35
administering, using Oracle Directory Manager, OID 4-13
content access items, OID 9-20
creating, using Oracle Directory Manager, OID 4-11
multiple, OID 9-3
structural access items, OID 9-20
viewing, using Oracle Directory Manager, OID 9-17
access control to database
with Oracle Connection Manager, NET 8-35
with protocol.ora, NET C-77
access control, prescriptive, OID 9-3
Access Control, System Level, ADQ 8-5
access items
content, OID 9-20
structural, OID 9-20
access methods, STU 4-20
cluster scans, STU 4-22
execution plans, SCN 124, STU 4-5
hash scans, STU 4-22
index scans, STU 4-22
table scans, STU 4-21
access path, STU 2-11
access paths
cluster join, STU 4-38
composite index, STU 4-39
defined, SCN 127, STU 4-7
hash cluster key, STU 4-38
indexed cluster key, STU 4-39
optimization, STU 4-20
single row by cluster join, STU 4-36
single row by hash cluster key (with unique key), STU 4-36
single row by rowid, STU 4-35
single row by unique or primary key, STU 4-37
access privileges, SUT 2-10
Export, SUT 1-4
ACCESS_INTO_NULL exception, PLS 6-5
accessing external LOBs, ADL 11-5
ACCOUNT LOCK clause
of ALTER USER. See CREATE USER
of CREATE USER, SQL 7-453
ACCOUNT UNLOCK clause
of ALTER USER. See CREATE USER
of ALTER USER. See CREATE USER.
of CREATE USER, SQL 7-453
accounting, RADIUS, OAS 4-22
accounts
creating for snapshots, REP 3-32
operating system
database administrator, SAD 1-4
operating-system
role identification, SAD 23-20
user
SYS and SYSTEM, SAD 1-4
ACI Directive format, OID 2-25
ACI directives, OID 2-25
ACI Items. See Access Control Information Item (ACI).
ACI. see Access Control Information Item (ACI)
ACIs. See Access Control Information Item (ACI).
ACL directives
within entries, OID 9-3
within subtrees, OID 9-2
ACLs. See Access Control Lists (ACLs).
ACOS function, SQL 4-13
ACPs. See Access Control Policy Points (ACPs).
acquiring rollback segments, PSA 3-5
distributed locks, SRF 1-42
initialization parameters, PSC 7-7
acquisition AST, PSC 5-27, PSC 5-30
ACT parameter, NET 8-36, NET C-76
ACTIVATE STANDBY DATABASE clause
of ALTER DATABASE, SQL 7-11
activating
standby databases, SBY 1-12, SBY 3-20
consequences, SBY 1-14
activating checksumming and encryption, OAS 2-7
Active Data Object
translating to PSP, ADG 12-3
active destination state
for archived redo logs, SAD 7-13
active online redo log
loss of group, SBR 6-10
active server instances
modifying configuration set entries in, OID 5-4
viewing, OID 5-4
Active Server Pages, ADO 3-9
translating to PSP, ADG 12-3
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-7
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 9-24
ACTIVE_DELAYS, NET A-94
ACTIVE_INSTANCE_COUNT, PSC 9-18
ACTIVE_INSTANCE_COUNT initialization parameter, SRF 1-12
ACTIVE_INSTANCE_COUNT parameter, PSA 1-8, PSG 5-6
ActiveX, ADO 3-9
actual parameters, PLS 5-8
AD (A.D.) date format element, SQL 2-46, SQL 2-48
Ada. See SQL*Module for Ada
adapters, OAS 1-11
adaptive multi-user
algorithm for, DWG 18-6
definition, DWG 18-6
adaptive multi-user feature, PSA 2-6
Add a Subscriber, ADQ 9-53
ADD clause
of ALTER DIMENSION, SQL 7-27
of ALTER TABLE, SQL 7-140
ADD DATAFILE clause
of ALTER TABLESPACE, SQL 7-179
ADD LOGFILE clause
of ALTER DATABASE, SQL 7-9
THREAD clause, PSC 7-3
thread required, PSA 3-7
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 statement, SAD 6-12
ADD LOGFILE option
ALTER DATABASE statement, SAD 6-11
ADD LOGFILE THREAD clause
of ALTER DATABASE, SQL 7-18
ADD OVERFLOW clause
of ALTER TABLE, SQL 7-155
ADD PARTITION, SQL 7-160
ADD PARTITION clause, SAD 15-14
of ALTER TABLE, SQL 7-158, SQL 7-160
ADD PRIMARY KEY clause
of ALTER MATERIALIZED VIEW LOG, SQL 7-61
ADD ROWID clause
of ALTER MATERIALIZED VIEW, SQL 7-61
of ALTER MATERIALIZED VIEW LOG, SQL 7-61
ADD SUBPARTITION clause, SAD 15-15
ADD TEMPFILE clause
of ALTER TABLESPACE, SQL 7-179
ADD_MONTHS function, SQL 4-13
ADD_POLICY procedure, ADG 11-38
addCertChain(byte[]) - oracle.security.ssl.OracleSSLCredential.addCertChain(byte[]), OAS F-22
addCertChain(String) - oracle.security.ssl.OracleSSLCredential.addCertChain(java.lang.String), OAS F-22
ADDED_EXTENTS, PSC A-12
adding
ACPs, OID 9-35
by using ldapmodify, OID 9-48
by using Oracle Directory Manager, OID 9-35
attributes
by copying an existing attribute, OID 6-28
by using Oracle Directory Manager, OID 6-24
guidelines for, OID 6-18
attributes to existing entries, OID A-7
audit log entries, OID 5-24
audit log event, OID 5-27
configuration set entries, OID 2-32, OID 5-12
by using command line tools, OID 2-32, OID 7-25
by using Oracle Directory Manager, OID 2-32
using Oracle Directory Manager, OID 5-4
configuration set entry, OID 5-2
datafiles, SBY 4-10, SBY 5-22, SBY 5-47
DSA to replicating system, OID B-1
entries, OID 7-12, OID 7-25
by copying an existing entry, OID 7-15
concurrently, OID 4-14, OID A-9
requires write access to parent, OID 7-12
requires write access to parents, OID 7-15
using ldapadd, OID 4-14, OID A-7
using ldapaddmt, OID A-9
using Oracle Directory Manager, OID 7-12
entry-level ACIs, by using ldapmodify, OID 9-49
group entries, by using Oracle Directory Manager, OID 7-20
input files, OID 5-13
mandatory attributes
to an existing object class, OID 6-4
to an object class in use, OID 7-22
multiple entries, using command line tools, OID 7-25
object classes, OID 6-2
using command line tools, OID 6-17
using Oracle Directory Manager, OID 6-13
objects
by using a template, OID 4-12
by using Oracle Directory Manager, OID 4-10, OID 4-12
redo logs, SBY 4-12, SBY 5-25
replication nodes, OID 10-18
user entries, by using Oracle Directory Manager, OID 7-18
adding a file, PSA 3-8, PSC A-20
adding nodes to a cluster, PSG 9-7
additional directory servers, connecting to, OID 4-12
additive conflict resolution method, REP 5-15
add.log, OID A-9
address, PLS 5-16
ADDRESS (ADD or ADDR) attribute, NET 9-4
ADDRESS parameter, NET B-2, NET C-38, NET C-49
ADDRESS_LIST parameter, NET B-2, NET C-38, NET C-49
addresses, configuring, NET 7-6
addTrustedCert(byte[]) - oracle.security.ssl.OracleSSLCredential.addTrustedCert(byte[]), OAS F-22
addTrustedCert(String) - oracle.security.ssl.OracleSSLCredential.addTrustedCert(java.lang.String), OAS F-22
ADMIN OPTION
about, SAD 23-11
revoking roles/privileges, SAD 23-13
roles, SCN 322
system privileges, SCN 305
with EXECUTE ANY TYPE, ADO 2-11
ADMIN_TABLES procedure, SAD 20-3, SAD 20-4
examples
building orphan key table, SAD 20-10
building repair table, SAD 20-9
ADMINISTER ANY TRIGGER system privilege, SQL 7-527
ADMINISTER_RESOURCE_MANAGER system privilege, SAD 25-3
administering instances
with initialization parameter files, PSG 4-4
with Oracle Parallel Server Management, PSG 7-2
administering schema objects, using Oracle Directory Manager, OID 4-13
administration
distributed databases, DDS 2-1
tools, DDS 1-31
administration tools, OID 4-14
bulk tools, OID 4-15
bulkdelete, OID A-25
bulkload, OID A-20
bulkmodify, OID A-23
Catalog Management, OID 4-16
command line, OID 1-4, OID 4-14
ldapadd, OID 4-14, OID A-7
ldapaddmt, OID A-9
ldapbind, OID A-6
ldapcompare, OID A-17
ldapdelete, OID 4-14, OID A-16
ldapmoddn, OID 4-14, OID A-18
ldapmodify, OID 4-14, OID A-11
ldapmodifymt, OID 4-14, OID A-14
ldapsearch, OID A-4
ldifwrite, OID A-21
OID Password Utility, OID 4-16
Oracle Directory Manager, OID 4-2
administrative context, OAS 17-6
described, NET 2-41
selecting, NET 6-19
Administrative Interface, ADQ 9-1
Views, ADQ 10-1
Administrative Interface, Views, ADQ 10-2
administrative queue, REP 2-24
administrative regions
defined, NET 6-47
delegated, NET 4-19
delegated, below root, NET 4-21
delegating domains, NET 6-73
described, NET 4-12
in Oracle Names, NET 4-12
root, NET 4-19
administrative requests, REP 2-22
states, REP 2-25
awaiting callback, REP 2-25
do callback, REP 2-25
error, REP 2-25
ready, REP 2-25
administrator
for replication
creating, RAR 2-4
for snapshot sites
creating, RAR 2-16
Administrator GUI, LSM
Clients Window on UNIX, LEG 2-21
Devices Window on UNIX, LEG 3-4
Devices Window on Windows NT, LEG 3-6
Edit Client Dialog Box on Windows, LEG 2-23
Edit Group Dialog Box on Windows, LEG 4-8, LEG 4-10
Groups Window on UNIX, LEG 4-8
labeling a volume on UNIX, LEG 3-14
labeling a volume on Windows, LEG 3-15
Messages display on UNIX, LEG 4-12
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-24
Sessions display on UNIX, LEG 4-12
Set Up Server Dialog Box on Windows, LEG 2-25
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 333
OUTLN schema, SCN 129
statement execution not audited, SCN 332
Administrator Role, ADQ 4-6
administrators
application, SAD 1-3
administrators, LSM
acceptable names, LEG 2-28
administrator server attribute, LEG 2-26, LEG 2-27
modifying on UNIX, LEG 2-29
modifying on Windows NT, LEG 2-30
server resource attributes, LEG 2-26, LEG 2-27
specifying, LEG 2-27
using wildcard to grant privileges, LEG 2-29
ADO. See attribute descriptor object
Adt Message, ADQ 12-28
ADT. See abstract data type
AdtMessage - oracle.jms.AdtMessage, JPR 2-5
Advanced Networking Option, GTK 3-70
Advanced Program-to-Program Communication (APPC), NET 4-4
Advanced Queueing
dequeue function, OCI 15-5
description, OCI 9-27
enqueue function, OCI 15-7
examples, OCI 15-8
OCI and, OCI 9-27
OCI descriptors for, OCI 9-27
OCI functions for, OCI 9-27
OCI vs. PL/SQL, OCI 9-28
Advanced Queuing, GTK 3-37 to GTK 3-40, GTK 4-6, SCN 65
administrative interface, SPR 4-11
privileges and access control, ADQ 4-5
agents, SCN 70
compatibility, MIG 9-13, MIG 9-32
message streaming, MIG 9-32
privileges, MIG 9-32
rule based subscriptions, MIG 9-32
creation of queue tables and queues, ADQ A-4
database event publication, GTK 3-39
DBMS_AQADM package, SPR 5-1, ADQ 4-4
DEQUEUE request, SCN 74
downgrading queue tables, MIG 13-39
event publication, SCN 99
exception handling, SCN 78
exception queues, SCN 70
exporting advanced queue tables, SUT 1-59
exporting queue tables, SCN 79
extended address field, MIG 7-31
features, SCN 73, ADQ viii
correlation identifier, ADQ 1-10
exception handling, ADQ 1-14
integrated database level support, ADQ 1-7
integrated transactions, ADQ 1-8
local and remote recipients, ADQ 1-13
message grouping, ADQ 1-11
modes of dequeuing, ADQ 1-13
multiple recipients, ADQ 1-13
navigation of messages in dequeuing, ADQ 1-13
optimization of waiting for messages, ADQ 1-14
optional transaction protection, ADQ 1-14
priority and ordering of messages in enqueuing, ADQ 1-11
propagation, ADQ 1-12
retention and message history, ADQ 1-8
retries with delays, ADQ 1-14
sender identification, ADQ 1-12
structured payload, ADQ 1-7
subscription & recipient list, ADQ 1-10
time specification, ADQ 1-12
tracking and event journals, ADQ 1-8
importing advanced queue tables, SUT 2-58
interoperability, MIG 9-32
sender's ID column, MIG 9-32
message properties, ADQ 2-3
message queuing, SCN 66
messages, SCN 70
multiple consumer queues, GTK 3-39
nonpersistent queues, GTK 3-40
object level and system level privileges, GTK 3-39
object type support, GTK 2-5
parallel server mode, GTK 3-40
point-to-point model, SCN 68
propagation, enhanced, GTK 3-39
addition of a sender's ID column, GTK 3-39
history management information, GTK 3-39
single view, GTK 3-39
statistics, GTK 3-39
publish-subscribe model, SCN 69
publish-subscribe support, SCN 77, SCN 99
queue monitor, SCN 72
queue monitor process, SCN 1-19, SCN 8-14, SCN 72
interval statistics, SCN 78
window of execution, SCN 73
queue tables, SCN 70
downgrading, MIG 13-39
recipients, SCN 71
rule-based subscriptions, SCN 72
subscription lists, SCN 71
remote databases, SCN 76
removing incompatibilities
downgrading, MIG 13-35
removing propagation, MIG 13-40
revoking object and system level privileges, MIG 13-38
revoking roles and privelieges, ADQ A-68
rules, SCN 72
rules engine, GTK 3-38
scripts
CATNOQUE.SQL, MIG 7-33
CATQUEUE.SQL, MIG 7-33
subscribers, SCN 71
upgrading, MIG 7-31
user queues, SCN 70
see also publish/subscribe
advanced queuing functions, OCI 15-4
Advanced Queuing, basics, ADQ 7-3
Advanced Queuing, multiple-consumer dequeuing of one message, ADQ 7-6
advanced replication, GTK 3-64 to GTK 3-66
column level snapshot subsetting, GTK 3-65
internal apply packages, GTK 3-64
mass deployment support, GTK 3-65
offline snapshot instantiation, GTK 3-65
Oracle Lite integration, improved, GTK 3-66
Replication Manager, GTK 3-66
security, improved, GTK 3-66
snapshot deployment templates, parameterized, GTK 3-65
snapshot refresh, GTK 3-64
Advanced Security option. See Oracle Advanced Security.
Advanced Symmetric Replication (ASR), OID 2-14
configuring, OID 10-6
using Oracle8 Replication Manager, OID 10-3
installed with Oracle 8i, OID 10-3
installing, OID 10-3
setting up, OID 10-3
advantages
OCI, ADG 1-7, OCI 1-3
ADVISE clause
of ALTER SESSION, SQL 7-84
affinity
awareness, PSA 13-19
disk, PSA 2-3, PSA 2-7
parallel DML, SCN 206
parallel processor, PSC A-17
partitions, SCN 205
AFTER clause
of CREATE TRIGGER, SQL 7-428
AFTER triggers, SCN 90, SQL 7-428
auditing and, ADG 13-35, ADG 13-38, SAD 24-21
correlation names and, ADG 13-16
defined, SCN 90
specifying, ADG 13-7
when fired, SCN 102
Agent, ADQ 2-3
Agent address must be specified for remote subscriber - error, ADQ D-15
Agent must be specified, ADQ D-2
agent self-registration
compatibility, MIG 9-12
agents
generic connectivity, DDS 6-6
Heterogeneous Services, DDS 6-3, DDS 6-5
definition, DDS 1-5
disabling self-registration, DDS 7-9
registering, DDS 7-5, DDS 7-6, DDS 7-7
specifying initialization parameters for, DDS 7-4
agents for queuing, SCN 70
agents, definition, ADQ 1-17
aggregate assignment, PLS 2-34
aggregate computability check, DWG 19-19
aggregate distinct queries, parallelization of, GTK 3-25
aggregate functions, DDS 2-33, SQL 4-6
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
aggregates, DWG 8-8, DWG 8-11, DWG 18-49, DWG 19-30
agreements, replication, OID 2-14
ALERT file, PSA 14-4, PSC 7-2
alert files, SCN 8-15, SRF 1-16, STU 11-4
ARCn processes, SCN 8-13
redo logs, SCN 8-10
alert log, SBR 6-17
about, SAD 4-15
checking after RESETLOGS, SBR 5-35
control file record messages, RMN 3-47
location of, SAD 4-16
monitoring overwriting of control file records, RMN 3-48
session high water mark in, SAD 22-7
size of, SAD 4-16
useful for RMAN, RMN 9-2
using, SAD 4-15
when written, SAD 4-16
alert logs, PSG C-10
Alias library, DCI 4-2
aliases
directory
exporting, SUT 1-58
importing, SUT 2-57
for columns, SQL 5-19
for expressions in view query, SQL 7-458
qualifying subqueries (inline views), SCN 10-17
specifying in queries and subqueries, SQL 7-576
aliasing, PLS 7-22
ALL, STU 4-67
ALL clause
of SELECT, SQL 7-573
of SET CONSTRAINTS, SQL 7-598
of SET ROLE, SQL 7-601
ALL EXCEPT clause
of SET ROLE, SQL 7-601
ALL operator, SQL 3-6
ALL option, PSA 13-5
ALL PRIVILEGES clause
of GRANT object_privileges, SQL 7-533
of REVOKE schema_object_privileges, SQL 7-560
ALL PRIVILEGES shortcut
of AUDIT sql_statements, SQL 7-214
All Propagation Schedules, Selecting, ADQ 10-12
All Queue Tables in Database, Selecting, ADQ 10-4
All Queues in Database, Selecting, ADQ 10-10
All Recipients in recipient_list must be specified - error, ADQ D-15
ALL row operator, PLS 5-3, PLS 5-5
ALL shortcut
of AUDIT sql_statements, SQL 7-214
ALL_ views, SCN 2-6
ALL_ALL_TABLES view, SRF 2-3
ALL_ARGUMENTS view, SRF 2-5
ALL_ASSOCIATIONS view, SRF 2-7
ALL_CATALOG view, SRF 2-7
ALL_CLUSTER_HASH_EXPRESSIONS view, SRF 2-9
ALL_CLUSTERS view, SRF 2-8
ALL_COL_COMMENTS view, SQL 7-228, SRF 2-9
ALL_COL_PRIVS view, SRF 2-10
ALL_COL_PRIVS_MADE view, SRF 2-11
ALL_COL_PRIVS_RECD view, SRF 2-11
ALL_COLL_TYPES view, SRF 2-12
ALL_CONS_COLUMNS view, SRF 2-13
ALL_CONSTRAINTS view, SRF 2-13
ALL_CONTEXT view, SRF 2-15
ALL_DB_LINKS view, DDS 2-21, SRF 2-15
ALL_DEF_AUDIT_OPTS view, SRF 2-16
ALL_DEPENDENCIES view, SRF 2-16
ALL_DIM_ATTRIBUTES view, SRF 2-18
ALL_DIM_CHILD_OF view, SRF 2-18
ALL_DIM_HIERARCHIES view, SRF 2-19
ALL_DIM_JOIN_KEY view, SRF 2-19
ALL_DIM_LEVEL_KEY view, SRF 2-20
ALL_DIM_LEVELS view, SRF 2-20
ALL_DIMENSIONS view, SRF 2-17
ALL_DIRECTORIES view, SRF 2-21
ALL_ERRORS view, SRF 2-21
debugging stored procedures, ADG 9-43
ALL_IND_COLUMNS view, SRF 2-22
ALL_IND_EXPRESSIONS view, SRF 2-23
ALL_IND_PARTITIONS view, SRF 2-23
ALL_IND_SUBPARTITIONS view, SRF 2-25
ALL_INDEXES view, SRF 2-27, STU 12-17
filling with data, SAD 19-7
ALL_INDEXTYPE_OPERATORS view, SRF 2-31
ALL_INDEXTYPES view, SRF 2-30
ALL_JOBS view, SRF 2-32
ALL_LIBRARIES view, SRF 2-33
ALL_LOB_PARTITIONS view, SRF 2-34
ALL_LOB_SUBPARTITIONS view, SRF 2-35
ALL_LOBS view, SRF 2-33
ALL_METHOD_PARAMS view, SRF 2-37
ALL_METHOD_RESULTS view, SRF 2-37
ALL_MVIEW_AGGREGATES view, SRF 2-38
ALL_MVIEW_ANALYSIS view, SRF 2-39
ALL_MVIEW_DETAIL_RELATIONS view, SRF 2-41
ALL_MVIEW_JOINS view, SRF 2-41
ALL_MVIEW_KEYS view, SRF 2-42
ALL_MVIEWS view, SRF 2-43
ALL_NESTED_TABLES view, SRF 2-46
ALL_OBJECT_TABLES view, SRF 2-47
ALL_OBJECTS view, SRF 2-49, STU 19-34
ALL_OPANCILLARY view, SRF 2-50
ALL_OPARGUMENTS view, SRF 2-51
ALL_OPBINDINGS view, SRF 2-51
ALL_OPERATORS view, SRF 2-52
ALL_OUTLINE_HINTS view, SRF 2-53
ALL_OUTLINES view, SRF 2-53
ALL_PART_COL_STATISTICS view, SRF 2-54
ALL_PART_HISTOGRAMS view, SRF 2-55
ALL_PART_INDEXES view, SRF 2-56
ALL_PART_KEY_COLUMNS view, SRF 2-57
ALL_PART_LOBS view, SRF 2-58
ALL_PART_TABLES view, SRF 2-59
ALL_PARTIAL_DROP_TABS view, SRF 2-61
ALL_POLICIES view, SRF 2-61
ALL_QUEUE_TABLES view, SRF 2-62
ALL_QUEUES view, SRF 2-63
ALL_REFRESH_CHILDREN view, RAR 9-55, SRF 2-65
ALL_REFRESH_DEPENDENCIES view, SRF 2-66
ALL_REFRESHS view, RAR 9-54, SRF 2-64
ALL_REFS view, SRF 2-66
ALL_REGISTERED_SNAPSHOTS view, RAR 9-56, SRF 2-67
ALL_REPCAT_REFRESH_TEMPLATES view, RAR 9-8
ALL_REPCAT_TEMPLATE_OBJECTS view, RAR 9-9
ALL_REPCAT_TEMPLATE_PARMS view, RAR 9-11
ALL_REPCAT_TEMPLATE_SITES view, RAR 9-13
ALL_REPCAT_USER_AUTHORIZATIONS view, RAR 9-14
ALL_REPCAT_USER_PARM_VALUES view, RAR 9-15
ALL_REPCATLOG view, RAR 9-6, SRF 2-2
ALL_REPCOLUMN view, RAR 9-17, SRF 2-2
ALL_REPCOLUMN_GROUP view, RAR 9-18, SRF 2-2
ALL_REPCONFLICT view, RAR 9-18, SRF 2-2
ALL_REPDDL view, RAR 9-19, SRF 2-2
ALL_REPGENERATED view, SRF 2-2
ALL_REPGENOBJECTS view, RAR 9-20, SRF 2-2
ALL_REPGROUP view, RAR 9-21, SRF 2-2
ALL_REPGROUP_PRIVILEGES view, RAR 9-22
ALL_REPGROUPED_COLUMN view, RAR 9-22, SRF 2-2
ALL_REPKEY_COLUMNS view, RAR 9-23, SRF 2-2
ALL_REPOBJECT view, RAR 9-23, SRF 2-2
ALL_REPPARAMETER_COLUMN view, RAR 9-25, SRF 2-2
ALL_REPPRIORITY view, RAR 9-26, SRF 2-2
ALL_REPPRIORITY_GROUP view, RAR 9-28, SRF 2-2
ALL_REPPROP view, RAR 9-28, SRF 2-2
ALL_REPRESOL_STATS_CONTROL view, RAR 9-29, SRF 2-2
ALL_REPRESOLUTION view, RAR 9-30, SRF 2-2
ALL_REPRESOLUTION_METHOD view, RAR 9-32, SRF 2-2
ALL_REPRESOLUTION_STATISTICS view, RAR 9-32, SRF 2-2
gathering statistics, RAR 6-29
ALL_REPSITES view, RAR 9-33, SRF 2-2
ALL_ROWS hint, SQL 2-64, STU 4-11, STU 7-6
ALL_SEQUENCES view, SRF 2-68
ALL_SNAPSHOT_LOGS view, RAR 9-57, SRF 2-68
ALL_SNAPSHOT_REFRESH_TIMES view, RAR 9-58, SRF 2-69
ALL_SNAPSHOTS view, RAR 9-59, SRF 2-69
ALL_SOURCE view, ADG 9-43, SRF 2-71
ALL_SUBPART_COL_STATISTICS view, SRF 2-72
ALL_SUBPART_HISTOGRAMS view, SRF 2-72
ALL_SUBPART_KEY_COLUMNS view, SRF 2-73
ALL_SUMDELTA view, SRF 2-74
ALL_SYNONYMS view, SRF 2-74
ALL_TAB_COL_STATISTICS view, SRF 2-75
ALL_TAB_COLUMNS view, SRF 2-75
filling with data, SAD 19-7
ALL_TAB_COMMENTS view, SQL 7-228, SRF 2-77
ALL_TAB_HISTOGRAMS view, SRF 2-77
ALL_TAB_MODIFICATIONS view, SRF 2-78, SRF 2-136, SRF 2-184
ALL_TAB_PARTITIONS view, SRF 2-79
ALL_TAB_PRIVS view, SRF 2-80
ALL_TAB_PRIVS_MADE view, SRF 2-81
ALL_TAB_PRIVS_RECD view, SRF 2-81
ALL_TAB_SUBPARTITIONS view, SRF 2-82
ALL_TABLES table, PSA 10-4
ALL_TABLES view, SRF 2-83
filling with data, SAD 19-7
ALL_TRIGGER_COLS view, SRF 2-87
ALL_TRIGGERS view, SRF 2-86
ALL_TYPE_ATTRS view, SRF 2-88
ALL_TYPE_METHODS view, SRF 2-88
ALL_TYPES view, SRF 2-89
ALL_UPDATABLE_COLUMNS view, SCN 10-16, SRF 2-90, SRF 2-139, SRF 2-186
ALL_USERS view, SRF 2-91
ALL_USTATS view, SRF 2-91
ALL_VARRAYS view, SRF 2-92
ALL_VIEWS view, SRF 2-92
ALLOCATE
allocating a cursor variable, PC_ 4-27
allocate channel command (RMAN), RMN 10-10
and multi-threaded server, RMN 10-11, RMN 10-15
for delete option, RMN 5-27, RMN 10-14
for maintenance option, RMN 10-14
ALLOCATE DESCRIPTOR statement, PC_ 14-13, PC_ F-14, PCO F-12
ALLOCATE EXTENT, PSA 8-9
!blocks parameter, PSA 8-13
DATAFILE option, PSA 8-10
exclusive mode, PSA 8-9
in exclusive mode, PSA 8-9
instance number, PSA 8-11
INSTANCE option, PSA 8-10
pre-allocating extents, PSA 8-12
SIZE option, PSA 8-9
ALLOCATE EXTENT clause
of ALTER CLUSTER, SQL 7-3, SQL 7-4
of ALTER INDEX, SQL 7-31, SQL 7-35
of ALTER TABLE, SQL 7-150
instance number, SRF 1-47
ALLOCATE EXTENT option
DATAFILE option, PSC 7-24
instance number, PSC 7-20
INSTANCE option, PSC 7-24
not available, PSC A-22
SIZE option, PSC 7-24
ALLOCATE SQL statement, PC_ 17-5
ALLOCATE SQL statements, PC_ F-12
ALLOCATE statement, PCO F-10
use with ROWID, PCO 4-33
allocating
cursor variables, PC_ 4-27
cursors, PC_ F-12, PCO F-10
thread context, PC_ 11-8, PC_ F-28, PCO 12-8, PCO F-19
allocating cursor variables, PCO 6-32
allocation
automatic, PSA 8-11, PSA 8-12, PSC 7-25
dynamic, PSA 6-6
extents, ADG 5-17, PSA 1-6, PSA 8-12, PSA 8-13, SAD 13-13
extents, dynamic, PSA 8-13
free space, PSC 7-24
minimizing extents for rollback segments, SAD 11-12
of memory, STU 19-2
of PCM locks, PSA 7-9
PCM locks, PSA 7-9, PSA 8-9, PSC 5-20, PSC 7-21, SRF 1-40
rollback segments, PSA 3-4, SRF 1-105
sequence numbers, PSC 8-14
static, PSA 6-6
temporary space, SAD 13-6
allocation duration
example, OCI 13-14
of objects, OCI 13-14
ALLOW_PARTIAL_SN_RESULTS initialization parameter: obsolete
ALLOW_PARTIAL_SN_RESULTS parameter
obsolete for 8.1, PSC A-6
Alter a Propagation Schedule, ADQ 9-75
Alter a Queue, ADQ 9-30
ALTER ANY CLUSTER system privilege, SQL 7-521
ALTER ANY DIMENSION system privilege, SQL 7-522
ALTER ANY INDEX system privilege, SQL 7-522
ALTER ANY INDEXTYPE system privilege, SQL 7-522
ALTER ANY MATERIALIZED VIEW system privilege, SQL 7-523
ALTER ANY OUTLINE system privilege, SQL 7-524
ALTER ANY PROCEDURE system privilege, SQL 7-524
ALTER ANY ROLE system privilege, SQL 7-525
ALTER ANY SEQUENCE system privilege, SQL 7-525
ALTER ANY SNAPSHOT system privilege, SQL 7-526
ALTER ANY TABLE system privilege, SQL 7-526
ALTER ANY TRIGGER system privilege, SQL 7-527
ALTER ANY TYPE privilege, ADO 2-10
See also privileges
ALTER ANY TYPE system privilege, SQL 7-528
ALTER AUTHORIZATION
changing password, PCO 3-10
ALTER CLUSTER command, ADG 2-6
ALLOCATE EXTENT option, ADG 5-17
ALTER CLUSTER statement, PSC A-22, SQL 7-2
ALLOCATE EXTENT, PSA 8-9
ALLOCATE EXTENT option, SAD 16-9
allocating extents, PSA 8-12
using for hash clusters, SAD 17-9
using for index clusters, SAD 16-9
ALTER DATABASE
statement, SQL 7-6
system privilege, SQL 7-521
ALTER DATABASE ADD LOGFILE command, PSA 4-7
ALTER DATABASE ADD LOGFILE statement, PSG 9-4
alter database command (RMAN), RMN 10-16
ALTER DATABASE CONVERT statement, MIG 4-4, MIG 4-32
re-running, MIG A-19
ALTER DATABASE DISABLE THREAD statement, PSA 3-8
ALTER DATABASE OPEN RESETLOGS statement, MIG 4-4, MIG 4-32, PSA 14-13
ALTER DATABASE RESET COMPATIBILITY statement, MIG 9-7
ALTER DATABASE statement, SBY 1-28, SCN 5-7
ADD LOGFILE, PSC 7-3, SRF 1-117
ADD LOGFILE MEMBER option, SAD 6-12
ADD LOGFILE option, SAD 6-11
adding or dropping log file, PSC A-20
ARCHIVELOG option, SAD 7-6
BACKUP CONTROLFILE clause, SBR 1-19, SBR 4-4, SBR 4-14
TO TRACE option, SBR 4-14
CLEAR LOGFILE clause, SBR 6-9
CLEAR LOGFILE GROUP clause, SBY 4-16
CLEAR LOGFILE option, SAD 6-17
CLEAR UNARCHIVED LOGFILE clause, SBR 2-14, SBY 4-12, SBY 5-28
CLEAR UNARCHIVED LOGFILE option, SAD 6-7
CLOSE clause, PSA 4-7
CREATE STANDBY CONTROLFILE clause, SBY 4-15, SBY 5-15
database name, SRF 1-32
database partially available to users, SAD 3-8
DATAFILE OFFLINE and ONLINE options, PSC A-20
DATAFILE OFFLINE DROP clause, SBY 4-13
DATAFILE ONLINE option, SBR 5-30
DATAFILE...OFFLINE DROP option, SAD 10-8
DATFILE RESIZE, PSA 9-5
DISABLE, PSA 3-8
DROP LOGFILE MEMBER option, SAD 6-16
DROP LOGFILE option, SAD 6-15
ENABLE THREAD, SRF 1-117
ENABLE THREAD clause, SBY 4-12
MOUNT option, SAD 3-8
MOUNT STANDBY DATABASE clause, SBY 3-4, SBY 4-15
NOARCHIVELOG option, SAD 7-6
NORESETLOGS option, SBR 4-16, SBR 5-34
OPEN option, SAD 3-8
OPEN READ ONLY clause, SBY 3-18, SBY 3-19, SBY 4-17
OPEN RESETLOGS clause, RMN 3-12, SBY 5-28
READ ONLY option, SAD 3-9
RECOVER, PSA 14-7
RECOVER ... FROM option, SBR 5-6, SBR 5-10
RECOVER AUTOMATIC LOGFILE option, SBR 5-13
RECOVER LOGFILE option, SBR 5-12
RECOVER option, PSA 14-7
RENAME DATABASE clause, RMN 6-10
RENAME FILE option
datafiles for multiple tablespaces, SAD 10-11
renaming a file, PSC A-20
RESETLOGS option, SBR 4-16, SBR 5-16, SBR 5-17, SBR 5-34
RESETLOGS parameter, SBY 3-7
setting the log mode, PSA 3-2, PSA 3-8, PSC B-3
THREAD, PSA 3-8, SRF 1-117
thread of redo, PSA 3-8
UNRECOVERABLE DATAFILE option, SAD 6-18
ALTER DIMENSION statement, SQL 7-25
ALTER FUNCTION statement, SQL 7-28
COMPILE option, SAD 19-25
ALTER INDEX COALESCE, SAD 14-7
ALTER INDEX command, ADG 2-6
ALTER INDEX REBUILD statement, STU 12-9
ALTER INDEX statement, SAD 14-15, SQL 7-30
COMPUTE STATISTICS clause, GTK 3-27
DEALLOCATE UNUSED option, PSA 8-14
for maintaining partitioned indexes, SAD 15-12 to SAD 15-32
no-logging mode for SPLIT PARTITION, SCN 11-58, SCN 151
online rebuild, GTK 3-41
partition attributes, SCN 11-36
REBUILD PARTITION clause, SCN 11-60
ALTER JAVA CLASS statement, SQL 7-45
ALTER JAVA SOURCE statement, SQL 7-45
ALTER MATERIALIZED VIEW LOG statement, SQL 7-58
ALTER MATERIALIZED VIEW statement, DWG 8-17, SQL 7-47
enabling query rewrite, DWG 19-5
ALTER object privilege, SQL 7-535
ALTER OUTLINE statement, SQL 7-63
ALTER PACKAGE statement, SQL 7-64
COMPILE option, SAD 19-25
ALTER privilege, ADG 11-22
ALTER PROCEDURE statement, SQL 7-67
COMPILE option, SAD 19-25
ALTER PROFILE
statement, SQL 7-69
system privilege, SQL 7-525
ALTER PROFILE statement
altering resource limits, SAD 22-23
ALTER RESOURCE COST
statement, SQL 7-73
system privilege, SQL 7-525
ALTER RESOURCE COST statement, SAD 22-24
ALTER ROLE statement, SQL 7-76
changing authorization method, SAD 23-7
ALTER ROLLBACK SEGMENT
statement, SQL 7-78
system privilege, SQL 7-525
ALTER ROLLBACK SEGMENT command, PSC 7-8
ALTER ROLLBACK SEGMENT statement, PSA 3-4
changing storage parameters, SAD 11-9
OFFLINE option, SAD 11-11
ONLINE option, SAD 11-10, SAD 11-11
STORAGE clause, SAD 11-9
ALTER SEQUENCE command, ADG 2-30
ALTER SEQUENCE statement, SAD 18-13, SQL 7-81
ALTER SESSION
statement, SQL 7-83
system privilege, DDS 3-2, SQL 7-525
ALTER SESSION command
SERIALIZABLE, ADG 7-25
SET SCHEMA, ADG 11-19
ALTER SESSION SET INSTANCE statement, PSA 8-8
ALTER SESSION SET SCHEMA statement, ADG 11-44
ALTER SESSION statement, SCN 14
ADVISE clause, DDS 5-13
CLOSE DATABASE LINK clause, DDS 3-2
dynamic parameters, SCN 5-5
ENABLE PARALLEL DML clause, SCN 195
examples, STU 6-5
FORCE PARALLEL DDL clause, SCN 181, SCN 184
create or rebuild index, SCN 181, SCN 184
create table as select, SCN 182, SCN 184
move or split partition, SCN 181, SCN 184
FORCE PARALLEL DML clause
insert, SCN 180, SCN 183
update and delete, SCN 178, SCN 183
HASH_JOIN_ENABLED, STU 4-53
OPTIMIZER_GOAL, STU 4-11
SET CONSTRAINTS DEFERRED clause, SCN 275
SET HASH_AREA_SIZE clause, SRF 1-43
SET HASH_JOIN_ENABLED clause, SRF 1-44
SET INSTANCE option, PSA 8-8, PSC 7-24
SET NLS_CURRENCY clause, NLS 2-24, NLS 2-25
SET NLS_DATE_FORMAT clause, NLS 2-15
SET NLS_LANGUAGE clause, NLS 2-12
SET NLS_NUMERIC_CHARACTERS clause, NLS 2-22
SET NLS_TERRITORY clause, NLS 2-12
SET SESSION_CACHED_CURSORS statement, STU 19-21
SET SQL_TRACE initialization parameter, SAD 4-17
transaction isolation level, SCN 218, SCN 242
ALTER SNAPSHOT LOG. See ALTER MATERIALIZED VIEW LOG
ALTER SNAPSHOT LOG statement, RAR 7-17
ALTER SNAPSHOT. See ALTER MATERIALIZED VIEW
ALTER statement, SCN 12
auditing partitions, SCN 11-63
triggers on, SQL 7-430
ALTER SYSTEM
statement, SQL 7-102
system privilege, SQL 7-521
ALTER SYSTEM ARCHIVE LOG CURRENT statement, PSA 4-7
ALTER SYSTEM ARCHIVE LOG statement, PSA 4-7, PSA 13-21
CURRENT clause, PSA 13-15
CURRENT option, PSC A-21
global log switch, PSA 13-15, PSA 13-21
THREAD clause, PSA 4-7, PSA 13-5
ALTER SYSTEM CHECK DATAFILES statement, PSC 7-2
instance recovery, PSA 14-4
ALTER SYSTEM CHECKPOINT LOCAL statement, PSA 4-7
ALTER SYSTEM CHECKPOINT statement, PSA 13-14
global versus local, PSA 4-7
specifying an instance, PSA 4-7
ALTER SYSTEM privilege, PSA 13-14, PSA 13-15
ALTER SYSTEM statement, SCN 14
ARCHIVE ALL option
using to archive online redo logs, SBR 1-19
ARCHIVE LOG ALL option, SAD 7-9
ARCHIVE LOG CURRENT clause, SBY 3-21, SBY 5-42
ARCHIVE LOG option, SAD 7-9
CHECKPOINT clause, STU 24-7
DISABLE DISTRIBUTED RECOVERY clause, DDS 5-28
dynamic parameters, SCN 5-5
LOG_ARCHIVE_MAX_PROCESSES, SCN 8-13, SCN 361
ENABLE DISTRIBUTED RECOVERY clause, DDS 5-28
ENABLE RESTRICTED SESSION option, SAD 3-9
MTS_DISPATCHERS parameter, STU 21-8
RESUME clause, SAD 3-14
RESUME option, SBR 4-11
SET LICENSE_MAX_SESSIONS option, SAD 22-4
SET LICENSE_MAX_USERS option, SAD 22-6
SET LICENSE_SESSIONS_WARNING option, SAD 22-4
SET MTS_SERVERS option, SAD 4-8
SET NLS_LANGUAGE clause, NLS 2-12
SET RESOURCE_LIMIT option, SAD 22-22
SET RESOURCE_MANAGER_PLAN, SAD 25-18
SUSPEND clause, SAD 3-14
SUSPEND option, SBR 4-11
SWITCH LOGFILE clause, SBY 4-11, SCN 8-12
SWITCH LOGFILE option, SAD 6-16
ALTER SYSTEM SWITCH LOGFILE statement, PSA 4-7, PSA 13-15, PSC A-21
DBA privilege, PSA 13-15, PSC A-21
ALTER TABLE command, ADG 2-6, ADG 2-9
defining integrity constraints, ADG 4-18
DISABLE ALL TRIGGERS option, ADG 13-32
DISABLE integrity constraint option, ADG 4-21
DROP integrity constraint option, ADG 4-24
ENABLE ALL TRIGGERS option, ADG 13-31
ENABLE integrity constraint option, ADG 4-21
INITRANS parameter, ADG 7-25
ALTER TABLE statement, SQL 7-123
add or coalesce hash partition, SCN 11-16
ALLOCATE EXTENT, PSA 8-9
ALLOCATE EXTENT option, SAD 13-14
allocating extents, PSA 8-12, PSA 8-13, SRF 1-47
auditing, SCN 335
bitmap index invalidation, MIG 9-26
CACHE clause, SCN 7-4
DEALLOCATE UNUSED clause, SCN 4-15
DISABLE ALL TRIGGERS option, SAD 19-14
DISABLE integrity constraint option, SAD 19-18
disable or enable constraints, SCN 276
DISABLE TABLE LOCK clause, PSA 7-17, PSA 10-4
DISABLE TABLE LOCK option, PSC 4-13
DROP COLUMN clause, SCN 10-7
drop column support, GTK 3-41
DROP integrity constraint option, SAD 19-20
ENABLE ALL TRIGGERS option, SAD 19-14
ENABLE integrity constraint option, SAD 19-18, SAD 19-19
ENABLE ROW MOVEMENT, GTK 3-46
ENABLE TABLE LOCK clause, PSA 7-17, PSA 10-4
ENABLE TABLE LOCK option, PSC 4-13
example, SAD 13-12
EXCHANGE PARTITION, SCN 11-11
for maintaining partitions, SAD 15-12 to SAD 15-32
MAXEXTENTS option, PSA 8-13
MERGE PARTITIONS clause, SCN 11-14
merging partitions, GTK 3-45
MODIFY CONSTRAINT clause, GTK 3-28, SCN 277
MOVE clause for IOT or non-partitioned table, GTK 3-29
no longer invalidates bitmap indexes, GTK 3-25
NOLOGGING clause, DWG 18-60
no-logging mode for SPLIT PARTITION, SCN 11-58, SCN 151
partition attributes, SCN 11-26
triggers, SCN 87
UNUSED column, SCN 10-7
validate or novalidate constraints, SCN 276
ALTER TABLESPACE
statement, SQL 7-176
system privilege, SQL 7-527
ALTER TABLESPACE statement
ADD DATAFILE, PSA 9-5
ADD DATAFILE option, PSC A-20
ADD DATAFILE parameter, SAD 10-5
BACKUP option, PSA 13-20
BEGIN BACKUP option, SBR 4-5, SBR 4-9
BEGIN/END BACKUP clause, RMN 3-35
END BACKUP option, SBR 4-9
OFFLINE and ONLINE options, PSC A-20
ONLINE option
example, SAD 9-17
READ ONLY clause, SCN 3-11
READ ONLY option, PSA 5-3, SAD 9-18
READ WRITE clause, SCN 3-11
READ WRITE option, SAD 9-20
RENAME DATA FILE option, SAD 10-10
renaming a data file, PSC A-20
TEMPORARY or PERMANENT, SCN 3-13
ALTER TRIGGER command
DISABLE option, ADG 13-31
ENABLE option, ADG 13-31
ALTER TRIGGER statement, SQL 7-183
DISABLE option, SAD 19-14
ENABLE option, SAD 19-13
ALTER TYPE statement, SQL 7-186
ALTER USER
statement, SQL 7-193
system privilege, SQL 7-528
ALTER USER privilege, SAD 22-18
ALTER USER statement
default roles, SAD 23-18
GRANT CONNECT THROUGH clause, SAD 22-14
REVOKE CONNECT THROUGH clause, SAD 22-14
temporary segments, SCN 4-20
ALTER VIEW statement, SQL 7-198
COMPILE option, SAD 19-24
alter(Session, AQjmsDestinationProperty) - oracle.jms.AQjmsDestination.alter(javax.jms.Session, oracle.jms.AQjmsDestinationProperty), JPR 2-65
altering
control files, SBY 4-12, SBY 5-26
propagation method, SPR 37-16, SPR 37-24, RAR 8-82, RAR 8-90
storage parameters, ADG 2-9
tables, ADG 2-9
altering dimensions, DWG 9-14
altering storage parameters, SAD 13-12
altering users, SAD 22-19
alternate character mappings, NLS 4-10
AlternateServers attribute, in failover, OID 14-4
alterPropagationSchedule(Session, String, Double, String, Double) - oracle.jms.AQjmsDestination.alterPropagationSchedule(javax.jms.Session, java.lang.String, java.lang.Double, java.lang.String, java.lang.Double), JPR 2-66
Always Use Dedicated Server option in Net8 Assistant, NET 8-21
ALWAYS_ANTI_JOIN initialization parameter, SRF 1-13
ALWAYS_ANTI_JOIN parameter, STU 4-29, STU 4-61, STU 7-23, STU 7-24
ALWAYS_SEMI_JOIN initialization parameter, SRF 1-14
ALWAYS_SEMI_JOIN parameter, STU 4-62
AM (A.M.) date format element, SQL 2-46, SQL 2-48
American National Standards Institute (ANSI)
ANSI-compatible locking, ADG 7-17
American National Standards Institute. See ANSI
amount parameter
reading and loading LOB data, the size of, ADL 6-4
used with BFILEs, ADL 11-47
AM/PM abbreviation
language of, NLS 2-17
analysis
of applications for Oracle Parallel Server, PSA 5-3
analysis dictionary, STU 11-5
analytic functions, DWG 17-21, SQL 4-7
CUME_DIST, SQL 4-28
FIRST_VALUE, SQL 4-34
LAG, SQL 4-40
LAST_VALUE, SQL 4-42
LEAD, SQL 4-44
NTILE, SQL 4-61
PERCENT_RANK, SQL 4-66
RANK, SQL 4-67
RATIO_TO_REPORT, SQL 4-68
ROW_NUMBER, SQL 4-80
ANALYZE, OID 13-6
Import parameter, SUT 2-18
ANALYZE ANY system privilege, SQL 7-529
ANALYZE CLUSTER statement, SQL 7-200
ANALYZE function of DBMS_STATS package, OID 13-3
ANALYZE INDEX statement, SQL 7-200
ANALYZE statement, DWG 18-51, SCN 13, SRF 2-27, SRF 2-75, SRF 2-77, SRF 2-83, SRF 2-111, SRF 2-136, SRF 2-137, SRF 2-183, SRF 2-185, STU 20-31
CASCADE option, SAD 19-9
COMPUTE STATISTICS option, SAD 19-5
corruption reporting, SAD 20-5
creating histograms, SCN 134, STU 8-18
dangling REFs, GTK 3-36
ESTIMATE STATISTICS SAMPLE option, SAD 19-5
estimated statistics, SCN 137
LIST CHAINED ROWS option, SAD 19-9
parallel, GTK 4-2
partition statistics, SCN 11-13
shared pool, SCN 7-11
shared SQL and, SAD 19-8
STATISTICS option, SAD 19-4
VALIDATE STRUCTURE option, SAD 19-9
validating structure, SAD 20-4
ANALYZE TABLE statement, DDS 3-7, DWG 15-3, SQL 7-200
ANALYZE TABLE VALIDATE STRUCTURE statement
change in release 8.1, MIG 9-18
analyzer statistics, SUT 2-61
analyzing archived redo logs, SAD 7-26
analyzing data
for parallel processing, DWG 18-69
analyzing objects
about, SAD 19-3
privileges, SAD 19-4
analyzing tables
cost-based optimization, DDS 3-7
ANCILLARY TO clause
of CREATE OPERATOR, SQL 7-341
AND expression
for simple subquery snapshots, REP 3-15
AND operator, SQL 3-11, SQL 3-12
AND_EQUAL hint, SQL 2-65, STU 7-16, STU 12-7
angle brackets, PC_ xvi
ANO. See Advanced Networking Option.
anonymous
authentication, OID 4-4
login, OID 4-4
anonymous authentication, OID 1-5, OID 2-21
in access control, OID 9-24, OID 9-30
anonymous PL/SQL block, PLS 7-2
anonymous PL/SQL blocks, ADG 11-10, SCN 24, SCN 53
about, ADG 9-2
applications, SCN 26
calling a stored procedure, SCN 28
compared to triggers, ADG 9-28
contrasted with stored procedures, SCN 53
dynamic SQL, SCN 28
dynamic SQL and, SPR 51-2
performance, SCN 53
ANSI, SQL B - 1
compliance, PC_ xvii
datatypes, SQL 2-28
conversion to Oracle datatypes, SQL 2-28
standards, SQL v, SQL 1-2
supported datatypes, SQL 2-12
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 Entry SQL compliance, PCO cxxviii
ANSI format
COBOL statements, PCO 2-12
ANSI SQL standard
datatypes of, SCN 12-23
Oracle certification, SCN 1-3
ANSI SQL92
FIPS flagger, ADG 7-2
ANSI standard for LOBs, ADL 10-10
ANSI, address of, PC_ xvii
ANSI/ISO SQL
compliance, PCO cxxvi
extensions, PCO 14-21
ANSI/ISO SQL standard, SCN 1-3
composite foreign keys, SCN 266
data concurrency, SCN 212
isolation levels, SCN 221
ANSWER_TIMEOUT parameter, NET C-73
anti-joins, STU 4-61
ANY, STU 4-67
ANY - oracle.xml.parser.v2.ElementDecl.ANY, JPR 4-32
ANY comparison operator, PLS 5-5
ANY operator, SQL 3-6
API
MM, LEG 1-11
apostrophes, PLS 2-9
APPC architecture, NET 4-4
APPEND hint, DWG 18-60, SQL 2-67, STU 7-28
APPEND keyword
SQL*Loader, SUT 5-44
append sequences conflict resolution method, REP 5-25
append site name conflict resolution method, REP 5-24
APPEND to table
example, SUT 4-11
SQL*Loader, SUT 5-33
appendChild(Node) - oracle.xml.parser.v2.XMLNode.appendChild(org.w3c.dom.Node), JPR 4-106
appending
one LOB to another
internal persistent LOBs, ADL 9-181
one temporary LOB to another, ADL 10-133
write appending to a LOB
internal persistent LOBs, ADL 9-191
application administrators, SAD 21-11
application context, SAD 21-4
as secure data cache, ADG 11-47
bind variables, ADG 11-48
CREATE CONTEXT statement, GTK 3-69
creating, ADG 11-52
design principles, ADG 11-45
examples, ADG 11-53
fine-grained access control, ADG 11-14, ADG 11-18, ADG 11-47
how to use, ADG 11-49
introduction, ADG 11-4, ADG 11-40
parallel query, ADG 11-51
performance, ADG 11-56
returning predicate, ADG 11-48
security features, ADG 11-41
setting, ADG 11-52
USERENV namespace, ADG 11-42
using in policy, ADG 11-52
versioning, ADG 11-51
application design, STU 2-9
application designer, STU 1-8
application developer, STU 1-8
application developers
privileges for, SAD 21-10
roles for, SAD 21-11
application development, GTK 3-69
constraints, DDS 3-3
database links
controlling connections, DDS 3-2
distributed databases, DDS 3-1
analyzing execution plan, DDS 3-10
controlling connections, DDS 3-2
handling errors, DDS 3-3
handling RPC errors, DDS 3-12
managing distribution of data, DDS 3-2
managing referential integrity, DDS 3-3
optimizing distributed queries, DDS 1-47
overview, DDS 1-44
remote procedure calls, DDS 1-46
tuning distributed queries, DDS 3-3
tuning using collocated inline views, DDS 3-4
using cost-based optimization, DDS 3-5
using hints to tune queries, DDS 3-8
distributing data, DDS 3-2
Heterogeneous Services, DDS 9-1, DDS 9-2
controlling array fetches between non-Oracle server and agent, DDS 9-11
controlling array fetches between Oracle server and agent, DDS 9-11
controlling reblocking of array fetches, DDS 9-11
DBMS_HS_PASSTHROUGH package, DDS 9-2
pass-through SQL, DDS 9-2
using bulk fetches, DDS 9-9
using OCI for bulk fetches, DDS 9-10
referential integrity, DDS 3-3
remote connections
terminating, DDS 3-2
security for, SAD 21-10
using Heterogeneous Services, DDS 9-1
application development process, PC_ 2-8, PCO 2-2
application failover
callback example, OCI 9-22
callback registration, OCI 9-22
OCI callbacks, OCI 9-20
Application Generator for Microsoft Visual Studio, GTK 3-85
application information, in attributes, OID 2-4
application program interface (API), for non-Oracle data sources, NET 10-2
application schema, GTK 2-9
application security
considerations for use, ADG 11-6
introduction, ADG 11-4, ADG 11-5
limitations, ADG 11-15
specifying attributes, ADG 11-41
through validation, ADG 11-41
application servers
allowing to connect as a user, SQL 7-195
Application, Sample, ADQ 8-3
applications
administrator, ADG 11-8, SAD 1-3
allowing to connect as a user, SQL 7-195
analysis for Oracle Parallel Server, PSA 5-3
application context
compatibility, MIG 9-12
downgrading, MIG 13-45
application vs. database triggers, SCN 83
availability, PSA 14-3
building with Net8 OPEN, NET 10-7
calling stored procedures and packages, ADG 9-51
can find constraint violations, SCN 256
client/server, STU 3-11
client/server configurations
upgrading, MIG 10-4
compatibility, MIG 9-16, MIG 10-2
configuring system to use custom, NET 10-8
context, SCN 327
converting to multi-instance, PSG 9-3
data dictionary references, SCN 2-4
data warehouses
star queries, DWG 16-2
data warehousing, SCN 10-34
star queries, STU 4-62
database access through, SCN 8-2
database users, ADG 11-6
decision support, DWG 18-2, STU 3-4, STU 9-15
decision support systems, DWG 6-3
decision support systems (DSS), SCN 10-35
parallel SQL, SCN 158, SCN 188
departmentalized, PSC 8-7
dependencies of, SCN 117
designing, PSA A-2
development
role during migration, MIG 2-7
development for Oracle Parallel Server, PSA 5-2
direct-load INSERT, SCN 195
discrete transactions, SCN 39
disjoint data, PSC 8-6
distributed databases, STU 3-8
DSS, PSC 8-6
enhancing security with, SCN 1-41, SCN 256
errors
RAISE_APPLICATION_ERROR() procedure, DDS 3-12
recovery after, SBR 1-12
for Oracle Parallel Server, determining suitability, PSA 5-2
index-organized tables, SCN 10-43
compatibility, MIG 9-17
information retrieval (IR), SCN 10-44
insert-intensive, PSC 7-19
interoperability, MIG 9-16
linking, OCI 2-37
linking with newer libraries, MIG 10-6
network communication and, SCN 6-5
object dependencies and, SCN 119
OCI
compatibility, MIG 9-18
interoperability, MIG 9-18
OLTP, PSC 8-6, STU 3-2
One Big Application User model, ADG 11-6, ADG 11-7
online analytical processing (OLAP), SCN 10-45
online transaction processing (OLTP)
reverse key indexes, SCN 10-33
Oracle Parallel Server, STU 3-10
parallel DML, SCN 194
parallel query, STU 3-5
partitioning, methodology, PSA 5-8
performance, PSC 7-19
physical ROWIDs and UROWIDs, MIG 9-17
physical ROWIDs in Oracle8i, MIG 12-2
PL/SQL
compatibility, MIG 9-21
interoperability, MIG 9-21
precompiler
compatibility, MIG 9-20
interoperability, MIG 9-20
processes, SCN 8-4
profiles, PSC 8-7
program interface and, SCN 8-27
query-intensive, PSC 8-6
random access, PSC 8-6
registering with the database, STU 11-8
roles, ADG 11-5, ADG 11-9
roles and, SCN 320
running against older server, MIG 10-6
samples provided with Net8 OPEN, NET 10-9
scalability, PSC 8-10, PSC 8-12
securing, SQL 7-261
security, ADG 11-7, ADG 11-12
application context, SCN 327
sharing code, SCN 7-19
spatial applications, SCN 10-45
table access patterns, PSA 5-3
that do not scale, PSC 9-23
transaction termination and, SCN 35
transactions, PSA 5-3
tuning, PSA 11-1
tuning performance, PSC 7-19
Tuxedo applications
compatibility, MIG 9-18
unhandled exceptions in, ADG 9-46
upgrading, MIG 10-1
compatibility rules, MIG 10-5
options, MIG 10-8
relinking rules, MIG 10-5
validating, SQL 7-261
applications administrator, SAD 1-3
Apply button, in Oracle Directory Manager, OID 4-10
applying log files
SQL*Plus, SBR 5-11
AQ Agent List Type, ADQ 2-4
AQ Excetpion (string) - error, ADQ D-9
AQ Object Types, Access to, ADQ 4-7
AQ Recipient List Type, ADQ 2-4
AQ. See Advanced Queueing.
AQ. See Advanced Queuing
AQ Subscriber List Type, ADQ 2-4
AQ_ADMINISTRATOR role, SCN 73
AQ_ADMINISTRATOR_ROLE role, SQL 7-530
AQ_TM_PROCESS parameter, SCN 72, SCN 73
AQ_TM_PROCESSES, ADQ 2-7
AQ_TM_PROCESSES initialization parameter, SRF 1-14
AQ_TM_PROCESSES parameter
of ALTER SYSTEM, SQL 7-108
AQ_USER_ROLE role, SQL 7-530
AQjmsAdtMessage - oracle.jms.AQjmsAdtMessage, JPR 2-7
AQjmsAgent - oracle.jms.AQjmsAgent, JPR 2-24
AQjmsAgent() - oracle.jms.AQjmsAgent.AQjmsAgent(), JPR 2-25
AQjmsAgent(String, String) - oracle.jms.AQjmsAgent.AQjmsAgent(java.lang.String, java.lang.String), JPR 2-25
AQjmsAgent(String, String, int) - oracle.jms.AQjmsAgent.AQjmsAgent(java.lang.String, java.lang.String, int), JPR 2-25
AQjmsBytesMessage - oracle.jms.AQjmsBytesMessage, JPR 2-28
AQjmsBytesMessage_C - oracle.jms.AQjmsBytesMessage_C, JPR 2-43
AQjmsConnection - oracle.jms.AQjmsConnection, JPR 2-43
AQjmsConnectionMetaData - oracle.jms.AQjmsConnectionMetaData, JPR 2-49
AQjmsConnectionMetaData() - oracle.jms.AQjmsConnectionMetaData.AQjmsConnectionMetaData(), JPR 2-50
AQjmsConstants - oracle.jms.AQjmsConstants, JPR 2-54
AQjmsConstants() - oracle.jms.AQjmsConstants.AQjmsConstants(), JPR 2-55
AQjmsConsumer - oracle.jms.AQjmsConsumer, JPR 2-56
AQjmsDeqSelConstants - oracle.jms.AQjmsDeqSelConstants, JPR 2-64
AQjmsDestination - oracle.jms.AQjmsDestination, JPR 2-64
AQjmsDestinationProperty - oracle.jms.AQjmsDestinationProperty, JPR 2-73
AQjmsDestinationProperty() - oracle.jms.AQjmsDestinationProperty.AQjmsDestinationProperty(), JPR 2-74
AQjmsDestinationProperty(AQQueueProperty) - oracle.jms.AQjmsDestinationProperty.AQjmsDestinationProperty(oracle.jms.AQQueueProperty), JPR 2-77
AQjmsError - oracle.jms.AQjmsError, JPR 2-77
AQjmsException - oracle.jms.AQjmsException, JPR 2-77
AQjmsFactory - oracle.jms.AQjmsFactory, JPR 2-79
AQjmsInvalidDestinationException - oracle.jms.AQjmsInvalidDestinationException, JPR 2-82
AQjmsInvalidSelectorException - oracle.jms.AQjmsInvalidSelectorException, JPR 2-83
AQjmsMapMessage - oracle.jms.AQjmsMapMessage, JPR 2-84
AQjmsMapMessage_C - oracle.jms.AQjmsMapMessage_C, JPR 2-100
AQjmsMessage - oracle.jms.AQjmsMessage, JPR 2-100
AQjmsMessageEOFException - oracle.jms.AQjmsMessageEOFException, JPR 2-122
AQjmsMessageFormatException - oracle.jms.AQjmsMessageFormatException, JPR 2-123
AQjmsMessageHeaderExt - oracle.jms.AQjmsMessageHeaderExt, JPR 2-124
AQjmsMessageNotReadableException - oracle.jms.AQjmsMessageNotReadableException, JPR 2-124
AQjmsMessageNotWriteableException - oracle.jms.AQjmsMessageNotWriteableException, JPR 2-125
AQjmsMessages - oracle.jms.AQjmsMessages, JPR 2-126
AQjmsObjectMessage - oracle.jms.AQjmsObjectMessage, JPR 2-126
AQjmsOracleDebug - oracle.jms.AQjmsOracleDebug, JPR 2-130
AQjmsProducer - oracle.jms.AQjmsProducer, JPR 2-132
AQjmsQueueBrowser - oracle.jms.AQjmsQueueBrowser, JPR 2-146
AQjmsQueueConnectionFactory, ADQ B-81
AQjmsQueueConnectionFactory - oracle.jms.AQjmsQueueConnectionFactory, JPR 2-150
AQjmsQueueReceiver - oracle.jms.AQjmsQueueReceiver, JPR 2-153
AQjmsQueueSender - oracle.jms.AQjmsQueueSender, JPR 2-156
AQjmsSession - oracle.jms.AQjmsSession, JPR 2-157
AQjmsStreamMessage - oracle.jms.AQjmsStreamMessage, JPR 2-184
AQjmsTextMessage - oracle.jms.AQjmsTextMessage, JPR 2-198
AQjmsTopicConnectionFactory - oracle.jms.AQjmsTopicConnectionFactory, JPR 2-201
AQjmsTopicPublisher - oracle.jms.AQjmsTopicPublisher, JPR 2-204
AQjmsTopicReceiver - oracle.jms.AQjmsTopicReceiver, JPR 2-207
AQjmsTopicSubscriber - oracle.jms.AQjmsTopicSubscriber, JPR 2-210
ARCH process, PSA 13-4, STU 19-8
specifying multiple processes, SAD 7-20
ARCH processes
multiple, DWG 18-56
ARCH_IO_SLAVES initialization parameter: obsolete
architecture, PLS 1-17
client/server, SCN 1-32
components of Oracle Parallel Server, PSC 3-1
connection pooling, NET 2-12
dedicated server, NET 2-13
for parallel processing, PSC 2-1
MPP, SCN 206
multi-threaded server, NET 2-7
Net8, NET 3-1
of Oracle, SCN 1-12
OPSCTL utility on UNIX, PSG 6-4
OPSCTL utility on Windows NT, PSG 6-5
Optimal Flexible Architecture (OFA), PSG 1-8, PSG 1-9, SAD 2-5
Oracle Connection Manager, NET 4-5
Oracle Enterprise Manager, PSG 6-7
Oracle Internet Directory, OID 2-1
Oracle Names, NET 4-10
Oracle Parallel Server, PSG 1-2
Oracle Parallel Server Management, PSG 6-2
SMP, SCN 206
architecture and CPU, STU 18-13
architecture of SSL
in an Oracle environment, OAS 10-3
with other authentication methods, OAS 10-8
architecture, LSM, LEG 2-2, LEG 2-3
archive buffer parameters, SAD 7-21
archive destinations, SBY 2-17, SBY 5-31
MANDATORY, SBY 5-31
OPTIONAL, SBY 5-32
archive log
backup, PSA 13-8
ARCHIVE LOG clause
CURRENT option, PSA 13-15, PSA 13-21, PSC A-21
global log switch, PSA 13-15, PSA 13-21
manual archiving, PSA 13-5
of ALTER SYSTEM, SQL 7-103
THREAD option, PSA 13-1, PSA 13-5
ARCHIVE LOG CURRENT clause
ALTER SYSTEM statement, SBY 3-21, SBY 5-42
archive log destination parameters
new in release 8.1, MIG B-13
archive log destinations
conversion to multi-instance, PSG 9-3
multiple
on UNIX, PSG 4-15
on Windows NT, PSG 4-16
shared
on UNIX, PSG 4-10
on Windows NT, PSG 4-12
ARCHIVE LOG option
ALTER SYSTEM statement, SAD 7-9
ARCHIVE LOG START statement
automatic archiving, SRF 1-55
ARCHIVE LOG statement, PSA 13-4
LIST option, SAD 6-15
archive logs
backing up with RMAN, PSA 13-8
archive mode
switch, PSA 3-8
archive processes, SAD 4-12
archive tracing
and standby databases, SBY 4-6
ARCHIVE_DEST_n initialization parameter
downgrading, MIG 13-47
archived redo logs, SAD 7-2, SBR 2-14, SBR 2-23, SCN 1-47
accessing information about, SBY 4-5, SBY 4-9
ALTER SYSTEM ARCHIVE ALL statement, SBR 1-19
analyzing, SAD 7-26
from other databases, MIG 9-44
and standby databases, SBY 4-5
applying during media recovery, SBR 5-9, SBR 5-12
archiving modes, SAD 7-6
automatic archiving, SCN 360
automatic versus manual, SRF 1-61
automating application, SBR 5-11
backing up, RMN 5-20
using RMAN, RMN 5-9, RMN 5-10
cataloging, RMN 3-9
checking status of, SBY 1-26
compatibility, MIG 9-42
copies, listing, RMN 4-2
definition, SBR 1-10
deleting after recovery, SBR 5-7
destination file, SRF 1-55
destination states, SAD 7-12, SBY 2-18
active/inactive, SAD 7-13
bad param, SAD 7-14
deferred, SAD 7-13
enabled/disabled, SAD 7-13
valid/invalid, SAD 7-13
destinations
re-archiving to failed, SAD 7-19, SBY 2-18
sample scenarios, SAD 7-17
displaying information, SBR 2-16
enabling, SCN 359
enabling automatic archival, SBR 2-20
enabling automatic archiving, SAD 7-7
errors during recovery, SBR 5-14
failed destinations and, SAD 7-16
location during recovery, SBR 5-9
location of, SQL 7-13
loss of, SBR 6-11
manual archiving, SCN 361
multiplexing, SAD 7-10, SBR 2-21, SBY 2-16, SBY 5-7
normal transmission of, SAD 7-14, SBR 2-23
rearchiving, MIG 9-42
restoring to disk, SBR 5-6
restoring using RMAN, RMN 6-14
RMAN fails to delete, RMN 9-30
specifying destinations for, SAD 7-10, SBR 2-21
standby transmission of, SAD 7-14, SBR 2-23
status information, SAD 7-23, SBR 2-4, SBR 2-16
storage device, SRF 1-55, SRF 1-58
storage locations, SQL 7-89, SQL 7-112
transmitting, SAD 7-14, SBR 2-23, SBY 3-13
tuning, SAD 7-19
using for recovery
in non-default location, SBR 5-10
ARCHIVELOG clause
of ALTER DATABASE, SQL 7-9, SQL 7-18
of CREATE CONTROLFILE, SQL 7-266
ARCHIVELOG mode, PSA 3-2, PSA 3-8, SAD 7-4, SBR 2-18, SRF 1-55
advantages, SAD 7-4, SBR 2-19
archiver process (ARCn) and, SCN 1-18, SCN 8-12, SCN 359
archiving, SAD 7-3, SBR 2-17
archiving destination, SRF 1-55, SRF 1-58
automatic archiving, PSA 13-3, PSC 1-5, SRF 1-61
automatic archiving in, SAD 7-5
backup strategies when using, SBR 3-5
changing mode, PSA 3-2, PSA 3-8, PSC B-3
creating a database, PSA 3-2
datafile loss in, SBR 6-3
defined, SCN 359
definition of, SAD 7-4, SBR 2-18
distributed databases, SAD 7-5, SBR 3-9
enabling, SAD 7-6
manual archiving in, SAD 7-5
online and offline backups, PSA 13-3, PSC 1-5
overview, SBR 1-11, SCN 1-47
partial database backups, SCN 1-49, SCN 366
running in, SAD 7-4, SBR 2-18
strategies for backups in, SBR 3-5
switching to, SAD 7-6
taking datafiles offline and online in, SAD 10-8
whole database backups, SCN 365
archivelog process (ARCn)
tracing, SAD 7-25
archivelogRecoverSpecifier clause (RMAN), RMN 10-18
archiver, SAD 4-12
archiver process (ARCn)
automatic archiving, SCN 360
described, SCN 1-18, SCN 8-12
example, SCN 359
multiple processes, SCN 1-18, SCN 8-13
not used for manual archiving, SCN 362
trace file, SCN 361
archiving
advantages, SAD 7-3, SBR 2-17
after inconsistent closed backups, SBR 1-19
after open backups, SBR 1-19
ALTER SYSTEM ARCHIVE ALL statement, SBR 1-19
automatic
disabling, SAD 7-8
disabling at instance startup, SAD 7-8
enabling, SAD 7-7
enabling after instance startup, SAD 7-8
enabling at instance startup, SAD 7-8
changing archiving mode, SAD 7-6
destination states, SAD 7-12, SBY 2-18
active/inactive, SAD 7-13
enabled/disabled, SAD 7-13
valid/invalid, SAD 7-13
destinations
failure, SAD 7-16
disabling, SAD 7-6, SAD 7-8
disadvantages, SAD 7-3, SBR 2-17
enabling, SAD 7-6, SAD 7-8
error detection behavior, MIG 9-43
increasing speed of, SAD 7-22
manual, SAD 7-9
minimizing impact on system performance, SAD 7-22
multiple ARCH processes, SAD 7-20
privileges
disabling, SAD 7-8
enabling, SAD 7-7
for manual archiving, SAD 7-9
setting archive buffer parameters, SAD 7-21
setting initial mode, SAD 7-6
to failed destinations, SAD 7-19, SBY 2-18
trace, controlling, SAD 7-25
tuning, SAD 7-19
viewing information on, SAD 7-23, SBR 2-4, SBR 2-16
archiving redo log files, PSA 13-1
automatic versus manual, PSA 13-4
creating a database, PSA 3-2
forcing a log switch, PSA 13-15
history, PSA 13-7
identified in control file, PSC 7-5
log sequence number, PSA 13-6
online archiving, PSA 13-3, PSC 1-5
ARCHVIELOG clause
OF CREATE DATABASE, SQL 7-270
ARCn background process, SCN 1-18, SCN 8-12
See also archiver process
ARGS parameter, NET B-3
arguments
attributes, OCI 6-16
arguments of operators, SQL 3-1
ARGV0 parameter, NET B-3
arithmetic operators, SQL 3-3
array fetches, DDS 9-10
agents, DDS 9-11
array interface, STU 22-16
array of structs, PC_ 8-17, PC_ A-2
array processing, SCN 23
ARRAYLEN statement, PC_ 7-17, PCO 6-17
arrays, ADO 9-26
batch fetch, PC_ 8-5
BIND_ARRAY procedure, SPR 51-6
binds, OCI 12-3
bulk DML using DBMS_SQL, SPR 51-15
bulk operations (ANSI dynamic SQL), PC_ 14-8
chapter discusses how to use, PC_ 8-1
committing after insert
Import, SUT 2-19
defines, OCI 12-6
definition of, PC_ 4-41
host arrays, PC_ 2-7
operations, PC_ 2-7
size of VARRAYs, ADO 1-8, SCN 13-11
skip parameter for, OCI 5-24
variable (VARRAYs), ADO 1-8, SCN 13-11
varying length, PC_ 18-3
arrays of structures, OCI 5-22
indicator variables, OCI 5-25
OCI calls used, OCI 5-25
skip parameters, OCI 5-23
AS 'filespec' clause
of CREATE LIBRARY, SQL 7-317
AS clause
of CREATE JAVA, SQL 7-314
AS EXTERNAL clause
of CREATE FUNCTION, SQL 7-289, SQL 7-357
of CREATE TYPE BODY, SQL 7-450
AS OBJECT clause
of CREATE TYPE, SQL 7-440
AS SELECT option
CREATE TABLE statement, SBR 5-3
AS subquery
of CREATE MATERIALIZED VIEW / SNAPSHOT, SQL 7-319, SQL 7-328
of CREATE TABLE, SQL 7-409
of CREATE VIEW, SQL 7-459
AS TABLE clause
of CREATE TYPE, SQL 7-444
AS VARRAY clause
of CREATE TYPE, SQL 7-444
ASACC precompiler option, PCO 14-12
ASC clause
of CREATE INDEX, SQL 7-299
ascending indexes, SQL 7-299
ASCII
character set, SQL 2-34
Import, SUT 2-53
fixed-format files
exporting, SUT 1-3
ASCII character set
sorting order, NLS 2-28
ASCII function, SQL 4-14
ASIN function, SQL 4-15
A.SMD record, NET 7-11, NET 11-14, NET A-42
ASP, ADO 3-9
ASR. See Advanced Symmetric Replication (ASR).
assigning
one collection to another collection in temporary LOBs, ADL 10-11
one temporary LOB to another, ADL 10-10
assigning new pincode to SecurID card, OAS 7-12
assigning object classes to entries, OID 6-3
assignment operator, PLS 1-4
assignment statement
syntax, PLS 11-3
assignment tables, REP 3-11
assignments
aggregate, PLS 2-34
character string, PLS B-2
collection, PLS 4-11
cursor variable, PLS 5-32
field, PLS 4-47
record, PLS 4-47
semantics, PLS B-2
ASSOCIATE STATISTICS statement, SQL 7-210
Associating the Extensible Optimizer Methods with Database Objects, DCI 11-62
association operator, PLS 7-13
associations
downgrading, MIG 13-43
associative interface, PC_ 17-4
when to use, PC_ 17-4
ASSUME_SQLCODE precompiler option, PCO 14-13
AST
definition of, PSC 5-27
ASTERISK - oracle.xml.parser.v2.ElementDecl.ASTERISK, JPR 4-32
asterisk (*) row operator, PLS 5-3
asymmetrical multiprocessing, PSC 8-12
Asynchronous, ADQ 1-12
asynchronous (challenge-response) authentication mode in RADIUS, OAS 4-6
asynchronous I/O, DWG 18-26
parallel recovery and, SCN 352
asynchronous lock operations
analyzing, PSA 12-17
Asynchronous Notifications, ADQ 8-77
asynchronous operations, PLS 8-17
asynchronous processing, SCN 66
asynchronous replication, REP 2-29
asynchronous trap, PSC 5-29
asynchronous traps, PSC 5-27, PSC 5-30
Asynchronously Receiving Message w/ Message Listener, ADQ 12-82
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-45
of EXECUTE statement, PC_ F-52, PCO F-40
of INSERT statement, PC_ F-69
of INSERT statements, PCO F-56
of SAVEPOINT statement, PC_ F-102, PCO F-79
of SELECT statement, PC_ F-105, PCO F-82
of SROLLBACK statement, PC_ F-99
of UPDATE statement, PC_ F-113, PCO F-87
restriction on, PC_ 3-11
restrictions, PCO 3-7
use of, PC_ 3-10
ATAN function, SQL 4-15
ATAN2 function, SQL 4-16
atomic nullness, OCI 10-29
atomic nulls, ADO 2-2, SUT 5-94
atomically null, PLS 9-23
attack
data modification, OAS 2-5
replay, OAS 2-5
Attempts Per Names Server field, NET 6-63
AttListDecl - oracle.xml.parser.v2.XMLToken.AttListDecl, JPR 4-135
AttName - oracle.xml.parser.v2.XMLToken.AttName, JPR 4-136
ATTRDECL - oracle.xml.parser.v2.XMLNode.ATTRDECL, JPR 4-106
Attribute - oracle.xml.parser.v2.XMLToken.Attribute, JPR 4-136
ATTRIBUTE clause
of ALTER DIMENSION, SQL 7-26
of CREATE DIMENSION, SQL 7-280
attribute descriptor object, OCI 11-23
attribute indexes, created by bulkload, OID 7-29
attribute indicator, PLS 1-7
attribute syntax, OID 2-6
attribute values, size, OID F-8
attribute-level conflicts, OID 10-25
attributes, DWG 9-7, PLS 1-7
%ROWTYPE, PLS 2-33
%TYPE, PLS 2-32
adding, OID 6-18
by using ldapadd, OID A-7
by using ldapmodify, OID 6-31
by using Oracle Directory Manager, OID 6-24, OID 6-28
concurrently, using ldapaddmt, OID A-9
guidelines for, OID 6-18
to existing entries, OID A-7
adding to a dimension, SQL 7-27
AlternateServers, for failover, OID 14-4
as DNs, OID 7-11
base schema
deleting, OID 6-19
modifying, OID 6-19
c, NET 2-40
cn, NET 2-40
commonName, NET 2-40, OID 2-5
configuration set entry, OID F-5
country, NET 2-40
cursor, PLS 5-35
defined, NET 2-40
deleting, OID 6-19, OID A-13
guidelines for, OID 6-19
values, using ldapmodify, OID A-13
determined by object classes, OID 6-2
domain component, NET 2-40
dropping from a dimension, SQL 7-27
dropping indexes from, OID 6-31
in base schema, OID 6-18
in LDIF files, OID A-2
indexed, OID 6-12, OID 6-30
indexing, OID 6-34
by using command line tools, OID 6-33
using Oracle Directory Manager, OID 6-30
inheritance of, OID 6-2, OID 6-12
jpegPhotos, OID 2-5, OID 7-26
kinds of information in, OID 2-4
leaf-level, ADO 7-1
leaf-level scalar, ADO 7-1
making available for searches, OID 6-30
managing
by using Oracle Directory Manager, OID 6-19
overview, OID 6-18
using command line tools, OID 6-31
mandatory, OID 2-7, OID 6-2, OID 7-22
matching rules, OID 2-6
maximum number of in object type, SQL 7-392, SRF 4-2
modifying
guidelines for, OID 6-18
rules for, OID 6-18
using command line tools, OID 7-25
using ldapmodify, OID 6-31
multi-valued, OID 2-4, OID 9-3
converting to single-valued, OID 6-19
null, SUT 5-93
null values in, OID 6-2
o, NET 2-41
object, PLS 9-3, PLS 9-7
object types, SCN 13-2, SCN 13-4
objectclass, OID 5-25
objects associated with an ACI, OID 9-6
of dimensions, defining, SQL 7-280
of handles, OCI 2-13
of object types, ADO 1-3
of objects, OCI 10-17
of parameter descriptors, OCI 6-5
of parameters, OCI 6-5
optional, OID 2-7, OID 6-2
orclauditlevel, OID 5-28
orclauditmessage, OID 5-25
orclauditoc, OID 5-25
orclDBDistinguishedName, OAS E-2
orclDBGlobalName, OAS E-2
orclDBNativeUser, OAS E-2
orclDBRoleOccupant, OAS E-2
orclDBServerMember, OAS E-2
orclDBServerRole, OAS E-2
orclDBTrustedDomain, OAS E-2
orclDescList, NET D-5
orclDescName, NET D-5
orcleventtime, OID 5-25
orcleventtype, OID 5-25
orclLoadBalance, NET D-5
orclNetAddrList, NET D-5
orclNetAddrString, NET D-5
orclNetConnParamList, NET D-5
orclNetFailover, NET D-5
orclNetInstanceName, NET D-5
orclNetProtocol, NET D-5
orclNetProtocolStack, NET D-5
orclNetSdu, NET D-5
orclNetServiceName, NET D-5
orclNetSourceRoute, NET D-5
orclopresult, OID 5-25
orclsequence, OID 5-25, OID 5-26
orclSid, NET D-5
orcluserdn, OID 5-25
orclVersion, NET D-5
organization, NET 2-41, OID 2-5
organizationalUnitName, OID 2-5
organizationUnitName, NET 2-41
ou, NET 2-41
redefining mandatory, OID 6-3
searching for, by using Oracle Directory Manager, OID 6-19
single-valued, OID 2-4
converting to multi-valued, OID 6-19
size of values, OID F-8
sn, OID 2-5
specifying as mandatory or optional, OID 6-2
stored in schema, OID 2-10
surname, OID 2-5
syntax, OID 2-6
syntaxes
cannot modify, OID 6-19
selecting, OID 6-32
system operational, OID 5-15
tab page in Oracle Directory Manager, OID 6-10
types, OID 2-3
values, OID 2-3
rules for changing, OID 7-22
viewing, OID 7-11
attributes for resources
client resource, LEG 2-20, LEG 2-21, LEG 2-22, LEG 2-23
server resource, LEG 2-26, LEG 2-27
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-4
Attributes of Viiew, ADQ 10-1
attributes, USERENV, ADG 11-43
AttValue - oracle.xml.parser.v2.XMLToken.AttValue, JPR 4-136
AUD, SMS 47-1
AUDIT (Schema Objects) statement, SQL 7-221
AUDIT ANY system privilege, SQL 7-529
audit levels, OID 5-27
audit log, OID 5-24
cleaning up entries, OID 5-24
container object, OID 5-30
default configuration, OID 5-24
entries
position in DIT, OID 5-26
searching, OID 5-24, OID 5-26
viewing, OID 5-24
queries, OID 5-24
sample, OID 5-26
schema elements, OID F-4
structure of entries, OID 5-25
using, OID 5-24
audit log events
access violation, OID 5-27
ACL modification, OID 5-27
add, OID 5-27
bind, OID 5-27
deleting, OID 5-27
DSE modification, OID 5-27
modify, OID 5-27
modifyDN, OID 5-27
replication login, OID 5-27
schema element
add/replace, OID 5-27
delete, OID 5-27
selected, OID 5-28
super user
login, OID 5-27
user password modification, OID 5-27
AUDIT sql_statements statement, SQL 7-213
AUDIT statement, SAD 24-9, SCN 13
BY proxy clause, SAD 24-11
locks, SCN 240
schema objects, SAD 24-10
statement auditing, SAD 24-10
system privileges, SAD 24-10
AUDIT SYSTEM system privilege, SQL 7-521
audit trail, SAD 24-14, STU 11-4
archiving, SAD 24-15
auditing changes to, SAD 24-17
controlling size of, SAD 24-14
creating and deleting, SAD 24-4
deleting views, SAD 24-5
described, NET 12-25
dropping, SAD 24-4
interpreting, SAD 24-17
maximum size of, SAD 24-14
protecting integrity of, SAD 24-16
purging records from, SAD 24-15
recording changes to, SAD 24-17
records in, SAD 24-7
reducing size of, SAD 24-16
script for using information, NET 12-26
table that holds, SAD 24-2
views on, SAD 24-4
AUDIT_ACTIONS table, SRF 2-93
AUDIT_FILE_DEST initialization parameter, SRF 1-14
AUDIT_TRAIL initialization parameter, SRF 1-15
migration, MIG A-3
setting, SAD 24-13
auditable events, OID 5-27
auditing, SAD 24-2, SCN 1-43, SCN 329
audit option levels, SAD 24-8
audit options, SCN 331
audit records, SCN 331
AUDIT statement, SAD 24-9
audit trail records, SAD 24-5
audit trails, SCN 331
database, SCN 331
operating system, SCN 333, SCN 334
by access, SCN 339
mandated for, SCN 340
by session, SCN 338
prohibited with, SCN 340
compromised by One Big Application User, ADG 11-6
conflict resolution, RAR 6-29
connect with administrator privileges, SCN 333
data dictionary used for, SCN 2-5
database and OS usernames, SCN 282
database links, DDS 1-31
DDL statements, SCN 335
default options, SAD 24-10
deleting data in dictionary, SCN 2-5
described, SCN 1-43, SCN 330
disabling default options, SAD 24-13
disabling options, SAD 24-11, SAD 24-12, SAD 24-13
disabling options versus auditing, SAD 24-12
distributed databases and, SCN 334
DML statements, SCN 335
enabling options, SAD 24-9, SAD 24-13
about, SAD 24-9
privileges for, SAD 24-13
enabling options versus auditing, SAD 24-9
guidelines, SAD 24-2
historical information, SAD 24-4
keeping information manageable, SAD 24-2
managing the audit trail, SAD 24-4
multi-tier environments, SAD 24-11
n-tier systems, ADG 11-66, ADG 11-71
operating-system audit trails, SAD 24-7
options
for database objects, SQL 7-215
for SQL statements, SQL 7-218
partitioned tables and indexes, SCN 11-63
policies for, SAD 21-19
privilege audit options, SAD 24-8
privilege use, SCN 330, SCN 335
privileges required for object, SAD 24-11
privileges required for system, SAD 24-10
range of focus, SCN 331, SCN 337
schema object, SCN 330, SCN 336
schema objects, SAD 24-10
stopping, SQL 7-552
security and, SCN 334
session level, SAD 24-8
SQL statements, SQL 7-215
SQL statements, stopping, SQL 7-550
startup and shutdown, SCN 333
statement, SAD 24-10, SCN 330, SCN 335
statement level, SAD 24-8
successful executions, SCN 337
suspicious activity, SAD 24-3
system privileges, SAD 24-10
transaction independence, SCN 332
triggers and, ADG 13-34, SAD 24-20, SAD 24-21
types of, SCN 330
unsuccessful executions, SCN 337
user, SCN 340
using the database, SAD 24-2
viewing
active object options, SAD 24-19
active privilege options, SAD 24-19
active statement options, SAD 24-18
default object options, SAD 24-19
views, SAD 24-4
when options take effect, SCN 333
auditing selected events, OID 5-28
authenticated access, using SSL, OID 1-5
AUTHENTICATED BY clause
CREATE DATABASE LINK statement, DDS 2-16
of CREATE DATABASE LINK, SQL 7-275
authenticated RPC
protocol adapter includes, OAS 12-3
authenticating remote clients, SRF 1-103
authenticating users, SRF 1-90
authentication, OAS 1-6, OAS 1-11, OID 2-20, OID 2-21, OID 2-33
anonymous, OID 1-5, OID 2-21, OID 4-4
in access control, OID 9-24, OID 9-30
biometric, OAS 8-1
by database, SAD 22-8
by SSL, SAD 22-7, SAD 22-12
certificate-based, OID 1-5, OID 2-22
compromised by One Big Application User, ADG 11-6
configuring multiple methods, OAS 11-4
database administrators, SCN 291
database links, DDS 1-25
described, SCN 281
directory service, SAD 22-12
external, SAD 22-9
global, SAD 22-11
in Oracle Internet Directory, OID 1-5
Kerberos, OID A-8, OID A-10, OID A-16
middle tier, ADG 11-4, ADG 11-64, ADG 11-65, ADG 11-66, ADG 11-67
modes in RADIUS, OAS 4-5
multi-tier, SAD 22-13, SCN 287
network, SCN 282
no SSL, OID 4-6
none, in access control, OID 9-24, OID 9-30
n-tier systems, ADG 11-69
one-way SSL, OID 2-22
operating system, SAD 1-7, SCN 282
options, OID 2-21
Oracle, SCN 285
parameters, OID F-5
password file, SAD 1-9
password policy, SAD 21-5
password-based, OID 1-5, OID 2-21, OID 4-4
PKI, OID 2-21
public key infrastructure, SCN 283
remote, SCN 285
simple, OID 1-5, OID 4-4
for access control subjects, OID 9-24, OID 9-30
specifying for access control subjects, OID 9-23, OID 9-30
specifying no SSL, OID F-5
specifying when creating a user, SAD 22-15
SSL, OID 2-22, OID A-7, OID A-8, OID A-10, OID A-11, OID A-15
for Oracle Directory Manager, OID 4-6
one-way, OID F-5
server only, OID 4-6
two-way, OID 4-6
strong, OID 2-21
two-way SSL, OID 2-22, OID F-5
users, SAD 21-2
ways to authenticate users, SAD 22-7
authentication management, OCI 8-12
authentication methods
CyberSAFE, NET 4-26
Identix, NET 4-26
Kerberos, NET 4-26
NDS, NET 4-25
Novell Directory Services, NET 4-25
RADIUS, NET 4-26
SecurID, NET 4-26
SSL, NET 4-26
Windows NT native authentication, NET 4-25
AUTHENTICATION_DATA attribute, ADG 11-44
AUTHENTICATION_LEVEL parameter, NET C-73
AUTHENTICATION_TYPE attribute, ADG 11-44
AUTHID clause, PLS 7-4, PLS 7-6, PLS 7-31
AUTHID CURRENT_USER clause
of ALTER JAVA, SQL 7-46
of CREATE FUNCTION, SQL 7-288
of CREATE JAVA, SQL 7-313
of CREATE PACKAGE, SQL 7-345
of CREATE PROCEDURE, SQL 7-357
of CREATE TYPE, SQL 7-188, SQL 7-441
AUTHID DEFINER clause
of ALTER JAVA, SQL 7-46
of CREATE FUNCTION, SQL 7-288
of CREATE JAVA, SQL 7-313
of CREATE PACKAGE, SQL 7-345
of CREATE PROCEDURE, SQL 7-357
of CREATE TYPE, SQL 7-188, SQL 7-441
authorization, OAS 1-10, OID 2-20, OID 2-25
changing for roles, SAD 23-7
global, SAD 22-11
omitting for roles, SAD 23-7
operating-system role management and, SAD 23-9
roles
about, SAD 23-8
multi-threaded server and, SAD 23-9
authorization ID, OID 2-21
authorize functions, OCI 15-90
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-10
AUTO_CONNECT precompiler option, PC_ 10-11, PCO 14-14
AUTOEXTEND, PSA 9-5
AUTOEXTEND clause
for datafiles, SQL 7-17
of ALTER DATABASE, SQL 7-10
of ALTER TABLESPACE, SQL 7-177, SQL 7-179
of CREATE DATABASE, SQL 7-268
of CREATE TABLESPACE, SQL 7-419, SQL 7-421
of CREATE TEMPORARY TABLESPACE, SQL 7-424, SQL 7-425
AUTOLOCATE
RMAN option, PSA 13-11
Automated, ADQ 1-15
automated parallel query tuning, GTK 3-27
automated standby databases, GTK 3-50
automatic archival, GTK 3-50
read-only databases, GTK 3-51
automatic archiving, PSA 13-4
automatic bootstrap backup, LEG 2-5, LEG 4-8
automatic connections, PC_ 3-4, PC_ 3-8
automatic logons, PCO 3-5, PCO 3-9
automatic recovery, PSA 13-8
AUTOMATIC_IPC parameter, MIG F-14, NET 8-21, NET C-80
autonomous PL/SQL blocks, GTK 3-78
autonomous routine, ADG 7-32
autonomous scope
versus autonomous transaction, ADG 7-32
autonomous transactions, ADG 7-32 to ADG 7-40, PLS 5-52
advantages, PLS 5-52
compatibility, MIG 9-13
controlling, PLS 5-56
autonomous triggers, PLS 5-58
AUTONOMOUS_TRANSACTION, ADG 7-32
AUTONOMOUS_TRANSACTION pragma, PLS 5-53
syntax, PLS 11-7
AUTORECOVERY option
SET statement, SBR 5-11
auxiliary
object class type, OID 2-9
object classes, OID 6-4
auxiliary databases
for RMAN TSPITR
converted filenames, RMN 8-15
using datafile copies, RMN 8-14
auxiliary sets
for RMAN TSPITR, RMN 8-4
naming datafiles in tablespaces, RMN 8-13
Availability, ADQ 5-2
availability
and interconnect, PSC 2-5
benefit of parallel databases, PSC 1-3
capacity planning, PSC 9-4
data files, PSA 14-4, PSC 7-2
measuring, PSC 9-2
shared disk systems, PSC 2-6
single-node failure, PSA 14-2
steps of recovery, PSA 14-5
availability, capabilities in Oracle Internet Directory, OID 14-7
available option (RMAN)
change command, RMN 3-13
available()
as a function of UTL_TCP, SPR 66-5
average conflict resolution method, REP 5-16
Average Elapsed Time data view, STU 14-11
average latency, OID 13-2
AVG aggregate function, PLS 5-3
AVG function, SQL 4-16
avoiding dangerous backup techniques, SBR 3-10
AY date format element, SQL 2-46

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents