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

From: Mladen Gogala <>
Date: 10 Nov 2008 13:10:14 +0100
Message-ID: <491824a6$>

On Mon, 10 Nov 2008 06:52:42 -0500, Serge Rielau wrote:

> Other RDBMS which do have transactional DDL can very well monitor their
> system, even explain a query on DDL that isn't committed so long as the
> one explaining is the session that did the DDL, just like their own
> modifications to regular data. The schema catalog is just another set of
> tables after all.

Hmmm, I am not sure that any Oracle DBA worth his salt would like to see that. As a DBA, I am frequently running explain plan on other sessions. What would be gained by transactional DDL? Why is it so significant?

Mladen Gogala
Received on Mon Nov 10 2008 - 06:10:14 CST

Original text of this message