Re: ORA-01467: sort key too long

From: Markus Flechtner <flechtne_at_uni-duesseldorf.de>
Date: 1998/01/31
Message-ID: <34ce434f.6640368@news.rz.uni-duesseldorf.de>#1/1

On Mon, 26 Jan 1998 18:14:07 -0500, Tansel Ozkan <tansel_at_openix.com> wrote:

>Hello everyone,
>
>I am having a strange problem. A query that I am running on our
>production database is giving me "ORA-01467: sort key too long" error
>message. One of the selected fields is datatype varchar2(2000). The
>query returns 20 records with the varchar2(2000) field occupying full
>2000 characters. To create the same environment on the development
>database, I inserted new records such that for a given where condition
>the query returns about 20 records with that field occupying 2000
>characters. However, when we run the same query on the development
>database, we are not getting this error message. Any ideas??
>

Check the DB_BLOCK_SIZE. It may be different (smaller on the production database)

Markus Flechtner Received on Sat Jan 31 1998 - 00:00:00 CST