I have exported 809GB data to data file using fast export with MLSCRIPT option sucessfully. I imported to table again using ml script which is generated by fast export script. I did the row count validation, found 1 record mismatch.
.BEGIN EXPORT ;
.EXPORT OUTFILE test.dat
SELECT * FROM DB.TABLE;
Note: In export log row count is correct. In import log " Candidate records considered: 132131233" (count is 1 less). NO records are inserted in error tables.
May I know the possilbe reason.
Thanks in advance.
Can not share the o/p file is in binary format also it is size of 1.6TB.
Kindly let me know the possible reasons for not loading ONE record when I imported the data using MLScript which has generated by Fastexport with MLSCRIPT option. This I noticed only for large tables (e.g... more than 600GB TD tables). For small tables loaded perfectly.
I only need the FEXP job output and the corresponding FEXP-generated MLOAD job output. These files should not be as large as 1.6TB.
The huge data file is not needed. At least, please share with us the table definition of your target table.