Re: Why Oracle does not allow rollback of DDL statements?
Date: Wed, 12 Nov 2008 11:38:22 -0800
> Dbms_redef appears only for redefining tables. Its purpose is on-line
> redefinition of tables. It has too much overhead: requires lots of
> additional storage depending on size of your tables.
Incorrect. Look at the demo in Morgan's Library. You can change constraints, triggers, etc.
> I doubt Oracle will provide transaction based ddl because of its
> architecture and all exiting base of code; however, this does not mean
> that this feature is not useful.
A bottle of scotch can be useful. But I generally don't carry one with me while driving a car. I would make the same argument with respect to production databases. It might be nice to have in dev but anyone using it in test or prod should be shown the door.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Nov 12 2008 - 13:38:22 CST