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

Last updated on DECEMBER 06, 2016

Applies to:

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

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                        => 'BINGO_BIW',
   tname                        => 'ACCOUNTS'
 );
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                        => 'BINGO_BIW',
   tname                        => 'ACCOUNTS',
   lob_store_as                 => 'xx'
 );
END;
/
BEGIN
*
ERROR at line 1:
ORA-32422: commit SCN-based materialized view log cannot be created on table
"BINGO_BIW"."ACCOUNTS" 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                        => 'BINGO_BIW',
   tname                        => 'ACCOUNTS',
   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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms