The maximum length of an index is a function of the Oracle block size.
Since Oracle 8, the maximum length of a varchar2 is 4000 (no bigger even in
9i). An index entry is limited in length to 1/3 the block size, so to get
an index on a varchar2(4000) column, you would need a 16K block size.
Steve
-----Original Message-----
From: Stacy Mader [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 18 September 2001 10:46 AM
To: DBI Users
Subject: Oracle field lengths
Hi all,
I'm running Oracle 7.3.3 (I know, its rather old) under Solaris 2.5...
With
most of our tables, the maximum number of characters (varchar2)
is set to 2000 - I think this is because anything longer does not allow
you to perform a search on indexed fields...
Do the newer versions of Oracle allow you to extend the length
to beyond 2000 characters and still allow you to search?
Thanks,
Stacy.
