I HAVE TAKE EXPORT BACKUP OF USER IN ORACLE 9i AND IMPORT IN 10G
AFTER IMPORTING IN 10G SORTING ORDER OF MY ALL REPORTS ARE CHANGED IN 9i SORTING ORDER IS RIGHT
IS THERE SOME PARAMETERS IN ORACLE AFTER CHANGING THAT MY SORTING ORDER WILL SET IN ORDER AS
This is one of the 'features' of 10g. aggregation functions (group by , distinct etc) are faster at 10g - but the downside is the results dont come back in order. This optimization can be disabled if you want to revert to 9i behaviour.
gbyhash_aggregation=false (from memory not 100% sure).
As with any _ paramter you should check with oracle support before setting it.