Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: About rollback consumption

Re: About rollback consumption

From: Pierre Charpenay <pcharpenay_at_unilog.fr>
Date: Thu, 28 Sep 2000 14:15:43 +0200
Message-ID: <39D3366F.18F1A5A4@unilog.fr>

spencer a écrit :
>
> ...
>
> but why is this important to you ?
>

For example, to add a new not null column in an existing table, you must :

- alter the table to add the new column,
- update all the occurrences of the table with a not null value,
- alter the table again to "not nulled" it

When the table is particularly big (say five millions rows), the update may not pass with a simple "update" order, so a PL/SQL can be necessary to commit transactions (so, you must 'manually' manage the integrity).

At the end, it will change the time needed to write an automat that must do these database modifications.

That's all !

-- 
 Pierre CHARPENAY
Received on Thu Sep 28 2000 - 07:15:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US