Can you rollback a table creation?
From: Jim Egerton Digital-PCS GmbH <egerton_at_pcs.dec.com>
Date: Thu, 7 Apr 1994 03:51:42 GMT
Message-ID: <1994Apr7.035142.7242_at_janix.pcs.dec.com>
Date: Thu, 7 Apr 1994 03:51:42 GMT
Message-ID: <1994Apr7.035142.7242_at_janix.pcs.dec.com>
any help appreciated,
jim
$ sqldba
SQL*DBA: Release 7.0.12.0.0 - Production on Thu Apr 7 06:14:28 1994
Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
ORACLE7 Server Release 7.0.12.0.0 - Production
SQLDBA> connect /;
Connected.
SQLDBA> create table test (name char(10));
Statement processed.
SQLDBA> rollback;
Statement processed.
SQLDBA> create table test (name char(10));
create table test (name char(10))
*
ORA-00955: name is already used by an existing object
Received on Thu Apr 07 1994 - 05:51:42 CEST