Issue in default Sorting in Oracle 10g
Posted on 2009-04-13
My application runs in eight independent instance of Oracle server. only user form level data will be same in all the instances, data entered by user in one instance will not be available in other instance. I really have strange issue. I am performing a select query withour order by clause on the user form level data, out of 8 instance 7 instance are returning that common data in same order, but one instance is returning in different. I am seeing this difference only after migrating the backend from Oracle 9i to Oracle 10g.
Requesting to help me to understand why such a behaviour, and let me know how to resolve the problem.