Hi All,
We have the below issue while loading the data to target table using Bulk load stage
LoadEDWSale..TgtEDWSaleOra: DATEFORMAT='YYYY-MM-DD'.
LoadEDWSale..TgtEDWSaleOra: TIMEFORMAT='hh24:mi:ss'.
LoadEDWSale..TgtEDWSaleOra: MAXRECORDNUM='10000'.
LoadEDWSale..TgtEDWSaleOra: LOADMODE='Automatic'.
LoadEDWSale..TgtEDWSaleOra: DIRPATH='/PX_Scratch1'.
LoadEDWSale..TgtEDWSaleOra: CTRLFILE='edw_sale.ctl'.
LoadEDWSale..TgtEDWSaleOra: DATAFILE='edw_sale.dat'.
LoadEDWSale..TgtEDWSaleOra: DELIMITER='|'.
LoadEDWSale..TgtEDWSaleOra.IDENT1: Row 16334649 cannot be loaded. See next Oracle error message for details.
Error:ORA-26095: unprocessed stream data exists
Please let me know your thoughts on this issue.
Thanks,
Satheesh
Oracle Bulk Load Stage issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am