Getting to Know Oracle8i
Release 8.1.5
A68020-01

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

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

printed part numbers, 5-5

drop column, 2-41

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

E

F

factoring matrix

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

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

Web based tools, 2-3

invoker rights, 2-78

IOTs. See index-organized tables

J

JDBC drivers, 2-17

SQLJ translator, 2-18

Java development tools/utilities

JDeveloper, 2-21

JPublisher, 2-20

loadjava and dropjava, 2-21

development models

Java stored procedures, 2-18

JServer Accelerator, 2-18

JDeveloper, 2-21

JPublisher, 2-20

JServer Accelerator, 2-16

JServer. See Java VM

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

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

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

OSS. See Oracle Security Server.

P

packages

DBMS_APPLICATION_INFO, 2-28

DBMS_DEBUG, 2-80

DBMS_OLAP, 2-23

DBMS_PROFILER, 2-80

DBMS_REPAIR, 2-40

DBMS_RESOURCE_MANAGER, 2-49

DBMS_RESOURCE_MANAGER_PRIVS, 2-49

DBMS_STATS, 2-27

DBMS_TRACE, 2-79

OUTLN_PKG, 2-37

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

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

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

plan stability for optimizer, 2-37

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

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

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

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

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

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

Copyright © 1999 Oracle Corporation.
All Rights Reserved.