Re: Migrating 8i database to 9i

On 20 Mar 2002, Don Seiler wrote:

> Yes I downloaded 9i and was reading the documentation. Seems like
> they have it all laid out for me in terms of migrating from 7 to 9i.
> Being able to export/import would be nice, but this database is QUITE
> large, so there is not only concern of time, but of space. I don't
> have enough disk to hold to concurrent copies of our database.

On Wed, 20 Mar 2002, Hemant K Chitale wrote:

> If you are migrating from HPUX to Linux,
> Export-Import is the only option you can use
> to "migrate" from 8i to 9i.

Actually, you could also set up both database systems, establish database links and CTAS the data across. Since your upgrade approach prevents you from doing an in-place migration, this method should be considered (especially if the number of tables is low).

You will probably want to use exp/imp to get the DDL for creating all these objects (exporting with rows=n). Using links rather than exp/imp will give you much greater control over transaction granularity and avoiding ORA-1555s (unless you have the luxury of running exp in "startup restrict").

Snapshots might also be an option, since simple snapshots can transmit incremental changes. Scripting all of this can get complex, though.

p.s. If you don't have good bandwidth between the servers, hack in a

     tnsnames.ora entry for an "ssh -C" session to gzip the data stream.
     Have you patched your zlib yet?

    ---------------------------------------------------------------------------
   / Charles J. Fisher                   |"The prettiest girls in the world  /
  /  cfisher_at_rhadmin.org                 | live in Des Moines, Iowa."       /
 /   http://rhadmin.org                  |   -Jack Kerouac                 /
---------------------------------------------------------------------------