Spatial (MOSC)

MOSC Banner

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;

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