"MDSYS"."SDO_ORDINATE_ARRAY" does not exist or has different identifier
Hi,
I am trying to import spatial (locator) data into Oracle 10g XE, but I am getting the error message below. Could some one please shed some light on it, why am I getting the error message and how to get around it? TIA.
. importing GEOSERVER's objects into COINS_MOBIL
. importing GEOSERVER's objects into COINS_MOBIL
IMP-00060: Warning: Skipping table "COINS_MOBIL"."VEZSZAKOK_GEOM" because object type *"MDSYS"."SDO_ORDINATE_ARRAY" does*
not exist or has different identifier
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"declare schema_name varchar2(200); username varchar2(64); begin execute i"
"mmediate 'select sys_context(''userenv'', ''CURRENT_SCHEMA'') from dual '"
" into schema_name; execute immediate 'select user from dual ' into userna"
"me; if username != schema_name then mdsys.sdo_meta.change_all_sdo_geom_"
"metadata(schema_name, 'VEZSZAKOK_GEOM','OBJEKTUM_GEOMETRIA',mdsys.SDO_dim_a"
"rray(MDSYS.SDO_DIM_ELEMENT('X',600000,900000,.001),MDSYS.SDO_DIM_ELEMENT('X"
"',150000,400000,.001)),23700) ; else execute immediate ' begin del"
"ete from user_sdo_geom_metadata where table_name= ''VEZSZAKOK_GEOM'' and co"
"lumn_name= ''OBJEKTUM_GEOMETRIA''; INSERT INTO USER_SDO_GEOM_METADATA value"
"s (''VEZSZAKOK_GEOM'',''OBJEKTUM_GEOMETRIA'',mdsys.SDO_dim_array(MDSYS.SDO_"
"DIM_ELEMENT(''X'',600000,900000,.001),MDSYS.SDO_DIM_ELEMENT(''X'',150000,40"
"0000,.001)),23700); end; ' ; end if; end; "
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 361:
PLS-00201: identifier 'MDSYS.SDO_DIM_ARRAY' must be declared
ORA-06550: line 2, column 266:
PL/SQL: Statement ignored
IMP-00088: Problem importing metadata for index IDX_VEZSZAKOK_GEOM. Index creation will be skipped
IMP-00017: following statement failed with ORACLE error 1418:
"ANALYZE INDEX "VEZSZAKOK_GEOM_PK" ESTIMATE STATISTICS "
IMP-00003: ORACLE error 1418 encountered
ORA-01418: specified index does not exist
Import terminated successfully with warnings
Tamas
Edited by: Tamas Szecsy on Dec 16, 2010 11:01 PM
Edited by: Tamas Szecsy on Dec 16, 2010 11:02 PM