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 -> Function Based Index

Function Based Index

From: rplumley <member26369_at_dbforums.com>
Date: Tue, 11 Mar 2003 21:51:04 +0000
Message-ID: <2631616.1047419464@dbforums.com>

I am creating a function based index on a partitioned table. I am getting the ORA-01450. This error message indicates that the length of each of the columns and the number of columns (added together) must be less than an operational specific number. Our block size is 8K, so it appears that approximately 2000 to 3000 should suffice.

However, the total size of the columns is less than 60, but I am creating a function based index.

Does anyone know if the size of the function is added to the size of the index?

Thank you for any support (or insight).

--
Posted via http://dbforums.com
Received on Tue Mar 11 2003 - 15:51:04 CST

Original text of this message

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