DBMS_REDEFINITION.REDEF_TABLE Error ORA-23514: Invalid or Incorrect Number of Arguments (Doc ID 1901074.1)

Last updated on AUGUST 23, 2021

Applies to:

Symptoms

 >> Executions of the Oracle 12c DBMS_REDEFINITION.REDEF_TABLE procedure are not behaving as expected:
>> From the documentation it appears all but the first two parameters are default, yet calling it with only two parameters fails:

BEGIN
 DBMS_REDEFINITION.REDEF_TABLE(
   uname                        => 'XXX',
   tname                        => 'TEST'
 );
END;
/
BEGIN
*
ERROR at line 1:
ORA-23514: invalid or incorrect number of arguments
ORA-06512: at "SYS.DBMS_REDEFINITION", line 2525
ORA-06512: at line 2

>> Calling it with a third parameter works (ignoring my other ORA-32422 issue), at least it parses.

BEGIN
 DBMS_REDEFINITION.REDEF_TABLE(
   uname                        => 'XXX',
   tname                        => 'TEST',
   lob_store_as                 => 'xx'
 );
END;
/
BEGIN
*
ERROR at line 1:
ORA-32422: commit SCN-based materialized view log cannot be created on table
"XXX"."TEST" when there exist direct load/PMOP log entries for the
table
ORA-06512: at "SYS.DBMS_REDEFINITION", line 2525
ORA-06512: at line 2

>> Calling it with the same third parameter, with a NULL string value fails again.

BEGIN
 DBMS_REDEFINITION.REDEF_TABLE(
   uname                        => 'XXX',
   tname                        => 'TEST',
   lob_store_as                 => ''
 );
END;
/
BEGIN
*
ERROR at line 1:
ORA-23514: invalid or incorrect number of arguments
ORA-06512: at "SYS.DBMS_REDEFINITION", line 2525
ORA-06512: at line 2

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.