Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Extracting data from old Oracle files
AFAIK, is impossible...The storage method used by Oracle is proprietary, so to get at it, you would need an 'Oracle Aware' set of tools..Even to generate a CSV file would require 'reading' the data and without Oracle's control files and stuff, it would be a real task, and possibly not 'doable' at all...
There may be some consultants out there that can do it, but ..$$$....
( Even if you reinstalled Oracle , you would need the control files and other parts of the original database...just the *.dbf files wouldn't be enough..)
"Colin Carpenter" <ccarpenter_at_planetcs.co.uk> wrote:
>Hi All,
>
>I've been given something of a tricky task, a set of .dbf files from an old
>HP-UX server running Oracle 6.3 we don't have Oracle here any more but I
>need to be able to open these files and get at the data. Does anyone have
>any suggestions, are there any utilities out there that can open these files
>and possibly save the tables out to CSV files perhaps??
>
>Thanks in advance,
>
>Colin.
>
>
>
>
Received on Fri May 04 2001 - 15:32:00 CDT