ORA-12899: value too large for column ColumnName

Error  :

. . imported "DatabaseName"."TableName"                   171.3 KB    5789 rows
ORA-02374: conversion error loading table "DatabaseName"."TableName"
ORA-12899: value too large for column ColumnName (actual: 31, maximum: 30)
ORA-02372: data for row: ColumnName : 0X'5467ASH567UJGFRT4VXH567HFGHK5EWHD57GQ5'

You are trying to restore the database with IMPDP command, sometimes you will receive the error in logs, ORA-12899: value too large for column Column Name

If you faced this error too, then solve as below:

1. Check the table name and column name from the logs, for which this error occur
2. After restore complete alter the table and increase the size of column (using alter command)
3. Again execute the IMPDP command for specific table only and include the below 3 parameter in your IMPDP command

Use below 3 parameter in your IMPDP command, see below parameter and description

• remap_Table - Specify which table need to map with existing table
• tables - Specify, which particular table need to restore
• table_exists_action - Specify, what should be the action if table already exists, these are of 4 type  {SKIP | APPEND | TRUNCATE | REPLACE}, for more information you can read official website

use below parameter along with the usage, see below:

• remap_Table = OldTableName_InBackup:NewdatabasetableName
• tables = TypeYourTableNameHere
• table_exists_action=Truncate

See full IMPDP command here (Click Here)