日期:2014-05-17 浏览次数:21189 次
SQL> select count(distinct index_name) from dba_indexes; COUNT(DISTINCTINDEX_NAME) ------------------------- 4788 SQL> select count(distinct index_name) from dba_ind_columns; COUNT(DISTINCTINDEX_NAME) ------------------------- 3887
--不一样很正常的,执行这个就应一样了 purge recyclebin; / --LOB类型的在dba_ind_columns是不存在的 select count(distinct index_name) from dba_indexes where index_type<>'LOB'; / --正常情况下,此处会含有回收站中的 select count(distinct index_name) from dba_ind_columns; /