RE: Re[2]: Datafile Migration Tool
Exactly ;) "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 1:13 PM To: Multiple recipients of list ORACLE-L Oh my, we were right, they are picking on us, I told you didn't I. No, I told you No you didn't. "Use the delete key, personally you can read what you like, judging by some of the posts, it is better read than some other posts on paranoid schizophrenics." The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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).
RE: Re[2]: Datafile Migration Tool
Oh my, we were right, they are picking on us, I told you didn't I. No, I told you No you didn't. "Use the delete key, personally you can read what you like, judging by some of the posts, it is better read than some other posts on paranoid schizophrenics." The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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).
RE: Re[2]: Datafile Migration Tool
"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." And why do we need to read this? Use the delete key, personally you can read what you like, judging by some of the posts, it is better read than some other posts on paranoid schizophrenics. "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." Again - why do we need to read this? Any person even little knowlegeble in Oracle DBA knows this Use the delete key, again, I don't care what you read and what you don't read. That is your choice, the delete key is your choice. "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." SQLLDR cannot use sxport dump file as a source Agreed. Merely stating import speed is not effected by direct exports. Only direct sql loads using sqlldr is it's "import" speed effected". There is a lot of confusion that direct exports effect the speed of the import as well. This is false. "Conventional exports are cpu bound, where direct path exports are io bound." Who told you so? A little bird, and Oracle, as well as testing and experimenting. "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 11:52 AM To: Multiple recipients of list ORACLE-L "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." And why do we need to read this? "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." Again - why do we need to read this? Any person even little knowlegeble in Oracle DBA knows this "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." SQLLDR cannot use sxport dump file as a source "Conventional exports are cpu bound, where direct path exports are io bound." Who told you so? Alex Hillman -- 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).
RE: Re[2]: Datafile Migration Tool
"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." And why do we need to read this? "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." Again - why do we need to read this? Any person even little knowlegeble in Oracle DBA knows this "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." SQLLDR cannot use sxport dump file as a source "Conventional exports are cpu bound, where direct path exports are io bound." Who told you so? Alex Hillman -Original Message- Sent: Thursday, August 16, 2001 11:28 AM To: Multiple recipients of list ORACLE-L 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 !! > >
RE: Re[2]: Datafile Migration Tool
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). __
RE: Re[2]: Datafile Migration Tool
Last i checked there was no direct=y on imp only on exp (ok and sqlldr) :) joe >>> [EMAIL PROTECTED] 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 >>> [EMAIL PROTECTED] 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 GouletReply SeparatorAuthor: "Rachel Carmichael" <[EMAIL PROTECTED]>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 <[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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX:
RE: Re[2]: Datafile Migration Tool
DOH! mixing up my tools again! thanks Joe! "Last i checked there was no direct=y on imp only on exp (ok and sqlldr) :)" Tom Mercadante Oracle Certified Professional -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 8:48 AMTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]Subject: RE: Re[2]: Datafile Migration Tool Last i checked there was no direct=y on imp only on exp (ok and sqlldr) :) joe >>> [EMAIL PROTECTED] 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 >>> [EMAIL PROTECTED] 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 GouletReply SeparatorAuthor: "Rachel Carmichael" <[EMAIL PROTECTED]>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 <[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)._
RE: Re[2]: Datafile Migration Tool
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 Interne
RE: Re[2]: Datafile Migration Tool
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
RE: Re[2]: Datafile Migration Tool
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
