Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: Datafile Migration Tool

RE: Re[2]: Datafile Migration Tool

From: Mercadante, Thomas F <>
Date: Thu, 16 Aug 2001 05:35:04 -0700
Message-ID: <>


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

  face=Tahoma>-----Original Message-----From: JOE TESTA   []Sent: Thursday, August 16, 2001 8:48   AMTo:;
  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)   :)
  >>> 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 >>> 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" 
  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
  <>>Reply-To: >To:   Multiple recipients of list ORACLE-L
  <>>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,
  You Yahoo!?>Get your free address at <A   href="">   >>-->Please see the official ORACLE-L FAQ: <A   href="">   >-->Author: Scott Shafer>   INET: >>Fat City Network Services    Received on Thu Aug 16 2001 - 07:35:04 CDT

Original text of this message