Path: utzoo!censor!geac!torsqnt!lethe!yunexus!ists!helios.physics.utoronto.ca!news-server.csri.toronto.edu!bonnie.concordia.ca!thunder.mcrcim.mcgill.edu!snorkelwacker.mit.edu!tut.cis.ohio-state.edu!ucbvax!agate!shelby!msi.umn.edu!cs.umn.edu!peng
From: peng@cs.umn.edu (Lim Ee Peng)
Newsgroups: comp.databases
Subject: Rollback in ORACLE
Message-ID: <1991Jan10.160300.8839@cs.umn.edu>
Date: 10 Jan 91 16:03:00 GMT
Organization: University of Minnesota, Minneapolis, CSci dept.
Lines: 37


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?

Thanks.

peng
(I can be reached by email : peng@umn-cs.cs.umn.edu)

--------------------------------------------------------------- 
SQL*Plus: Version 2.1.11 - Production on Thu Jan 10 09:55:25 1991

Copyright (c) 1986, Oracle Corporation, California, USA.  All rights reserved.

Enter user-name: system
Enter password: 
Connected to: ORACLE V5.1.22.3 - Production


SQL> create table temp(attrib char(10));

Table created.

SQL> rollback;
rollback complete
SQL> select * from temp;

no records selected

SQL> quit
Disconnected from ORACLE V5.1.22.3 - Production