I have ORA-29855 error while importing data from production database. Can anybody solve this problem.
No problem at Production database.
. importing SPECTRA_TAKE_ OVER's objects into SPECTRA_TAKE_ OVER
. importing FREQPLAN's objects into FREQPLAN
IMP-00017: following statement failed with ORACLE error 29855:
"CREATE INDEX "GDG_SPATIAL_ IDX" ON "GEO_DATA_GEOM" ("GEO_GEOMETRY" ) INDEXT"
"YPE IS "MDSYS"."SPATIAL_ INDEX""
IMP-00003: ORACLE error 29855 encountered
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-06550: line 1, column 8:
PLS-00201: identifier 'MDSYS.MDPRVT_ IDX' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
ORA-06512: at "MDSYS.SDO_INDEX_ METHOD_10I" , line 10
ORA-06512: at line 1
. importing SPECTRA's objects into SPECTRA
IMP-00017: following statement failed with ORACLE error 29855:
"CREATE INDEX "SDG_SPATIAL_ IDX" ON "SITE_DATA_GEOM" ("SDG_GEOMETRY" ) INDEX"
"TYPE IS "MDSYS"."SPATIAL_ INDEX""
IMP-00003: ORACLE error 29855 encountered
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-06550: line 1, column 8:
PLS-00201: identifier 'MDSYS.MDPRVT_ IDX' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
ORA-06512: at "MDSYS.SDO_INDEX_ METHOD_10I" , line 10
ORA-06512: at line 1
. importing SPECTRA_TAKE_ OVER's objects into SPECTRA_TAKE_ OVER
. importing FREQPLAN's objects into FREQPLAN
Thanks and best regards
