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 -> Why do objects become invalid?

Why do objects become invalid?

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: Wed, 16 Sep 1998 02:03:10 GMT
Message-ID: <36081a34.7145388@news.twsc.pouchen.com.tw>


Hello,
I want to ask a question,
When I connect as system/mamanger and
SELECT * FROM ALL_OBJECTS WHERE STATUS = 'INVALID'; I can find some objetcs like procedures,triggers,views become INVALID. And if I recompile the scripts,the objects' STATUS become VALID. But I don't know why?
'Cause I don't alter the objects,but they become INVALID. Please give me more information about this. Please Cc to : violin.hsiao_at_mail.pouchen.com.tw,Thank you :-) Received on Tue Sep 15 1998 - 21:03:10 CDT

Original text of this message

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