RE: Oracle8i to 10g upgrade using exp and imp
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, " Thomas F \(LABOR\)Mercadante" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- Date: Thu, 25 Jun 2009 13:49:30 +0000 (GMT)
Hi
My database was around 170Gb pretty smallish what i had done was taken a export
in 8i using full=y and then imported into 10g using imp full=y .
The database is functioning well but my concern was what would have happened to
the old sys and system objects of 8i that got imported into the new 10g version
regards
Hrishy
--- On Thu, 25/6/09, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante@xxxxxxxxxxxxxxxxx> wrote:
From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
Subject: RE: Oracle8i to 10g upgrade using exp and imp
To: hrishys@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
Date: Thursday, 25 June, 2009, 1:20 PM
Hrishy,
Why would you want to do an exp with full=Y?
I would simply recreate any scripts to create local roles and users. Include
any privs assigned to each user in the recreate scripts.
Run these scripts to create the roles and users.
Export and import each schema individually. Export with Oracle 8 and Import
with Oracle 10.
Resolve any problems. Should be a snap.
You don’t say how big your database is and this may be a deciding factor in how
you do this.
Hope this helps.
Tom
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of hrishy
Sent: Thursday, June 25, 2009 6:37 AM
To: oracle-l@xxxxxxxxxxxxx; Herald ten Dam
Subject: 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:
