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

From: Rajesh Aialavajjala <r.aialavajjala_at_gmail.com>
Date: Tue, 27 May 2014 20:49:21 -0400
Message-ID: <CAGvtKv4xqE8dfwaD-etH7=_weQxc9vq0v80Nbpq26F1MZmNzkQ_at_mail.gmail.com>

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_at_gmail.com> 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_at_gmail.com<javascript:_e(%7B%7D,'cvml','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<javascript:_e(%7B%7D,'cvml','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<javascript:_e(%7B%7D,'cvml','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
>>>>
>>>
>>

-- 
Sent from Gmail Mobile

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

Received on Wed May 28 2014 - 02:49:21 CEST