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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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" <[EMAIL PROTECTED]> > Sent: Monday, March 11, 2002 11:53 AM > > > > [EMAIL PROTECTED] 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 > > [EMAIL PROTECTED] > > ------------------------------------------------------------------------ > > 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: [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: 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Yount 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).
