Hi,
This is the first time we have to run adop phase=actualize_all.
After running it and also adop phase=cleanup we have 2 old invalid views. (from the pre 12.2 migration)
select OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME from dba_objects where EDITION_NAME = 'ORA$BASE'
OWNER OBJECT_NAME OBJECT_TYPE CREATED LAST_DDL_TIME
----- ----------------------- ----------- ----------------- -----------------
OE OC_CUSTOMERS VIEW 10-8-2017 3:21 PM 10-8-2021 4:05 AM
OE OC_CORPORATE_CUSTOMERS VIEW 10-8-2017 3:21 PM 10-8-2021 4:05 AM
If I try to recreate with FORCE EDITIONABLE or simply try to drop them I have lock.
ORA-04020: deadlock detected while trying to lock object 30x70001005F7094800x7000100893048D00x70001009C7E13A0
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.
I cannot simply ignore those objects because at every FORM I launch it uses a trigger refering to those views.
@$AD_TOP/sql/ADZDSHOWOBJS.sql
=========================================================================
= Editioned Objects Per Edition
=========================================================================
EDITION_NAME A_VALID A_INVALID A_TOTAL S_VALID S_INVALID S_TOTAL TOTAL
--------------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
ORA$BASE 4 2 6 0 0 0 6
V_20211009_1611 0 0 0 0 2 2 2
V_20211010_2201 0 0 0 0 2 2 2
V_20211129_1301 0 0 0 0 2 2 2
V_20211130_1123 0 0 0 0 2 2 2
V_20211214_1704 0 0 0 0 2 2 2
V_20211217_1226 0 0 0 0 2 2 2
V_20220128_0813 0 0 0 0 2 2 2
V_20220325_0922 0 0 0 0 2 2 2
V_20220422_0802 0 0 0 0 2 2 2
V_20220527_0735 0 0 0 0 2 2 2
V_20221201_2054 0 0 0 0 2 2 2
V_20221219_0931 0 0 0 0 2 2 2
V_20230202_1118 0 0 0 0 2 2 2
V_20230421_1043 0 0 0 0 2 2 2
V_20230512_0917 0 0 0 0 2 2 2
V_20230609_0933 0 0 0 0 2 2 2
V_20230611_1905 0 0 0 0 2 2 2
V_20230920_0942 0 0 0 0 2 2 2
V_20230921_0736 0 0 0 0 2 2 2
V_20230922_1043 0 0 0 0 2 2 2
V_20230926_0853 310136 2 310138 0 2 2 310140
Note :
(A_) - Actual Objects
(S_) - Stub Objects