| Oracle 10g in HP UX 11. [message #195160] |
Wed, 27 September 2006 04:39  |
Meyyappan
Messages: 2
Registered: September 2006
|
Junior Member |
|
|
Hi,
I have installed Oracle 10 server in HP UX 11 machine.
After creating an user, I imported an user dump for 9i server to 10g.
Now when I connect to the user through TOAD, and open schema browsers to see the tables, the tables are not sorted by name.
But when I connect to the user in 9i through same TOAD session, everything is fine there.
Has any one faced this problem already ?
Please help me, Im going mad trying to locate a table in the schema browser.
|
|
|
|
| Re: Oracle 10g in HP UX 11. [message #195255 is a reply to message #195160] |
Wed, 27 September 2006 11:31  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
Don't use TOAD browser as a reference because you can't easily be sure how they process the list of tables. Do a
select table_name, owner from all_tables order by table_name;
Also compare database nls_sort settings on both databases.
select * from v$parameter where name = 'nls_sort';
select * from nls_session_parameters where parameter = 'NLS_SORT';
|
|
|
|
| Re: Oracle 10g in HP UX 11. [message #195271 is a reply to message #195255] |
Wed, 27 September 2006 12:51 |
Meyyappan
Messages: 2
Registered: September 2006
|
Junior Member |
|
|
Thank you for the input.
I would use the select query in future.
My TOAD version is 7.2
Have to admit that I got used to the TOAD schema browser and the filters and the sorts. So will take some time to get rid of it.
I compared the nls_sorting on both 9i and 10g DB.
All the parameter values are same except for some new parameters in 10g in the result of the 1st query.
Another interesting thing is that I did a fresh installation on Oracle10g in another test machine and there are no issues there in that machine.
I'm puzzled !
[Updated on: Wed, 27 September 2006 12:52] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
