Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS [OBJECT_GRANT:"BIEEMLOPR"]
ORA-31600: invalid input value 200001 for parameter HANDLE in function CLOSE
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 1080
.......
SELECT process_order, duplicate, completion_time, in_progress FROM "SYS"."SYS_IMPORT_SCHEMA_01" WHERE partition_name IS NULL AND subpartition_name IS NULL AND object_type = :1 AND object_schema = :2 AND object_name IS NULL AND :3 IS NULL AND object_long_name IS NULL AND :4 IS NULL AND base_object_type = :5 AND base_object_schema = :6 AND base_object_name = :7 AND grantor = :8
ORA-01422: exact fetch returns more than requested number of rows
可能是之前的导出进程异常有残留数据未清理，可以通过如下SQL查询下job的记录，如果有可以手工清理下
select o.status, o.object_id, o.object_type, o.owner||'.'||object_name "OWNER.OBJECT" from dba_objects o, dba_datapump_jobs j where o.owner=j.owner_name and o.object_name=j.job_name and j.job_name not like 'BIN$%' order by 4, 2;
另外可以尝试不导出统计信息：
exclude=table_statistics
评论
有用 0
墨值悬赏