Hi All.
Yesterday I got a dump from a Production Database which I have no access and it's not under my administration. This dump was delivered to me because it was necessary to update a development database with some new records of the tables from Production.
The Production Database has NLS_CHARACTERSET=WE8ISO8859P1 and the Development Database has NLS_CHARACTERSET=AL32UTF8 and it needs to be in this CHARSET because of the Application requirements.
While importing this dump, two tables got a problem with ORA-02374 and ORA-12899. The results were that six records got missed because of this conversion problem. I'm listing the errors below in this thread.
Reading the note ID 1922020.1 (Import And Insert With Issues ORA-12899: Value Too Large For Column) I could see that Oracle gives an alternative and a workaround which consists in creating a .sql file with the metadata contents and then modifying the columns that got the problem with the CHAR value, instead of BYTE. So, following the document I've done the workaround and generated a .sql file from this dump. Reading the file content after finishing the import I saw that the columns were already in this CHAR value.
Does anyone have another workaround for these cases? Because I can't change the CHARSET from the Production Database and the Development Database and it's not a good idea keep without these missing records.
Errors received importing the dump: (Both columns listed bellow are VARCHAR2(4000))
ORA-02374: conversion error loading table "PPM"."KNTA_SAVED_SEARCH_FILTERS"
ORA-12899: value too large for column FILTER_HIDDEN_VALUE (actual: 3929, maximum: 4000)
ORA-02372: data for row: FILTER_HIDDEN_VALUE : '5.93.44667.(NET.UNO) - BI NET.UNO - Ambiente Teste'
. . imported "PPM"."KNTA_SAVED_SEARCH_FILTERS" 5.492 MB 42221 out of 42225 rows
ORA-02374: conversion error loading table "PPM"."KDSH_DATA_SOURCES_NLS"
ORA-12899: value too large for column BASE_FROM_CLAUSE (actual: 3988, maximum: 4000)
ORA-02372: data for row: BASE_FROM_CLAUSE : 0X'46524F4D20706D5F70726F6A6563747320700A494E4E455220'
. . imported "PPM"."KDSH_DATA_SOURCES_NLS" 308.4 KB 229 out of 230 rows
Thanks a lot
Bruno Palma