Nobody yet answered you?
Unlucky boy.........
"roberto santinelli" <robertos.esc_at_dbcaditaly.com> ha scritto nel messaggio
news:ba2mgp$ok08e$1_at_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 Thu May 22 2003 - 10:03:34 CDT
