My Oracle Support Banner

After Upgrade To 19c Online Index Rebuild throws ORA-01450 (Doc ID 2769650.1)

Last updated on APRIL 30, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.7.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 19.7.0.0.0 version, RDBMS

After upgrade to 19c online index rebuild throwing ORA-01450 error message.

create table test(id number(19), val1 varchar2(801 CHAR));
declare
  l_val varchar2(801 CHAR);
begin
  for i in 1..801 loop
  l_val := l_val || 'ю';
  end loop;
  insert into test(id, val1) values (1, l_val);
  commit;
end;
/
create unique index ui_test_val1 on test(val1) online;
alter index ui_test_val1 rebuild online;
 
env 1
Oracle ver. 12.2.0.1.0
MAX_STRING_SIZE = STANDARD
NLS_CHARACTERSET = AL32UTF8
db_block_size = 8192

Index Create / Rebuild Command Execution: Success


 
env 2
Oracle ver. 12.2.0.1.0
MAX_STRING_SIZE = EXTENDED
NLS_CHARACTERSET = AL32UTF8
db_block_size = 8192

Index Create / Rebuild Command Execution: Success

 
env 3
Oracle ver. 19.7.0.0.0
MAX_STRING_SIZE = STANDARD
NLS_CHARACTERSET = AL32UTF8
db_block_size = 8192

Create / rebuild index command execution: error ORA-00604: error occurred at recursive SQL level 1
ORA-01450: maximum key length (3215) exceeded
 
env 4
Oracle ver. 19.6.0.0.0
MAX_STRING_SIZE = EXTENDED
NLS_CHARACTERSET = AL32UTF8
db_block_size = 8192
Create / rebuild index command execution: error ORA-00604: error occurred at recursive SQL level 1
ORA-01450: maximum key length (3215) exceeded
 

ERROR
-----------------------
ORA-01450


Changes

 Upgraded the database to 19c from 12c version

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


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