Re: it possible to recover drop table in oracle 9i
From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 28 May 2008 09:24:57 -0700
Message-ID: <1211991910.356698@bubbleator.drizzle.com>
>
> Since 9i doesn't have flashback functionality, your only option is to
> perform incomplete recovery (point-in-time recovery) to the time just
> before the drop, export the table and then restore the database (for
> example, from a cold backup taken just before the incomplete
> recovery,) and import the table. This obviously requires a full backup
> taken before the drop which you don't seem to have, so the answer is
> "regrettably no."
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
Date: Wed, 28 May 2008 09:24:57 -0700
Message-ID: <1211991910.356698@bubbleator.drizzle.com>
Vladimir M. Zakharychev wrote:
> On May 28, 5:48 pm, "rajnikant.par..._at_gmail.com"
> <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
>
> Since 9i doesn't have flashback functionality, your only option is to
> perform incomplete recovery (point-in-time recovery) to the time just
> before the drop, export the table and then restore the database (for
> example, from a cold backup taken just before the incomplete
> recovery,) and import the table. This obviously requires a full backup
> taken before the drop which you don't seem to have, so the answer is
> "regrettably no."
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
A very minor clarification. As of 9.0.1 Oracle included the DBMS_FLASHBACK built-in package. But it won't address a dropped table only deleted rows.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed May 28 2008 - 11:24:57 CDT