Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: upgrade 8.1.5 to 9i
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