is it true that whenever u perform alter table...u invalid table -elated procedure?
hi,
I have got someone telling me that whenever we perform any Alter Table.....it is effectively invalidating all procedures related to that table? is this TRUE? as I dont wish to run the risk/trouble so I hope anyone can help to clarify here?
thanks in advance :)
rgds,
nick
Re: is it true that whenever u perform alter table...u invalid table -elated procedure?
Quote:
Originally posted by ngwh
hi,
I have got someone telling me that whenever we perform any Alter Table.....it is effectively invalidating all procedures related to that table? is this TRUE?
No, not quite. Only some of the ALTER TABLE comands (basicaly only those which change the table's "visible" structure) indeed cause dependant procedures to be invalidated, but there are many ALTER TABLE clauses that actually have no effect on related procedures..