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>
>
> You think it is normal to change the DDL of a running production
> system?
>
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