APEX Upgrade to 23 Version on DB with Block Size of 4K Fails With ORA-01450
(Doc ID 2987919.1)
Last updated on NOVEMBER 17, 2023
Applies to:
Oracle Application Express (APEX) - Version 23.1 and laterInformation in this document applies to any platform.
Symptoms
While Upgrading to APEX 23 finding below errors
....
not ok 4 - Creating APEX Tables | 0,12
# Message: ORA-01450: maximum key length (3118) exceeded
# Statement: alter table wwv_flow_push_subscriptions$ add constraint wwv_flow_push_subscriptions_uk unique ( security_group_id, flow_id, user_name, subscription_interface
)
# 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
ok 5 - Installing Package Specs (Runtime)
....
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 |
| Cause |
| Solution |
| References |