Trigger valid/invalid

[realabhijeet4u]

If status of any trigger is invalid, then what does that mean and how can I make that valid. Please guide. Thanks upfront.

[debasisdas]

A trigger becomes invalid if the base object (ex..table) becomes invalid or altered. and the trigger refers to the affected column.

Recompile the trigger to validate it.

u can get the code of the trigger from the following query
select TRIGGER_BODY from USER_TRIGGERS where TRIGGER_NAME ='NAME'