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

Andrew,
What does Block Size have to do with anything? And where did you get the value of 4k or 8k? Besides, changing the block size, means recreating the database. You are offerring drastic advise, why replace the car when the tire has a flat...and are we sure that the car is the reason for the flat?

Satar

In article <ABtWeGsK42_at_protasov.kiev.ua>,   oracle_at_protasov.kiev.ua wrote:
> 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
>
> > Hi,
> > I'm still porting from Sqlanywhere to ORACLE 7.3.3 under NT 4.0.
> > Now, it looks I have a showstopper.
> >
> > I've a view which look likes this:

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 06 1998 - 12:22:20 CST