RE: Oracle8i to 10g upgrade using exp and imp

Hi Joel
 
hehe you got me confused .But what i understood from the documentation is ful 
export and full import is supported
 
regards
Hrishy

--- On Thu, 25/6/09, Joel.Patterson@xxxxxxxxxxx <Joel.Patterson@xxxxxxxxxxx> 
wrote:


From: Joel.Patterson@xxxxxxxxxxx <Joel.Patterson@xxxxxxxxxxx>
Subject: RE: Oracle8i to 10g upgrade using exp and imp
To: hrishys@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx, Herald.ten.Dam@xxxxxxxxxxxxxxx
Date: Thursday, 25 June, 2009, 3:17 PM








Yes, but when I read something like ‘followed by a full or partial import’…in 
oracle documentation, it leaves me ambiguous as to what happens to the existing 
system schema in the destination database, and the consequences thereof.

Joel Patterson 
Database Administrator 
904 727-2546 




From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of hrishy
Sent: Thursday, June 25, 2009 9:55 AM
To: oracle-l@xxxxxxxxxxxxx; Herald ten Dam
Subject: RE: Oracle8i to 10g upgrade using exp and imp
 





Hi Hearld

 

Thank you very much i appreciate the highlighting to reinforce the way i read 
the documentation and confirming it.

 

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: "hrishy" <hrishys@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" 
<oracle-l@xxxxxxxxxxxxx>
Date: Thursday, 25 June, 2009, 1:23 PM


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 [oracle-l-bounce@xxxxxxxxxxxxx] namens 
hrishy [hrishys@xxxxxxxxxxx]
Verzonden: donderdag 25 juni 2009 11:52
Aan: 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: