fixing data dictionary corruption

[Sri]

Dear erman,

Could you plz let us know what do they mean by 'Missing Parent'

SQL> @adzddmpfix.sql

"---- Fixing Data Dictionary Corruptions (missing parent) ----"
12 rows deleted.
Commit complete.
System altered.
"---- Compiling invalids ----"
PL/SQL procedure successfully completed.
Commit complete

Thank you

[ErmanArslansOracleBlog]

You know what Parent-Child relationship in computer science , right?
This is the same. This is about a logical thing. A logical corruption.
It is about Parent Child relationship , a dependency, an integrity.
It is probably related with the referential integrity, as it is often thought like parent/child table relationships.

That script is probably looking for the records in the data dictionary tables for the parentless children, or orphans.

So it should be checking the records in the data dictionary tables by considering the parent-child relationship that needs to be present between them. And it seems, if it finds a child record without having a related parent record, it deletes that child record as well.
Bytheway, I m writing this without ever looking at the sql code .So, I need to check the sql to be sure. You can check it yourself as well.