Home > Database > Mysql Tutorial > ora-00604,ora-02429:无法删除用于强制唯一/主键的索引。

ora-00604,ora-02429:无法删除用于强制唯一/主键的索引。

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 17:15:05
Original
1728 people have browsed it

今天删除数据库中的表空间时,发现始终删不掉,错误信息为:quot;ora-00604,ora-02429:无法删除用于强制唯一/主键的索引。quot;最

今天删除数据库中的表空间时,发现始终删不掉,错误信息为:"ora-00604,ora-02429:无法删除用于强制唯一/主键的索引。"

最终发现是其他某个用户在创建索引时没有注意到其中tablespace设置,直接把这个索引的表空间指定到这个表空间中,故删除之,并重新创建到其他表空间中.故障接触.

操作语法:
select 'alter table '||owner||'.'||table_name||' drop constraint '||constraint_name||' ;'
from dba_constraints
where constraint_type in ('U', 'P')
   and (index_owner, index_name) in
       (select owner, segment_name
          from dba_segments
         where tablespace_name = 'ENESYS0922');

更多Oracle相关信息见Oracle 专题页面 ?tid=12

linux

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template