Re: recovering lost tables from oracle9i database
Date: Thu, 3 Apr 2008 15:13:12 +0200
"gazzag" <gareth_at_jamms.org> schreef in bericht
> On 3 Apr, 13:32, anujit..._at_yahoo.co.in 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 ;)
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