Getting to Know Oracle8i
Release 8.1.5

A68020-01

Library

Product

Contents

Prev

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 


A

Advanced Networking Option, 2-70
Advanced Queuing, 2-37 to 2-40, 3-6
database event publication, 2-39
multiple consumer queues, 2-39
nonpersistent queues, 2-40
object level and system level privileges, 2-40
parallel server mode, 2-40
propagation, enhanced, 2-39
addition of a sender's ID column, 2-39
history management information, 2-39
single view, 2-39
statistics, 2-39
rules engine, 2-38
see also publish/subscribe
advanced replication, 2-64 to 2-66
column level snapshot subsetting, 2-65
internal apply packages, 2-64
mass deployment support, 2-65
offline snapshot instantiation, 2-65
Oracle Lite integration, improved, 2-66
Replication Manager, 2-66
security, improved, 2-66
snapshot deployment templates, parameterized, 2-65
snapshot refresh, 2-64
Advanced Security option. See Oracle Advanced Security.
aggregate distinct queries, parallelization of, 2-26
ALTER INDEX statement
COMPUTE STATISTICS clause, 2-27
online rebuild, 2-42
ALTER TABLE statement
drop column support, 2-41
ENABLE ROW MOVEMENT, 2-46
merging partitions, 2-46
MODIFY CONSTRAINT clause, 2-28
MOVE option for IOT or non-partitioned table, 2-29
no longer invalidates bitmap indexes, 2-25
ANALYZE command
dangling REFs, 2-36
ANALYZE command,parallel, 3-2
ANO. See Advanced Networking Option.
application context, 2-69
CREATE CONTEXT statement, 2-70
Application Generator for Microsoft Visual Studio, 2-85
automated parallel query tuning, 2-27
automated standby databases, 2-50
automatic archival, 2-50
read-only databases, 2-51
automatic instance registration, Net8, 2-76
autonomous PL/SQL blocks, 2-78

B

backup and recovery, incremental, 3-6
bitmap indexes, 3-4
ALTER TABLE no longer invalidates, 2-25
new ALTER TABLE options
MINIMIZE RECORDS PER BLOCK, 2-25
NOMINIMIZE RECORDS PER BLOCK, 2-25

C

cache fusion, 2-61
call specs, 2-19, 2-44
cartridge services, 2-32
certificate authority, 2-74
collections
collection unnesting, 2-35
SQL*Loader support, 2-36
COM Cartridge, 2-87
compatibility flag, 6-6
composite partitioning, 2-46
COMPUTE STATISTICS option of CREATE and ALTER INDEX statements, 2-27
CONNECT INTERNAL desupported, 6-6
Connection Manager, Oracle, 3-6
connection multiplexing, 3-6
connection pooling, 3-6
constraint processing, 3-14
constraints
constraint modification with ALTER TABLE, 2-28
DISABLE VALIDATE constraint state, 2-28
control file character set, 2-52
CORBA, 2-19
CREATE CONTEXT statement, 2-70
CREATE MATERIALIZED VIEW statement, 2-22
CREATE OUTLINE statement, 2-37
CREATE_STORED_OUTLINES session parameter, 2-37
Cryptographic Toolkit, 6-8
CUBE operation, GROUP BY clause, 2-24

D

Data Migration Assistant, 2-60
data mining, 2-24
Data warehousing
DISABLE VALIDATE state, 2-28
data warehousing, 2-21 to 2-30
database resource manager, 2-48
function-based indexes, 2-24
materialized views, 2-22
related features, 2-30
SAMPLE function, 2-24
statistics gathering
COMPUTE STATISTICS option of CREATE and ALTER INDEX statements, 2-27
DBMS_STATS package, 2-27
transportable tablespaces, 2-23
Database Configuration Assistant, 2-59
database resource management, 2-48
database resource manager, 2-48
DBMS_RESOURCE_MANAGER package, 2-49
DBMS_RESOURCE_MANAGER_PRIVS package, 2-49
resource allocation methods, 2-49
resource consumer groups, 2-49
resource plan directives, 2-49
resource plans, 2-49
database SUSPEND/RESUME, 2-52
date format strings, 6-2
direct path load API, 2-24
distributed lock manager (DLM), 2-62
distributed systems, 2-64 to 2-68
documentation
online, 5-2
printed part numbers, 5-5
drop column, 2-41
dynamic (connection) load balancing, Net8, 2-76

E

Enterprise JavaBeans, 2-19
Enterprise Manager, 2-60
Export/Import utilities, 2-57
extended aggregate operators, 2-24
extensibility, 3-13
extensibility framework, 2-31 to 2-33
cartridge services, 2-32
extensible indexing, 2-31
extensible optimizer, 2-32
heterogeneous services, 2-66
user-defined operators, 2-31
extensible indexing, 2-31
extensible optimizer, 2-32
external procedures (routines)
call specification, 2-44
DLL Caching, 2-45
object support, 2-45
Pro*C/C++, 2-81
external procedures. See external routines
external routines, 3-12
external routines. See external procedures (external routines)

F

factoring matrix
features, 4-4
options, 4-2
Fast-Start fault recovery, 2-51
see also transaction recovery
feature factoring matrix, 4-4
fine-grained access control, 2-69
DBMS_RLS package, 2-69
function-based indexes, 2-24

G

Group Membership Services (GMS), 2-62

H

hash cluster, single-table-only, 2-26
hash partitioning, 2-46
heterogeneous services
agent self-registration, 2-67
agent shared library, 2-67
fixed views, 2-67
multi-threaded service agent, 2-67

I

iFS. See Internet File System
IIOP, 2-71
indexes
building online, 2-41
defragment using COALESCE, 2-42
descending, 2-25
extensible indexing, 2-31
function-based, 2-24
secondary for index-organized tables, 2-29
see also bitmap indexes
index-organized tables, 3-14
full table functionality, 2-29
key compression, 2-29
LOB column support, 2-29
logical ROWIDs, 2-29
nested table data, 2-34
parallel loading of, 2-29
partitioning, 2-47
rebuilding with ALTER TABLE MOVE, 2-29
secondary indexes, 2-29
instance affinity for jobs, 2-63
DBMS_JOB package, 2-63
INSTEAD OF trigger, 3-15
interMedia
Audio, Image, and Video, 2-8
Audio, Image, and Video Java Client, 2-9
Locator, 2-9
Text, 2-6
Web based tools, 2-3
invoker rights, 2-78
IOTs. See index-organized tables

J

Java, 3-13
JDBC drivers, 2-17
SQLJ translator, 2-18
Java development tools/utilities
JDeveloper, 2-21
JPublisher, 2-20
loadjava and dropjava, 2-21
Java VM, 2-16
development models
CORBA, 2-18
EJBs, 2-18
Java stored procedures, 2-18
JServer Accelerator, 2-18
JDBC, 3-13
JDeveloper, 2-21
JPublisher, 2-20
JServer Accelerator, 2-16
JServer. See Java VM
JSQL, 3-13
JVM. See Java VM

L

LDAP, 2-73, 2-74
Legato Storage Manager, 3-6
Lightweight Directory Access Protocol. See LDAP.
loadjava and dropjava, 2-21
LOBs
convert LONG to LOB, 2-33
DBMS_LOB API to append data to LOB, 2-34
in index-organized tables, 2-29
LOB chunk size, 2-34
Open/Close/IsOpen APIs, 2-34
partitioning of tables with, 2-47
SQL*Loader support, 2-36
temporary, 2-33
variable width character sets for CLOBs and NCLOBs, 2-34
locally managed tablespaces, 2-41
LOG_ARCHIVE_DEST_n initialization parameter, 2-50
logical ROWIDs, 2-29
LogMiner, redo log analysis, 2-40
long running operations, statistics generation for, 2-28

M

materialized views. See summary management
Media Management API
version 2.0, 2-53
Microsoft Transaction Server integration, 2-86
migration utility, 3-14
multimedia data, 3-13
multiplexing, connection, 3-6
multi-tier authentication and authorization, 2-77

N

national language support, 2-43
native authentication on Windows NT, 2-77
NCHAR datatype, 3-15
nested tables
collection locators, 2-34
data stored in indexed-organized table, 2-34
OCICollIsLocator(), 2-34
triggers on view columns, 2-35
user-specified storage clauses for, 2-34
UTL _COLL package, 2-34
Net8, 2-64, 2-71
automatic instance registration, 2-76
dynamic (connection) load balancing, 2-76
native authentication on Windows NT, 2-77
Net8 Assistant, 2-75
Net8 Easy Config, 2-75
service naming, 2-75
NOCOPY parameter passing mode, 2-79
non-deferred linking, 6-4

O

object cache, 2-35, 2-36, 3-12
Object Database Designer, 3-13
object relational enhancements, 2-33 to 2-37
ANALYZE command, dangling REFs, 2-36
collection unnesting, 2-35
object cache enhancements, 2-36
object identifiers, user defined, 2-34
object views, 2-35
parallel query support, 2-37
partitioning of tables containing user-defined types, 2-37
referential integrity constraint on REF column, 2-34
SQL*Loader support, 2-36
value subqueries, 2-36
see also LOBs
see also nested tables
see also varrays
Object Type Translator, 3-12
object types, 3-11
object views, 2-35, 3-11, 3-12
object-relational technology, 3-10
Objects for OLE, 2-86
OCI enhancements, 2-83
API to append data to LOB, 2-34
AQ support, 2-38
array DMLs, 2-84
asynchronous event notification, 2-84
collection locator, 2-34
direct path load, 2-24
DML returning, 2-83
LOBs, 2-34
NLS interface, 2-43
non-blocking OCI, 2-85
object cache, 2-36
OCI callback registrations, 2-84
OCIDescribeAny, 2-84
Open/Close/IsOpen API for LOBS, 2-34
UCS2 (fixed-width Unicode) support, 2-43
OCI non-deferred linking, 6-4
OCI single-task linking, 6-5
OCI support for client notification, 2-38
see also OCI enhancements, asynchronous event notification
OiD, 6-8
OiD. See Oracle Internet Directory.
online index builds, 2-41
online read-only tablespaces, 2-42
OPS Assistant, 2-62
optimizer
and remote join enhancement, 2-68
and ROLAP enhancement, 2-24
extensible, 2-32
plan stability, 2-37
option factoring matrix, 4-2
Oracle Advanced Security, 2-70
integrated security and directory services, 2-72
RADIUS, 2-72
SSL, 2-70
Oracle Advanced Security option, 6-8
Oracle Connection Manager, 3-6
Oracle Database Configuration Assistant, 2-59, 2-63
Oracle Internet Directory, 2-70, 2-74
Oracle Internet File System, 2-2
Oracle Management Server (OMS), 2-61
Oracle Parallel Server Management (OPSM), 2-62
Parallel Server Manager, 2-62
Oracle Parallel Server Management(OPSM)
Group Membership Services (GMS), 2-62
OPS Assistant, 2-62
Oracle Security Server, 2-70, 2-72, 6-8
Oracle Software Packager, 2-58
Oracle Universal Installer, 2-59, 2-63
Oracle wallet, 2-74
Oracle Wallet Manager, 2-73
Oracle8i Spatial, 2-10
Oracle8i Time Series, 2-13
Oracle8i Visual Information Retrieval, 2-12
Oradebug, 2-62
OSS. See Oracle Security Server.

P

packages
DBMS_APPLICATION_INFO, 2-28
DBMS_DEBUG, 2-80
DBMS_JOB, 2-63
DBMS_LOB, 2-34
DBMS_OLAP, 2-23
DBMS_PROFILER, 2-80
DBMS_REPAIR, 2-40
DBMS_RESOURCE_MANAGER, 2-49
DBMS_RESOURCE_MANAGER_PRIVS, 2-49
DBMS_RLS, 2-69
DBMS_SQL, 2-79
DBMS_STATS, 2-27
DBMS_TRACE, 2-79
OUTLN_PKG, 2-37
UTL_COLL, 2-34
UTL_REF, 2-79
parallel ANALYZE, 3-2
parallel DML, 2-46, 3-4
parallel index scans, 3-4
parallel query, 3-4
automated tuning, 2-27
parallel server, 2-61 to 2-63
cache fusion, 2-61
database configuration, 2-63
distributed lock manager (DLM), 2-62
Group Membership Services (GMS), 2-62
installation, 2-63
instance affinity for jobs, 2-63
inter process communication protocol, 2-62
OPS Assistant, 2-63
Oradebug, 2-62
see also, OPSM
Parallel Server Manager, 2-62
parallelization of aggregate distinct queries, 2-26
parameter passing by reference, 2-79
partition elimination, enhanced, 2-47
partition views, 6-6
partitioning, 3-2
new partitioning methods
composite, 2-46
hash, 2-46
local indexes, 2-47
queries, DML, and DDL for, 2-47
of index-organized tables, 2-47
of object tables, 2-37
of tables containing user defined types, 2-37
of tables with LOBs, 2-47
range partitioning enhancements
merging partitions, 2-46
updatable partition keys, 2-46
PKI, 2-73
plan stability for optimizer, 2-37
PL/SQL, 2-78
autonomous blocks, 2-78
bulk binds, 2-79
dynamic SQL
DBMS_SQL package, 2-79
increased package body size, 2-80
invoker rights, 2-78
monitoring and analysis of program execution
DBMS_DEBUG, 2-80
DBMS_PROFILER, 2-80
DBMS_TRACE, 2-79
NOCOPY parameter passing mode, 2-79
parameter passing by reference, 2-79
procedures for supporting REF-based operations
UTL_REF package, 2-79
purity rules relaxed, 2-80
see also external procedures (routines)
precompilers, enhancements, 2-81
Pro*C/C++, 2-81
Pro*COBOL, 2-82
program interfaces, 2-77 to 2-87
publish/subscribe
client notification, 2-38
database event publication, 2-39
publishers, 2-38
rules based subscriptions, 2-38
subscribers, 2-38
publish/subscribe, AQ based, 2-38

R

RADIUS, 2-72
range partitioning, 2-46
read-only databases, 2-51
recoverability and availability enhancements
multiple ARCH processes, 2-50
multiple, remote archive destinations, 2-50
see also automated standby databases
Remote Authentication Dial-In User Service. See RADIUS
remote join enhancements, 2-68
Reorganizing non-partitioned table with ALTER TABLE MOVE option, 2-42
replication, 3-9
Replication Manager, 2-66
see also advanced replication
Replication Manager, 2-66
reverse key indexes, 3-14
ROLAP enhancements, 2-24
ROLLUP operation, GROUP BY clause, 2-24
ROWIDs
logical, 2-29
universal, 2-30

S

SAMPLE function, 2-24
Secure Sockets Layer. See SSL
security enhancements, 2-68 to 2-77
application context, 2-69
fine-grained access control, 2-69
integrated security and directory services, 2-72
multi-tier authentication and authorization, 2-77
native authentication on Windows NT, 2-77
SERIALIZABLE=TRUE, 6-2
Server Manager, 6-7
service naming, Net8, 2-75
SGADEF file, 6-7
single sign-on, 3-9
single-table-only hash cluster, 2-26
single-task linking, 6-5
Software Packager, Oracle, 2-58
sort improvements, 2-26
spatial data, 2-10
SQL*Loader, 2-36, 2-47, 2-56
SQL92_SECURITY initialization parameter, 6-2
SSL, 2-70
Public Key Infrastructure, 2-73
X.509v3 certificates, 2-71
star-query optimization, 3-3
statistics generation for long running operations, 2-28
stored procedures, Java, 2-19
summary management, 2-22
CREATE MATERIALIZED VIEW statement, 2-22
dimensions (dimension schema object), 2-22
materialized view, 2-22
query rewrite, 2-22
refreshing materialized views, 2-22
summary advisory functions package (DBMS_OLAP), 2-23

T

tables
drop column support, 2-41
temporary, 2-42
tablespace point-in-time recovery, 3-6
tablespaces
locally managed, 2-41
online read-only, 2-42
point-in-time recovery, 3-6
transportable, 2-23
temporary tables, 2-42
THE keyword for subqueries, 6-7
Time Series, 2-13
transaction recovery
fast-start checkpointing, 2-51
Fast-Start on-demand rollback, 2-52
Fast-Start parallel rollback, 2-52
inter-transaction, 2-52
intra-transaction, 2-52
transparent application failover, 3-8
transportable tablespaces, 2-23
triggers
on DATABASE and SCHEMA, 2-39
on nested table view columns, 2-35
with CALL to a procedure as trigger body, 2-39
TRIM function, 2-44

U

Universal Installer, 2-59, 2-63
universal ROWIDs (UROWIDs), 2-30
UROWID datatype, 2-30
USE_STORED_OUTLINES session parameter, 2-37
user defined object identifiers, 2-34
user-defined operators, 2-31

V

V$OPTION table, 4-14
V$SESSIONS_LONGOPS view, 2-28
Version 6, 6-6
value subqueries
argument to a type constructor or function, 2-36
in VALUES clause of INSERT statement, 2-36
varrays
storage parameters for storing as LOBs, 2-35
virtual private database, 2-45, 2-68
Visual Information Retrieval, 2-12

W

Wallet Manager, Oracle, 2-73
WebDB, 2-2, 2-5

X

X.509 certificates, 2-72
X.509v3 certificates, 2-71, 2-73
XA support, 3-8

Z

zero-length strings, 6-2


Prev
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents