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 -> Adding fields with default on tables with invalid triggers

Adding fields with default on tables with invalid triggers

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: 19 Jan 2000 15:45:06 GMT
Message-ID: <01bf6294$135c9660$2c289a0a@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 - 09:45:06 CST












Original text of this message













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