Sort Key too long [message #370552] |
Sun, 19 December 1999 10:48 |
NVB
Messages: 3 Registered: December 1999
|
Junior Member |
|
|
Hi,
I get the error O-01467 "sort key too long"
when I am creating an index. I use oracle 7.3.4
How do I get rid of this error?
Regards
Nagendra
|
|
|
Re: Sort Key too long [message #370553 is a reply to message #370552] |
Sun, 19 December 1999 19:54 |
Paul
Messages: 164 Registered: April 1999
|
Senior Member |
|
|
Nagendra,
According to my Oracle 8 documetation, an ORA-01467 error occurs when a GROUP BY, ORDER BY, DISTICT, or SET requires a sort key longer than allowed. It means you have specified either too many columns or too many group functions in your select. Without seeing the SQL statement that generated the error, it's hard to say what you can do to correct the situation.
Hope this helps,
Paul
|
|
|
Re: Sort Key too long [message #370555 is a reply to message #370553] |
Mon, 20 December 1999 03:43 |
NVB
Messages: 3 Registered: December 1999
|
Junior Member |
|
|
Paul,
Mine is a simple "create index" statement on a single column of datatype number(9).
The "create index" statement runs for some time beforecoming out with this error. I have plenty of space in temporary tablespace.
Regards
Nagendra
|
|
|
Re: Sort Key too long [message #370557 is a reply to message #370555] |
Mon, 20 December 1999 06:53 |
Paul
Messages: 164 Registered: April 1999
|
Senior Member |
|
|
Nagendra,
Any possibility that there are a lot of constraints on that column, or that it is a FK and the PK it references has a lot of constraints on it? Grasping at straws here, but these are the only logical possibilities that come to mind.
Paul
|
|
|
Re: Sort Key too long [message #370565 is a reply to message #370557] |
Tue, 21 December 1999 14:21 |
NVB
Messages: 3 Registered: December 1999
|
Junior Member |
|
|
Paul,
The column is an FK, but the PK which it references does not have any other FKs attached to it.
I run Oracle 7.3.4
Oracle support says that in certain cases Oracle gives Ora 1407 because of some internal problem
They have advised me to apply patchset 7.3.4.5
Regards
|
|
|