Last i checked there was no direct=y on imp only on exp (ok and sqlldr)
:)
joe
>>> NDATFM_at_labor.state.ny.us 08/16/01 09:18AM
>>>Alex,It's tough to guess how long an import will
take. It all depends on howmany indexes and constraints you have -
these are what take the most time atimport time. The data gets sucked
in real fast. Using Direct Load reallyspeeds the import up but, again,
rebuilding the indexes takes forever.Gene is correct in that export is
extremely fast.Tom MercadanteOracle Certified
Professional-----Original Message-----Sent: Wednesday, August
15, 2001 7:01 PMTo: Multiple recipients of list ORACLE-LAlex -
you must be joking, 60hrs? i get ~1gb/3mins for export. i haven'tdone
an import lately, but its not that bad. exp/imp are great tools tomove
data around.gene >>> Alex.Hillman_at_usmint.treas.gov
08/15/01 06:08PM >>>exp/imp does not work(takes too much time)for
large databases. How long doyou think import will take for 200G database? -
about 60 hours?Alex Hillman-----Original Message-----Sent:
Tuesday, August 14, 2001 5:03 PMTo: Multiple recipients of list
ORACLE-LRachel, I can see what he is
proposing, but I'm not sure anyone would care. IknowI can't take
the datafiles from one of our HP-UX servers and use them tocreatea
database on NT for instance. Wish I could for our Support Magic
junk. Inthat case they do a bunch of things (like create objects) as
SYS which nevergetincluded in an export. The problem that I see is
that there is a toolsetthatcurrently exists, namely export & import,
that work cross platform with noproblems. Just not at the datafile
level. And although that type of toolwouldbe interesting to me it
would not be of much value since I've only the oneproblem.Dick
Goulet____________________Reply Separator____________________Author:
"Rachel Carmichael"
<carmichr_at_hotmail.com>Date:
8/14/2001 12:41 PMit 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 toanother.While this is an
interesting trick, I'm not sure there's a large market for
it.>From: Scott Shafer
<sknd100_at_yahoo.com>>Reply-To: ORACLE-L_at_fatcity.com >To:
Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>>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 <A
href="
http://mail.yahoo.com">
http://mail.yahoo.com
>>-->Please see the official ORACLE-L FAQ: <A
href="
http://www.orafaq.com">
http://www.orafaq.com >-->Author:
Scott Shafer> INET: sknd100_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)._________________________________________________________________Get
your FREE download of MSN Explorer at <A
href="
http://explorer.msn.com/intl.asp">
http://explorer.msn.com/intl.asp
-- Please see the official ORACLE-L FAQ: <A
href="
http://www.orafaq.com">
http://www.orafaq.com -- Author: Rachel
Carmichael INET: carmichr_at_hotmail.com Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).-- Please see the official ORACLE-L
FAQ:
http://www.orafaq.com --
Author: INET: dgoulet_at_vicr.com Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).-- Please see the official ORACLE-L
FAQ:
http://www.orafaq.com --
Author: Hillman, Alex INET: Alex.Hillman_at_usmint.treas.gov
Fat City Network Services -- (858) 538-5051 FAX:
(858) 538-5051San Diego,
California -- Public Internet access /
Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).-- Please see the official ORACLE-L
FAQ:
http://www.orafaq.com-- Author:
Gene Sais INET: Gsais_at_co.palm-beach.fl.usFat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso 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: NDATFM_at_labor.state.ny.usFat City
Network Services -- (858) 538-5051 FAX: (858)
538-5051San Diego, California --
Public Internet access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
Received on Thu Aug 16 2001 - 07:57:39 CDT
