Dbms_aqadm.move_queue_table fails with ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 3072362.1)

Last updated on FEBRUARY 27, 2025

Applies to:

Symptoms

BEGIN
  dbms_aqadm.move_queue_table(
  queue_table => 'QT_QUEUETABLE',
  to_tablespace => '<tablespace_name>');
END;
Error report -
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 18964
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 19120
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 18913
ORA-06512: at "SYS.DBMS_AQADM", line 2242
ORA-06512: at line 2
06502. 00000 - "PL/SQL: numeric or value error%s"

Changes

Cause

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