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>
>
> 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.
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 LabReceived on Mon Nov 10 2008 - 13:27:43 CST