Conventional Import (IMP) Fails With IMP-00058 ORA-20000 ORA-06512 ORA-04088 Errors
Last updated on JANUARY 16, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
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-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 18.104.22.168.0 - Production
PL/SQL Release 22.214.171.124.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.
The source and destination belong to the same database. Basically intended to truncate the table and refresh with the new table data.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms