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_at_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 <ORACLE-L_at_fatcity.com>
> <wisernet100_at_y cc:
>
> ahoo.com> Subject: Re: export
> database from AIX to Sun
> Sent by:
>
> root_at_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 <mitchell_at_comnet.ca> 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_at_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_at_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_at_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_at_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_at_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_at_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_at_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_at_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_at_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_at_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).
Received on Wed Dec 12 2001 - 16:19:50 CST