Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Lost tables

Re: Lost tables

From: José María Ferre Jorge <jmferre_at_redestb.es>
Date: 1998/06/11
Message-ID: <6lo5f3$idd$1@diana.bcn.ibernet.es>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US