Forum Stats

  • 3,826,361 Users
  • 2,260,636 Discussions
  • 7,896,916 Comments

Discussions

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

Andrzej Pauli-Oracle
Andrzej Pauli-Oracle Member Posts: 4 Employee
edited May 8, 2022 4:42PM in APEX Discussions

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