Re: Sort key too long

Francis Mignault wrote:
>
> 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
>
> Francis_mignault_at_nt.com

You can't have a sort sequence that is bigger than the block size. So without doing big-time database mods, you have to either shrink or eliminate the sorting that the query is doing whether explicitly (with order by) or implicitly - maybe look at doing adding a "FIRST_ROWS" or "INDEX( xx yy)" hint to try retrieve the data in sorted order so that the sort is not required...Other than that, I think a new block size mau be in order...(You get some other benefits as well - faster DB, more extents etc etc)

Cheers

-- 
Connor McDonald
Systems Administrator-Unix/Oracle
BHP Iron Ore
"You're not drunk if you can lie on the floor without holding on"
            - Dean Martin