in 10g, Oracle data files are made "platform aware" -- that is, the file headers store detailed platform information. the new v$transportable_platform view will show you the full list of supported platforms.
so in 9i this is unsupported; you need 10g. if certain "tricks" work, you are on your own.
Lex.
Tom Kyte Seminar:
http://www.naturaljoin.nl/events/seminars.html
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of biti_rainy
Sent: Thursday, January 20, 2005 11:18
To: 'oracle-l'
Subject: Re: RE: (NEW) very interesting thing about migrate db from different OS(oracle 9.2.0.4,not 10G)
hi,Lex de Haan
thanks for your reply.
i had read oracle 10i beta document on May-2003 ,when i saw the feature i am very intersting ,but at that time i do not test it beacause there is only version for HP unix,Sun soalris and linux ,and i have not these platforms.
today,i want to know why and how.
Best regards
msn: biti_rainy_at_hotmail.com
a dba from alibaba(china)
- from the mail-----
>
>if you look at the various releases of Oracle, up til the current one
>(10g), you can see that Oracle has been working on this -- for a
>perfect example, check out the transportable tablespace feature.
>initially very limited, but now (in 10g) quite useful.
>
>therefore, it is obvious that certain "tricks" work in certain releases.
>this having said, what you describe below in highly unsupported --
>which means that you are completely on your own (i.e. no support) if
>things go wrong.
>
>hope this helps, kind regards,
>
>Lex.
>
>----------------------------------------------------------------
>Tom Kyte Seminar: http://www.naturaljoin.nl/events/seminars.html
>----------------------------------------------------------------
>
>
>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org]
>On Behalf Of biti_rainy
>Sent: Thursday, January 20, 2005 07:24
>To: oracle-l
>Subject: (NEW) very interesting thing about migrate db from different
>OS(oracle 9.2.0.4,not 10G)
>
>hi,all
>
>we find a very interesting thing:
>
>we copy the WINDOWS2000 datafile to linux (they have the same
>byte
>order)
>
>and , dd a linux datafile header to cover the windows datafile
>header(the header block is not include in dba_data_files),the
>block is not seem in database ,it is for OS. ls -l can see
>,the datafile size is bigger than dba_data_files for one oracle block.
>
>
>when we change the OS file header,we can create controlfile
>and open the database ,and we can query /create table ... etc.
>
>
>the db version is oracle9204,not 10g. and someone told me that he
>can copy the datafile from windows and solaris for x86 pc to linux ,
>and not change the header with oracle8i.
>
>is there someone can discuss it?
>
>
>Best regards
>msn: biti_rainy_at_hotmail.com
>a dba from alibaba(china)
>
>
>--
>http://www.freelists.org/webpage/oracle-l
>
　　　　　　　　
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 20 2005 - 06:31:52 CST
