Here is the parameter file:

userid=*****/*****
touser=custom
constraints=N
ignore=Y
rows=Y

You may wonder why I am saying ignore=Y, with an empty schema. When I chose ignore=N, I was getting errors saying CREATE table failed because object already exists (in an empty schema!!) Oracle support said there was a bug and suggested I use ignore=Y.

I am passing fromuser via a shell script.

#!/bin/ksh
clear

PIPEFILE=/of11dev3-01/apphome/tkhis_full_pipe.dmp
FILENAME=/of11dev3-01/apphome/tkhis20051216_14:41:02.dmp.gz
cat $FILENAME | gunzip > $PIPEFILE &

fromuser="GL RG HR SSP HXT OTA RLA VEH QA ICX AZ AR OE OSM PA CN INV PO BOM ENG MRP CRP WIP PJM CS CE EC MLJA"
for i in $fromuser
do
echo "$i\n"
imp fromuser=$i parfile=/of11dev3-01/apphome/imp_tkhis_full.par file=$PIPEFILE log=tkhis_full_dmp.log
done

The import log is almost a gig in size, too big to post to post it here.

Mind you, the import does successfully get some tables, but fails with the unique constraint error for others. I chose constraints=N after getting the errors, but I am still getting the constraint errors.