首页 » ORACLE [C]系列, ORACLE 9i-23ai » Troubleshooting ORA-600 [KKZGPKORID] impdp from 11G to 19C

Troubleshooting ORA-600 [KKZGPKORID] impdp from 11G to 19C

从oracle 11.2.0.4 impdp导入到 oracle 19.6,生成本地dump文件,在导入时出现 ORA-600 [KKZGPKORID]

...
Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-00600: internal error code, arguments: [KKZGPKORID], [0], [], [], [], [], [], [], [], [], [], []

KKZG ==> upport for snapshots or Materialized View validation and operation, 与物化视图有关,同是也是在导出SCHEMA_EXPORT/MATERIALIZED_VIEW出错

检查原库MVIEWS是否为无效状态,修正并重新导出, 或导入时排除物化视图EXCLUDE=MATERIALIZED_VIEW.

打赏

对不起,这篇文章暂时关闭评论。