import with indexfile=xxx problem

[farrokhp]

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?

[marist89]

Originally posted by farrokhp
why it skips tables?

Because you specified indexfile=.

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

[jmodic]

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).

ROWS = Y
IGNORE = N
COMMIT= Y

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