Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: update 7.3.2 to 8.x on NT

Re: update 7.3.2 to 8.x on NT

From: glenn meyers <glennmeyers_at_maxinter.net>
Date: Thu, 24 Jun 1999 18:44:19 -0400
Message-ID: <930264450.946.50@news.remarQ.com>


You should migrate the 7.3.2 database to 7.3.4 and then convert to 8. That is how I have proceded before.
Let me know if it helps.
GMM Sybrand Bakker wrote in message
<930254657.8730.0.pluto.d4ee154e_at_news.demon.nl>...
>Answers ... embedded
>Hth,
>Sybrand Bakker, Oracle DBA
>
>Vick wrote in message <7ku1e5$f7d$1_at_nnrp1.deja.com>...
>>Hello...
>>I have an Oracle 7.3.2 database that I need to migrate to version 8. I
>>know that there is a migration option that I can choose when installing
>>8, but so far when I do that, the database pukes. I've been doing all
>>this in a test situation with a tiny DB only about 1.5 GB. My
>>production database is 42GB, I'm a little concerned!
>>
>>I have schema owner/user exports with all the grants, inserts and
>>triggers etc, maybe I can export from 7.3.2 and then import into 8.0.5
>>and not lose data? (some tablespace fragmentation that this should
>>fix?)
>
>This should work ok. The only thing to be done in the Oracle 8 database is
>run the catexp7 script to be able to read the v7 export.
>>
>>Can I change the DB Block size in the new DB and still import the old
>>data? (from 2048 to 8192, to help with performance issues)
>>
>Yes
>
>>Has anyone had good fortune with the migration tool?
>
>The migration tool will only work with 7.3.4 databases.
>It does not convert all the rowids to the new format while imp will.
>When in doubt use the imp/exp way
>I once migrated from 6 to 7 with the migration tool and it miscalculated
the
>extra room in the system tablespace. I have an inkly feeling this will
still
>apply with Oracle 8 migration.
>>
>>Suggestions? Maybe even a good resource book for questions like this?
>
>What about the Oracle 8 New Features for Administrators course?
>
>>Thanks
>>Vickie
>>
>>
>>Sent via Deja.com http://www.deja.com/
>>Share what you know. Learn what you don't.
>
>
Received on Thu Jun 24 1999 - 17:44:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US