Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Showstopper ORA-01467: sort key too long - PLEAAASEEE HEEELP

Re: Showstopper ORA-01467: sort key too long - PLEAAASEEE HEEELP

From: Eric Euerlings <euerlings_at_swift.ch>
Date: Fri, 6 Nov 1998 08:58:09 +0100
Message-ID: <71ua8b$9vl$1@bw107zhb.bluewin.ch>

Oops,

how do I evaluate the blocksize and how do I encrease this ?

Cheers Eric

-----Original Message-----
From: Andrew Protasov <oracle_at_protasov.kiev.ua> Newsgroups: comp.databases.oracle.server Date: Freitag, 6. November 1998 06:25
Subject: Re: Showstopper ORA-01467: sort key too long - PLEAAASEEE HEEELP

>Hi,
>
>What is block size of your database? Is it 2k? It is too small.
>You should increase it. Export full, recreate database with
>4k or 8k block size and then import full.
>
>Andrew Protasov
Received on Fri Nov 06 1998 - 01:58:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US