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!

we have most of sys objects in database invalid

meirben1Dec 20 2016 — edited Dec 20 2016

alter type anydata compile;

ORA-04098: trigger 'EXFSYS.EXPFIL_RESTRICT_TYPEEVOLVE' is invalid and failed re-validation

alter trigger EXFSYS.EXPFIL_RESTRICT_TYPEEVOLVE compile;

ORA-24344: success with compilation error

ora-04098 : trigger 'EXFSYS.EXPFIL_RESTRICT_TYPEEVOLVE' is invalid PLS-00905: object SYS.EXF$DBMS_EXPFIL_SYSPACK is invalid

alter package exf$dbms_expfil_syspack compile;

ORA-04098: trigger 'EXFSYS.EXPFIL_RESTRICT_TYPEEVOLVE' is invalid and failed re-validation

This is a loop that we cannot resolve... each object is depending from the other an so on ...

Someone knows how to resolve this sutuation ?

thank you

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 17 2017
Added on Dec 20 2016
6 comments
617 views