Re: it possible to recover drop table in oracle 9i
Date: Tue, 3 Jun 2008 10:59:05 -0700 (PDT)
On Jun 2, 5:57 pm, Michael Austin <maus..._at_firstdbasource.com> wrote:
> rajnikant.par..._at_gmail.com wrote:
> > Dear All
> > I have accidently drop a table, Is it possible to recover this table
> > in oracle 9i ?
> > I have no backup
> > and My database is running in archive log mode.
> > Can i recover a table from log file ?
> > Thank you
> > Raj
> Just curious, but what good is having ARCHIVE LOG MODE running without
> ever doing a backup?
It sure does seem stupid, but I've wound up doing this on test db's where I need to test performance or space, when the db comes from a restoration or other type of load. And in 10g, you gotta watch to see if the backup jobs work after patching.
> Second Q: do you have an updated resume? After this, you may need it.
-- @home.com is bogus. Damn compuserve billing systems to hell. word: rescureaReceived on Tue Jun 03 2008 - 12:59:05 CDT