hint IGNORE_ROW_ON_DUPKEY_INDEX
11G新加 IGNORE_ROW_ON_DUPKEY_INDEX 这个hint可以让对有主键的重复值时，不去报错：
SQL> drop table test purge;
Table dropped.
SQL> create table test (id number primary key, name varchar2(10));
Table created.
SQL> insert into test values (1,'111');
1 row created.
SQL> insert into test values (1,'111');
insert into test values (1,'111')
*
ERROR at line 1:
ORA-00001: unique constraint (SONG.SYS_C0011677) violated
SQL> insert /*+ IGNORE_ROW_ON_DUPKEY_INDEX(test,SYS_C0011677)*/ into test values (1,'111');
0 rows created.
SQL> insert /*+ IGNORE_ROW_ON_DUPKEY_INDEX(test,aaa)*/ into test values (1,'111'); --hints用错，会报错
insert /*+ IGNORE_ROW_ON_DUPKEY_INDEX(test,aaa)*/ into test values (1,'111')
*
ERROR at line 1:
ORA-38913: Index specified in the index hint is invalid
SQL> drop table test purge;
Table dropped.
SQL> create table test (id number primary key, name varchar2(10));
Table created.
SQL> insert into test values (1,'111');
1 row created.
SQL> insert into test values (1,'111');
insert into test values (1,'111')
*
ERROR at line 1:
ORA-00001: unique constraint (SONG.SYS_C0011677) violated
SQL> insert /*+ IGNORE_ROW_ON_DUPKEY_INDEX(test,SYS_C0011677)*/ into test values (1,'111');
0 rows created.
SQL> insert /*+ IGNORE_ROW_ON_DUPKEY_INDEX(test,aaa)*/ into test values (1,'111'); --hints用错，会报错
insert /*+ IGNORE_ROW_ON_DUPKEY_INDEX(test,aaa)*/ into test values (1,'111')
*
ERROR at line 1:
ORA-38913: Index specified in the index hint is invalid
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25099483/viewspace-1068150/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
shareplex两个参数
请登录后发表评论
登录
全部评论
