ORA-01461: can bind a LONG value only for insert into a LONG column [message #295851] |
Wed, 23 January 2008 14:08 |
caprikar
Messages: 226 Registered: March 2007
|
Senior Member |
|
|
Hi,
I took export dump from our production database from table
GLOBE_TAX:
TAX_ID NOT NULL NUMBER(6)
GN_TYPE_ID NOT NULL NUMBER(10)
TAX_GN_TEXT CLOB
T_NAME VARCHAR2(60)
TAX_GN_ID NOT NULL NUMBER(15)
CT_DATE DATE
CT_USER_ID VARCHAR2(30)
UP_DATE DATE
UP_USER_ID VARCHAR2(30)
and while trying to import into QA database i get the following error:
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: 202 rows rolled back
-can anyone tell me what could be the problem?
Thanks,
GK
|
|
|
|
|
|
|
|