Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 9.2.0.5.0 to 10g AND BACK!

Re: 9.2.0.5.0 to 10g AND BACK!

From: Mladen Gogala <mgogala_at_allegientsystems.com>
Date: Thu, 17 Feb 2005 10:24:02 -0500
Message-ID: <4214B712.6020902@allegientsystems.com>


Niall Litchfield wrote:

>You will need to run 10g with compatible set lower than 10. Once the
>compatability is set at 10 you won't be able to move the datafiles
>back.
>
>
>

The reason for that is the fact that 10g writes platform information into file header, such as
platform name, big Indian or little Indian, how many bits in long (32/64) and alike. You can
dump file headers in 9i and 10g and see the difference for yourself.

-- 
Mladen Gogala
Oracle DBA
Ext. 121


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 17 2005 - 10:28:02 CST

Original text of this message

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