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: Best way to move Oracle 8 from UNIX to NT?

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

From: MotoX <rat_at_tat.a-tat.com>
Date: Fri, 3 Jul 1998 08:41:40 +0100
Message-ID: <899451622.8259.0.nnrp-08.c2de712e@news.demon.co.uk>


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

Original text of this message

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