| ORA-01467: sort key too long [message #33118] |
Tue, 21 September 2004 17:59 |
Rahul
Messages: 94
Registered: December 1998
|
Member |
|
|
Hi,
I am facing ORA-01467: sort key too long issue when I run procedure that contains complex query. I am in development stage of my project. I found few Workarounds from Oracle.
Oracle suggested Workarounds are:
1. Increase the db_block_size of the database. The only way to change the database block size of a database is increase the db_block_size in the init.ora and recreate the database. (This task I cannot carry out now as I am in the middle of my development)
2. Break down the query into smaller queries. Change the order by or group by statement. (I am working on this task)
3. Create and index on the columns where the sorting is happening. This way Oracle can use the index instead of having to sort the column. (This has been tested by creating Indexes but the issue is not resolved)
Otherthan above Workarounds, I am still working with Database Level Parameters to solve this issue.
Could you please someone help me in resolving this issue with Database Level Parameters or any Parameters that works fine with my current environment.
Thanks in advance.
Regards,
Rahul.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
