in Oracle other sessions can NOT see uncommitted data!
But the Oracle documentation says
In a conventional load,
ROWSis the number of rows to read before a commit operation. A direct load data save is similar to a conventional load commit, but it is not identical.
The similarities are as follows:
- A data save will make the rows visible to other users.
- Rows cannot be rolled back after a data save.
The major difference is that in a direct path load data save, the indexes will be unusable (in Index Unusable state) until the load completes.
A data save will make rows visible to other users.
The other users can't see the data until the "data save," just like a commit. The high water mark is adjusted, so even a crash doesn't lose it. But indices are another story.
So I am assuming that the statement "save data point reached - logical record count 1000000" on my command line is a "data save". I am still not able to view the data.
Try doing a rollback or commit before viewing.
Just tried that. It did not work. Here is the control file that I am using.
INFILE 'C:\CAL2.txt' "str X'0D0A'"
INTO TABLE TEST
FIELDS TERMINATED BY '|'
OPTIONALLY ENCLOSED BY '"'
COL5 DATE 'MM/DD/YYYY',
COL6 DATE 'MM/DD/YYYY',
Just to be clear, I meant in the other session. I was thinking that you were getting a view of the data from before your data save. Perhaps someone else has a better idea what is going on.