export won't necessarily take longer, but import will almost always take longer than the export by a factor of anywhere from twice to four times.
--- Jeremiah Wilton <[EMAIL PROTECTED]> wrote: > Yes, export may not take longer than file copy if you are cloning a > tiny database less than 1 Gb. > > However, export will always be more complicated to use for cloning, > and more error-prone. > > Some related supporting points can be found at: > > http://www.speakeasy.org/~jwilton/oracle/export-backups.html > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Wed, 9 Jan 2002, Babich , Sergey wrote: > > > With all my respect, this is not always the case > > Best regards, > > Serge > > > > -----Original Message----- > > Sent: Wednesday, January 09, 2002 10:15 AM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Clone a database > > > > easier perhaps only if you have the exact same disk layouts and > space > > available. > > > > and certainly MUCH more time to create -- an import takes anywhere > from > > 2-4 times as long as the export did. > > > > --- "Babich , Sergey" <[EMAIL PROTECTED]> wrote: > > > Hi, Beatriz, > > > If you want to create an identical copy of your production > (that's my > > > understanding), it is a lot easier to export it (FULL=Y) and then > > > import the > > > dump file into your new database. Let me know if you need more > info. > > > Regards, > > > Sergey Babich, Oracle DBA > > > > > > -----Original Message----- > > > Sent: Wednesday, January 09, 2002 4:50 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Clone a database > > > > > > Hello list, > > > I new to clone a database for changing between test to > production. > > > The new database is going to be in a different host. > > > I have the copy obtained through the enterprise manager (I > suppose > > > it´s > > > a cold backup). > > > Which are the steps I should follow? > > > A lot of thanks > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeremiah Wilton > 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!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 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).