Home » RDBMS Server » Server Utilities » ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-01461: can bind a LONG value only for insert into a LONG column [message #295851] Wed, 23 January 2008 14:08 Go to next message
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
Re: ORA-01461: can bind a LONG value only for insert into a LONG column [message #296003 is a reply to message #295851] Thu, 24 January 2008 03:10 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

IMP-00028: partial import of previous table rolled back: 202 rows rolled back
It is becuase export dump file is not consistent.
so again export with CONSISTENT=y then try to import.
Re: ORA-01461: can bind a LONG value only for insert into a LONG column [message #296081 is a reply to message #296003] Thu, 24 January 2008 09:37 Go to previous messageGo to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
I used consistent=y but still the same problem.
Re: ORA-01461: can bind a LONG value only for insert into a LONG column [message #296083 is a reply to message #295851] Thu, 24 January 2008 09:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Possibly, bug 6167249.
Re: ORA-01461: can bind a LONG value only for insert into a LONG column [message #296092 is a reply to message #295851] Thu, 24 January 2008 10:19 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Hmm this is ringing a bell...

What Database version?

What version of the import/export utility ?

Trying to recall when I saw this and what the resolution was...
Re: ORA-01461: can bind a LONG value only for insert into a LONG column [message #296154 is a reply to message #295851] Thu, 24 January 2008 21:44 Go to previous message
caprikar
Messages: 226
Registered: March 2007
Senior Member
I'm using Oracle 10.2.0.3
-GK
Previous Topic: extract data from one database to other - both database cant talk each other (behind firewall)
Next Topic: generate DDL for tablespace objects
Goto Forum:
  


Current Time: Sat Dec 03 22:40:26 CST 2016

Total time taken to generate the page: 0.04485 seconds