Database Administration (MOSC)

MOSC Banner

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),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center