Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle APEX 22.1 installer - @apexins.sql error inside core/tab.sql

Andrzej Pauli-OracleMay 8 2022 — edited May 8 2022

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 )
/

Comments
Post Details
Added on May 8 2022
7 comments
469 views