Re: Can you rollback a table creation?

From: Kari Pannila <pannika1_at_news.ougf.fi>
Date: 7 Apr 1994 13:55:51 +0300
Message-ID: <2o0ornINN2kt_at_news.ougf.fi>


Jim Egerton Digital-PCS GmbH (egerton_at_pcs.dec.com) wrote:

: Is it possible to rollback the creation of a table?
: The attached seems to indicate that you can't; what am I doing wrong?

  No, you can not: CREATE TABLE is a DDL statement (Data Definition Language) and after and before every DDL statements Oracle issues an implicit COMMIT.

 You can instead use DROP TABLE...

---Kari

-- 
 /*  Kari Pannila                                                   *
  *  Leppavaaran kartano, SF-02620 Espoo, Finland , puh: 90-5092583 *
  *                                                                 */
Received on Thu Apr 07 1994 - 12:55:51 CEST

Original text of this message