Posts Tagged ‘主键约束’

主键约束引起ORA-02429错误

Bright Posted on 2006-5-9 11:00 | Views(1,546) | Comments (1) | Category: Oracle | Tags: ORA-02429, oracle, 主键约束

drop index时出现如下错误：
SQL> drop index oos_index;
drop index oos_index
*
ERROR at line 1:
ORA-02429: cannot drop index used for enforcement of unique/primary key
我们知道当创建Primary key和unique约束时，如果在该key上不存在索引，则 oracle 会自动创建对应的unique索引，而当你要删除该索引时，必须先Disable或Drop该约束。看下面的例子：

Page 1 of 11

搜索本站

站点日历

订阅本站

订阅到Google Reader

订阅到鲜果

订阅到抓虾

订阅到有道

文章分类

English (4)
商务智能 (7)
存储 (1)
小米 (19)
操作系统 (15)
- Unix|Linux (12)
- Windows (3)
数据库 (96)
- MS SQL (21)
- Mysql (2)
- Oracle (73)
网络 (5)
随笔 (63)

最新日志

热点文章

expdp常见用法 (6,335)
IMP-00010: 不是有效的导出文件，标题验证失败 (5,056)
ORA-12500: TNS: 监听程序无法启动专用服务器进程 (3,904)
ORA-01102: cannot mount database in EXCLUSIVE mode (3,503)
一则ora-03113错误的解决 (3,427)
Checking monitor:must be configured to display at least 256 colors (3,285)
ORA-12545:Connect failed because target host or object does not exist (3,202)
CRS无法启动的解决过程 (2,657)
ORA-02019: connection description for remote database not found (2,469)
ORA-12535: TNS: 操作超时 (2,237)
【ZT】Oracle分布式事务故障处理 (2,132)
ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid (2,093)
ORA-00600: internal error code, arguments: [17285], [0x2A97446380], [4294967295], [0x1DD7B1238] (2,082)
Choosing an I/O Scheduler for Red Hat® Enterprise Linux® 4 and the 2.6 Kernel (1,899)
苏州圆融时代广场 (1,872)
WARNING: inbound connection timed out (ORA-3136) (1,864)
Oracle CRS log (1,861)
ORA-12528: TNS:listener: all appropriate instances are blocking new connections (1,798)
Oracle RAC升级问题记录 (1,628)
主键约束引起ORA-02429错误 (1,546)

日志存档

常用标签