Unable to restore Database: ORA 12889
471233Feb 14 2006 — edited Feb 15 2006Hi there!,
This is Aleksander Stukov from Spain. Im having lots of problems when trying to import any backup from BETA 1. I guess is something wrong with NLS_LANG parameter or anything about some other languaje parameters.
Here are the errors:
IMP-00019: fila rechazada debido al error ORACLE 12899 -- Original
IMP-00019: row rejected due to ORACLE error -- English
IMP-00003: se ha encontrado un error 12899 de ORACLE -- Original
IMP-00003: ORACLE error 12899 encountered-- English
ORA-12899: el valor es demasiado grande para la columna-- Original
ORA-12899: value too large for column string (actual: string, maximum: string).-- English
Its pretty obvious whats going on. I've some special characters in some field which is VARCHAR2(40). In the original database (BETA 1) the field was filled up to 40 chars and some were special ones. Now, when trying to import database its happening a char conversion and field grows up to (at least ) 41 chars. That's why some rows are imported (those which 39 chars or less) and some not.
I've been surfing deep on forums but haven't find anything yet. ¿Any ideas?. NLS_LANG at Windows registry is set to default value and I've check with another 10g Database server, and it has the same value.
Thanks a lot!!!,
A. Stukov.