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
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.