exp/imp NLS_NUMERIC_CHARACTERS problem

From: Holger Bruch <bruch_at_logiball.de>
Date: Mon, 16 Jul 2001 10:50:05 +0200
Message-ID: <3B52AABD.15FFD67E_at_logiball.de>

Hi,

when exporting/importing a user via exp/imp I encounter a problem with the numeric characters encoding during creation of a spatial index:

Without setting NLS_NUMERIC_CHARACTERS exporting and reimporting leads to
a wrong representation of the numeric value '0,005' as ,005 (missing single quotes):

IMP-00088: Problem beim Importieren von Metadaten f³r Index GDF_SDO_AREAS_IDX. I
ndexerstellung wird ³bersprungen
IMP-00017: Nachfolgende Anweisung war wegen Oracle-Fehler 936 erfolglos:
"BEGIN "
"execute immediate 'INSERT INTO USER_SDO_GEOM_METADATA values (''POI"

"NTS'',''GEOMETRY'',mdsys.SDO_dim_array(MDSYS.SDO_DIM_ELEMENT(''X'',50000000,"

"160000000,,005),MDSYS.SDO_DIM_ELEMENT(''Y'',450000000,600000000,,005)),,005"
") ' ; "
"COMMIT; END;"

IMP-00003: Oracle-Fehler 936 gefunden
ORA-00936: missing expression
ORA-06512: at line 2
IMP-00088: Problem beim Importieren von Metadaten f³r Index POINTS_IDX.

I
ndexerstellung wird ³bersprungen

After setting the NLS_NUMERIC_CHARACTERS variable to ".," and exporting again
the numeric value is represented as "005 (decimal seperator is missing, closing quote as well):

IMP-00017: Nachfolgende Anweisung war wegen Oracle-Fehler 972 erfolglos:
"BEGIN "
"execute immediate 'INSERT INTO USER_SDO_GEOM_METADATA values (''POI"

"NTS'',''GEOMETRY'',mdsys.SDO_dim_array(MDSYS.SDO_DIM_ELEMENT(''X'',50000000"

",160000000,"005),MDSYS.SDO_DIM_ELEMENT(''Y'',450000000,600000000,"005)),"00"
"5) ' ; "
"COMMIT; END;"

IMP-00003: Oracle-Fehler 972 gefunden
ORA-00972: identifier is too long
ORA-06512: at line 2
IMP-00088: Problem beim Importieren von Metadaten f³r Index POINTS_IDX.

Indexerstellung wird ³bersprungen

Originally, the index was created via
INSERT INTO USER_SDO_GEOM_METADATA
  VALUES (
  'points',
  'geometry',
  MDSYS.SDO_DIM_ARRAY(
    MDSYS.SDO_DIM_ELEMENT('X',-125000000,-115000000, '0,005'),     MDSYS.SDO_DIM_ELEMENT('Y', 30000000, 42100000, '0,005')      ),
  NULL
);

Any hints how to reimport the index correctly?

Thanks,

Holger Received on Mon Jul 16 2001 - 10:50:05 CEST