r12.2

[Sri]

Hi Erman,

Please can you clarify what is NON-EXISTENT object_type


SQL> select object_name, object_type, edition_name from user_objects_ae where object_name ='PER_ALL_PEOPLE_F';
OBJECT_NAME           OBJECT_TYPE        EDITION_NAME
PER_ALL_PEOPLE_F SYNONYM               V_20170213_2045
PER_ALL_PEOPLE_F NON-EXISTENT      ORA$BASE
PER_ALL_PEOPLE_F NON-EXISTENT      V_20170213_0218

Thank you

[ErmanArslansOracleBlog]

It means, dropped.

Dropped objects appear with OBJECT_TYPE = NON-EXISTENT.

[Sri]

Erman,

Thanks for your quick update.Are these objects that dropped when we run cleanup phase?

[ErmanArslansOracleBlog]

Yes it seems so..

Here is the reference from Oracle Support:

STANDARD cleanup performs removal of obsolete crossedition triggers and seed data, drops (removes) obsolete editioned code objects.