All Forums Tools
KM 5 posts Joined 02/06
28 Feb 2006
Logfile in MLOAD

Hi could someone please tell me, how to specify the LOG file in MLOAD , simillar to SQL*Loader in Oracle .Your help will be highly appreciated .

pavan sriram 4 posts Joined 02/06
28 Feb 2006

You can use the log table in mload as below...RUN FILE LOGON or (LOGON TDP/username, ;-) .LOGTABLE Database1.Table1;.BEGIN IMPORT MLOAD TABLES &DB_NAME..&TBL_NAME WORKTABLES &DB_NAME..WT_&TBL_NAME ERRORTABLES &DB_NAME..ET_&TBL_NAME &DB_NAME..UV_&TBL_NAME ERRLIMIT &ERRLIM CHECKPOINT &CHCKPNT SESSIONS &SESSNS TENACITY &TNCTY SLEEP &SLP AMPCHECK ALL; .....

You must sign in to leave a comment.