My Oracle Support Banner

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

Last updated on JULY 20, 2024

Applies to:

Oracle Transportation Management - Version 5.5 to 5.5.05 [Release 5.5]
Oracle Solaris on x86-64 (64-bit)


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


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

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