Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Overview of Oracle9i

Introducing Oracle9i

Oracle9i Database

Oracle9i Application Server

Oracle9i Developer Suite

Oracle9i Database New Features

Availability

Scalability

Performance

Security

Development Platform for Developing E-Business Applications

Manageability

Windows Integration

Internet Content Management

E-Business Integration

Packaged Applications

Business Intelligence

2 Oracle9i Database New Features

Oracle9i Database

Availability

Enhanced Disaster Recovery Environment

Online Data Evolution

Precision Database Repair

Scalability

Increased Transaction Throughput on Oracle9i Real Application Clusters

Scalable Session State Management

Fine-Grained, Automatic Resource Management

Performance

Security

Strong Three-Tier Security

Security for Hosting Environments

Standards-Based Public Key Infrastructure (PKI)

Improved User and Security Policy Management

Data Encryption and Label Security

Manageability

Oracle9i Systems Management

Database Self-Management

Streamlined Operational Management of the Database

Enhanced Recovery Manager (RMAN) Performance

Simplification of Oracle9i Administration Through Oracle Enterprise Manager

Management of the Oracle Stack Through Oracle Enterprise Manager

Development Platform for E-Business Applications

Enterprise Java Engine

New XML Features in the Server

Oracle XML Developer's Kit

SQL and PL/SQL Improvements

Windows Integration

Integration Capabilities

Development and Deployment Improvements

Internet Content Management

Storage, Management, and Aggregation of All Types of Content

Efficient Searching and Indexing of All Types of Content

Collaborative Projects

Location-Enabled, Mobile-Ready Content

E-Business Integration

Provides a Standard Infrastructure

Supports Industry Standard Business Messaging Formats

Packaged Applications

Database Globalization

Development Features for Independent Software Vendors

Business Intelligence

Performance, Scalability, and Manageability

Data Warehouse Manageability

Integrated Analysis and Personalization Capabilities

Other Oracle9i New Features

Heterogeneous Services

Oracle Net Services

Replication

Oracle Spatial

3 Oracle9i Documentation

Online Documentation Structure

Documentation Titles

Oracle9i Master Index and Master Glossary

Oracle9i Server and SQL*Plus

Oracle9i Directory, Networking, and Security Documentation

Oracle9i Real Application Clusters

Oracle9i Server Application Development

Oracle Text

Oracle9i OLAP Services

Oracle Enterprise Manager

Oracle Workflow, Release 2.5.2

Oracle Internet File System, Release 1.1

Oracle Ultra Search

4 Deprecated and Desupported Features

Overview of Deprecated and Desupported Features

Oracle9i Desupported and Deprecated Features

The ANALYZE Statement

CONNECT INTERNAL

C_Rep API

Default Temporary Tablespace

INCREMENTAL functionality of Export/Import

National Character Set

Oracle Net Services (Net8) Unsupported Features

Oracle Names

User-Managed Tablespace Point-in-Time Recovery (TSPITR) on a Clone Database

Relational Model of Oracle Spatial

Server Manager

Single-Task and Non-Deferred Linking

FOR RECOVER Clause of ALTER TABLESPACE ... OFFLINE

VARCHAR Datatype

Visual Information Retrieval

Desupported and Deprecated Initialization Parameters

Oracle8 and Oracle8i Desupported and Deprecated Features

Strings of Zero Length Not Equivalent To NULL

Date Format Strings

SELECT Privilege

SERIALIZABLE=TRUE

ESTAT/BSTAT

Partition Views

Use of "THE (subquery)" Expression

The SGADEF File

LONG Columns

Oracle Security Server and Cryptographic Toolkit

A Oracle8i Options and Features

Oracle8i Options

Oracle8i Features

The V$OPTION Table

B Oracle8 Options and Features

Oracle8 Options

Oracle8 Features

Index