ORA-12899 value too large for column, when executing dbms_redefinition
Hello to all,
We must partition some tables in a 12.1 Oracle Database using package DBMS_REDEFINITION, and we are facing following errors when executing “dbms_redefinition.start_redef” for table “TEXTOSFACTURAS”. Table "TEXTOSFACTURAS_RDF " is the interim table.
BEGIN
DBMS_REDEFINITION.START_REDEF_TABLE('BDD_GFP', 'TEXTOSFACTURAS','TEXTOSFACTURAS_RDF');
END;
/
ORA-12008: error in materialized view refresh path ;
ORA-12899: value too large for column "BDD_GFP"."TEXTOSFACTURAS_RDF"."TEXTO" (real: 731, max : 700)
ORA-06512: at "SYS.DBMS_REDEFINITION", line 75
ORA-06512: at "SYS.DBMS_REDEFINITION", line 3554
ORA-06512: at line 2
Both the type of the interim table column “TEXTO” and the original is the same: varchar2(700).