Impdp Fails With ORA-600 [kkqfca:invalid input] While Processing Materialized Views (Doc ID 750702.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2 to 11.1.0.6
This problem can occur on any platform.

Symptoms

While performing an import with Data Pump, the import stops while processing materialized views with the following errors in the import log file:

Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.

ORA-39014: One or more workers have prematurely exited.

At the same time the alert log is showing following error :

ORA-600: internal error code, arguments: [kkqfca:invalid input], [], [], [], [], [], [], []

The call stack functions from the trace file will look similar to:

ksedst <- ksedmp <- kgerinv <- kgeasnmierr <- kkzqfca <- kkzpgcinfo <- kkzpcbk <- opikkzprs1 <- opiSem <- opiprs <- kksParseChildCursor <- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0 ...

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