博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

2010年6月17日

摘要: //首先找到所有cons物件select object_name from all_objects where object_name like '%CONSTRAINT%';//找出constraint错误具体的object,找出记录删除之。搞定收工select * from ALL_CONSTRAINTS where constraint_name='SYS_C0042235' 阅读全文

posted @ 2010-06-17 10:57 幸福人生 阅读(362) 评论(0) 推荐(0) 编辑

摘要: ora-01086 Oracle Error Reason and SolutionIt may be because you're executing it all as one batch.The DBMS has to parse eveything at once, and create a planfor it. At compile time there is no savepoint... 阅读全文

posted @ 2010-06-17 10:56 幸福人生 阅读(2079) 评论(0) 推荐(0) 编辑