Oracle Import Error - Field Length

Question

I'm running into errors when trying to import a table from a western character set into UTF character set. I know the problem is that some of the data "grows". F

For example:

ORA-02374: conversion error loading table "RESULT"
ORA-12899: value too large for column MATRIX_NAME (actual: 11, maximum: 10)
ORA-02372: data for row: MATRIX_NAME :

I know originally when the backup was done in the source database (which uses Western English character set), that column field length is defined as varchar(10), however when imported into target database (uses UTF character set), the data grows to length of 11.

Does Oracle have a way to automatically fix the field length (so it expands the field length automatically into 11), before it imports the data, so to ensure there is no truncating of the data. How to do it?

I'm using Oracle 11G.

it was defined as 10 bytes in source database, the target schema is empty. — rvpals
Ha, for some reason I thought this was for SQL*Loader, sorry. Are you using exp/imp or expdp/impdp? — Alex Poole

rvpals rvpals · Accepted Answer · 2015-02-19T19:24:44

0

votes

Yes. Oracle's built-in import / export tool can automatically handle size issues.

Oracle Import Error - Field Length

1 Answers