CREATE TABLE TEST(
id NUMBER(10) NOT NULL,
code VARCHAR2(10) NOT NULL,
description VARCHAR2(50),
CONSTRAINT dest_pk PRIMARY KEY (id)
);
-- Create the error logging table.
BEGIN
DBMS_ERRLOG.create_error_log (dml_table_name => 'TEST');
END;
It will create ERR$_TEST new table
INSERT INTO TEST
SELECT *
FROM source
LOG ERRORS INTO err$_test ('INSERT') REJECT LIMIT UNLIMITED;
SELECT ora_err_number$, ora_err_mesg$
FROM err$_test
WHERE ora_err_tag$ = 'INSERT';
No comments:
Post a Comment