Re: Lost data

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Wed, 27 Feb 2002 19:04:32 GMT
Message-ID: <3C7D2DC2.1C56F0EF@ci.seattle.wa.us>

I'm not sure from what you wrote what happened. You can not delete a table.

You can drop a table ... DDL ... which means the table, all of its data, constraints, and triggers are gone. And there is no rollback option.

Or you can delete data ... DML ... which would have a rollback option.

As yo have not stated what version of Oracle, what hardware platform, what operating system, or anything about the nature of the backup ... helping you is impossible. Guess is not. And I'm not into guessing today.

Daniel Morgan

Patrick Hardy wrote:

> Hi, someone made a a mistake and deleted an important table... then, second
> error, didn't do the rollback...
>
> Those data were on a data server not really important and not managed by the
> DB guys so the only backup we could have was a HardDisk backup..
>
> So i have a orant directory with all the files in it and i'd like to recover
> the data in any format even if it means reenter all data by one by one...
>
> Thanks a lot
>
> Pat
> el_lasso_at_hotmail.com
Received on Wed Feb 27 2002 - 13:04:32 CST