Re: How to extract data directly from a datafile ?

2003-09-18 Thread Tanel Poder
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

Re: How to extract data directly from a datafile ?

2003-09-18 Thread Pete Finnigan
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

RE: How to extract data directly from a datafile ?

2003-09-18 Thread Kirtikumar Deshpande
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

Re: How to extract data directly from a datafile ?

2003-09-18 Thread tjambu_fatcity
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

Re: How to extract data directly from a datafile ?

2003-09-17 Thread Pete Finnigan
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

RE: How to extract data directly from a datafile ?

2003-09-17 Thread Richard Ji
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

Re: How to extract data directly from a datafile ?

2003-09-17 Thread Pete Finnigan
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

RE: How to extract data directly from a datafile ?

2003-09-17 Thread Richard Ji
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.

RE: How to extract data directly from a datafile ?

2003-09-17 Thread K Gopalakrishnan
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

RE: How to extract data directly from a datafile ?

2003-09-17 Thread Richard Ji
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

Re: How to extract data directly from a datafile ?

2003-09-17 Thread Binley Lim
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

RE: How to extract data directly from a datafile ?

2003-09-17 Thread Richard Ji
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

Re: How to extract data directly from a datafile ?

2003-09-17 Thread Binley Lim
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

RE: How to extract data directly from a datafile ?

2003-09-17 Thread Richard Ji
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