Re: recovering lost tables from oracle9i database

From: Shakespeare <>
Date: Thu, 3 Apr 2008 15:13:12 +0200
Message-ID: <47f4d7ea$0$14351$>

"gazzag" <> schreef in bericht
> On 3 Apr, 13:32, wrote:
>> in my oracle 9i database,around 150 tables were created and used
>> frequently. but one fine day,only around 20 tables are seen and other
>> tables are missing. How can I recover all the other tables. The tables
>> are all created by scott/tiger. pls help me out asp.
> Depending on your setup, Flashback Query may be of some benefit:
> Of course, at the risk of sounding like I'm shutting the gate after
> the horse has bolted, your main concern is how this happened and how
> you are going to prevent it happening again. You may want ot examine
> your backup solution, too ;)
> -g

a.. Flashback query does not work through DDL operations that modify columns, or drop or truncate tables.

I fear the worst....

Shakespeare Received on Thu Apr 03 2008 - 08:13:12 CDT

Original text of this message