IMP-00058 ORA-01461 when importing to Non-Partition OTM database
(Doc ID 788065.1)
Last updated on MAY 06, 2022
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