Re: Why Oracle does not allow rollback of DDL statements?

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Tue, 11 Nov 2008 14:07:33 +0100
Message-ID: <49198397$0$187$e4fe514c@news.xs4all.nl>


sybrandb_at_hccnet.nl schreef:
> On Mon, 10 Nov 2008 07:24:58 -0500, Serge Rielau <srielau_at_ca.ibm.com>
> wrote:
>

>> OK, let's walk through a simple example.
>> Assume a table with a column c1 and a view on that table.
>> CREATE TABLE T(c1 NUMBER);
>> CREATE OR REPLACE VIEW V AS SELECT c1 AS X FROM T;

>
> You think it is normal to change the DDL of a running production
> system?
>

You don't CHANGE DDL. You USE it to change definitions.

Shakespeare Received on Tue Nov 11 2008 - 07:07:33 CST

Original text of this message