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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Alter Table impact ? ?

Re: Alter Table impact ? ?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 07 Dec 2004 21:44:12 -0800
Message-ID: <1102484546.798203@yasure>


Chris Leonard wrote:
> If you are only changing the field length of some columns, AND if your
> triggers do not have code that is dependent on the field lengths you are
> changing, then you should be fine.

The trigger will still be marked invalid. That isn't necessarily a problem but it is one the OP should be aware of.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Tue Dec 07 2004 - 23:44:12 CST

Original text of this message

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