Re: Non-Sql data extraction (recovery tools)
- From: Tim Gorman <tim@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 15 Aug 2013 12:16:00 -0600
One of two things are going on here...
1. Performing recovery from a unopenable Oracle database, when this is
the only possible method to extract the data for reload
* Though it isn't free, DUDE (http://www.ora600.be) is the best
tool available at the lowest cost
o if the data is truly of value, then the cost should
considered in light of the value of the data
o Extracting data directly from the datafiles for any other
purpose or reason is foolish
+ Bypassing the consistent-read mechanism built into the
SQL API of Oracle can yield corrupted data
2. Hacking into some Oracle datafiles
* I am not interested in helping someone do this, both for the
reasons stated above and because it might be irresponsible
Whomever wants to do this should clarify their reasons, I think?
Full disclosure: I am the US representative for DUDE, which is based in
Belgium.
On 8/15/2013 11:55 AM, Andrew Kerber wrote:
> I think he is looking for a method that does not use sql or exp, it says
> something that reads the oracle files directly, so he is looking for
> something like dude or dul.
>
> On Thu, Aug 15, 2013 at 12:50 PM, Carlos Sierra <carlos.sierra.usa@xxxxxxxxx
>> wrote:
>> John,
>> You may want to check SQL Developer. It has an option to Export data on
>> "loader" format.
>>
>> Cheers,
>>
>> Carlos Sierra
>> carlos.sierra.usa@xxxxxxxxx
>>
>> Powered by Optimism!
>>
>> On Aug 15, 2013, at 10:37 AM, John Smith <john40855@xxxxxxxxx> wrote:
>>
>>> Does anyone know of any freeware/shareware tools for pulling data
>> directly
>>> from Oracle database files, into sql loader format or similar? I have
>> seen
>>> some commercial tools on the market, and I would like to find out more
>>> about that capability.
>>>
>>>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
