Re: Exporting Domain Index PTG.CTRY_SPATIAL_IDX results in ORA-39127 and ORA-06512

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_at_gmail.com> 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_at_gmail.com>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_at_gmail.com>
>> 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
>>>
>>
>

--
http://www.freelists.org/webpage/oracle-l