From jwilton@speakeasy.net Wed, 12 Dec 2001 15:04:27 -0800 From: Jeremiah Wilton Date: Wed, 12 Dec 2001 15:04:27 -0800 Subject: RE: export database from AIX to Sun Message-ID: MIME-Version: 1.0 Content-Type: text/plain Gopal, Are all the datatype representations identical between solaris and HP OS? Are they both big-indian/little-indian? I know you and I have discussed this before - I actually requested Oracle to build a migration utility that takes this approach. As for CTAS over DB link, doesn't that do on e round trip per row? That seems like it would be much slower than parallel unload/load over named pipes / dd with large blocksizes over a fast network. The latter approach uses many fewer round trips One advantage of CTAS over DB link is that the new tables can be created NOLOGGING, which cannot be accomplished with import. SQL*Loader, however can do parallel nologging loads, so I would say the most supportable, most efficient method is parallel unload/nologging sqlload over named pipes/dd/rsh/dd with large blocksizes over a fast network. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 12 Dec 2001, K Gopalakrishnan wrote: > Until Oracle or some one (guess who??) gives a tool, which reads the AIX > datafiles and writes as Solaris Datafiles. IIRC we can copy the datafiles > from Sun to HP (and HP to Sun) and use that, Not sure about Oracle Support's > stand on these type of migrations. > > Other than these two, you can migrate the database using CTAS. (Create table > as select over a dblink). This will be much faster than export and import > (oracle Metalink has some statistics). This can be used if you have very > few, huge tables. > > Best Regards, > K Gopalakrishnan > (408) 934 9310 > > > -----Original Message----- > Carmichael > Sent: Wednesday, December 12, 2001 12:10 PM > To: Multiple recipients of list ORACLE-L > > okay let me modify my statement... > > that's the only SIMPLE way to do it > > > --- Jared.Still@radisys.com wrote: > > > > Unless of course you want to do it some other way, like dump to > > flat files and use sqlloadder. :) > > > > Jared > > > > > > > > > > > > > > Rachel > > > > Carmichael To: Multiple recipients > > of list ORACLE-L > > > > > ahoo.com> Subject: Re: export > > database from AIX to Sun > > Sent by: > > > > root@fatcity.c > > > > om > > > > > > > > > > > > 12/12/01 09:50 > > > > AM > > > > Please respond > > > > to ORACLE-L > > > > > > > > > > > > > > > > > > > > in fact, that's the only way to move a database from one platform to > > another. > > > > > > --- mitchell wrote: > > > Hi Gurus: > > > > > > It is possible to exp database from aix 4.3.3. oracle 8.0.5.1 and > > > imp to > > > Sun Soloris 2.7 Oracle 8.1.7 > > > I have only done on same os. env before. > > > > > > > > > Thanks in advance > > > Mitchell > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: mitchell > > > INET: mitchell@comnet.ca > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California -- Public Internet access / Mailing > > > Lists > > > > > -------------------------------------------------------------------- > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: ListGuru@fatcity.com (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). > > > > > > __________________________________________________ > > Do You Yahoo!? > > Check out Yahoo! Shopping and Yahoo! Auctions for all of > > your unique holiday gifts! Buy at http://shopping.yahoo.com > > or bid at http://auctions.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > INET: wisernet100@yahoo.com > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing > > Lists > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: ListGuru@fatcity.com (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). > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > INET: Jared.Still@radisys.com > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing > > Lists > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: ListGuru@fatcity.com (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). > > > __________________________________________________ > Do You Yahoo!? > Check out Yahoo! Shopping and Yahoo! Auctions for all of > your unique holiday gifts! Buy at http://shopping.yahoo.com > or bid at http://auctions.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: wisernet100@yahoo.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (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). > > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: K Gopalakrishnan > INET: kaygopal@yahoo.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: jwilton@speakeasy.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (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).