SQL> alter table gyj_1000 add primary key(id);
alter table gyj_1000 add primary key(id)
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-08102: index key not found, obj# 52, file 1, block 28280 (2)
SQL> conn / as sysdba
Connected.
SQL> SELECT /*+ FULL(t1) */
2owner#, NAME, con#
3FROM CON$ t1
4MINUS
5SELECT /*+ index(t I_CON2) */
6owner#, NAME, con#
7FROM CON$ t;
OWNER# NAME
CON#
---------- ------------------------------ ----------
0 _NEXT_CONSTRAINT
3764
如需了解更多请登录网站http://www.jianfengedu.com/Discuz/detail/id/64
|