My Oracle Support Banner

IMP-00058 ORA-01461 when importing to Non-Partition OTM database (Doc ID 788065.1)

Last updated on APRIL 23, 2019

Applies to:

Oracle Transportation Management - Version 5.5 to 5.5.05 [Release 5.5]
Oracle Solaris on x86-64 (64-bit)
***Checked for relevance on 10-Nov-2013***


Symptoms

-- Problem Statement:
The database was initially created with partitioning, however, there is now a need to remove the partitioning.

To do this, the table was recreate without partitioning and the data was imported into the table. When this step was done, the following error was encountered:

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: 2101 rows rolled back

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.