Conventional Import (IMP) Fails With IMP-00058 ORA-20000 ORA-06512 ORA-04088 Errors
(Doc ID 2223357.1)
Last updated on JANUARY 16, 2017
Applies to:
Oracle Database - Enterprise Edition - Version 8.0.6.0 and laterInformation in this document applies to any platform.
Symptoms
1. Conventional import is failing with the following errors:
. importing TIMS's objects into TIMS
. . importing table "Q_BIBILLHDR"
IMP-00058: ORACLE error 20000 encountered
ORA-20000: TGM-15000
ORA-06512: at "TIMS.PKG_SYS", line 110
ORA-06512: at "TIMS.BILLHDR_R5", line 54
ORA-04088: error during execution of trigger 'TIMS.BILLHDR_R5'
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 INPUT_GATEWAY_ORDERS_PROCESSED 1289611 rows exported
. . exporting table BI_CHARGE 195536 rows exported
. . exporting table Q_BIBILLHDR 3484362 rows exported
. . exporting table OMS_TRANSACTIONS_ROWS_ARCH 1642452 rows exported
. . exporting table FTT_DETAIL_CHARGES_ARCHIVE 4604710 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 |
| This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |