RE: Oracle8i to 10g upgrade using exp and imp
Date: Thu, 25 Jun 2009 08:20:33 -0400
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.
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of hrishy Sent: Thursday, June 25, 2009 6:37 AM
To: oracle-l_at_freelists.org; Herald ten Dam Subject: RE: Oracle8i to 10g upgrade using exp and imp
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)
- 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
org> ] namens hrishy [hrishys_at_yahoo.co.uk
Verzonden: donderdag 25 juni 2009 11:52 Aan: oracle-l_at_freelists.orglink which spells out that i can do exp full=y on 8i database and imp full=y into 10g database.
Onderwerp: Oracle8i to 10g upgrade using exp and imp Hi I would like to know any metalink note or Oracle documentation
I searched this but unable to locate that this is a a supported method for upgrading from 8i to 10g
regards HrishyReceived on Thu Jun 25 2009 - 07:20:33 CDT