oracle导出-导入语句
导出
exp name/pwd@127.0.0.1/servicename file=d:\orcl.dmp full=y
imp name/pwd file=d:\xxx.dmp full=yimp usr_hq_0/111111@urpdb file=c:/a.dmp fromuser=usr_hq_0 touser=usr_hq_0imp name/pwd@127.0.0.1/servicename file=d:\orcl.dmp fromuser=name touser=name
drop user usr_hq_0 cascade;
exp username/password@servicename file=filename owner=(user1,user2)
imp system/manager@TEST file=d:daochu.dmp tables=(table1)