Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Lost tables
Sorry, but i think the only way you have to recover this deletion is using your latest backup, i had this problem before.
One suggestion is to protect your tables from deletion or truncation is enabling constrainsts in order to force an organized deletion/truncation of the tables, this is not the definitive solution but it helps, because the only way to delete this tables is with a real knowledge of the action you are doing, not by mistake.
Lot's of luck
Peter Townsed escribió en mensaje <6ln6v9$fm6$1_at_galaxy.us.dell.com>...
>Gentlemen :
>
>Is there any way in Oracle to trace back deletion/truncation of schema
>objects (Oracle Tables)
>Several tables are missing from a production database and we suspect this
>was done by a disgruntled employee
>Any information will be appreciated
>thanks
>Peter Townsed
>
>
Received on Thu Jun 11 1998 - 00:00:00 CDT