DBMS_ERRLOG

CREATE TABLE T1 AS SELECT ROWNUM A,ROWNUM B FROM DBA_SEGMENTS WHERE ROWNUM <=10;

CREATE TABLE T2 AS SELECT ROWNUM A,ROWNUM B FROM DBA_SEGMENTS WHERE ROWNUM <=20;

ALTER TABLE T1 ADD CONSTRAINT PK_T1_A PRIMARY KEY(A);

BEGIN
DBMS_ERRLOG.CREATE_ERROR_LOG('T1','ERR_T1',SCOTT);
END;

SELECT * FROM ERR_T1;

INSERT INTO T1 SELECT * FROM T2
LOG ERRORS INTO ERR_T1('ERR_T1')REJECT LIMIT 30;

SELECT * FROM ERR_T1;

DROP TABLE T1 PURGE;
DROP TABLE T2 PURGE;

CREATE TABLE T1 AS SELECT OWNER A,SEGMENT_NAME B,ROWNUM C FROM DBA_SEGMENTS WHERE ROWNUM <=10;

CREATE TABLE T2 AS SELECT OWNER A,SEGMENT_NAME B,ROWNUM C FROM DBA_SEGMENTS WHERE ROWNUM <=20;

ALTER TABLE T1 ADD CONSTRAINT PK_T1_A PRIMARY KEY(A,B);

SELECT * FROM ERR_T1;

INSERT INTO T1 SELECT * FROM T2
LOG ERRORS INTO ERR_T1('ERR_T1_NEW')REJECT LIMIT 30;

SELECT * FROM ERR_T1;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23382569/viewspace-761070/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23382569/viewspace-761070/