Re: Huge undotbs during insert

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 29 May 2005 18:43:38 -0700
Message-ID: <1117391983.733638@yasure>

tim.kearsley_at_milton-keynes.gov.uk wrote:

>>COPY is a dead ally, as it is going to be desupported.
>>
>>
>>--
>>Sybrand Bakker, Senior Oracle DBA

>
>
> Indeed it is. But so what? It works with the release the OP is using
> and it may do the job he requires, so who cares really?
>
> Regards,
> Tim Kearsley
> HBS Milton Keynes

But So what you ask? I can think of quite a few so what's.

Did you use dictionary managed tablespaces in 9i?
Did you use rollback segments in 9i?
Are you still creating tables with LONG and LONG RAW?

The point here is that as soon as Oracle announces deprecation of functionality all new work should use the newly recommended methodology. Not doing so is a violation of your fiduciary responsiblity and professional ethics. Basically what it is saying is that your personal convenience at a point-in-time is more important than your employer's need to have a system that is upgradable and maintainable.

The only way a developer or DBA should make that decision ... is if the license cost of the Oracle software came directly out of that developer or DBA's paycheck.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Sun May 29 2005 - 20:43:38 CDT