Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to restore Database: ORA 12889

471233Feb 14 2006 — edited Feb 15 2006
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 15 2006
Added on Feb 14 2006
4 comments
1,343 views