DOH!
mixing up my tools again!
thanks Joe!
"Last i checked there was no direct=y
on imp only on exp (ok and sqlldr) :)<SPAN
class=833034312-16082001>"
Tom Mercadante Oracle Certified
Professional
<FONT
face=Tahoma>-----Original Message-----From: JOE TESTA
[mailto:JTESTA_at_longaberger.com]Sent: Thursday, August 16, 2001 8:48
AMTo: ORACLE-L_at_fatcity.com;
NDATFM_at_labor.state.ny.usSubject: RE: Re[2]: Datafile Migration
Tool
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:35:04 CDT