impdp失败,出现ORA-02270

我正在尝试使用impdp实用程序将模式导入同一数据库中的另一个模式

,但由于以下错误而失败:

ORA-39083: Object type REF_CONSTRAINT:"FOUNDATION_FORMBUILDER_QC_RE"."FKT52CCE6N3RSJ03MLIWYHDJ4JV" failed to create with error:
ORA-02270: no matching unique or primary key for this column-list
Failing sql is:
ALTER TABLE "FOUNDATION_FORMBUILDER_QC_RE"."CRM_CUSTOMER_SLA" ADD CONSTRAINT "FKT52CCE6N3RSJ03MLIWYHDJ4JV" FOREIGN KEY ("SLA_PROGRESS") REFERENCES "FOUNDATION_FORMBUILDER_QC_RE"."SLA_PROGRESS" ("RECID") ENABLE
ORA-39083: Object type REF_CONSTRAINT:"FOUNDATION_FORMBUILDER_QC_RE"."SYS_C0020737" failed to create with error:
ORA-02270: no matching unique or primary key for this column-list

我尝试手动创建它,但由于相同的错误而失败

LiJ86 回答:impdp失败,出现ORA-02270

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/2745263.html

大家都在问