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 09:45:45 -0400
Message-ID: <CAGvtKv6B-Z94+aSSuwoWv2ABT-YSNBQ19EMOxvAx7HkmQ6URvw_at_mail.gmail.com>

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 Received on Tue May 27 2014 - 15:45:45 CEST