RE: Oracle8i to 10g upgrade using exp and imp

Hi,

the paragraph states:
Export/Import

Unlike the DBUA or a manual upgrade, the Export/Import utilities physically 
copy data from your current database to a new database. You can use either the 
Oracle Data Pump Export and Import utilities (available as of Oracle Database 
10g) or the original Export and Import utilities to perform a full or partial 
export from your database, followed by a full or partial import into a new 
Oracle Database 10g database. Export/Import can copy a subset of the data in a 
database, leaving the database unchanged.



I think above paragraph states the use of full for both Export as Import.



Herald ten Dam

Superconsult

________________________________
Van: hrishy [hrishys@xxxxxxxxxxx]
Verzonden: donderdag 25 juni 2009 12:36
Aan: oracle-l@xxxxxxxxxxxxx; Herald ten Dam
Onderwerp: RE: Oracle8i to 10g upgrade using exp and imp

Hi

It doesnt seem to say anywhere that i can export the whole 8i database with 
full=y (including sys and system users) and then import into 10g using 
full=y(including sys and system)

regards
Hrishy

--- On Thu, 25/6/09, Herald ten Dam <Herald.ten.Dam@xxxxxxxxxxxxxxx> wrote:

From: Herald ten Dam <Herald.ten.Dam@xxxxxxxxxxxxxxx>
Subject: RE: Oracle8i to 10g upgrade using exp and imp
To: "hrishys@xxxxxxxxxxx" <hrishys@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" 
<oracle-l@xxxxxxxxxxxxx>
Date: Thursday, 25 June, 2009, 11:20 AM

Hi,

Oracle has the Oracle Database Upgrade Guide. In this the method is mentioned.
See 
http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/preup.htm#i694345.
 Start reading from the paragraph Export/Import

Herald ten Dam
Superconsult


Van: 
oracle-l-bounce@xxxxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l-bounce@xxxxxxxxxxxxx>
 
[oracle-l-bounce@xxxxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l-bounce@xxxxxxxxxxxxx>]
 namens hrishy 
[hrishys@xxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys@xxxxxxxxxxx>]
Verzonden: donderdag 25 juni 2009 11:52
Aan: 
oracle-l@xxxxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l@xxxxxxxxxxxxx>
Onderwerp: Oracle8i to 10g upgrade using exp and imp


Hi

I would like to know any metalink note or Oracle documentation link which 
spells out that i can do exp full=y on 8i database and imp full=y into 10g 
database.

I searched this but unable to locate that this is a a supported method for 
upgrading from 8i to 10g

regards
Hrishy


Other related posts: