Re: Oracle transactions and DDL statements.

peter.koch.larsen_at_gmail.com wrote:
> But what if my transaction requires the creation or destruction of ten
> tables? This is what I wrote above, this is what the software does and
> this what caused it to fail: you can't abort it after having created
> the first five tables as those table alerady have been created.
>
> /Peter

In almost 20 years of Oracle development and DBA work I've NEVER seen a business requirement to create and destroy tables on-the-fly.

If you are trying to duplicate SQL Server in Oracle you are sowing the seeds of your own destruction. You need to pick up a copy of Tom Kyte's "Expert one-on-one Oracle" and read it.

What I see is the forced implementation of an architecture that is at odds with best practice. What is the business requirement as opposed to your proposed solution.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org