Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

invalid objects

user8838095Feb 19 2020 — edited Feb 20 2020

Hello,

DB - 12.1.0.2.0

OS - Oracle Linux Server 6.10

One of the Oracle Database assign to me for audit purpose, i don't have the history of the database. Where given the task by management.

Find out the Invalid objects  ? I can find the query

What is the reason for the Invalid objects ?

How to make those objects Valid ? I can take care

How much time it will take to compile the objects ?

What are the challenges we can face during the change window while recompile the INVALID objects ?

Thank You.

Comments
Post Details
Added on Feb 19 2020
6 comments
1,108 views