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 later
Information in this document applies to any platform.

Symptoms

1.  Conventional import is failing with the following errors:

Export file created by EXPORT:V08.00.06 via conventional path
. 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

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