Archive for 5月 9th, 2006

主键约束引起ORA-02429错误

Bright Posted on 2006-5-9 11:00 | Views(3,147) | Comments (0) | 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)

最新日志

热点文章

ORA-02019: connection description for remote database not found (11,328)
expdp常见用法 (10,886)
ORA-01102: cannot mount database in EXCLUSIVE mode (10,373)
IMP-00010: 不是有效的导出文件，标题验证失败 (8,970)
一则ora-03113错误的解决 (8,113)
CRS无法启动的解决过程 (7,553)
ORA-12500: TNS: 监听程序无法启动专用服务器进程 (6,668)
ORA-12545:Connect failed because target host or object does not exist (6,661)
Checking monitor:must be configured to display at least 256 colors (6,432)
ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid (4,442)
ORA-12535: TNS: 操作超时 (4,417)
ORA-12528: TNS:listener: all appropriate instances are blocking new connections (4,382)
【ZT】Oracle分布式事务故障处理 (4,346)
Oracle CRS log (4,312)
ORA-00600: internal error code, arguments: [17285], [0x2A97446380], [4294967295], [0x1DD7B1238] (4,308)
苏州圆融时代广场 (3,867)
Choosing an I/O Scheduler for Red Hat® Enterprise Linux® 4 and the 2.6 Kernel (3,692)
WARNING: inbound connection timed out (ORA-3136) (3,639)
2010第一贴 (3,295)
ANS1312E (RC12) Server media mount not possible (3,265)

日志存档

常用标签