RE: Oracle8i to 10g upgrade using exp and imp

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Thu, 25 Jun 2009 13:54:41 +0000 (GMT)
Message-ID: <213937.97087.qm_at_web23702.mail.ird.yahoo.com>



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_at_superconsult.nl> wrote:

From: Herald ten Dam <Herald.ten.Dam_at_superconsult.nl> Subject: RE: Oracle8i to 10g upgrade using exp and imp To: "hrishy" <hrishys_at_yahoo.co.uk>, "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> 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_at_yahoo.co.uk]
Verzonden: donderdag 25 juni 2009 12:36
Aan: oracle-l_at_freelists.org; 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_at_superconsult.nl> wrote:

From: Herald ten Dam <Herald.ten.Dam_at_superconsult.nl> Subject: RE: Oracle8i to 10g upgrade using exp and imp To: "hrishys_at_yahoo.co.uk" <hrishys_at_yahoo.co.uk>, "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> 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_at_freelists.org [oracle-l-bounce_at_freelists.org] namens hrishy [hrishys_at_yahoo.co.uk] Verzonden: donderdag 25 juni 2009 11:52
Aan: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 25 2009 - 08:54:41 CDT

Original text of this message