Hi Rajesh, I checked USER_SDO_GEOM_METADATA. All of our indexes had the same tolerance values for x and y if I remember correctly so I got the values from the other indexes there. Once I knew that and the column being indexed, I could populate USER_SDO_GEOM_METADATA. Ronan On 28 May 2014 00:22, "Rajesh Aialavajjala" <r.aialavajjala@xxxxxxxxx> wrote: > Ronan, > If I might ask - what means did you use to obtain the "Spatial metadata" > for insertion into user_sdo_geom_metadata - the note makes a reference to > "ask your spatial developer" - is that just saying query the information > yourself ? > > Thanks, > > --Rajesh > > > On Tue, May 27, 2014 at 7:18 PM, Ronan Merrick <merrickronan1@xxxxxxxxx>wrote: > >> Hi Rajesh, >> >> I had this problem before. MOS 463844.1 sorted it out for me. >> >> Ronan >> On 27 May 2014 14:46, "Rajesh Aialavajjala" <r.aialavajjala@xxxxxxxxx> >> wrote: >> >>> I am encountering the following errors during the use of data pump to >>> migrate an EBS instance following instructions in "Export/import >>> process for 12.0 or 12.1 using 11gR1 or 11gR2 (Doc ID 741818.1)" - >>> specifically >>> >>> expdp "'/ as sysdba'" parfile=auexpdp.dat >>> >>> Processing object type >>> DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX >>> ORA-39127: unexpected error from call to local_str := >>> SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('CTRY_SPATIAL_IDX','PTG','SDO_INDEX_METHOD_10I','MDSYS',11.02.00.00.00,newblock,0) >>> ORA-01403: no data found >>> ORA-01403: no data found >>> ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 270 >>> ORA-06512: at line 1 >>> ORA-06512: at "SYS.DBMS_METADATA", line 8360 >>> >>> >>> To isolate - I picked one failing table - PTG.COUNTRY and a standalone >>> export produces the same error >>> >>> expdp "'/ as sysdba'" directory=dbadmpdir dumpfile=ptg_country.dmp >>> full=no tables=PTG.COUNTRY logfile=exp_ptg_country.log >>> >>> Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS >>> ORA-39127: unexpected error from call to local_str := >>> SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('CTRY_SPATIAL_IDX','PTG','SDO_INDEX_METHOD_10I','MDSYS',11.02.00.00.00,newblock,0) >>> ORA-01403: no data found >>> ORA-01403: no data found >>> ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 270 >>> ORA-06512: at line 1 >>> ORA-06512: at "SYS.DBMS_METADATA", line 8360 >>> Processing object type TABLE_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX >>> . . exported "PTG"."COUNTRY" 0 KB >>> 0 rows >>> >>> Oddly enough - on a VISION environment - this error fails to reproduce >>> >>> Any thoughts on what might be causing this ? I'd appreciate any >>> insights... >>> >>> Thanks, >>> >>> --Rajesh >>> >> >