Sort key too long

Can someone help me ?

I have one local DB V7.1.6
running with SQL*NET V2 under HP-UX9.04

and another DB remote.

I am doing an outer join between 2 tables remote and one table local.

I sometimes get the error ORA-1467 : Sort Key Too Long

I called Oracle and they told me that this is an internal error and that the only way to fix this error is to either upgrade to 7.3 or re-create my DB with a larger block size...

Does anyone know how I can fix this problem without re-creating the Database ?

Thank You

Francis_mignault_at_nt.com Received on Wed Feb 26 1997 - 00:00:00 CST