imp help=y 导入自己的表: 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
导入别人的表:
conn sys as sysdba; drop user test cascade; create user test identified by test;
下面是对的: 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 上面已经导入了,但又重复执行,会报错 imp test/[email?protected] file=D:scott_stu_add.dmp fromuser=scott touser=test 加上ignore 后,create 语句错误被忽略了,接着会执行后面的insert语句 imp test/[email?protected] file=D:scott_stu_add.dmp fromuser=scott touser=test ignore=y 下面这个是不对的: imp scott/[email?protected] file=D:scott_stu_add.dmp fromuser=scott touser=test
(编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|