Mitchell;
Mitchell;
I don't know if this has already been said but my take is;
If you have the time and space export import should be oK. However if you don't
have one or the other, but do have a network, the best way is to use "create
table as select" across the network.
You'll need to generate all your create table and index scripts. You should
also use an export of any empty database to get some of the other things you
need like procedures, grants etc.
We have done this from HP to SUN.
Vinny
- Ron Yount <ronwy_at_swbell.net> wrote:
> Mitchell,
>
> I have not been following the thread, but nonetheless, I will attempt to add
> some information. It is accurate to state that imp/exp is your only option
> in 8.0.5 when you are trying to move a database from one platform (AIX) to
> another (Solaris).
>
> Other options all up through version 8.1.7 only apply when the platform is
> not changing:
> e.g. Transportable tablespace
> Standby database
> or RMAN Hot Backup/Recover from disk or tape.
>
> I have heard that in version 9i, you can, in fact create a standby database
> on a different platform because it actually converts the redo logs into SQL
> type DML/DDL statements and applies them, but even this is no way to
> re-create a 300 Meg database.
>
> Of course, your option of imp/exp would be VERY time and resource intensive.
>
> HTH,
> -Ron-
>
> > -----Original Message-----
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of mitchell
> > Sent: Monday, March 11, 2002 11:09 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: database clone:
> >
> >
> > Hi DBAs.
> >
> > Thanks all your reply. I am still thinking it is possible to use
> > backup file
> > or cp files. It is hard to exp/imp on a large system with 300GB.
> >
> > Mitchell
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Monday, March 11, 2002 11:53 AM
> >
> >
> > > mitchell_at_comnet.ca wrote:
> > >
> > > > Hi DBAs:
> > > >
> > > >What is the best way to clone large oracle database ( 8.0.5, 300g) from
> > aix
> > > >4.3 o to Sun Soloris (2.8).
> > > >Any idea, articles, experience?
> > > >
> > > >
> > > >thanks in advance.
> > > >
> > > >Mitchell
> > > >
> > > >
> > > exp from aix, install, create the database and the tablespaces on sun,
> > > then imp.
> > >
> > >
> > > --
> > > --
> > > Bill "Shrek" Thater ORACLE DBA
> > > bthater2_at_netscape.net
> > > ------------------------------------------------------------------------
> > > You gotta program like you don't need the money,
> > > You gotta compile like you'll never get hurt,
> > > You gotta run like there's nobody watching,
> > > It's gotta come from the heart if you want it to work.
> > > ------------------------------------------------------------------------
> > > "Books won't stay banned - Ideas won't go to jail." - Alfred
> > Whitney Griswold
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: bill thater
> > > INET: bthater2_at_netscape.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_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: 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).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ron Yount
> INET: ronwy_at_swbell.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_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!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vincent Cimino
INET: vdcimino_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 Mar 13 2002 - 08:08:31 CST
