Upgrade To Apex 22.2 On A 4k Block_size 19c Database Fails With Sql Errors
(Doc ID 3026308.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.
Goal
On : 19.14.2.0.0 version, RDBMS
Upgrade to Apex 22.2 on a 4k block_size 19c database fails with sql errors
When upgrading Apex to version 22.2 on a 4k block_size 19c database the installation fails with sql errors.
Doc ID 2808568.1, he nls_length_semantics is set to byte. Is there another fix/workaround without recreating the database in 8k or higher block size?
ORA-20001: Install errors found in phase 1, see "not ok" messages above for details.
ORA-06512: at "APEX_220200.WWV_INSTALL_API", line 467
ORA-06512: at line 5
# Message: ORA-01450: maximum key length (3117) exceeded
# Statement: create index wwv_task_def_due_ix on wwv_flow_task_defs(due_on_interval, expiration_policy) compress
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |