import with indexfile=xxx problem
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?
An ounce of prevention is worth a pound of cure