Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

Database Migration Scripts

The scripts in Table 5-4 are useful when upgrading or downgrading to another release of Oracle. To run these scripts, you must be connected to Oracle as a user with SYSDBA privileges.

Table 5-4  Database Migration Scripts
Script Name Needed For Description

cmpdbmig.SQL

Upgrading components

Runs the database migration scripts for all components that can be upgraded when connected as a user with SYSDBA privileges

d0801070.sql

Downgrading to release 8.1.7 of Oracle

Provides a direct downgrade path from your current release of Oracle to release 8.1.7

d0900010.sql

Downgrading to release 9.0.1 of Oracle

Provides a direct downgrade path from your current release of Oracle to release 9.0.1

u0703040.sql

Upgrading from release 7.3.4 of Oracle

Provides a direct upgrade path from release 7.3.4 of Oracle to the new release

u0800060.sql

Upgrading from release 8.0.6 of Oracle

Provides a direct upgrade path from release 8.0.6 of Oracle to the new release

u0801070.sql

Upgrading from release 8.1.7 of Oracle

Provides a direct upgrade path from release 8.1.7 of Oracle to the new release

u0900010.sql

Upgrading from release 9.0.1 of Oracle

Provides a direct upgrade path from release 9.0.1 of Oracle to the new release

utlincmp.sql

Removing incompatibilities before a downgrade

Contains a set of queries that identify database objects that are incompatible with previous releases of Oracle

See Also:

Oracle9i Database Migration for more information about these scripts