Oracle8 Server Migration
Release 8.0
A54650_01

Library

Product

Contents

Index

Preface

This manual is to help you plan and execute migration, upgrades, and downgrades for the Oracle8 Server object relational database management system (ORDBMS). It describes basic principles, Oracle product features, and detailed procedural steps to use in various migration and upgrade/downgrade operations.

Migration is the process of transforming an installed version of the Oracle RDBMS into a later version, for example, Version 7 (Oracle7) into Version 8 (Oracle8). Thus, transforming an Oracle7 database into an Oracle8 database is called migrating an Oracle7 database to Oracle8.

Upgrading is the term used for the process of transforming an installed version of the Oracle RDBMS from one release into a later (higher-number) release-for example, OracleX, Release X.0.2 into Release X.1.3. In common usage and general software, however, the term upgrading is often used as an overall term for installing higher-release or higher-version executables. Applications also are often said to be upgraded to a higher release or a higher version.

Downgrading is the process of transforming an installed version of the Oracle RDBMS from a later release back into an earlier release-for example, from OracleX, Release X.3 back into Release X.2; or from OracleZ back into OracleY (like Oracle8 into Oracle7).

Start with Oracle Release 7.1+ or Later

The Oracle8 Migration Utility migrates only Oracle7 databases-Release 7.1.4 or higher. If the production database is an earlier version, for example, Version 6, migrate it to Oracle7, Release 7.1, at least, before implementing the Oracle8 migration procedures.

If the Oracle system to be migrated to Oracle8 is running a release previous to Release 7.1 (for example, Version 6 or Release 7.0) refer to Oracle7 Server Migration, Release 7.3. Use it to migrate or upgrade the system to Release 7.1 or higher. Then use this Oracle8 manual for migrating to Release 8.0.3.

Note: If you do not use the Migration utility but instead use Export/Import or data copying, you can migrate data directly from a pre-Oracle7 database (for example, Version 6) to Oracle8.

Audience and Assumed Knowledge

This manual is for database administrators (DBAs), application programmers, security administrators, system operators, and anyone who plans or executes migration, upgrade, or downgrade operations. Users are assumed to be familiar with the Oracle7 Server and with the operating system environment that Oracle is running in. Users are assumed also to be familiar with Oracle database management system(DBMS) concepts. The first chapter of Oracle8 Server Concepts is a comprehensive introduction to the concepts and terminology used in this migration manual.

How Oracle8 Server Migration is Organized

This manual comprises the following chapters and appendices:

Chapter 1: Migration Overview

This chapter summarizes migration procedures and the responsibilities of database administrators and application programmers.

Chapter 2: Preparing to Migrate

This chapter describes the steps to take before migrating the database.

Chapter 3: Migrating to Release 8.0.3 by Migration Utility

This chapter describes how to migrate an Oracle7, Release 7.1+ (or later) database to Oracle8, Release 8.0.3 using the Migration Utility.

Chapter 4: Migrating to Release 8.0.3 by Export/Import

This chapter describes how to migrate an Oracle7 or Version6 database to Oracle8 using the Export and Import utilities.

Chapter 5: After Migrating the Database

This chapter describes the steps to take after migrating the database to Oracle8.

Chapter 6: Upgrading Oracle7 Applications

This chapter describes the system resources and configuration required for successful migration, upgrade, or downgrade operations.

Chapter 7: Migration Issues for the New Oracle8 ROWIDs

This chapter covers issues associated with the new Oracle8 ROWIDs in relation to migrating columns containing ROWIDs to Oracle8.

Chapter 8: Downgrading from Oracle8

This chapter covers items that would require attention to downgrade an Oracle8, Release 8.0.3 database to Oracle7, Release 7.3.

Appendix A: Oracle8 Enhancements

This appendix briefly describes new features of the Oracle8 Server and specific changes from Release 7.3 that are important for migration. (For changes between Oracle7 releases, refer to Oracle7 Server Migration, Release 7.3.)

Appendix B: Migration Utility Messages

This appendix lists the messages displayed by the Migration Utility and includes an explanation of each message, probable cause(s), and suggested corrective action for each error condition.

Appendix C: Control File Fixed View Changes in Oracle8

This appendix briefly describes changes from Oracle7, Release 7.3, in the Oracle8 Server Control File Fixed Views.

Appendix D: Oracle8 INIT.ORA Changes

This appendix briefly describes Oracle INIT.ORA initialization parameters important for migration that have been added, changed, or dropped since Release 7.3.

Appendix E: New Oracle8 SQL Key and Reserved Words

This appendix lists the keywords and reserved words new to Oracle8.

Appendix F: General System Requirements for Migration to Oracle8

This appendix discusses certain system requirements that may be important for successful migration to Oracle8.

Conventions Used in This Manual

This manual follows the textual and typographic conventions explained in the following sections.

Text of the Manual

The following conventions are used in the text of this manual:
UPPERCASE Words	Uppercase calls attention to command keywords, object names, parameters, filenames, and so on. For example:
	"If you create a private rollback segment, its name must be included in the ROLLBACK_SEGMENTS parameter in the PARAMETER file."
Italicized Words	Italicized words are used at the first occurrence and definition of a term, as in the following example:
	"A database is a collection of data to be treated as a unit. The general purpose of a database is to store and retrieve related information, as needed."
	Italicized words are used also to indicate emphasis, book titles, and to highlight names of performance statistics.

PL/SQL, SQL, and SQL*Plus commands and statements are displayed in a fixed-width font, separated from normal text as in the following example:

ALTER TABLESPACE users   ADD DATAFILE 'users2.ora' SIZE 50K;

Punctuation: , ' "

Example statements may include internal punctuation such as commas or quotation marks. All punctuation given in example statements is required.

All statement examples end with a semicolon. Depending on the application in use, a semicolon or other terminator may or may not be required to end a statement.

UPPERCASE Words:
INSERT, SIZE

Uppercase words in example statements indicate the keywords in Oracle SQL. However, when you issue statements, keywords are not case sensitive.

Lowercase Words: emp, users2.ora

Lowercase words in example statements indicate words supplied only for the context of the example. For example, lowercase words may indicate the name of a table, column, or file. Some operating systems are case sensitive, so refer to your installation or user's manual to see if you must pay attention to case.

Such commands and statements use the following conventions:

We Welcome Your Comments

We value and appreciate your comments as an Oracle user and reader of the Oracle manuals. As we write, revise, and evaluate our documentation, your opinions are especially important input for us. At the back of each printed manual is a Reader's Comment Form, which we encourage you to use to tell us what you like and dislike about this manual or any other Oracle manual. If you do not find this form, please write your remarks to us anyway in any convenient form. At your earliest convenience please send us your opinions to the following U.S. mail address, fax number, or email.

Server Technologies Documentation Manager
Oracle Corporation
500 Oracle Parkway
Redwood City, CA 94065
U.S.A.
Fax: 415-506-7200

infodev@us.oracle.com

Library

Product

Contents

Index