dbAnt

前两天遇到一个问题，在删除一个主键的之后，插入重复的数据报错ORA-00001唯一性约束冲突 test@TESTDB> insert into t1 select * from dba_objects where rownum < 100; insert into t1 select * from dba_objects where rownum < 100 * ERROR at line 1: ORA-00001: unique constraint (TEST.PK_T1_OBJECT_ID) violated 查询T1表主键及索引，发现主键索引仍然存在 test@TESTDB> select * from dba_cons_columns where table_name='T1'; no rows selected test@TESTDB> select INDEX_OWNER,INDEX_NA...... >>阅读全文<<