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: Chris Leonard <s_p_a_m_chris_at_hotmail.com>
Date: Tue, 7 Dec 2004 17:18:18 -0600
Message-ID: <_Sqtd.29$2z1.11637@news.uswest.net>


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.

-- 
Cheers,
Chris

___________________________________

Chris Leonard, The Database Guy
http://www.databaseguy.com

Brainbench MVP for Oracle Admin
http://www.brainbench.com

MCSE, MCDBA, OCP, CIW
___________________________________

<nroberts_at_ci.charlotte.nc.us> wrote in message 
news:1102359272.711982.295650_at_f14g2000cwb.googlegroups.com...

> 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
>
Received on Tue Dec 07 2004 - 17:18:18 CST

Original text of this message

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