标题: Import Failed with ORA-39068 and ORA-01775 [打印本页] 作者: 刘泽宇 时间: 2023-8-13 12:43 标题: 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