How to force move or force delete or recreate an object that won't move from an old db edition ?
Oracle EBS 12.2.10
Database 19.14
We have those 2 trailing objects(views) stuck in the ORA$BASE edition (OC_CUSTOMERS,OC_CORPORATE_CUSTOMERS)
When trying to CREATE OR REPLACE FORCE EDITIONABLE VIEW....
ORA-04020: deadlock detected while trying to lock object 30x700010076C5C0580x700010076563C200x70001009C686CF8
ORA-21700: l'objet n'existe pas ou va être supprimé
04020. 00000 - "deadlock detected while trying to lock object %s%s%s%s%s"
*Cause: While trying to lock a library object, a deadlock is detected.
*Action: Retry the operation later.
==============================================
= Editioned Objects Per Edition
==============================================
EDITION_NAME A_VALID A_INVALID A_TOTAL S_VALID S_INVALID S_TOTAL TOTAL