Re: ALTER TABLE ? ?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 06 Dec 2004 19:01:19 -0800
Message-ID: <1102388376.85651@yasure>

nroberts_at_ci.charlotte.nc.us wrote:
> HI All, I am wondering if the ALTER TABLE ddl will impact any triggers,
> etc... if I am only using it to increase field lengths in a few of my
> tables? I am not aware of any impact here - but am interested in your
> opinion! THanks much! PS - please no email / old address, I will check
> posts instead. thx

SQL> select status from user_objects

   2 where object_type = 'TRIGGER';

STATUS

---

VALID SQL> alter table t add (datecol date);

Table altered.

SQL> select status from user_objects

   2 where object_type = 'TRIGGER';

STATUS

---

INVALID SQL> That is one impact you should expect.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Mon Dec 06 2004 - 21:01:19 CST