nls_length_semantics problem
fehersJun 26 2006 — edited Jun 27 2006Hi,
I have an issue with importing some data from a 9.2.0.1 to 10g XE.
However I set nls_length_semantics to char it complains for the character fields' size:
IMP-00019: row rejected due to ORACLE error 12899
thanks a lot ., Sandor
Here are my settings:
declare -x NLS_LANG="HUNGARIAN_HUNGARY.EE8ISO8859P2"
declare -x ORACLE_HOME="/usr/lib/oracle/xe/app/oracle/product/10.2.0/server"
declare -x ORACLE_SID="xe"
SQL> show parameter nls
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_calendar string
nls_comp string
nls_currency string
nls_date_format string
nls_date_language string
nls_dual_currency string
nls_iso_currency string
nls_language string AMERICAN
nls_length_semantics string CHAR
nls_nchar_conv_excp string FALSE
nls_numeric_characters string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_sort string
nls_territory string AMERICA
nls_time_format string
nls_timestamp_format string
nls_timestamp_tz_format string
nls_time_tz_format string
SQL>