Creating DML Error log table for Dataload errors

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2089
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Creating DML Error log table for Dataload errors

Post by admin »

begin
DBMS_ERRLOG.CREATE_ERROR_LOG (dml_table_name => 'EMP');
end;

it will create table for dataload error,

CREATE TABLE "ERR$_EMP"
( "ORA_ERR_NUMBER$" NUMBER,
"ORA_ERR_MESG$" VARCHAR2(2000),
"ORA_ERR_ROWID$" UROWID (4000),
"ORA_ERR_OPTYP$" VARCHAR2(2),
"ORA_ERR_TAG$" VARCHAR2(2000),
"EMPNO" VARCHAR2(4000),
"ENAME" VARCHAR2(4000),
"JOB" VARCHAR2(4000),
"MGR" VARCHAR2(4000),
"HIREDATE" VARCHAR2(4000),
"SAL" VARCHAR2(4000),
"COMM" VARCHAR2(4000),
"DEPTNO" VARCHAR2(4000),
"STATUS" VARCHAR2(4000)
) ;

COMMENT ON TABLE "ERR$_EMP" IS 'DML Error Logging table for "EMP"';
Malik Sikandar Hayat
Oracle ACE Pro
info@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests