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.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy