Try to import fromuser touser with indexfile=xxxx, I was expecting tables with data created but instead of index the sql file xxx.sql contents index script, but tables did not created as well.

Here is the parfile

fromuser=scott
touser=s4
file=f:\napp_scott.dmp
log=f:\napp_s4_import.log
ROWS = Y
IGNORE = N
COMMIT= Y
INDEXFILE=f:\xxx.sql

and this is output:


import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. . skipping table "BONUS"

. . skipping table "DEPT"

. . skipping table "EMP"

. . skipping table "SALGRADE"

Import terminated successfully without warnings.


why it skips tables?