RE: Oracle8i to 10g upgrade using exp and imp
- From: Herald ten Dam <Herald.ten.Dam@xxxxxxxxxxxxxxx>
- To: hrishy <hrishys@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Jun 2009 14:23:46 +0200
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:
