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

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Mon, 10 Nov 2008 14:27:43 -0500
Message-ID: <6nrg9gFhvlbU1@mid.individual.net>

sybrandb_at_hccnet.nl wrote:
> 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?

Define normal.... Its done to us and our customers are expecting us to do more and more while queries are in flight. E.g. replace a view while a warehousing query on it is executing.

Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Received on Mon Nov 10 2008 - 13:27:43 CST