Home » RDBMS Server » Server Administration » indexes very urgent!!
indexes very urgent!! [message #59009] Tue, 21 October 2003 09:47 Go to next message
Kapil
Messages: 145
Registered: May 2002
Senior Member
create index t_idx on t(myfunc(a));
*
ERROR at line 1:
ORA-01450: maximum key length (3218) exceeded

Report message to a moderator

Re: indexes very urgent!! [message #59014 is a reply to message #59009] Tue, 21 October 2003 19:21 Go to previous message
fly
Messages: 4
Registered: October 2003
Junior Member
The index key size is limited by the value of db_block_size.what's the value of your db_block_size?

Report message to a moderator

Previous Topic: Date datatypes and indexes
Next Topic: Urgent!!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 15:25:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.