Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export 8.1.6 solaris / import 9.2.0.1 windows xp
"Jeremy" <newspostings_at_hazelweb.co.uk> wrote in message
news:MPG.1ad5e6bcf4d0325e989b75_at_news.individual.net...
> New database on a Win2k box. Existing 8i (8.1.6) db on solaris box.
>
> Is it straightforward to export from 8i and import into the 9i database?
> Might I encounter character set conversion issues? Appreciate any tips
> or pointers.
>
> cheers
>
> --
> jeremy
It is straightforward, provided you remember the rule: Use the Higher
version of the export executable against the lower version of the database.
In your case, make sure you fire up exp in the version 9 Oracle Home\bin
directory and use tnsnames aliases to direct it to connect to the 8i
database.
Regards
HJR
-- ------------------------------------------- Dizwell Informatics: http://www.dizwell.com -A mine of useful Oracle information- ===========================================Received on Thu Apr 01 2004 - 03:08:14 CST
![]() |
![]() |