Re: corrupt datafile

From: Hanne Iren Midttun <hannem_at_tihlde.org>
Date: Fri, 3 Jan 2003 08:32:00 +0100
Message-ID: <Pine.LNX.4.21.0301030823210.27999-100000@colargol.tihlde.org>

On Thu, 2 Jan 2003, ronia wrote:

> Supose I have only a datafile data.dbf
> I not have system.dbf, redologs.dbf temp.dbf etc.
>
> Are anyway to recover the data. At least manualy???
> I heard that Oracle Consulting can do it.

If it's only a tiny amount of data and all the data are varchars (text), you can read the data in unix this way:
cat <your database file> | strings | <and then a more or a less>

This is only if you are desperate :) I recomand calling Oracle.

(I learned this when a worked with a really clever Unix type. One day he told me that his name was not in the database. I asked how the heck he know - he could no oracle commands, and then he showed me this. The sad thing - from his point of view - is that you can't read numbers, blobs, dates.. and so on...)

regards Hanne Received on Fri Jan 03 2003 - 01:32:00 CST