Re: Problem with rollback
From: Jukka Holopainen <jukka.holopainen_at_ou.fp.enso.com>
Date: 1998/06/05
Message-ID: <01bd905d$a6ee8650$55da0490_at_holopjuou>#1/1
Date: 1998/06/05
Message-ID: <01bd905d$a6ee8650$55da0490_at_holopjuou>#1/1
Master2 <skcee_at_uno.edu> wrote in article <3576E6EC.A31B9A02_at_uno.edu>...
> Hi,
> I have dropped a table accidentally and was trying to rollback the
> transaction.
> "Rollback was succesfull" was the message, but when I queried the table,
>
> the table was not found. What could be the reason? Is there something to
> do with
> the rollback segment? What should be the size of this segment in
> general?
> Any suggestions towards this are greatly appreciated.
> thank u
> Sravan
>
>
Table is gone.
Drop command make autocommit so you cannot do rollback
dropped table.
Only if you have backup somewhere you can restore that.
T: Jukka Holopainen Received on Fri Jun 05 1998 - 00:00:00 CEST