Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: About rollback consumption
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 CHARPENAYReceived on Thu Sep 28 2000 - 07:15:43 CDT