I made export with "expdp" over source database and runned Import in destination database this way:
expdp userid=system/a@local.casino167 CONTENT=METADATA_ONLY FULL=Y DUMPFILE=exp_casino_ddl.dmp LOGFILE=exp_casino_ddl.log
impdp system/a@local.casino167 DIRECTORY=DATA_PUMP_DIR FULL=y DUMPFILE=EXP_CASINO_DDL.DMP LOGFILE=imp_casino.log
Then i looked into file "imp_casino.log" and i don't understand which line says that importing of my table's T1 foreign key constraint F1 is started?
Why i want to find that place in log file? Because the foreign key constraint "T1.F1" is missing in destination database, but in source database it exists.
I searched with phrase "F1" the import log file, didn't find it. I see that still check-constraints, and PK-constraint was created for the table T1.
Also i see that other tables got foreign key constraints.
I don't understand what could be the answer for the mistery.
(Oracle 10g, Linux OS)
And in import log file i see that some constraints but not the F1 failed in schema where T belongs to:
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-14071: invalid option for an index used to enforce a constraint
Failing sql is:
ALTER TABLE "CASINO"."AGENTOPERATORSERIALS" ADD CONSTRAINT "PK_AOS_AGENT_END_START" PRIMARY KEY ("AGENTOPERATORCODE", "ENDDATE", "STARTDATE") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPRESS 1 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "INDX" ENABLE
ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-14071: invalid option for an index used to enforce a constraint
...
(7 similar fails more below, but not F1)
I understand that creation of FK-constraints for my schema is done on section
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
But i don't see anywhere in log file F1 or T1.
I see that new data pump tools (impdb/expdb) are bad, and old good imp/exp are good, because they produced in log files exactly the things that they execute and one could analyze where is the problem.
Edited by: CharlesRoos on 17.12.2010 18:50