Help with ROLLBACKS on DDL

• Quoting Steve - Schow to All dated 09-16-94 ***
  > I am tryiing to use ROLLBACK transaction processing to automatically
  > ROLLBACK create view transactions(which are DDL). However ORACLE by default >
  does an implicit commit before and after all DDL
  > statements(wonderful!)...so.....
  > How can turn that off while creating a particular view so that I can
  > decide to rollback to BEFORE the create view if I want to?
  

You cannot.

However, I cannot think of ANY good reason why somebody would want to, either. Received on Mon Sep 19 1994 - 16:09:04 CEST