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