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

Last updated on JULY 20, 2024

Applies to:

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

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