Oracle Database Discussions

Hi,

I met the following error while I am doing IMPORT (creating ddl using INDEXFILE option) as.

imp system/oracle@hpfw9i file='F:\C2Prop\ProdDump20051109.dmp' fromuser=FWORKSADM touser=FWORKSADM indexfile=ddlfile.sql log=st-imp.log

. . skipping table "FWDEFECTCOMPONENT_PN21"
. . skipping table "FWDEFECTCOMPONENT_PN22"
. . skipping table "FWDEFECTCOMPONENT_PN23"
. . skipping table "FWDEFECTCOMPONENT_PN24"
. . skipping table "FWDEFECTCOMPONENT_PN25"
. . skipping table "FWDEFECTCOMPONENT_PN26"
. . skipping table "FWEQPATTRIBUTE"
. . skipping table "FWEQPATTRIBUTEHISTORY"

IMP-00009: abnormal end of export file
Import terminated successfully with warnings.

Have you ever experienced the following error message when you imported the db..?

Also I could see the import was not done successfully when I compared my ddlfileold.sql which is already done using this same dump file

My actions to make ddlfile

- I have tried three times to make ddlfile but I failed all and met the same error message.

try 1 : using 9210 version
try 2 : using 9206 version
try 3 : using 9206 version at other machine.

I need your advice and help.

Thanks,
Riaz.