When running @apexins.sql on freshly created PDB I see error:
Timing command is obsolete.
# Inherit Privileges
Timing command is obsolete.
...apxsqler_exit.sql
Errors found. Drop APEX_220100 before re-starting the installation.
# Actions in Phase 1:
ok 1 - BEGIN | 0.00
ok 2 - Creating APEX_GRANTS_FOR_NEW_USERS_ROLE | 0.00
ok 3 - Creating SYS Objects | 0.02
not ok 4 - Creating APEX Tables | 0.22
Message: ORA-01735: invalid ALTER TABLE option
Statement: alter table wwv_flow_task_def_actions add constraint wwv_task_def_act_uk unique (task_def_id, name) using index compress 2
alter table wwv_flow_task_def_actions add constraint wwv_task_def_act_ws_mod_ck
check ( web_src_module_id is null or web_src_operation_id is null )
ok 5 - Installing Package Specs (Runtime) | 0.42
ok 6 - Installing Package Bodies (Runtime) | 0.27
ok 7 - Dev Grants | 0.00
This is stopping the whole installation for me (on DB 19c)
Looks like it is caused by core/tab.sql alter table (line 16512):
alter table wwv_flow_task_def_actions add constraint wwv_task_def_act_uk unique (task_def_id, name) using index compress 2
This is the fix IMVHO (but might wrong) in formof diff patch:
--- core/tab.sql 2022-05-08 14:01:26.894854550 +0000
+++ core/tab.sql 2022-05-08 14:01:47.637864851 +0000
@@ -16509,8 +16509,8 @@
)
lob (action_clob) store as (cache reads enable storage in row)
/
-alter table wwv_flow_task_def_actions add constraint wwv_task_def_act_uk unique (task_def_id, name) using index compress 2
-
+alter table wwv_flow_task_def_actions add constraint wwv_task_def_act_uk unique (task_def_id, name) using index compress
+/
alter table wwv_flow_task_def_actions add constraint wwv_task_def_act_ws_mod_ck
check ( web_src_module_id is null or web_src_operation_id is null )
/