Re: Problem with rollback

On Thu, 04 Jun 1998 13:26:52 -0500, Master2 <skcee_at_uno.edu> wrote:
>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.

Read the Concepts manual about transactions. When you do a DDL statement, Oracle commits any current transaction and commits the DDL as a new single statement transaction. You can't rollback because you've already committed.

>thank u
>Sravan
>

-- 
These opinions are my own and not necessarily those of Information Quest
or Pebble In The Sky                     http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry jgarry_at_nospameiq.com
"See your DBA?"  I AM the _at_#%*& DBA!     Remove nospam to reply.  Sorry.