Error ORA-01467: Sort Key Too Long, While Upgrading APEX From 20.x to 21.1
(Doc ID 2793949.1)
Last updated on JULY 22, 2021
Applies to:
Oracle Application Express (APEX) - Version 20.1 and laterInformation in this document applies to any platform.
Symptoms
On: APEX 20.x version, Administration
When attempting to upgrade to APEX 21.1, the following error occurs.
ERROR
-----------------------
not ok 377 - Update Plug-In Settings of Applications | 0,00
# Message: ORA-01467: sort key too long
# Statement:
# merge
# into wwv_flow_plugin_settings dst
# --
# -- source query: select all component settings for native Plug-Ins
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On an APEX 20.x environment, start SQL Plus as SYS
2. Run APEX 21.1 installation script
3. Error message appears at end of installation process, and can be viewed in the installation log
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |