Hi,
I have created a SQL script containing the command:
host exp user/pwd@db file=dmp/produkt.dmp log=log/ex_produkt.log tables=produkt rows=y grants=n indexes=n constraints=n triggers=n
It works perfectly well, in the log file it sais:
... rows exported
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
Then I have another SQL script containing the commands:
truncate table owner.produkt;
host imp user/pwd@db file=dmp/produkt.dmp log=log/im_produkt.log tables=produkt ignore=y
This command does load the data in the table, but then the dos box does not close, so my script does not continue until I manually close the dos box. Also, a log file is created but no information is written in it.
If I remove the "ignore=y" option, then the dos box DOES close automatically and in the log file I get the "can't create table ..." error. But that is why the ignore option is invented of course.
Any ideas on what I can do or check to solve this problem?
Start Free Trial
