Re: How to extract data directly from a datafile ?
Heh, strangely, this kind of idea of freeDUL (or whatever) has been also in my mind for couple of years, I planned to write it in C, but since I'm lazy, I've not got past of planning phase :) Anyway, keep up the good work and if your source happens to be free, put it up somewhere allowing others to study it as well. I wonder if anyone has written an equivalent to BBED yet? (this is also a plan of mine ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 6:09 AM I wouldn't call it the equivalent of DUL. :) Like I said it's a on a much smaller scale because I wrote it to work with what I have. So it only works with 8i, I have only test it on Linux and Solaris (so yes, it works with both little endian and big endian). There are a few data types it doesn't support yet such as BLOBs, etc. You get the idea. So a lot more work is needed, and I will probably ask for people to help me out by giving me some data files from various platforms, in varies block sizes, containing varies data. It's a working version as I have used it but there are a lot of enhancements needed to be able to use it in anyone's environment. And yes, it's in Java. Richard Ji -Original Message- Sent: Wednesday, September 17, 2003 10:00 PM To: Multiple recipients of list ORACLE-L I am aware its called DUL. And you have written the equivalent of DUL in Java then? If you understand the high-end/low-end bits, I'm interested in what you think - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 12:39 PM Yes and it's called data unloader DUL. And they charge you a fortune for using it. Just ask the other list members. :) -Original Message- Sent: Wednesday, September 17, 2003 8:25 PM To: Multiple recipients of list ORACLE-L I believe someone has done this within Oracle, ie to read the datafile and dump into a flat-file, which you can then SQL*load. Don't know what the current status is. As for OS format converter, I thought its more than just an endian issue - with high-order/low-order bits to represent file/block and porting groups free to shift the bits as they see fit? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:29 AM Richard: Not sure whether somebody else also tried this. Sometime back we (yours turley and few others ) tried developing a tool to convert a datafile from one OS format to another OS Format (little endian-big endian or Solaris to NT etc) by reading the datablocks from one format and writing to another format. The original plan was to have a iDUL kind of tool with a fileconverter to covert oracle datafiles from one OS to another OS. So the user will have a choice to download the data from data files or convert from one os to another OS. Since oracle started addressing this facility/feature in the current (for future?) versions we have dropped that idea as we don't want to compete with Oracle :D I would be interested in knwoing abt your tool too .. KG --- Richard Ji [EMAIL PROTECTED] wrote: Good idea. I am actually planning on write something like that myself. I have wrote on a smaller scale one just to extract data for our company's database (8.1.7.4) and it was extremely handy in one of our recovery situation where a complete recovery wasn't possible. And I am using Java as well. So maybe we can combine efforts. Richard Ji -Original Message- Sent: Wednesday, September 17, 2003 5:50 PM To: Multiple recipients of list ORACLE-L Shame, maybe you could email the guy who is writing it and ask for details of where he is with it? kind regards Pete = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services
Re: How to extract data directly from a datafile ?
Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: How to extract data directly from a datafile ?
At the recent OW conf, Oracle folks did announce that Oracle10g will support TTS across platforms/OS. No word on any data extraction tool as you guys are discussing here. - Kirti --- Richard Ji [EMAIL PROTECTED] wrote: KG, Yes, if Oracle start to address this, then it will be pretty hard to compete with them. :) Besides they already have the DUL, just hasn't made it freely availble to us. So this is something they address in 10G? Both the ability to unload data from data file directly and convert data files accross different platforms? That'd be great. But it might still be good to have such tools for 8i and 9i since people will probably be on it for years to come. Richard -Original Message- Sent: Wednesday, September 17, 2003 6:30 PM To: Multiple recipients of list ORACLE-L Richard: Not sure whether somebody else also tried this. Sometime back we (yours turley and few others ) tried developing a tool to convert a datafile from one OS format to another OS Format (little endian-big endian or Solaris to NT etc) by reading the datablocks from one format and writing to another format. The original plan was to have a iDUL kind of tool with a fileconverter to covert oracle datafiles from one OS to another OS. So the user will have a choice to download the data from data files or convert from one os to another OS. Since oracle started addressing this facility/feature in the current (for future?) versions we have dropped that idea as we don't want to compete with Oracle :D I would be interested in knwoing abt your tool too .. KG __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: How to extract data directly from a datafile ?
Hi Juan For which platform do you want it for? Not saying I have it! ;-) ta tony At 12:19 AM 17/09/2003 -0800, Juan Miranda wrote: We need to extract the data of a datafile directly, because we donĀ“t have the rest of the database (other tablespaces, controlfile, etc). Are there some utility like DUL ? What about Unicenter Fast Unload ?. Works it with the datafile directly ? Does it need the database open ? thanks
Re: How to extract data directly from a datafile ?
Hi, There is a tool called jDul on sourceforge but it wasn't available for download last time I looked, you might want to take a look again and see if it is now? hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: How to extract data directly from a datafile ?
Looks like it's still in the planning stage. -Original Message- From: Pete Finnigan [mailto:[EMAIL PROTECTED] Sent: Wed 9/17/2003 6:59 AM To: Multiple recipients of list ORACLE-L Cc: Subject:Re: How to extract data directly from a datafile ? Hi, There is a tool called jDul on sourceforge but it wasn't available for download last time I looked, you might want to take a look again and see if it is now? hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). winmail.dat
Re: How to extract data directly from a datafile ?
Shame, maybe you could email the guy who is writing it and ask for details of where he is with it? kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: How to extract data directly from a datafile ?
Good idea. I am actually planning on write something like that myself. I have wrote on a smaller scale one just to extract data for our company's database (8.1.7.4) and it was extremely handy in one of our recovery situation where a complete recovery wasn't possible. And I am using Java as well. So maybe we can combine efforts. Richard Ji -Original Message- Sent: Wednesday, September 17, 2003 5:50 PM To: Multiple recipients of list ORACLE-L Shame, maybe you could email the guy who is writing it and ask for details of where he is with it? kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: How to extract data directly from a datafile ?
Richard: Not sure whether somebody else also tried this. Sometime back we (yours turley and few others ) tried developing a tool to convert a datafile from one OS format to another OS Format (little endian-big endian or Solaris to NT etc) by reading the datablocks from one format and writing to another format. The original plan was to have a iDUL kind of tool with a fileconverter to covert oracle datafiles from one OS to another OS. So the user will have a choice to download the data from data files or convert from one os to another OS. Since oracle started addressing this facility/feature in the current (for future?) versions we have dropped that idea as we don't want to compete with Oracle :D I would be interested in knwoing abt your tool too .. KG --- Richard Ji [EMAIL PROTECTED] wrote: Good idea. I am actually planning on write something like that myself. I have wrote on a smaller scale one just to extract data for our company's database (8.1.7.4) and it was extremely handy in one of our recovery situation where a complete recovery wasn't possible. And I am using Java as well. So maybe we can combine efforts. Richard Ji -Original Message- Sent: Wednesday, September 17, 2003 5:50 PM To: Multiple recipients of list ORACLE-L Shame, maybe you could email the guy who is writing it and ask for details of where he is with it? kind regards Pete = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: How to extract data directly from a datafile ?
KG, Yes, if Oracle start to address this, then it will be pretty hard to compete with them. :) Besides they already have the DUL, just hasn't made it freely availble to us. So this is something they address in 10G? Both the ability to unload data from data file directly and convert data files accross different platforms? That'd be great. But it might still be good to have such tools for 8i and 9i since people will probably be on it for years to come. Richard -Original Message- Sent: Wednesday, September 17, 2003 6:30 PM To: Multiple recipients of list ORACLE-L Richard: Not sure whether somebody else also tried this. Sometime back we (yours turley and few others ) tried developing a tool to convert a datafile from one OS format to another OS Format (little endian-big endian or Solaris to NT etc) by reading the datablocks from one format and writing to another format. The original plan was to have a iDUL kind of tool with a fileconverter to covert oracle datafiles from one OS to another OS. So the user will have a choice to download the data from data files or convert from one os to another OS. Since oracle started addressing this facility/feature in the current (for future?) versions we have dropped that idea as we don't want to compete with Oracle :D I would be interested in knwoing abt your tool too .. KG --- Richard Ji [EMAIL PROTECTED] wrote: Good idea. I am actually planning on write something like that myself. I have wrote on a smaller scale one just to extract data for our company's database (8.1.7.4) and it was extremely handy in one of our recovery situation where a complete recovery wasn't possible. And I am using Java as well. So maybe we can combine efforts. Richard Ji -Original Message- Sent: Wednesday, September 17, 2003 5:50 PM To: Multiple recipients of list ORACLE-L Shame, maybe you could email the guy who is writing it and ask for details of where he is with it? kind regards Pete = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: How to extract data directly from a datafile ?
I believe someone has done this within Oracle, ie to read the datafile and dump into a flat-file, which you can then SQL*load. Don't know what the current status is. As for OS format converter, I thought its more than just an endian issue - with high-order/low-order bits to represent file/block and porting groups free to shift the bits as they see fit? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:29 AM Richard: Not sure whether somebody else also tried this. Sometime back we (yours turley and few others ) tried developing a tool to convert a datafile from one OS format to another OS Format (little endian-big endian or Solaris to NT etc) by reading the datablocks from one format and writing to another format. The original plan was to have a iDUL kind of tool with a fileconverter to covert oracle datafiles from one OS to another OS. So the user will have a choice to download the data from data files or convert from one os to another OS. Since oracle started addressing this facility/feature in the current (for future?) versions we have dropped that idea as we don't want to compete with Oracle :D I would be interested in knwoing abt your tool too .. KG --- Richard Ji [EMAIL PROTECTED] wrote: Good idea. I am actually planning on write something like that myself. I have wrote on a smaller scale one just to extract data for our company's database (8.1.7.4) and it was extremely handy in one of our recovery situation where a complete recovery wasn't possible. And I am using Java as well. So maybe we can combine efforts. Richard Ji -Original Message- Sent: Wednesday, September 17, 2003 5:50 PM To: Multiple recipients of list ORACLE-L Shame, maybe you could email the guy who is writing it and ask for details of where he is with it? kind regards Pete = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: How to extract data directly from a datafile ?
Yes and it's called data unloader DUL. And they charge you a fortune for using it. Just ask the other list members. :) -Original Message- Sent: Wednesday, September 17, 2003 8:25 PM To: Multiple recipients of list ORACLE-L I believe someone has done this within Oracle, ie to read the datafile and dump into a flat-file, which you can then SQL*load. Don't know what the current status is. As for OS format converter, I thought its more than just an endian issue - with high-order/low-order bits to represent file/block and porting groups free to shift the bits as they see fit? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:29 AM Richard: Not sure whether somebody else also tried this. Sometime back we (yours turley and few others ) tried developing a tool to convert a datafile from one OS format to another OS Format (little endian-big endian or Solaris to NT etc) by reading the datablocks from one format and writing to another format. The original plan was to have a iDUL kind of tool with a fileconverter to covert oracle datafiles from one OS to another OS. So the user will have a choice to download the data from data files or convert from one os to another OS. Since oracle started addressing this facility/feature in the current (for future?) versions we have dropped that idea as we don't want to compete with Oracle :D I would be interested in knwoing abt your tool too .. KG --- Richard Ji [EMAIL PROTECTED] wrote: Good idea. I am actually planning on write something like that myself. I have wrote on a smaller scale one just to extract data for our company's database (8.1.7.4) and it was extremely handy in one of our recovery situation where a complete recovery wasn't possible. And I am using Java as well. So maybe we can combine efforts. Richard Ji -Original Message- Sent: Wednesday, September 17, 2003 5:50 PM To: Multiple recipients of list ORACLE-L Shame, maybe you could email the guy who is writing it and ask for details of where he is with it? kind regards Pete = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: How to extract data directly from a datafile ?
I am aware its called DUL. And you have written the equivalent of DUL in Java then? If you understand the high-end/low-end bits, I'm interested in what you think - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 12:39 PM Yes and it's called data unloader DUL. And they charge you a fortune for using it. Just ask the other list members. :) -Original Message- Sent: Wednesday, September 17, 2003 8:25 PM To: Multiple recipients of list ORACLE-L I believe someone has done this within Oracle, ie to read the datafile and dump into a flat-file, which you can then SQL*load. Don't know what the current status is. As for OS format converter, I thought its more than just an endian issue - with high-order/low-order bits to represent file/block and porting groups free to shift the bits as they see fit? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:29 AM Richard: Not sure whether somebody else also tried this. Sometime back we (yours turley and few others ) tried developing a tool to convert a datafile from one OS format to another OS Format (little endian-big endian or Solaris to NT etc) by reading the datablocks from one format and writing to another format. The original plan was to have a iDUL kind of tool with a fileconverter to covert oracle datafiles from one OS to another OS. So the user will have a choice to download the data from data files or convert from one os to another OS. Since oracle started addressing this facility/feature in the current (for future?) versions we have dropped that idea as we don't want to compete with Oracle :D I would be interested in knwoing abt your tool too .. KG --- Richard Ji [EMAIL PROTECTED] wrote: Good idea. I am actually planning on write something like that myself. I have wrote on a smaller scale one just to extract data for our company's database (8.1.7.4) and it was extremely handy in one of our recovery situation where a complete recovery wasn't possible. And I am using Java as well. So maybe we can combine efforts. Richard Ji -Original Message- Sent: Wednesday, September 17, 2003 5:50 PM To: Multiple recipients of list ORACLE-L Shame, maybe you could email the guy who is writing it and ask for details of where he is with it? kind regards Pete = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: How to extract data directly from a datafile ?
I wouldn't call it the equivalent of DUL. :) Like I said it's a on a much smaller scale because I wrote it to work with what I have. So it only works with 8i, I have only test it on Linux and Solaris (so yes, it works with both little endian and big endian). There are a few data types it doesn't support yet such as BLOBs, etc. You get the idea. So a lot more work is needed, and I will probably ask for people to help me out by giving me some data files from various platforms, in varies block sizes, containing varies data. It's a working version as I have used it but there are a lot of enhancements needed to be able to use it in anyone's environment. And yes, it's in Java. Richard Ji -Original Message- Sent: Wednesday, September 17, 2003 10:00 PM To: Multiple recipients of list ORACLE-L I am aware its called DUL. And you have written the equivalent of DUL in Java then? If you understand the high-end/low-end bits, I'm interested in what you think - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 12:39 PM Yes and it's called data unloader DUL. And they charge you a fortune for using it. Just ask the other list members. :) -Original Message- Sent: Wednesday, September 17, 2003 8:25 PM To: Multiple recipients of list ORACLE-L I believe someone has done this within Oracle, ie to read the datafile and dump into a flat-file, which you can then SQL*load. Don't know what the current status is. As for OS format converter, I thought its more than just an endian issue - with high-order/low-order bits to represent file/block and porting groups free to shift the bits as they see fit? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:29 AM Richard: Not sure whether somebody else also tried this. Sometime back we (yours turley and few others ) tried developing a tool to convert a datafile from one OS format to another OS Format (little endian-big endian or Solaris to NT etc) by reading the datablocks from one format and writing to another format. The original plan was to have a iDUL kind of tool with a fileconverter to covert oracle datafiles from one OS to another OS. So the user will have a choice to download the data from data files or convert from one os to another OS. Since oracle started addressing this facility/feature in the current (for future?) versions we have dropped that idea as we don't want to compete with Oracle :D I would be interested in knwoing abt your tool too .. KG --- Richard Ji [EMAIL PROTECTED] wrote: Good idea. I am actually planning on write something like that myself. I have wrote on a smaller scale one just to extract data for our company's database (8.1.7.4) and it was extremely handy in one of our recovery situation where a complete recovery wasn't possible. And I am using Java as well. So maybe we can combine efforts. Richard Ji -Original Message- Sent: Wednesday, September 17, 2003 5:50 PM To: Multiple recipients of list ORACLE-L Shame, maybe you could email the guy who is writing it and ask for details of where he is with it? kind regards Pete = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services--