Import Error
All,
I run an import and get
IMP-00058: ORACLE error 1461 encountered
ORA-01461: can bind a LONG value only for insert into a LONG column
IMP-00028: partial import of previous table rolled back: 40443 rows rolled back
The export client is oracle 8i and import client is 11g.
I know I could set NLS_LANG but I tried and it doesn't work yet.
===the 8i exporting database--
SQL> select * from nls_database_parameters where parameter = 'NLS_CHARACTERSET';
PARAMETER VALUE
---------------------- -------- ----------------------------NLS_CHARACTERSET US7ASCII
========the 11g importing database===
PARAMETER VALUE
--------------------- ---------------------
NLS_CHARACTERSET AL32UTF8
here is my NLS_LANG setting before running the import which failed..
set NLS_LANG=AMERICAN_AMERICA.US7ASCII
export NLS_LANG
thanks...
Looking for the greatest evil in the world? Look in the mirror.