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

 Thanks for your reply - the status shows VALID - I also took the liberty of looking at the SDO_GEOM_METADATA_TABLE (s)- and found that the required metadata is present (sorry for the formatting mess on the 2nd query...)

Thanks,

--Rajesh

SQL> l

  1 SELECT   2 OWNER,INDEX_NAME,INDEX_TYPE,TABLE_OWNER,TABLE_NAME,TABLE_TYPE,STATUS,DOMIDX_STATUS,DOMIDX_OPSTATUS,FUNCIDX_STATUS FROM DBA_INDEXES   3 WHERE INDEX_NAME IN
('CTRY_SPATIAL_IDX','CITY_SPATIAL_IDX','PCODE_SPATIAL_IDX','STATE_SPATIAL_IDX','UD_SPATIAL_IDX','CNTY_SPATIAL_IDX')   4* AND OWNER='PTG' SQL> /

OWNER                          INDEX_NAME
INDEX_TYPE                  TABLE_OWNER                    TABLE_NAME
                   TABLE_TYPE  STATUS   DOMIDX_STATU DOMIDX FUNCIDX_



------------------------------ ------------------------------

--------------------------- ------------------------------

------------------------------ ----------- -------- ------------

• --------

PTG                            CITY_SPATIAL_IDX               DOMAIN
                   PTG                            CITY
          TABLE       VALID    VALID        VALID

PTG                            CNTY_SPATIAL_IDX               DOMAIN
                   PTG                            COUNTY
          TABLE       VALID    VALID        VALID

PTG                            CTRY_SPATIAL_IDX               DOMAIN
                   PTG                            COUNTRY
          TABLE       VALID    VALID        VALID

PTG                            PCODE_SPATIAL_IDX              DOMAIN
                   PTG                            POSTALCODE
          TABLE       VALID    VALID        VALID

PTG                            STATE_SPATIAL_IDX              DOMAIN
                   PTG                            STATE
          TABLE       VALID    VALID        VALID

PTG                            UD_SPATIAL_IDX                 DOMAIN
                   PTG                            USERDEFINED
          TABLE       VALID    VALID        VALID

SQL>
l

1* select * from MDSYS.SDO_GEOM_METADATA_TABLE where sdo_table_name='POSTALCODE' and sdo_column_name='GEOMETRY'

SQL>
/

SDO_OWNER
SDO_TABLE_NAME
SDO_COLUMN_NAME SDO_DIMINFO(SDO_DIMNAME, SDO_LB, SDO_UB,
SDO_TOLERANCE)
SDO_SRID



--------------------------------

-------------------------------- ---------------

-----------------------------------------------------------------------------------------------

PTG
POSTALCODE
GEOMETRY SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', -180, 180, .000005), SDO_DIM_ELEMENT('Y', -90, 90, .000005)) 8307

WIRELESS
POSTALCODE
GEOMETRY
SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', -180, 180, .5), SDO_DIM_ELEMENT('Y', -90, 90, .5))
8307

On Tue, May 27, 2014 at 12:45 PM, sumit Tyagi <dba.tyagisumit_at_gmail.com>wrote:

> have you checked the "status, domidx_status and domidx_opstatus" of your
> domain index from the dba_indexes view.
>
> Please share the status. Status shold be valid and not failed.
>
>
> On Tue, May 27, 2014 at 7:15 PM, 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
>>
>
>
>
> --
>
> *--*
> *BR*
> *Sumit Tyagi*
> *+91-7829543355 <%2B91-7829543355>*
>

--

http://www.freelists.org/webpage/oracle-l Received on Tue May 27 2014 - 18:48:55 CEST