Ora_setup error "ORA-01450: maximum key length (3118) exceeded" (86991)

Ora_setup error out with the following error:

SPLEX.SHAREPLEX_JOB_STATS already exists; continuing setup . . .
SPLEX.SHAREPLEX_DATAEQUATOR already exists; continuing setup . . .
SQL> CREATE GLOBAL TEMPORARY TABLE splex.SHAREPLEX_DATAEQUATOR_INS_TEMP
(OOS_ROWID VARCHAR2(4000) PRIMARY KEY) ON COMMIT PRESERVE ROWS

OCIStmtExecute: Oracle error ORA-01450: maximum key length (3118) exceeded

/xxxxx/oracle/SharePlex/yyyy/10g/prod/.app-modules/ora_setup: Failed to create objects.
[abcd]oracle@zzzzz $

The maximum key length is related to the blocksize. It depends on DB_BLOCK_SIZE

The minimum allowed size reported in ORA-01450 varies, depending on which block size the index is using:

If 2K block size then maximum index key length=758
If 4K block size then maximum index key length=1578
If 8K block size then maximum index key length=3218
If 16K block size then maximum index key length=6498

WORKAROUND:

Increase the database block size. Create a tablespace with bigger block size.