[help]ORA-1467 sort key too long

Hi.. everyone..

I got ORA-1467 error, when I query sometable.

Follow is My state.

First, create table.

	create table content (
		blockid number,
		...
		block varchar2(2000));

Second, insert some rows.

Third, query

	select blockid, block
	from content
	order by blockid;

I got the error "ORA-1467 : sort key too long".

I use Solaris 2.5 and Oracle 7.2.3.

How can I solve this problem..?

Thanks in advances. Received on Thu Jun 26 1997 - 00:00:00 CEST