Re: Why Oracle does not allow rollback of DDL statements?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: 10 Nov 2008 13:10:14 +0100
Message-ID: <491824a6$1@news.x-privat.org>
Date: 10 Nov 2008 13:10:14 +0100
Message-ID: <491824a6$1@news.x-privat.org>
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 http://mgogala.freehostia.comReceived on Mon Nov 10 2008 - 06:10:14 CST