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 11.2.0.4.0

Solution:

Need to install the Oracle Client 11.2.0.4 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
    .

Solution:

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
WHERE
name = ‘max_string_size’;

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

Successfully Altered.


You may also like...