Re: Export 8.1.6 solaris / import 9.2.0.1 windows xp

In article <406c0983$0$28283$afc38c87_at_news.optusnet.com.au>, Howard J. Rogers says...
>
> "Jeremy" <newspostings_at_hazelweb.co.uk> wrote in message
> news:MPG.1ad5ef42719cb8b3989b77_at_news.individual.net...
> > In article <406bdc04$0$25657$afc38c87_at_news.optusnet.com.au>, Howard J.
> > Rogers says...
> > >
> > > "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.
> > > >
> >
> > >
> > > 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.
> > >
> > Thanks very much Howard, that's just the sort of thing I was looking
> > for!
>
> Well apart from the fact it was complete garbage!!
>
> As you'll see elsewhere, it's the wrong way round. Use your 8i export to
> export, and your 9i import to import.
>
> A thousand apologies. I wasn't thinking properly.

No sweat, I hadn't progressed far before seeing the other post!

Importing as we speak !

-- 

jeremy