Issues and Resolutions – AWS RDS Oracle DB

Issues and Resolutions

Issues List

Issue 1: Oracle Client Installation Issues

UDI-00018: Data Pump client is incompatible with database version


Need to install the Oracle Client to Execute the Impdp Commands.

Issue 2: Value too large for column

  1. ORA-02374: conversion error loading table “<Schema_name>”.”<Table_name>”
    ORA-12899: value too large for column <COLUMNNAME> (actual: 4005, maximum: 4000)
    ORA-02372: data for row


You can’t alter the datatype in 11g more than the limit Varchar2(4000 BYTES)
Unless you use Oracle 12c, it’s not possible to store more than 4000 characters

By extending MAX_STRING_SIZE = EXTENDED parameter in Parameter_Group length issue can be resolved.

SELECT name, value FROM v$parameter
name = ‘max_string_size’;

ALTER TABLE “<Schema>”.”Table_Name>” MODIFY COLUMNNAME Varchar2(4006 bytes);

Successfully Altered.

You may also like...