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 dblink or ..

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

From: Sashidhar Kondareddy <Sashidhar.Kondareddy_at_itsprojects.com>
Date: Sat, 14 Jun 2003 00:28:50 -0700
Message-ID: <F001.005B1C36.20030614000937@fatcity.com>


Hi:

Thanks to everyone who responded to my message on Cross Platform Migration... I will update the list if we come to any conclusions not consilient with the findings given on the list..

Thanks & Regards,
Sashi

Sashidhar Kondareddy
 Project Manager
 IT Solutions Inc, a SEI CMM Level 5 Company  Chennai 600006, India
 efax : +1 (360) 242-8334



The nice thing about standards is that you have so many to choose from. Furthermore, if you do not like any of them, you can just wait for next year's model. -- Andrew S. Tanenbaum in Computer Networks, 2nd Edition

I'd like to know if anyone has done this and how daunting the task is.

Are there any 3rd Party tools which can help out?

Coming to the conventional approaches:

  1. What do you think of Export/Import of a 200 GB database? 1a. How much time will it take? 1b. Any strategies for cutting that down?
  2. How does CTAS over dblink compare to Export/Import?
  3. Is there any tool that converts Oracle datafiles on HP-UX 11.0 to Oracle datafiles on Solaris 9. If so we would just need to recreate the control files on the target database and we are done.

Any suggestions, pointers, words of wisdom are greatly appreciated...

Thanks & Regards,
Sashi
--

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

Author: Sashidhar Kondareddy
  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 Sat Jun 14 2003 - 02:28:50 CDT

Original text of this message

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