Skip to Main Content

Oracle Database Express Edition (XE)

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!

Random Invalid objects

User_KA3ECJan 15 2020 — edited Jan 22 2020

     Hi All,

All of sudden we have many db objects become invalid and our DBA have to recompile them to avoid consequences.

Can we know what are all conditions can cause the DB objects invalid.

We were not applying or applied any patch  or we have not modified any code.

There is no configuration updates and there is no data fixes running at the time of issue occurrence.

We are trying to identify  what caused the DB objects Invalid.

Any guidance or help is much appreciated.

Thanks,

Asaraf.

Comments
Post Details
Added on Jan 15 2020
6 comments
347 views