Import Failed with ORA-39068 and ORA-01775

刘泽宇

现象：
Oracle version 11.2.0.4

导入出现报错：
ORA-39002: invalid operation
ORA-39068: invalid master table data in row with PROCESS_ORDER=-1
ORA-01775: looping chain of synonyms
CHANGES


原因：
DUAL public SYNONYM was created for XXXXX.DUAL not for SYS.DUAL

Import failed with below errors.

Import: Release 11.2.0.4.0 - Production on Fri May 29 07:11:51 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Master table "XXXX"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
ORA-39068: invalid master table data in row with PROCESS_ORDER=-1
ORA-01775: looping chain of synonyms

解决方法：
Please take backup of public synonym which has created for "XXXXX"."DUAL"

Drop the public synonym which has created for "XXXXXXX"."DUAL"

Create public synonym which should point to SYS.DUAL using below command

CREATE PUBLIC SYNONYM DUAL FOR SYS.DUAL;

然后再次进行导入