Re: it possible to recover drop table in oracle 9i

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.

:-)

Depends.

jg

--
@home.com is bogus.
Damn compuserve billing systems to hell.
word: rescurea