My Oracle Support Banner

Conventional Import (IMP) Fails With IMP-00058 ORA-20000 ORA-06512 ORA-04088 Errors (Doc ID 2223357.1)

Last updated on OCTOBER 09, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.6.0 and later
Information in this document applies to any platform.

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data.
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Symptoms

1.  Conventional import is failing with the following errors:

Export file created by EXPORT:V08.00.06 via conventional path
. importing <SCHEMA>'s objects into <SCHEMA>
. . importing table "<TABLE_NAME>"
IMP-00058: ORACLE error 20000 encountered
ORA-20000: TGM-15000
ORA-06512: at "<SCHEMA>.<PACKAGE_NAME>", line 110
ORA-06512: at "<SCHEMA>.<TRIGGER_NAME>", line 54
ORA-04088: error during execution of trigger '<SCHEMA>.<TRIGGER_NAME>'
IMP-00017: following statement failed with ORACLE error 2264

2.  The export is completed without any issue:

Connected to: Oracle8 Enterprise Edition Release 8.0.6.2.0 - Production
PL/SQL Release 8.0.6.2.0 - Production
Export done in US7ASCII character set and WE8ISO8859P1 NCHAR character set

About to export specified tables via Conventional Path ...
...
... exporting table <TABLE_NAME> 3484362 rows exported
...
Export terminated successfully without warnings.

Changes

The source and destination belong to the same database. Basically intended to truncate the table and refresh with the new table data.

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


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