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: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over

Re: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Mon, 09 Jun 2003 07:37:51 -0700
Message-ID: <F001.005AD892.20030609071421@fatcity.com>


Aah ! Hint, hint that some certain RDBMS vendor will offer cross-platform compatibility of database files soon.
Hemant
At 04:14 AM 07-06-03 -0800, you wrote:
Sashidar:

In THEORY HP datafiles and Sun data files are compaible. That is you can just move the HP data files to the Sun server and recreate the data files. Both data files are in same endianness and they are cross platform compatible.
There is no tool to convert a datafile from one OS format to another OS format. Some time back, some one (Guess who??) tried developing a tool and the idea was dropped since Oracle started addressing this issue as a standard feature inside the RDBMS product. So there is no third party tool available in the market to do that conversion and I don't expect any new tools to do that.
Having said that, that above said method is NOT officially supported by Oracle in current versions. You have to wait for some more time to get that officially supported by Oracle (clue!!) If you have a faster interconnect CTAS will be much faster than export import method, I remember seeing some comparitive numbers in Metalink.. Have you checked that?



Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale
Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Hemant K Chitale
 INET: [EMAIL PROTECTED]
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jun 09 2003 - 09:37:51 CDT

Original text of this message

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