Oracle IMP DMP

Tag: DDR error OTT ADE repeat ASC Cascade self-executing

Imp help=y
To import your own tables:
Exp Scott/[email protected] tables= (student, address) File=d:\scott_stu_add.dmp Log=d:\scott_stu_add.log
Imp scott/[email protected] file=d:\scott_stu_add.dmp Log=d:log.log
Imp scott/[email protected] file=d:\scott_stu_add.dmp tables=student

Import someone else's table:

Conn Sys as SYSDBA;
Drop user test cascade;
Create user test identified by test;

Here's the right one:
Imp test/[email protected] file=d:\scott_stu_add.dmp Fromuser=scott touser=test
Imp sys/[email protected] file=d:\scott_stu_add.dmp Fromuser=scott touser=test
The above has been imported, but repeated execution, will be error
Imp test/[email protected] file=d:\scott_stu_add.dmp Fromuser=scott touser=test
After adding ignore, the CREATE statement error is ignored, followed by the INSERT statement
Imp test/[email protected] file=d:\scott_stu_add.dmp Fromuser=scott touser=test ignore=y
Here's the wrong one:
Imp scott/[email protected] file=d:\scott_stu_add.dmp Fromuser=scott touser=test

Oracle IMP DMP