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"';
Creating DML Error log table for Dataload errors
Creating DML Error log table for Dataload errors
Malik Sikandar Hayat
Oracle ACE Pro
info@erpstuff.com
Oracle ACE Pro
info@erpstuff.com
Who is online
Users browsing this forum: No registered users and 0 guests