G'day,
Here's a new one (to me at least). I was running a full export over a dblink
into one database, let's call it uat1, and some hours later started another
full export over database link from the same source database (mask1) into
another database, say dev1. All databases reside on different physical servers.
The database link exists in the target database, that is one in dev1 and
another in uat1. There is no database link in mask1. The impdp jobs are started
independently from each other on the servers where the target database resides.
All database homes involved, (including impdp) are on version 11.2.0.4.5.
Some time after starting the second import (several hours in fact) I receive
the following errors in the first import:
ORA-39126: Worker unexpected fatal error in
KUPW$WORKER.UPDATE_TYPE_COMPLETION_ROW [239]
INSERT INTO "SYSTEM"."SYS_IMPORT_FULL_01" (process_order, duplicate,
object_path_seqno, object_type_path, object_number, start_time, completed_rows, instance_id)
values(:1, :2, :3, :4, :5, :6, 0, :7)
ORA-01502: index 'SYSTEM.SYS_C004322316' or partition of such index is in
unusable state
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 9721
Is this expected? Can I in fact run two unrelated import jobs from the same
source database, or is this an unsupported arrangement?
Cheers,
Tony