My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.