Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: upgrade 8.1.5 to 9i

Re: upgrade 8.1.5 to 9i

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Tue, 01 Jul 2003 16:01:54 GMT
Message-ID: <MPG.196b504ec09267499897de@news.la.sbcglobal.net>


Telemachus was kind enough to write:
> Just import the schemas or tables that you want into your newly created
> database.
>
>
> Check out the Utilities guide for how to do this.
> "Roger" <roger.sjolin_at_telia.com> wrote in message
> news:rtcMa.18455$dP1.34690_at_newsc.telia.net...
> > Hi
> > I have a full exportfile xx.dmp from my 8.1.5 database and I want to
> upgrade
> > to version 9i using Enterprice manager.
> > How shall I do?
> > I dont want to use the upgrade utility beacause I am doing a clean
> > installation of 9i on a new computer.
> > Regards
> > Roger
> >
>

Just to make sure you caught the sublety in the post by Telemachus, you don't want to do a full import (else you'll import the 8.1.5 dictionary objects). Create a 9i db, create some schema owners, then import just the objects for those schema owners.

-- 
[:%s/Karsten Farrell/Oracle DBA/g]
Received on Tue Jul 01 2003 - 11:01:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US