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;
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;
LOG ERRORS INTO ERR_T1('ERR_T1')REJECT LIMIT 30;
SELECT * FROM ERR_T1;
DROP TABLE T1 PURGE;
DROP TABLE T2 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;
LOG ERRORS INTO ERR_T1('ERR_T1_NEW')REJECT LIMIT 30;
SELECT * FROM ERR_T1;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23382569/viewspace-761070/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
