Resolution:
You get this error in cases where the oracle database has been created with insufficient value for db_block_size parameter. As a result of smaller value for db_block_size, the combined length of all the columns specified in a CREATE INDEX statement in the sql script exceeded themaximum index length. The maximum index length varies by operating system. The total index length
is computed as the sum of the width of all indexed columns plus the number of indexed columns.
Date fields have a length of 7, character fields have their defined length, and numeric fields
have a length of 22. Numeric length = (precision/2) + 1. If negative, add +1.

According to oracle documentation, a value higher than 8K is usually recommended(range 2048 to 32768). Below
is the correlation between db_block_size and index key length:

DB_BLOCK_SIZE: Maximum Index Key Length:
=============== =====================

2K (2048) 758 Bytes
4K (4096) 1578 Bytes
8K (8192) 3218 Bytes
16K (16384) 6498 Bytes

Action:

1. Action: Select columns to be indexed so the total index length does not exceed the maximum index
length for the operating system. Pl. check with support@tibco.com before creating your custom indices.

2. So you could recreate your database after specifying 8K(8192 or more) for db_block_size in
$ORACLE_HOME/rdbms/install/rdbms/cnfg.orc file.....

When creating BC tables using the oracle sql scripts, I see error "ORA-01450: maximum key length (1578) exceeded". What is the cause and how can it be rectified?.

Product: TIBCO BusinessConnect Version: 3.0.0, 3.0.1 OS: HP 11.00 --------------------