Re: Oracle transactions and DDL statements.

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 10 May 2006 13:50:34 -0700
Message-ID: <1147294234.523467@bubbleator.drizzle.com>

peter.koch.larsen_at_gmail.com wrote:
> DA Morgan skrev:
>

>> peter.koch.larsen_at_gmail.com wrote:
>>> Sybrand Bakker skrev:
>>>
>>>> On 9 May 2006 14:09:39 -0700, peter.koch.larsen_at_gmail.com wrote:
>>>>
>>>>> Right. But thus time it is not a feature, but a limitation that is not
>>>>> as i see it is not in any way based on some requirement for logical
>>>>> consistency - more like the opposite if anything.
>>>> It rather seems you have a basic lack of understanding of relational
>>>> and transactional concepts. You probably would better stick to your
>>>> Mickey Mouse products.
>>> Excuse me, but this is simply false. If you simply must come with
>>> personal attacks instead of giving evidence to support your cause you
>>> really should reserve that "Mickey Mouse" adjective to describe your
>>> own mindset.
>>>
>>> /Peter
>>>
>>>
>>>> --
>>>> Sybrand Bakker, Senior Oracle DBA
>> Actually Peter my instinct here is to agree with Sybrand. Everything
>> you've written flies in the face of good practice in an Oracle database.

>
> If I were to develop a new application, naturally I would take the
> idiosyncracies of the target platform into consideration.. Instead I am
> porting an existing one that runs on a wide range of platforms -
> including several databases of which I've already mentioned a few.
> This should be evident had you read the first post on this thread.
>
> /Peter

It is evident. It should be evident to you from my response and those of others that have be involved in this thread that we are all consider your products design, at least as you have presented it, as far from being best practice. And, further, that Oracle will not change its concepts and architecture to make what you are trying to do work as you seemingly wish.

If you want to work with Oracle. And you want to engage in best practices rather than using duct tape you will need to re-examine the underlying design decisions.

-- 
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

Received on Wed May 10 2006 - 15:50:34 CDT