Ora_setup errors 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.
Depending on the value of DB_BLOCK_SIZE, ora_setup can raise ORA-01450.
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
Create a tablespace for SharePlex using the following procedure, and then execute ora_setup.
1. Set the db_8k_cache_size parameter.
<Setting example>
alter system set db_8k_cache_size = 100M scope = both;
2. Create a tablespace with a DB block size of 8k.
<Creation example>
CREATE TABLESPACE splextbs
DATAFILE'/u01/app/oracle/oradata/orcl2/splextbs.dbf' SIZE 100M
AUTOEXTEND ON NEXT 500K MAXSIZE 1024M BLOCKSIZE 8K;
3. Specify the tablespace created by running ora_setup.
Enter the default tablespace for use by SharePlex [USERS]: SPLEXTBS
