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

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 - 02:41:40 CDT