Preface

This manual guides you through the process of planning and executing migrations, upgrades, and downgrades on the Oracle database system. It describes migrating using the following methods: Migration utility, Oracle Data Migration Assistant, export/import, and data copying.

In addition, this manual provides information about compatibility, about upgrading applications to the current release, and about important changes in the current release of Oracle, such as initialization parameter changes and data dictionary changes.

The following topics are covered in this preface:

Oracle8i Migration contains information that describes the features and functionality of the Oracle8i and the Oracle8i Enterprise Edition products. Oracle8i and the Oracle8i Enterprise Edition have the same basic features. However, several advanced features are available only with the Enterprise Edition, and some of these are optional. For example, to use partitioning, you must have the Enterprise Edition and the partitioning option.

See Also:
Getting to Know Oracle8i for information about the differences between Oracle8i and the Oracle8i Enterprise Edition and the features and options that are available to you.

Audience and Assumed Knowledge

This manual is for database administrators (DBAs), application developers, security administrators, system operators, and anyone who plans or executes migration, upgrade, or downgrade operations on Oracle databases. It is assumed that users of this manual are familiar with their current release of the Oracle server and with their operating system environment. It also is assumed that users are familiar with Oracle database management system (DBMS) concepts. The first chapter of Oracle8i Concepts provides a comprehensive introduction to the concepts and terminology used in this manual.

How This Book Is Organized

This manual contains the following chapters and appendices:

Chapter 1: Introduction

Contains definitions for the terms used throughout this manual. This chapter also provides information about running different versions and releases of Oracle on the same computer system.

Chapter 2: Overview of Migration

Summarizes migration procedures and the responsibilities of database administrators and application developers.

Chapter 3: Preparing to Migrate

Describes the steps to complete before migrating the database.

Chapter 4: Migrating from Oracle7 Using the Migration Utility

Provides step-by-step instructions for using the Migration utility to migrate an Oracle7 database to Oracle8i.

Chapter 5: Migrating from Oracle7 Using the Oracle Data Migration Assistant

Provides step-by-step instructions for using the Oracle Data Migration Assistant to migrate an Oracle7 database to Oracle8i.

Chapter 6: Migrating Using Export/Import

Describes how to migrate an Oracle7 or version 6 database to Oracle8i using the Export and Import utilities.

Chapter 7: Upgrading from a Previous Version 8 Release to the New Oracle8i Release

Provides step-by-step instructions for performing the following actions:

Upgrading a database from an 8.0 release or a previous 8.1 release to the new 8.1 release of Oracle
Upgrading specific components of Oracle software to the current release
Changing the word size of your database (switching between 32-bit and 64-bit software)

Chapter 8: After Migrating or Upgrading the Database

Describes the actions to complete after migrating or upgrading the database to the new Oracle8i release.

Chapter 9: Compatibility and Interoperability

Contains information about compatibility and interoperability between different releases of Oracle, including detailed information about the COMPATIBLE initialization parameter. This chapter also lists the release 8.1 features that require an 8.1.0 or higher compatibility level and discusses specific issues relating to compatibility and interoperability.

Chapter 10: Upgrading Your Applications

Provides general information about upgrading Oracle7 applications and tools for use with Oracle8i.

Chapter 11: Migrating from Server Manager to SQL*Plus

Describes modifying your Server Manager line mode scripts for use with SQL*Plus. Oracle Corporation recommends scripting in SQL*Plus instead of Server Manager line mode.

Chapter 12: Migration Issues for Physical Rowids

Covers issues associated with the version 8 ROWIDs, including specific information about migrating columns containing ROWIDs to version 8.

Chapter 13: Downgrading to an Older Version 8 Release

Provides instructions for downgrading a database from the new 8.1 release to a previous 8.1 release or to an 8.0 release. This chapter also includes information about removing incompatibilities with the release to which you are downgrading, and information about resetting the compatibility level of the database.

Chapter 14: Downgrading to Oracle7

Provides instructions for downgrading a database from Oracle8i to Oracle7.

Appendix A: Troubleshooting Migration Problems

Describes common migration problems and the actions required to correct these problems. In addition, this appendix lists the messages displayed by the Migration utility and Oracle Data Migration Assistant, and includes an explanation for each message. If the message is an error message, then this appendix discusses probable cause(s) of the error, and suggests corrective action for the error.

Appendix B: Changes to Initialization Parameters

Lists Oracle initialization parameters that are important for migration. Specifically, this appendix describes initialization parameters that have been added, renamed, or obsoleted in version 8. In addition, this appendix describes compatibility issues relating to specific initialization parameters.

Appendix C: Changes to Static Data Dictionary Views

Lists the static data dictionary views that have been added or obsoleted. This appendix also lists the static data dictionary views with added columns, dropped columns, and renamed columns. This appendix also lists columns in static data dictionary views that may return NULLs in release 8.1 but did not return NULLs in past releases.

Appendix D: Changes to Dynamic Performance Views

Lists the dynamic performance views (V$ views) that have been added or obsoleted. This appendix also lists the dynamic performance views with added columns and dropped columns.

Appendix E: New Internal Datatypes and SQL Functions

Lists the new internal datatypes and SQL functions.

Appendix F: SQL*Net and Net8 Considerations for Migrations and Upgrades

Discusses considerations for migrating SQL*Net from Oracle7 to the new release and considerations for upgrading SQL*Net or Net8 from Oracle release 8.0 to release 8.1.

Appendix G: Migration and Compatibility for Replication Environments

Provides step-by-step instructions for migrating an Oracle replication system on an Oracle7 database to version 8. Also, discusses the compatibility issues between version 8 of Oracle replication and previous versions.

Changes To This Book

The following major changes were made to this book:

In past releases, this book did not fully cover migrations, upgrades, and downgrades on Windows platforms. In this release, this book covers specific steps to complete on Windows platforms for these operations.
Two appendices were added: Appendix F, "SQL*Net and Net8 Considerations for Migrations and Upgrades" and Appendix G, "Migration and Compatibility for Replication Environments".

Conventions Used in This Manual

The following conventions are used in this manual:

UPPERCASE Words

Uppercase words indicate statement keywords, object names, initialization parameters, static data dictionary view names, and dynamic data dictionary view names. For example:

"Oracle enables you to control the compatibility of your database with the COMPATIBLE initialization parameter."

Italicized Words

Italicized words indicate the first occurrence of a term and its definition. For example:

"Migration is the process of transforming an installed version of an Oracle database into a later version."

Italicized words also indicate variables. For example:

"Run uold_release.sql where old_release refers to the release you had installed prior to upgrading."

Italicized words also are used for emphasis and for book titles.

Code Examples

SQL, Server Manager line mode, and SQL*Plus commands and statements are displayed in a fixed-width courier font, separated from normal text, as in the following example:
SELECT username FROM dba_users WHERE username = 'MIGRATE';

Example statements may include punctuation, such as commas or quotation marks. All punctuation in example statements is required syntax. Depending on the application, a semicolon or other terminator may or may not be required to end a statement, and some applications require a slash (/) on the next line to end a statement.
Uppercase words in example statements indicate the keywords within SQL. When you issue statements, however, keywords are not case sensitive.
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.
Where a fixed-width courier font appears within paragraphs, it indicates a file name, script name, executable name, or directory path, as in the following example:

To identify the user-defined types at 8.1 compatibility level, run the utlincmpt.sql script supplied with release 8.1.

Your Comments Are Welcome

We value and appreciate your comments as a user and reader of Oracle manuals. As we write, revise, and evaluate our documentation, your opinions are especially important input for us. Before the preface 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 or any other Oracle manual. If you do not find this form, then please write your remarks to the Information Development department in any convenient form. At your earliest convenience, please send 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 - 650.506.7228 Attn: Server Technologies Documentation Manager

You can send comments and suggestions to the Information Development department at the following e-mail address:

Electronic Mail - infodev@us.oracle.com

UPPERCASE Words	Uppercase words indicate statement keywords, object names, initialization parameters, static data dictionary view names, and dynamic data dictionary view names. For example: "Oracle enables you to control the compatibility of your database with the COMPATIBLE initialization parameter."

Italicized Words	Italicized words indicate the first occurrence of a term and its definition. For example: "Migration is the process of transforming an installed version of an Oracle database into a later version." Italicized words also indicate variables. For example: "Run `u``old_release``.sql` where old_release refers to the release you had installed prior to upgrading." Italicized words also are used for emphasis and for book titles.

`Code Examples`	SQL, Server Manager line mode, and SQL*Plus commands and statements are displayed in a fixed-width courier font, separated from normal text, as in the following example: SELECT username FROM dba_users WHERE username = 'MIGRATE'; Example statements may include punctuation, such as commas or quotation marks. All punctuation in example statements is required syntax. Depending on the application, a semicolon or other terminator may or may not be required to end a statement, and some applications require a slash (/) on the next line to end a statement. Uppercase words in example statements indicate the keywords within SQL. When you issue statements, however, keywords are not case sensitive. 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. Where a fixed-width courier font appears within paragraphs, it indicates a file name, script name, executable name, or directory path, as in the following example: To identify the user-defined types at 8.1 compatibility level, run the `utlincmpt.sql` script supplied with release 8.1.