http://www.itpub.net/showthread.php?s=&threadid=105392http://www.oradb.net/expimp/expimp_011.htm
http://www.itpub.net/showthread.php?s=&threadid=12023
http://www.macro-base.com/zxjs/wenzhang2.htm
http://www.itpub.net/showthread.php?s=&threadid=12023
http://www.macro-base.com/zxjs/wenzhang2.htm
救世主。。救我啊!·
你的问题:在IMP命令的后面加上Ignore=y就应该OK了!!试试!
compress=n
buffer=10000000
file=G:\exp\localdev\exp_dev_ehtemp.DMP
grants=Y
indexes=Y
rows=Y
constraints=Y
owner=ehtemp;imp userid = ehtemp/ehtemp@dev
LOG=imp_dev_ehtemp.log
buffer=10000000
file=G:\exp\localdev\exp_dev_ehtemp.DMP
grants=Y
indexes=Y
rows=Y
Commit=Y
Ignore=N
constraints=Y;
IMP 用户名/密码@system file=add full=y
del "E:\Program Files\add\CreateDataBaseTag.cmd"
create tablespace system datafile '路径' size 500M autoextend on next 100M maxsize 1000M;
create user 用户名 identified by 密码 default tablespace system temporary tablespace temp;
grant resource ,connect ,DBA,create table to 用户名;
exit