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

sybrandb@xxxxxxxxx wrote:
On Mon, 10 Nov 2008 07:24:58 -0500, Serge Rielau <srielau@xxxxxxxxxx>
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
.

Relevant Pages

  • Re: Informix Positive Post #2
    ... Serge Rielau ... DB2 Solutions Development ... IBM Toronto Lab ... They are backward in Canada? ...
    (comp.databases.informix)
  • Re: Does anyone read the e-mails from [mailto:db2@news.db2mag.com]
    ... Serge Rielau ... DB2 Solutions Development ... IBM Toronto Lab ... Funny, no one has mentioned this in anything in the mainstream press. ...
    (comp.databases.informix)
  • Re: getting the nearest number from a column
    ... There is a section on OLAP functions in the SQL Pocket Guide by Jonathan Gennick. ... Serge Rielau ... DB2 Solutions Development ... IBM Toronto Lab ...
    (comp.databases.oracle.server)
  • Re: Tampa Florida
    ... I can't afford a second mortgage ... Serge Rielau ... DB2 Solutions Development ... IBM Toronto Lab ...
    (comp.databases.informix)
  • Re: Informix in the press...
    ... My Windows uptime is so much shorter. ... Serge Rielau ... DB2 Solutions Development ... IBM Toronto Lab ...
    (comp.databases.informix)