RE: Oracle8i to 10g upgrade using exp and imp
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <hrishys@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Jun 2009 08:35:19 -0400
Hrishy,
The SYS user never exports even with full=y. I think your concern is
what happens to the SYSTEM user when it is being imported into the 10g
database. If nothing happens then you are thinking that full=y would
be easier but you have to resolve that conflict first.
I know I'm re-phrasing the question for the list and they can also
respond. If so, my response would be to use expdp (10g datapump) to
export the 8i database, and then impdp with the new 'exclude' option and
exclude SYSTEM.
I have not done this exact scenario so you should stay tuned for other
comments to this method.
Joel Patterson
Database Administrator
904 727-2546
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F
(LABOR)
Sent: Thursday, June 25, 2009 8:21 AM
To: hrishys@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle8i to 10g upgrade using exp and imp
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
<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l-bounce@freelists.
org> [oracle-l-bounce@xxxxxxxxxxxxx
<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l-bounce@freelists.
org> ] 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:
