Have a look at a very interesting paper from Nigel Noble (Churchill Insurance). Its title is : Techniques For Fast Database Re-Organization This paper may be found at this link (not at top) : http://www.doug.org/news/doug596.html
Regards. --------------------------------------------------------------- Gery Pannequin - Independant Consultant --------------------------------------------------------------- ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, March 11, 2002 6:28 PM > Your thinking is incorrect. You CAN NOT share AIX and Solaris Oracle > datafiles. They are platform specific in architecture. I'm currently > moving almost 200 databases from sun to AIX, what that I could just > move the datafiles. > > RF > > Robert G. Freeman - Oracle8i OCP > Oracle DBA Technical Lead > CSX Midtier Database Administration > > The Cigarette Smoking Man: Anyone who can appease a man's conscience can > take his freedom away from him. > > > > -----Original Message----- > Sent: Monday, March 11, 2002 12:09 PM > To: Multiple recipients of list ORACLE-L > > > 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: Freeman, Robert > 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: Gery PANNEQUIN 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).
