Errors IMP-58 ORA-12552 While Importing From 9.2.0.4 Export Dump To 11.1.0.7 Target
(Doc ID 1210623.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.7 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
While importing into 11.1.0.7 database using an export dump from 9.2.0.4 database following is shown in import log:
...
importing table "<TABLE_NAME1>" 0 rows imported
. . importing table "<TABLE_NAME2>" 0 rows imported
. . importing table "<TABLE_NAME3>" 0 rows imported
. . importing table "<TABLE_NAME4>" 0 rows imported
. . importing table "<TABLE_NAME5>"
IMP-00058: ORACLE error 12552 encountered
ORA-12552: TNS:operation was interrupted
IMP-00028: partial import of previous table rolled back: 165521 rows rolled back
. . importing table "<TABLE_NAME6>" 0 rows imported
. . importing table "<TABLE_NAME7>" 3 rows imported
...
importing table "<TABLE_NAME1>" 0 rows imported
. . importing table "<TABLE_NAME2>" 0 rows imported
. . importing table "<TABLE_NAME3>" 0 rows imported
. . importing table "<TABLE_NAME4>" 0 rows imported
. . importing table "<TABLE_NAME5>"
IMP-00058: ORACLE error 12552 encountered
ORA-12552: TNS:operation was interrupted
IMP-00028: partial import of previous table rolled back: 165521 rows rolled back
. . importing table "<TABLE_NAME6>" 0 rows imported
. . importing table "<TABLE_NAME7>" 3 rows imported
...
Also while importing that single table from same export dump shows:
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
. importing <SCHEMA_NAME>'s objects into <SCHEMA_NAME>
. . importing table "<TABLE_NAME>"
IMP-00058: ORACLE error 12552 encountered
ORA-12552: TNS:operation was interrupted
IMP-00028: partial import of previous table rolled back: 130259 rows rolled back
Import terminated successfully with warnings.
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
. importing <SCHEMA_NAME>'s objects into <SCHEMA_NAME>
. . importing table "<TABLE_NAME>"
IMP-00058: ORACLE error 12552 encountered
ORA-12552: TNS:operation was interrupted
IMP-00028: partial import of previous table rolled back: 130259 rows rolled back
Import terminated successfully with warnings.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |