Oracle7 Server Migration Guide Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index



Go to previous file in sequence Go to next file in sequence

Info


This manual is designed to aid database administrators and system programmers in the planning and implementation of migration, upgrade, and downgrade procedures. Detailed, procedural steps are provided to guide you through each of the various migration, upgrade, and downgrade operations. The use of tools and features involved with each operation is also explained.

The process of transforming one version of the Oracle database into a later version of the Oracle database is called migration. Thus, the transformation of an Oracle, Version 6 database into an Oracle, Version 7 database is described as "the migration of an Oracle, Version 6 database to an Oracle, Version 7 database". For specific information on migrating from Version 6 to any of the Version 7 releases, see Chapter 7 "Migrating from Version 6 to Version 7".

The process of transforming one release to another release of the same version of the Oracle database is called upgrading or downgrading. Thus, the process of transforming a Release 7.0 database into a Release 7.1 database is described as "upgrading Release 7.0 to Release 7.1". The reverse process, of transforming a Release 7.1 database into a Release 7.0 database, is described as "downgrading Release 7.1 into Release 7.0". For specific information on upgrading and downgrading between Releases 7.0, 7.1, 7.2, and 7.3, see Chapter 9 "Upgrading and Downgrading between Oracle7 Releases".


Audience

This manual is written for database administrators, application programmers, security administrators, and system operators who are responsible for planning and executing migration, upgrading, and downgrading operations.

Knowledge Assumed of the Reader

Readers of this manual are assumed to be familiar with either Version 5, Version 6, Release 7.0, Release 7.1 or Release 7.2 of the Oracle7 Server and with the operating system environment under which their particular Oracle version or release is running. Readers should also be familiar with the new features provided in each of the Oracle7 Server releases, as described in Appendices A, B, C, and D of this manual, and the Oracle7 Server README.DOC files for each of the Oracle7 releases.


How Oracle7 Server Migration Is Organized

This section contains the following topics:

This manual is divided into the following parts and chapters:

Part I: Generic Migration, Upgrading, and Downgrading Procedures

Chapter 1: Migration Overview

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

Chapter 2: Preparing to Migrate

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

Chapter 3: The Migration Utility

This chapter describes the process of migrating your database using the Migration Utility.

Chapter 4: Migrating Using Export/Import

This chapter describes the process of migrating your database using the Export and Import utilities.

Chapter 5: After Migrating the Database

This chapter describes the steps to take after you have converted your database using either the Migration Utility or Export/Import.

Part II: Migrating, Upgrading, and Downgrading between Specific Versions and Releases

Chapter 6: System Requirements for Migration This chapter describes the system requirements that must be satisfied to ensure successful migration, upgrading, and downgrading operations.

Chapter 7: Migrating from Version 6 to Version 7

This chapter describes how to migrate an Oracle6 database to any of the Oracle7 releases using either the Migration Utility or Export/Import.

Chapter 8: Migrating Version 6 Applications

This chapter describes how to run Oracle6 applications against the various Oracle7 releases.

Chapter 9: Upgrading and Downgrading between Oracle7 Releases

This chapter describes how to upgrade and downgrade between the various Oracle7 releases.

Part III: Appendices A, B, C, D, E, and F

Appendix A: Summary of Changes in Oracle7, Release 7.0

This appendix describes the differences between Oracle Version 6 and Oracle Release 7.0.

Appendix B: Summary of Changes in Oracle7, Release 7.1

This appendix describes the differences between Oracle7, Release 7.0 and Oracle7, Release 7.1.

Appendix C: Summary of Changes in Oracle7, Release 7.2

This appendix describes the differences between Oracle7, Release 7.1 and Oracle7, Release 7.2.

Appendix D: Summary of Changes in Oracle7, Release 7.3

This appendix describes the differences between Oracle7, Release 7.2 and Oracle7, Release 7.3.

Appendix E: Migration Utility Errors and Messages

This appendix lists the errors you may see when using the Migration Utility. The probable cause and corrective action are given for each error.

Appendix F: Operating System-Specific Information

This appendix lists references in this manual to your operating system-specific documentation.


Conventions Used in this Manual

This section contains the following topics:

Special Icons

Special icons alert you to particular information within the body of this manual:

Suggestion: The light bulb highlights suggestions and practical tips that could save time, make procedures easier, and so on.

Warning: The warning symbol highlights text that warns you of actions that could be particularly damaging or fatal to your operations.

Additional Information: The OSDoc icon refers you to the Oracle operating system-specific documentation for additional information.

Text of the Manual

The following sections describe the conventions used in the text of this manual.

UPPERCASE Characters

Uppercase text is used to call attention to command keywords, object names, parameters, filenames, and so on.

For example, "If you create a private rollback segment, the name must be included in the ROLLBACK_SEGMENTS parameter of the parameter file."

Italicized Characters

Italicized words within text indicate the definition of a word, book titles, or emphasized words.

An example of a definition is the following: "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."

An example of a reference to another book is the following: "For more information, see Oracle7 Server Tuning."

An example of an emphasized word is the following: "You must back up your database regularly."

Code Examples

SQL, Server Manager line mode, and SQL*Plus commands/statements appear separated from the text of paragraphs in a monospaced font. For example:

INSERT INTO emp (empno, ename) VALUES (1000, 'SMITH'); 
ALTER TABLESPACE users ADD DATAFILE 'users2.ora' SIZE 50K; 

Example statements may include punctuation, such as commas or quotation marks. All punctuation in example statements is required. All example statements terminate with a semicolon (;). Depending on the application, a semicolon or other terminator may or may not be required to end a statement.

Uppercase words in example statements indicate the keywords within Oracle SQL. When issuing 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.


Your Comments Are Welcome

We value and appreciate your comments as an Oracle user and reader of the manuals. As we write, revise, and evaluate, your opinions are the most important input we receive. At the back of this manual is a Reader's Comment Form which we encourage you to use to tell us both what you like and what you dislike about this (or other) Oracle manuals. If the form has been used, or you would like to contact us in California, please use the following address.

Oracle7 Server Documentation Manager

Oracle Corporation

500 Oracle Parkway

Redwood Shores, CA 94065

U.S.A.




Go to previous file in sequence Go to next file in sequence
Prev Next
Oracle
Copyright © 1996 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index