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

2003-06-14 Thread Sashidhar Kondareddy
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 Compa

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

2003-06-09 Thread Jared . Still
kumar Deshpande <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/09/2003 07:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or

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

2003-06-09 Thread mkb
Wondering out aloud here. Could you export/imp using pipes. I remember doing this on a 200gb database going from 7.3 to 8 on Solaris, granted on the same server. Took about 4-6 hours if I remember correctly. Anyway to create a remote pipe on another server to listen for inputs from another serv

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

2003-06-09 Thread Jeremiah Wilton
1. Join the 10i beta program 2. Convert your 9.2 datafiles using the cross-platform transportable tablespaces feature of a dummy 10i instance. ;-) Or... Back when one of our system swas at around 200M, we had a C program that dumped table data in parallel by rowid ranges, wrote the streams in S

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

2003-06-09 Thread Kirtikumar Deshpande
You may want to review an article, "Cross Platform Migration of a Large Production Database", in the latest issue(2nd Qtr 2003) of SELECT journal (by IOUG). The author details the procedure he followed to migrtate a 300GB production database from HP-UX to IBM AIX. - Kirti --- "Goulet, Dick"

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

2003-06-09 Thread Goulet, Dick
Exp/imp of a 200GB database is possible, but I'd think the time required would be the long pole in the tent. I'd say your looking at at least a 4 day weekend at best and only if you used direct mode. Someone has hinted that you can simply move the datafiles from one box to the other. Well I'd

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

2003-06-07 Thread K Gopalakrishnan
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 t

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

2003-06-07 Thread Sashidhar Kondareddy
Hi all: We are considering migration of an Oracle eBusiness Suite 11.5.8 from HP-UX 11.0 to Solaris9. 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/