Home » RDBMS Server » Server Administration » Sort Key too long
Sort Key too long [message #370552] Sun, 19 December 1999 10:48 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Login-problems
Next Topic: How can index on the remote database be used ?
Goto Forum:
  


Current Time: Thu Mar 28 04:33:16 CDT 2024