Oracle8 Server Migration

Oracle8 Server Migration
Release 8.0
A54650_01

Title

Preface

How Oracle8 Server Migration is Organized

We Welcome Your Comments

Chapter 1 Migration Overview

Migration to Oracle8: Overview of Steps

Step 1: Prepare to Migrate

Step 2: Test the Migration Process

Step 3: Test the Migrated Test Database

Step 4: Prepare and Preserve the Source Database

Step 5: Migrate the Source Database

Step 6: Tune and Adjust the New Production Database

Role of the Database Administrator During Migration

Role of the Application Developer During Migration

Chapter 2 Preparing to Migrate

Step 1: Prepare to Migrate

Become Familiar with the Features of the New Oracle8 Database

Assess System Requirements vs. Resources Available

Compare Migration Methods

Prepare a Backup Strategy

Choose a Migration Method

Develop a Testing Plan

Step 2: Test the Migration Process

Step 3: Test the Migrated Test Database

Chapter 3 Migrating to Release 8.0.3 by Migration Utility

Overview of Migration Using the Oracle8 Migration Utility

System Considerations and Requirements

Space Required for Migration by Migration Utility

Block Size Considerations

Considerations for Replication Environments

Migrating to a Different Computer Architecture

Character Encoding Considerations

Prepare the Oracle7 Source Database for Migration

Install the Oracle8 Migration Utility

Oracle8 Migration Utility Command Line Options

Migrate the Oracle7 Source Database

Migration on the Oracle7 Side

Step 4: Preserve the Oracle7 Source Database

Migration on the Oracle8 Side

Errors During Migration

Abandoning the Migration

Chapter 4 Migrating to Release 8.0.3 by Export/Import

Basics of Export/Import

Additional Export/Import Information Sources

Additional Options

Migrate the Pre-Oracle8 Source Database Using Export/Import

Chapter 5 After Migrating the Database

Back Up the Oracle8 Database

Test the Database and Compare Results

Tune the Target Database

Add New Features as Appropriate

Develop New Administrative Procedures as Needed

Chapter 6 Upgrading Oracle7 Applications

Upgrading Oracle Applications to Oracle8

XA Calls: Incompatibility with Release 7.1 XA Calls

Upgrading Precompiler and OCI Applications

Upgradinging Precompiler Applications

Upgrading OCI Applications: Enabling Constraints

OCI Application Link Line

Applications Using Oracle6 OCI Libraries

Upgrading LONGs to LOBs

Upgrading Oracle7 Forms or Developer/2000Applications

Data Dictionary Views Update

Upgrading SQL*Plus Scripts

PL/SQL V2 Compatibility Mode

PLSQL_V2_COMPATIBILITY Flag

Keyword Behavior Differences: Oracle7 vs. Oracle8

New Keywords or Types Behavior Differences: Oracle7 vs Oracle8

SQL*Net or Net8

For Oracle7-Net2 Client Without Relinking

For Oracle7-Net8 Client (relink client, but no code changes)

For Oracle8-Net8 Client

Backup Management: EBU and Recovery Manager

Dictionary Protection

Password Management

Oracle7 (or Lower) Client with Oracle8 Server

Oracle8 Client with Oracle7 (or Lower) Server

Export/Import Usage, Partitioned Objects

Cache Merge: Large/Unbounded Subordinate Sets

Migration and Compatibility Issues for Thread Safety, OCI

Upgrade and Compatibility Issues for Standby Database

Compatibility Issues for Export/Import

Downward Compatibility Techniques and Limitations

Message File Upgrade

NCHAR and NLS Use

Migration and NCHAR and NLS

NCHAR and NLS Compatibility and Interoperability

Chapter 7 Migration Issues for the New Oracle8 ROWIDs

Migrating Applications and Data

DBMS_ROWID Package

ROWID Conversion Types

ROWID Conversion Functions.

ROWID_TO_EXTENDED Conversion Procedure

Conversion Procedure Examples

Snapshot Refresh

Pre-Oracle8 Client Compatibility Issues

ROWID-Related Migration Questions and Answers

Chapter 8 Downgrading from Oracle8

Use of the Migration Utility

Downgrading Oracle8 to Release 7.x

Appendix A Oracle8 Enhancements

Oracle8 Server Enhancements

Relational Database Enhancements

1000-Column Table Size Support

Parallel DML Features

1Partitioning Features

Migration from Partition Views to Partitioned Tables

ROWID Enhancement

Tablespace-Relative Data Block Address

New Nontransactional Application Failover

Heterogeneous Services

Backup and Restore Kernel Enhancements

SHUTDOWN TRANSACTION Server Manager Command

ALTER SYSTEM DISCONNECT SESSION ...
POST_TRANSACTION SQL Command

MINIMUM EXTENT Parameter

Maintaining Security in Distributed Systems

Deferred Constraint Checking

Current User Database Links

Reverse-Key Indexes

Using National Character Set / Database Character Set
with Oracle8

Object-related Features

Export/Import Object Support

SQL*Loader Partitioned Object Support

Oracle8 Server Image Cartridge

Oracle8 Server Spatial Cartridge

Replication Enhancements

Performance Enhancements

Data Subsetting Based on Subqueries

Large Object Datatype (LOB) Support

Improved Management and Ease of Use

Oracle8 Server Enhanced Administrative Features

Password Management

Enhanced CREATE PROFILE Statement

Enhanced USER_USERS and DBA_USERS Catalog Views

Enhanced DBA_PROFILES Catalog Views

New USER_PASSWORD_LIMITS View

Compatibility Features

Server-managed Recovery

Recovery Manager Functionality

Backup and Restore Enhancements

Dictionary Views

Data Dictionary Protection

Advanced Queuing

DBMS_AQADM Package Administration Interface

Enhanced Data Storage Technology

Reliability, Availability, Serviceability (RAS)

Very Large Database Support

Support for Large Numbers of Users

Support for Nonrelational Data

System Management Administration Interface

OCI Callback Function

Oracle8 Client-side Enhancements

Enhanced Oracle Server Datatype Support

Object Support Features

Open Type System (OTS) Object Support

Oracle8 SQL Type Data Definition Language (DDL)

Oracle8 Oracle Call Interface (OCI) Enhancements

Encapsulated/Opaque Interfaces

Simplified User Authentication and Password Management

Extensions to Improve Application Performance and Scalability

Consistent Interface for Transaction Management

Oracle8 OCI Object Support

Benefits of the OCI's New Features

Oracle Precompilers

Arrays of Structs in Pro*C/C++

Object Type Support in Pro*C/C++

Enhanced SQL*Module, Ada 8.0

SQL and PL/SQL Enhancements

SQL Syntax Changes

PL/SQL External Procedures

Collections in PL/SQL 8.0

PL/SQL 8.0 Support for Object Types

PL/SQL Package for Oracle8 Large Objects

Scalability Enhancements

Process Enhancements

Network Enhancements

SQL Performance

PL/SQL Performance

Appendix B Migration Utility Messages

Appendix C Control File Fixed View Changes in Oracle8

Appendix D Oracle8 INIT.ORA Changes

Data Dictionary Protection

NCHAR and NLS Parameters and Compatibility

Pre-Oracle8 Parameters Renamed in Release 8.0.3

Release 7.3 Parameters Obsolete in Release 8.0.3

REPLICATION_DEPENDENCY_TRACKING for the Replication Server

Features No Longer Supported in Release 8.0.3

SERIALIZABLE=TRUE or _SERIALIZABLE

Appendix E New Oracle8 SQL Key and Reserved Words

Appendix F General System Requirements for Migration to Oracle8

Memory Requirements

Basic Memory Requirements

Oracle8 Executables

Concurrent Access

Using Oracle Parallel Server

Oracle8 New Sizes and Limits

CHAR and NCHAR Maximum Size Support

Index

Copyright © 1997 Oracle Corporation.
All Rights Reserved.