Spatial Index Creation Error for Table with german Umlaute
We are trying to create a spatial index for a table with special character name on Oracle Enterprise Edition 19.21 with Spatial installed. Same error on 19.17.
This one works perfect:
CREATE TABLE "TOPOGRAFIE"."GEBAEUDEGRENZEN2" ( "FID" NUMBER(10), "GEOM" "MDSYS"."SDO_GEOMETRY", "AREA" NUMBER(20, 8), "GEBÄUDENUMMER" NVARCHAR2(100), "GEBÄUDEBEZEICHNUNG" NVARCHAR2(200), "STRASSENBEZEICHNUNG" NUMBER(10), "FID_WZB" NUMBER(10), "ID_GEBAEUDE_NUTZUNG" NUMBER(10), "ID_GEMARKUNG" NUMBER(10), "FLUR" NUMBER(10), "FLURSTUECK" NVARCHAR2(10), "FID_EIGENTUEMER" NUMBER(10), "ERRICHTUNGSDATUM" DATE, "LETZTE_AENDERUNG" DATE, "BGF" NUMBER(10, 2), "KGF" NUMBER(10, 2), "NRF" NUMBER(10, 2), "NUF" NUMBER(10, 2), "TF" NUMBER(10, 2), "VF" NUMBER(10, 2), "BRI" NUMBER(10, 2), "FID_ORG" NUMBER(10), "ANSPRECHPARTNER_VERANTWORTLICH" NUMBER(10), "ANSPRECHPARTNER_OPERATIV" NUMBER(10), "GEBAEUDENUMMER" NVARCHAR2(100), "ABBRUCHDATUM" DATE, "GEBAEUDEBEZEICHNUNG" NVARCHAR2(200), CONSTRAINT "GEBAEUDEGRENZEN2_P" PRIMARY KEY ("FID") VALIDATE ) TABLESPACE "USERS" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS;