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

Home -> Community -> Usenet -> c.d.o.server -> Re: how to find out which tables where deleted

Re: how to find out which tables where deleted

From: Ralph Graulich <ralph_at_grauli.ch>
Date: Tue, 05 Mar 2002 14:35:26 +0100
Message-ID: <ralph-69B47F.14352505032002@doorway.ih.reiff.de>


Hi Roland,

> is there an v$ view or any other resource where i can find out, if a
> specific table was deleted/dropped by an
> application ?

You can use the log miner utility to search for tables not being there anymore.

A note to your post: A table can't be "deleted". You can either:

  1. DROP a table including its content (rows)
  2. DELETE the content of a table resulting in an empty table
  3. TRUNCATE a table (deleting its content, without being able to rollback the transaction as no redo information is written)

Regards
... Ralph ... Received on Tue Mar 05 2002 - 07:35:26 CST

Original text of this message

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