Exception while using Multiple Copy file
The Exception file which is generated i.e /home/amit/excp_acct.dat says about the erroneous record number but gives the wrong name of a file for eg always gives the name of first file provided in load file list i.e acct1 whereas the acct1 is empty and the error record is actually in 3rd file.
Can any 1 please let me know how to get the correct file name which has the erroneous record in exception file.
For eg:
COPY users_89.acct (acct_id
)
FROM LOCAL '/home/amit/acct1.dat', '/home/amit/acct3.dat', '/home/amit/acct3.dat'
DELIMITER as '|'
REJECTED DATA '/home/amit/rej_acct.dat'
EXCEPTIONS '/home/amit/excp_acct.dat'
NO ESCAPE
ABORT ON ERROR
DIRECT
Can any 1 please let me know how to get the correct file name which has the erroneous record in exception file.
For eg:
COPY users_89.acct (acct_id
)
FROM LOCAL '/home/amit/acct1.dat', '/home/amit/acct3.dat', '/home/amit/acct3.dat'
DELIMITER as '|'
REJECTED DATA '/home/amit/rej_acct.dat'
EXCEPTIONS '/home/amit/excp_acct.dat'
NO ESCAPE
ABORT ON ERROR
DIRECT
0