| Reg ROWID in Oracle 8i & 9i - Migration Issues [message #63566] |
Sat, 16 October 2004 01:14  |
Gurusubramanyam
Messages: 79
Registered: July 2001
|
Member |
|
|
Dear Friends,
I need one urgent clarification regarding the ROWID in Oracle 8i & 9i. Yesterday we have migrated our application database from 8i to 9i and we are facing some data sorting issues. Is there any difference between 8i & 9i in terms of rowid ?
Almost in all the master tables, after migration the displaying order of the data is changed. In some of the LOV's we have not specified the sorting order and hence the sorting order will be based on ROWID.
The 8i display order is (As per the rows inserted order)
code description
--------------------
AAA AAAAAAAAAAA
BBB BBBBBBBBBBBB
YYY YYYYYYYYYY
In the 9i database after migration
Code description
----------------------
YYY YYYYYYYYYY
AAA AAAAAAAAAAA
BBB BBBBBBBBBBBB
What could be the reason for that? Advanced thanks for your solutions.
Thanks & Regards,
B.Prasad
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
