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 <jwilton_at_speakeasy.net> 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" <SBabich_at_handexmail.com> 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: jwilton_at_speakeasy.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!?
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: 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).
Received on Wed Jan 09 2002 - 13:31:46 CST
