Re: Best way to move Oracle 8 from UNIX to NT?

Watch out for character set of your exported database, unless you export in Windows (maybe using OEM)
and then import from WIndows.

If your export is on HP and import is on NT, make sure the character sets are compatible.

Raman Batra, rrbatra_at_feist.com

MotoX wrote:
>
> Yes, you can.
>
> Just make sure when you copy (ftp?) the file across from the UNIX server you
> do it in 'binary' mode. Then use the Oracle 8 import: It'll show a warning
> that the objects were exported from a different version of Oracle, but it'll
> still import OK.
>
> Check the Oracle Manuals for more info. on database upgrades and migrations.
>
> MotoX.
>
> Jinsong Qui wrote in message <6ngfa4$43h$1_at_client3.news.psi.net>...
> >Can I move an Oracle database(7.3) at UNIX to Oracle server (8.0) at NT by
> >using Export/Import ?
> >
> >Thanks.
> >
> >MotoX wrote in message
> ><899365690.4519.0.nnrp-03.c2de712e_at_news.demon.co.uk>...
> >>
> >>Bob Hayden wrote in message <359AE4D3.DD4EF0B2_at_it.here.com>...
> >>>Hello,
> >>>
> >>>I need to move an 8.0.4 database from HP-UX to NT.
> >>
> >>Poor guy. :-)
> >>
> >>>Do I need to do an export/import
> >>
> >>Yes. A FULL one.
> >>
> >>> ...or is there a better way to do this... how about a wizard?
> >>
> >>No. And no! :-)
> >>
> >>>:) I will probably try the export/import, any gotchas I should be aware
> >>>of?
> >>
> >>
> >>Yep, make sure you create all the required tablespaces first and get the
> >>names right. Make sure there is enough space in your new db. The the old
> >>database has been correctly designed, don't compress the extents on the
> >>export (it defaults to 'y').
> >>
> >>MotoX.
> >>
> >>>
> >>>
> >>>-------------------------------------------
> >>>Bob Hayden
> >>>email:
> >>>bob at ljpc dot com
> >>>-------------------------------------------
> >>
> >>
> >
> >
Received on Fri Jul 03 1998 - 22:42:24 CDT