This looks logical since Oracle after creating the new column updates it
with the default value specified hence firing the trigger.
Peter Laursen < ptl_at_edbgruppen.dk> a écrit dans l'article
<01bf6294$135c9660$2c289a0a_at_apollo>...
> Hi
>
> Is this a bug or a feature?
>
> Oracle 8.0.5
> Alter table myTable add(a int default 1) fails if the table has an
invalid
> trigger (before insert or update for each row) .
> However if i explicitly compile the trigger first the alter table stmt
> completes.
>
> thanks
> Peter
>
Received on Wed Jan 19 2000 - 11:23:52 CST
