Hi,
I am trying to import an index organized table from one schema to another in a different machine, I get the following error :
-----------------------------------------------------------
Export file created by EXPORT:V10.01.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing PROADMIN2_PRD's objects into PROADMIN2_PRD
. . importing table "PRO_RELATIONS_CHILD"
IMP-00058: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"CREATE INDEX "IDX_CHILD_RECORD_ID" ON "PRO_RELATIONS_CHILD" ("RECORD_ID" ) "
" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 4194304 FREELISTS 1 FRE"
"ELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TBS_IDX_QUEUE_DATA" NOLOGGI"
"NG"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 20000:
"BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"IDX_CHILD_RECORD_ID"',NULL,NULL,NU"
"LL,5728901,48154,85602,1,66,5728901,2,2); END;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000: INDEX "PROADMIN2_PRD"."IDX_CHILD_RECORD_ID" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 1688
ORA-06512: at "SYS.DBMS_STATS", line 4781
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 942:
------------------------------------------------------------
I run Oracle 10.1.0.3. on both machines. I don't get this error for ordinary tables imported the same way, but for IOT.
thanx,
V Jikki