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 --- [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> > <wisernet100@y cc: > > ahoo.com> Subject: Re: export > database from AIX to Sun > Sent by: > > [EMAIL PROTECTED] > > 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > > 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: [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). > > > __________________________________________________ > 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: [EMAIL PROTECTED] > > 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: [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). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [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). __________________________________________________ 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: [EMAIL PROTECTED] 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: [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). _________________________________________________________ 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: [EMAIL PROTECTED] 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: [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).
