Imports/exports only use about 1/10 of your available sustained io
generally. Although direct exports are noticably faster and less stress on
the database.
Locking, rollback generation, constraints, triggers can affect the
performance of the import/export process as well. Also network io if it
isn't a local export/import.
Direct path exports do not effect the speed of imports. Unless your using
SQLLDR direct. Direct path exports only effect the speed in which the
export is created and the resources it uses.
Conventional exports are cpu bound, where direct path exports are io bound.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-----Original Message-----
Sent: Thursday, August 16, 2001 9:18 AM
To: Multiple recipients of list ORACLE-L
Alex,
It's tough to guess how long an import will take. It all depends on how
many indexes and constraints you have - these are what take the most time at
import time. The data gets sucked in real fast. Using Direct Load really
speeds the import up but, again, rebuilding the indexes takes forever.
Gene is correct in that export is extremely fast.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Wednesday, August 15, 2001 7:01 PM
To: Multiple recipients of list ORACLE-L
Alex - you must be joking, 60hrs? i get ~1gb/3mins for export. i haven't
done an import lately, but its not that bad. exp/imp are great tools to
move data around.
gene
>>> [EMAIL PROTECTED] 08/15/01 06:08PM >>>
exp/imp does not work(takes too much time)for large databases. How long do
you think import will take for 200G database? - about 60 hours?
Alex Hillman
-----Original Message-----
Sent: Tuesday, August 14, 2001 5:03 PM
To: Multiple recipients of list ORACLE-L
Rachel,
I can see what he is proposing, but I'm not sure anyone would care. I
know I can't take the datafiles from one of our HP-UX servers and use them
to create a database on NT for instance. Wish I could for our Support Magic
junk. In that case they do a bunch of things (like create objects) as SYS
which never get included in an export. The problem that I see is that there
is a toolset that currently exists, namely export & import, that work cross
platform with no problems. Just not at the datafile level. And although
that type of tool would be interesting to me it would not be of much value
since I've only the one problem.
Dick Goulet
____________________Reply Separator____________________
Author: "Rachel Carmichael" <[EMAIL PROTECTED]>
Date: 8/14/2001 12:41 PM
it doesn't sound like an ftp type tool. If I am reading this correctly, he
is proposing to provide a tool that copies datafiles directly from one OS to
another.
While this is an interesting trick, I'm not sure there's a large market for
it.
>From: Scott Shafer <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Datafile Migration Tool
>Date: Tue, 14 Aug 2001 12:00:53 -0800
>
>Not to be a smartass, but don't most OS's already have ftp built in?
>What kind of value-added are you proposing? Just curious...
>
>Scott Shafer
>San Antonio, TX
>
>
>K Gopalakrishnan wrote:
> >
> > Hi ,
> >
> > Will there be a market if I give a tool which migrates Oracle
> > database from One OS to another OS. (Data file migration at
> > Operating System
> > Level.)
> >
> > i.e it will convert from Oracle data files on NT to Oracle
> > Datafiles on Solaris and vice versa. In the target database you
> > need to recreate the control files and you are done. You can startup
> > the database. You don't need to export/import or CTAS over dblink..
> >
> > Send your replies directly to me..
> >
> > Thanks Yong..for bringing the cat out of the basket ;)
> >
> > =====
> > Have a nice day !!
> > ------------------------------------------------------------
> > Best Regards,
> > K Gopalakrishnan,
> > Bangalore, INDIA.
>
>_________________________________________________________
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Scott Shafer
> 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).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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: Hillman, Alex
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: Gene Sais
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: Mercadante, Thomas F
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: Christopher Spence
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).
