Re: upgrade 8.1.6 to oracle 10g

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 20 Apr 2005 07:38:37 -0700
Message-ID: <1114007917.570650.120500@f14g2000cwb.googlegroups.com>

Laurent wrote:
> Hy,
> i want to migrate my oracle server (windows 2K SP4) from V8.1.6 to
> oracle 10G.
> As the upgrade utility doesn't allow this migrate, i'm wondering the
> best solution :
> - upgrade by imp full database ;
> - upgrade by imp only my user, after creating all the tablespace used
;
>
> in the first solution, does i need to apply again different oracle
> pl/sql package, or after the full import, all is good ?
>
> regards,
> Laurent

Export from 8.1.6 (FULL=Y) and Import into 10.1.0 (FULL=Y) is not supported. You are only left with doing schema level import into 10g i.e. fromuser/touser option (2nd solution in your post).

Ofcourse you can first upgrade to 8.1.7 to avoid this restriction.

Regards
/Rauf Received on Wed Apr 20 2005 - 09:38:37 CDT