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

Last updated on NOVEMBER 10, 2013

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms