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: Export 8.1.6 solaris / import 9.2.0.1 windows xp

Re: Export 8.1.6 solaris / import 9.2.0.1 windows xp

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 1 Apr 2004 12:37:47 +0100
Message-ID: <406bff0c$0$6555$ed9e5944@reading.news.pipex.net>


"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:406bdc04$0$25657$afc38c87_at_news.optusnet.com.au...
>
> "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
Shouldn't that read use the *lower* version of exp, and the higher version of imp?

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Thu Apr 01 2004 - 05:37:47 CST

Original text of this message

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