Re: Exporting Domain Index PTG.CTRY_SPATIAL_IDX results in ORA-39127 and ORA-06512
- From: Rajesh Aialavajjala <r.aialavajjala@xxxxxxxxx>
- To: sumit Tyagi <dba.tyagisumit@xxxxxxxxx>
- Date: Tue, 27 May 2014 12:48:55 -0400
Sumit,
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@xxxxxxxxx>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@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
>>
>
>
>
> --
>
> *--*
> *BR*
> *Sumit Tyagi*
> *+91-7829543355 <%2B91-7829543355>*
>
Other related posts:
