My Oracle Support Banner

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 FEBRUARY 26, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Oracle 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.
***Checked for relevance on 26-NOV-2012***

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

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.

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


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