RE: How to extract data directly from a datafile ?

From: Richard Ji <Richard.Ji_at_ztango.com>
Date: Wed, 17 Sep 2003 15:14:44 -0800
Message-ID: <F001.005D0421.20030917151444@fatcity.com>

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 <Richard.Ji_at_ztango.com> 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: kaygopal_at_yahoo.com

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: 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: Richard.Ji_at_ztango.com

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: 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).

Received on Wed Sep 17 2003 - 18:14:44 CDT