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?

Quote:

---

Originally posted by farrokhp
why it skips tables?

---

Because you specified indexfile=.

http://download-west.oracle.com/docs...ch02.htm#17192

Quote:

---

Originally posted by farrokhp
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.

---

Nothing gets created inside the database if you specify INDEXFILE parameter in import. The only things that actually gets created is the indexfile outputfile itself (plus eventual logfile).

Quote:

---

ROWS = Y
IGNORE = N
COMMIT= Y

---

All this parameters are redundan and totaly useless when there is INDEXFILE parameter specified.