关于Oracle错误

发布于 2024-09-08 18:17:44 字数 250 浏览 5 评论 0原文

我收到以下 Oracle 错误。我使用 toad 检查了测试方案中是否有任何约束名称 CMF_CMP。但我找不到它。我如何检测失败的原因以及如何解决它。

ERROR at line 1:
ORA-20001: -2298: ORA-02298: cannot validate (TEST.FMF_CMP) - parent keys not found
ORA-06512: at test.test_SYN", line 46

原文

I am getting the below oracle error. I checked the test scheme for any constraint name CMF_CMP using toad. But i am unable to find it.
How do i detect the reason for failure and how to resolve it.

ERROR at line 1:
ORA-20001: -2298: ORA-02298: cannot validate (TEST.FMF_CMP) - parent keys not found
ORA-06512: at test.test_SYN", line 46

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

≈。彩虹 2024-09-15 18:17:44

听起来你有一个孤儿！
您需要追踪它并给它一个父级或删除孤儿

http:// /www.techonthenet.com/oracle/errors/ora02298.php

select * 
  from test_SYN ts
 where PARENTID not EXISTS(
                           select NULL 
                             from test_PARENT tp
                            where tp.ID = ts.ParentID)

您是否正在尝试启用该约束，或者我只是错过了标记？

Sounds like you have an orphan!
You'll need to track it down and give it a parent or drop the orphan

http://www.techonthenet.com/oracle/errors/ora02298.php

select * 
  from test_SYN ts
 where PARENTID not EXISTS(
                           select NULL 
                             from test_PARENT tp
                            where tp.ID = ts.ParentID)

Are you trying to enable the constraint or am I just missing the mark?

回复收藏 0 原文

~没有更多了~