Oracle Database Cloud Schema Service - Version N/A and later: Drop Tablespace Failed with ORA-02429: cannot drop index used for enforcement of unique/primary key
drop tablespace crm_idx including contents cascade constraints * ERROR at line 1: ORA-00604: error occurred at recursiveSQLlevel 1 ORA-02429: cannot drop index used for enforcement of unique/primary key ORA-02429的意思是: 让你删除该表空间下面的 primary key 和 unique key 处理办法: select 'alt...
ORA-02429: cannot drop index used for enforcement of unique/primary key 我们知道当创建Primary key和unique约束时,如果在该key上不存在索引,则Oracle会自动创建对应的unique索引,而当你要删除该索引时,必须先Disable或Drop该约束。看下面的例子: SQL>CREATE TABLE employees 2 ( 3 empno NUMBER(6) PRIMARY KEY...
Drop user 报ORA-00600 [KTSSDRP1] 2018-01-11 11:17 −一客户删除一个数据库用户THH时报错: 说明在获取seg$时没有找到相应的条目,先来解释下这个600错误的参数含义: Arg [a] Tablespace number Arg [b] File number Arg [c] Block number 无法删除整个用户,那就先尝试删除用... ...