Oracle8i Documentation Addendum -- Contents

Summary of New Features

How This Addendum Is Organized

Other Books Being Released for 8.1.7

Overview of New and Updated Features

CATSEARCH New SQL Operator

CREATE INDEX Updated Syntax

ALTER INDEX Updated Syntax

MULTI_COLUMN_DATASTORE New Datastore Type

PROCEDURE_FILTER New Filter Type

Procedure Filter Preference Example

Prefix Indexing New Feature

Enabling Sub-string and Prefix Indexing

Fuzzy Operator New Syntax

CTX_DDL.ADD_INDEX New Procedure

CTX_DDL.CREATE_INDEX_SET New Procedure

CTX_DDL.DROP_INDEX_SET New Procedure

CTX_DDL.REMOVE_INDEX New Procedure

CTX_DDL.OPTIMIZE_INDEX Updated Syntax

CTX_DDL.CREATE_STOPLIST Updated Syntax

CTX_DDL.ADD_STOPWORD Updated Syntax

CTX_THES.CREATE_TRANSLATION New Procedure

CTX_THES.DROP_TRANSLATION New Procedure

CTX_THES.HAS_RELATION New Procedure

CTX_THES.UPDATE_TRANSLATION New Procedure

CTX_DOC.TOKENS New Procedure

CTX_DOC.THEMES Updated Syntax

CTX_DOC.GIST Updated Syntax

Overview of Choosing and Migrating Character Sets

Data Truncation

Character Set Conversions

Database Character Set Migration

Data Scanning

Conversion of Data

What is the Character Set Scanner Utility?

Conversion Tests on Character Data

Access Privileges

Restrictions

Database Containing Data from Two or More Character Sets

Database Containing Data not from the Database Character Set

Scan Modes in the Scanner

Before Using the Scanner

Sample Scanner Sessions

Sample Session of Full Database Scan

Sample Session of User Tables Scan

Sample Session of Single Table Scan

Scanner Reports

Database Scan Summary Report

Individual Exception Report

Storage and Performance Considerations in the Scanner

Storage Considerations

Performance Consideration

Reference Material

Scanner Tables

Scanner Messages

Subsets and Supersets

Raw Partition Tablespace Size Requirements

Connecting to Secondary Instances

Recovery Manager Procedures for Oracle Parallel Server

New Parameter OPS_INTERCONNECTS for Solaris

Configuring Directory Server Access for Oracle8i Feature Integration

Configuring Directory Access During Installation

Configuring Directory Access After Installation

Adding Users to and Removing Users from the OracleNetAdmins Group

Configuring Session Data Unit for Net8 Performance

SDU Configuration on Clients

SDU Configuration on the Server

INSTANCE_ROLE Parameter for Primary and Secondary Instance Configurations

Oracle Names Control Utility Command Changes

DOMAIN_HINT Command Not Supported

REGISTER_NS and UNREGISTER_NS Commands for Oracle Names Server Registration

Package Overview

Using Oracle Supplied Packages

Creating New Packages

Referencing Package Contents

DBMS_LDAP

Summary of Subprograms

Exception Summary

Data-Type Summary

DBMS_OBFUSCATION_TOOLKIT

Overview of Key Management

DESEncrypt Procedure

Parameter Descriptions

Encryption Procedure Restriction

DESDecrypt Procedure

Parameter Descriptions

DESDecryption Procedure Restriction

DES Encryption Code Example

DES3Encrypt Procedure

Parameter Descriptions

Encryption Procedure Restriction

DES3Decrypt Procedure

Parameter Descriptions

DES3Decrypt Procedure Restriction

DES3 Encryption Code Example

Preparing a Standby Database Using RMAN

About Standby Database Preparation Using RMAN

Creating the Standby Control File Using RMAN

Making Image Copies of Standby Control Files

Naming the Standby Database Datafiles When Using RMAN

Naming the Standby Database Online Redo Logs When Using RMAN

Creating a Standby Database Using RMAN

About Standby Creation Using RMAN

Restrictions When Creating a Standby Database Using RMAN

Starting RMAN and the Standby Instance

Creating a Standby Database on a Remote Host with the Same Directory Structure

Creating a Standby Database on a Remote Host with a Different Directory Structure

Creating a Standby Database on the Local Host

Using Image Copies to Create a Standby Database

Backing Up Files at the Standby Site Using RMAN

About RMAN Backups of Standby Database Datafiles and Archived Logs

Restrictions When Making RMAN Standby Database Backups

Interpreting the RC_ARCHIVED_LOG View

Determining When to Back Up Standby Database Archived Redo Logs

Backing Up a Standby Database Using RMAN

Performing a Test Backup Using RMAN

Setting the Default Location of the RMAN Snapshot Control File

Crosschecking and Deleting on Multiple RMAN Channels

About Allocating Multiple RMAN Channels for Maintenance Commands

How RMAN Crosschecks and Deletes on Multiple Channels

Crosschecking Simultaneously on Disk and Tape Channels: Example

Crosschecking on Multiple OPS Nodes: Example

Deleting Simultaneously on Disk and Tape Channels: Example

Releasing Multiple Channels with One Command: Example

Connecting RMAN to a Target Database in an OPS Cluster

Selected RMAN Maintenance Commands No Longer Require a Catalog

Troubleshooting RMAN Character Set Errors: Scenario

Diagnosis of Cause

Solution

Setting Recovery Catalog Compatibility Level No Longer Required

Recovery Catalog Compatibility Changes

About RMAN Compatibility

RMAN Compatibility Matrix

RMAN Compatibility: Scenario

RMAN Syntax Diagram Changes

BACKUP

COPY

DEBUG

DUPLICATE

SET

Recovery Catalog View Changes

Backup and Recovery Dynamic Performance View Changes

ORACLE_TRACE_ENABLE

V$ARCHIVED_LOG

V$BACKUP_DATAFILE

V$BACKUP_SET

V$DATAFILE_COPY

V$PROXY_DATAFILE

V$SQL_SHARED_CURSOR

New Replication Features

Reduced Quiesce for Single Master Replication Environments

Documentation Additions

UTL_FILE_DIR Initialization Parameter and Generated Replication Files

Procedural Replication and Snapshot Sites

Avoiding Problems When Adding a New Snapshot Site

Documentation Updates

Replication of Sequences Is Not Supported

Updated "Base Table" Section

Guidelines for Scheduled Links

Guidelines for Scheduled Purges of a Deferred Transaction Queue

Serial and Parallel Propagation

The Replication Management Tool in DBA Studio

Usage Scenarios for the Replication Management Tool

Logging in to the Replication Management Tool

The Replication Management Tool Interface

The Replication Management Tool Wizards

Flowchart for Creating a Replicated Environment

Changes to the DBMS_REPCAT_INSTANTIATE Package

The offline_dirpath Parameter Added to INSTANTIATE_OFFLINE_REPAPI

Changes to the DBMS_REPCAT_RGT Package

The offline_dirpath Parameter Required in INSTANTIATE_OFFLINE_REPAPI

Documentation Additions

Switching Master Sites that are Running Different Releases of Oracle

Revised Script to Identify the Logs in a Gap Sequence

Additions to Compatibility and Operational Requirements

Compatibility and Operational Requirements

Changes to Enabling Online Changes to the Initialization Parameter Settings

Changes to Receiving Archived Redo Logs While in Read-Only Mode

Changes to Creating the Standby Database Files

Creating the Standby Database Files

Revised Scenario 1: Creating a Standby Database on the Same Host

Scenario 1: Creating a Standby Database on the Same Host

Revised Scenario 2: Creating a Standby Database on a Remote Host

Scenario 2: Creating a Standby Database on a Remote Host

Overview of Oracle Trace

Using Oracle Trace Data

Using Oracle Trace Manager

Managing Collections

Collecting Event Data

Accessing Collected Data

Using Oracle Trace Data Viewer

Using Oracle Trace Predefined Data Views

Viewing Oracle Trace Data

Getting More Information on a Selected Query in Oracle Trace

Manually Collecting Oracle Trace Data

Using the Oracle Trace Command-Line Interface

Using Initialization Parameters to Control Oracle Trace

Controlling Oracle Trace Collections from PL/SQL

Accessing Oracle Trace Collection Results

Formatting Oracle Trace Data to Oracle Tables

Running the Oracle Trace Statistics Reporting Utility

Contents

Title and Copyright Information

1 Introduction

2 interMedia Text

3 New Character Set Scanner Utility

4 Oracle Parallel Server

5 Net8

6 PL/SQL Supplied Packages

7 Recovery Manager

8 Reference

9 Replication

10 Replication Management API Reference

11 Oracle Label Security Error Messages

12 Standby Database

13 Using Oracle Trace

Index