Shulou(Shulou.com)06/01 Report--

Editor to share with you how to find invalid objects in Oracle, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Find invalid objects that you depend on:

Select do.obj# d_obj,do.name d_name, do.type# d_type, po.obj# p_obj

Po.name pairname HH24:MI:SS' toddchar (pendant timestamp, DDMY HH24:MI:SS') "P_Timestamp"

To_char (po.stime, 'DD-MON-YYYY HH24:MI:SS') "STIME"

Decode (sign (po.stime-p_timestamp), 0meme, Samuel, and diff.) X

From sys.obj$ do, sys.dependency$ d, sys.obj$ po

Where P_OBJ#=po.obj# (+) and D_OBJ#=do.obj#

And do.status=1

And po.status=1

And po. stimeted timestamp

Order by 2,1

The above is all the contents of the article "how to find invalid dependent objects in Oracle". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.