problem during exportation from 9 to 8: question of character??

From: roberto santinelli <robertos.esc_at_dbcaditaly.com>
Date: Fri, 16 May 2003 14:45:08 +0200
Message-ID: <ba2mgp$ok08e$1@ID-195100.news.dfncis.de>

Hi everybody,
i have the need to export an user containing SPATIAL DATA (table particelle) with field named "geometry", stored in my company DB Oracle 9i to an Oracle 8i DataBase for a client.
For this task we used the export utility provided with the client 8.i and not doubt , the result of this operation shows the following error message :

---

 EXP-00008: errore ORACLE 0 rilevato
ORA-00000: normale, completato con successo EXP-00078: Errore nell'esportazione dei metadati per l'indice IDX_PARTICELLE. La
 creazione dell'indice verrÓ saltata

EXP-00008: errore ORACLE 0 rilevato
ORA-00000: normale, completato con successo
EXP-00078: Errore nell'esportazione dei metadati per l'indice

IDX_PARTICELLE. La
 creazione dell'indice verrÓ saltata

. esportazione delle azioni di posttable in corso
. sto esportando istantanee
. sto esportando log di istantanee
. esportazione code dei lavori in corso
. esportazione gruppi e figli di aggiornamento in corso
. esportazione dimensioni in corso
. esportazione oggetti e azioni procedurali post-schema in corso
. esportazione statistiche

abnormal program termination

---

**
Sorry for the italian language of this error message !!!! Passing from the server DBMS with a given character set (WE8MSWIN1252) to the exportation target (WE8ISO8859P1) there's a possible conversion of character.
Let me remind another absolutely similar problem met in the same context: as matter of fact, indeed, the full export/import operation was'nt accomplished successfully neither using the 9i version alone (exp with 9 imp with 9) of the same table.

No problem for the exportation, but during the importation (sorry once again for italian error message) i got the following:

---

IMP-00017: l'istruzione seguente non Þ riuscita causa errore ORACLE 6550:  ///l'importazione non e' riuscita a fare il seguente statement PL/SQL
"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,

'PARTICELLE','GEOMETRY',mdsys.SDO_dim_array(MDSYS.SDO"

"_DIM_ELEMENT('X',2289618,03833368,2322007,1969373,,0000000005),MDSYS.SDO_DI "

"M_ELEMENT('Y',4763443,98323665,4795827,11076764,,0000000005),MDSYS.SDO_DIM_ "
"ELEMENT('Z',0,0,,0000000005)),NULL) ;
else execute immediate 'INSERT "
"INTO USER_SDO_GEOM_METADATA values

(''PARTICELLE'',''GEOMETRY'',mdsys.SDO_d"

"im_array(MDSYS.SDO_DIM_ELEMENT(''X'',2289618,03833368,2322007,1969373,,0000 "

"000005),MDSYS.SDO_DIM_ELEMENT(''Y'',4763443,98323665,4795827,11076764,,0000 "
"000005),MDSYS.SDO_DIM_ELEMENT(''Z'',0,0,,0000000005)),NULL) ' ; end if;
en"
"d; "
"COMMIT; END;"

IMP-00003: Riscontrato errore ORACLE 6550
ORA-06550: riga 2, colonna 426:
PLS-00103: Trovato il simbolo "," anzichÚ uno dei seguenti:
********************************************************************

It founds some kind of problem in the decimal separator "," (while it should be ".") . Thereafter it does'nt update the metadata table and consequently it does'nt ables the spatial index creation.

NOW I'M ASKING YOU: DO YOU HAVE ALREADY MET WITH THIS PROBLEM (it' s possible nobody has the need to export its spatial data in to another database?????) .
OR DO YOU HAVE IDEA ABOUT HOW TO OVERCOME IT?? Thanks for your patience and, in adance for every kind of help you can provide me,
Roberto Received on Fri May 16 2003 - 07:45:08 CDT