PL/SQL (MOSC)

MOSC Banner

ORA-12899 value too large for column, when executing dbms_redefinition

edited Feb 8, 2019 4:00AM in PL/SQL (MOSC) 6 commentsAnswered

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).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center