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!

nls_length_semantics problem

fehersJun 26 2006 — edited Jun 27 2006
Hi,

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>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2006
Added on Jun 26 2006
2 comments
324 views