cannot build index - ORA-01450: maximum key length (3215) exceeded
Hi,
working on oracle 12.2 Enterprise.
MAX_STRING_SIZE is standard, charset is AL32UTF8.
I have 2 tables in the SAME database
CREATE TABLE "CATID"."ABIEC_ADDRESS"
( "ID" NUMBER(19,0) NOT NULL ENABLE,
"VERSION" NUMBER(10,0) NOT NULL ENABLE,
"CITY" VARCHAR2(255 CHAR),
"COUNTRY" VARCHAR2(255 CHAR),
"HOUSENUMBER" VARCHAR2(255 CHAR),
"STREET" VARCHAR2(255 CHAR),
"ZIP" VARCHAR2(255 CHAR),
"BELMAPADDRESSID" NUMBER(19,0),
"BELMAPSTREETID" NUMBER(19,0),
"BELMAPVALID" NUMBER(1,0),
"EXPORTABLE" NUMBER(1,0) DEFAULT 1,
"BIEXPORT_BATCHID" NUMBER(10,0),
PRIMARY KEY ("ID"));
CREATE TABLE "BORABIEC"."ABIEC_ADDRESS"
( "ID" NUMBER(19,0) NOT NULL ENABLE,
"CITY" VARCHAR2(255 CHAR),
"COUNTRY" VARCHAR2(255 CHAR),
"HOUSENUMBER" VARCHAR2(255 CHAR),
"STREET" VARCHAR2(255 CHAR),
"VERSION" NUMBER(10,0) NOT NULL ENABLE,
"ZIP" VARCHAR2(255 CHAR),
"BELMAPADDRESSID" NUMBER(19,0),
"BELMAPSTREETID" NUMBER(19,0),