Re: recovering lost tables from oracle9i database
Date: Thu, 3 Apr 2008 06:26:11 -0700 (PDT)
Message-ID: <26e7c294-e5d7-4206-b687-bdb5e0d16118@e67g2000hsa.googlegroups.com>
On Apr 3, 8:56 am, "Shakespeare" <what..._at_xs4all.nl> wrote:
> <anujit..._at_yahoo.co.in> schreef in berichtnews:626b1d15-4e44-47f3-ad5a-58d12c3d558f_at_u36g2000prf.googlegroups.com...
>
> > 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.
>
> Since this does not sound like a real production system (scott/tiger!!!) I
> hope you have a backup!
>
> Shakespeare
Yes restoring the backup is the solution.
It is good practice as well to do a restore regularly to make sure you know how to do it. (so when you need to do it in production, you are confident of your restore process when the pressure is on!)
Ed Received on Thu Apr 03 2008 - 08:26:11 CDT