OraFAQ Forum: Server Utilities » ORA-01461: can bind a LONG value only for insert into a LONG column

Home » RDBMS Server » Server Utilities » ORA-01461: can bind a LONG value only for insert into a LONG column

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

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.

Report message to a moderator

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

caprikar
Messages: 226
Registered: March 2007

Senior Member

I used consistent=y but still the same problem.

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Possibly, bug 6167249.

Report message to a moderator

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

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...

Report message to a moderator

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

caprikar
Messages: 226
Registered: March 2007

Senior Member

I'm using Oracle 10.2.0.3
-GK

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 15:26:00 CDT 2024