View doesn't pull all modified records as of a certain time
I'm hoping to find an answer to this question - DBA's and Developers think this is a 'Data' problem, but all of my tests indicate that the data is fine.
I have a view that used to be able to process thousands of records.
Lately it only pulls about 24 records at the most.
The only thing that recently changed is that we upgraded from 10g to 11g.
The intended functionality of this view is to pull everything >= a date_time_stamp field in another table.
I've taken the view and forced a date and time of 10/20/2011 16:00:00 and expect to find over 2500 records.