Path: utzoo!attcan!uunet!unisoft!fai!sequent!dafuller
From: dafuller@sequent.UUCP (David Fuller)
Newsgroups: comp.databases
Subject: Re: Rollback in ORACLE
Message-ID: <50446@sequent.UUCP>
Date: 14 Jan 91 07:09:45 GMT
References: <1991Jan10.160300.8839@cs.umn.edu> <1991Jan10.234950.19957@inel.gov>
Reply-To: dafuller@sequent.UUCP (David Fuller)
Organization: Sequent Computer Systems, Inc
Lines: 23

In article <1991Jan10.234950.19957@inel.gov> cdm@gem-hy.Berkeley.EDU (Dale Cook) writes:
>In article <1991Jan10.160300.8839@cs.umn.edu>, peng@cs.umn.edu (Lim Ee
>Peng) writes:
>|> 
>|> I used Oracle Sqlplus recently and found out that the rollback command
>|> doesn't affect 'create table' operation at all.  All the while, I thought
>|> that 'create table' is simply an update to the system tables and rollback
>|> should also work.

The role of begin tx/commit is unspecified in the ANSI specifications and
so you can't rely on the effects of transactions to the schema.

This is too bad.  I'd always like to be able to roll back schema changes;
for example, Tandem's NonStop SQL handles pretty much any change to the
distributed schema as long as you observe the limits of the transaction
monitoring facility's ability to span long-lived transactions.

Dave
-- 
Dave Fuller				   
Sequent Computer Systems		  Think of this as the hyper-signature.
(708) 318-0050 (humans)			  It means all things to all people.
dafuller@sequent.com