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.
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.
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 software. 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.
This manual contains the following chapters and appendices:
Contains definitions for the terms used throughout this manual. This chapter also summarizes migration procedures and the responsibilities of database administrators and application developers.
Describes the steps to complete before migrating the database.
Provides step-by-step instructions for using the Migration utility to migrate an Oracle7 database to Oracle8i.
Provides step-by-step instructions for using the Oracle Data Migration Assistant to migrate an Oracle7 database to Oracle8i.
Describes how to migrate an Oracle7 or version 6 database to Oracle8i using the Export and Import utilities.
Describes the actions to complete after migrating the database to Oracle8i.
Provides step-by-step instructions for performing the following actions:
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 compatibility level or higher and discusses specific issues relating to compatibility and interoperability.
Provides general information about upgrading Oracle7 applications and tools for use with Oracle8i.
Describes modifying your Server Manager line mode scripts for use with SQL*Plus. Server Manager will be obsoleted in a future release of Oracle.
Covers issues associated with the version 8 ROWIDs, including specific information about migrating columns containing ROWIDs to version 8.
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.
Provides instructions for downgrading a database from Oracle8i to Oracle7.
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, this appendix discusses probable cause(s) of the error, and suggests corrective action for the error.
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.
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.
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.
Lists the new internal datatypes and SQL functions.
The following conventions are used in this manual:
Uppercase words indicate command keywords, object names, initialization parameters, static data dictionary view names, and dynamic data dictionary view names. For example:
Italicized words indicate the first occurrence of a term and its definition. For example:
Italicized words also indicate variables. For example:
Italicized words also are used for emphasis and for book titles.
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:
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.
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:
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, 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
500 Oracle Parkway
Redwood City, CA 94065
Fax - 650.506.7228 Attn: Server Technologies Documentation Manager
Electronic Mail - firstname.lastname@example.org