Shulou(Shulou.com)06/01 Report--

On August 14, 2017, an implementation colleague encountered an error IMP-00009&IMP when importing dmp files exported by exp using imp, as shown in the figure:

The reason for the error may be that the dmp file itself is incomplete. If you still want to import data, you can control the imp command plus commit=yes, and the feasible imp import command:

Imp zhul/zhulei file=/home/oracle/other/yy_basj_lyzlyy.dmp log=/home/oracle/other/yy_basj_lyzlyy.log full=y commit=yes

When the import is executed again, an error is reported by imp: IMP-00015, as shown in the figure:

The reason for this error is very clear, that is, although there is no data imported in the first import, the table structure has been created. If you import it again, you need to delete the table structure and import it again after deletion.

The import was executed successfully:

It should be noted that although imp plus commit=yes can import the data from the problematic dmp file, it may lose the data, so it is recommended to re-export and then import again.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.