Ronan, Thank you for your reply - appreciate it... I presumed that querying USER_SDO_GEOM_METADATA would be the option used and my thanks for the confirmation. I am taking the route suggested by 463844.1 - I'll update as to how it goes. Thanks, --Rajesh On Tuesday, May 27, 2014, Ronan Merrick <merrickronan1@xxxxxxxxx> wrote: > 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<javascript:_e(%7B%7D,'cvml','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<javascript:_e(%7B%7D,'cvml','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<javascript:_e(%7B%7D,'cvml','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 >>>> >>> >> -- Sent from Gmail Mobile