Path: utzoo!attcan!uunet!bu.edu!att!att!drutx!druco!mdeltoro
From: mdeltoro@druco.ATT.COM (DeltoroMA)
Newsgroups: comp.databases
Subject: Re: Rollback in ORACLE
Message-ID: <7167@drutx.ATT.COM>
Date: 11 Jan 91 15:37:00 GMT
References: <1991Jan10.160300.8839@cs.umn.edu>
Sender: news@drutx.ATT.COM
Reply-To: mdeltoro@druco.ATT.COM (DeltoroMA)
Organization: AT&T, Denver, CO
Lines: 22

in article <1991Jan10.160300.8839@cs.umn.edu>, peng@cs.umn.edu (Lim Ee Peng) says:
> 
> 
> 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.
> 
> I attached a script below to demonstrate my point.
> Can someone who knows Oracle well explain to me why does the rollback
> work this way?

ORACLE's rollback command does not work with DDL statements (e.g. create
or alter table, etc.).  This command only works with DML statements (e.g.
update, delete, etc.).


--
**********************************************************************
Michael 'DT' Del Toro                        303-538-1764
AT+T Bell Labs, 120th + Huron, Denver, CO
mdeltoro@druco.ATT.COM