--创建数据泵目录
create directory pump_dir as 'd:\db_backup';
--给用户授权
grant read on directory pump_dir to qhqy_user;
--数据导出
expdp qhqy/tr123@zhqy directory=pump_dir dumpfile=20120418.dmp logfile=20120418.log schemas=qhqy parallel=4;
--创建数据泵目录
create directory pump_dir as 'd:\db_backup';
--给用户授权
grant read on directory pump_dir to qhqy_user;
--数据导出
expdp qhqy/tr123@zhqy directory=pump_dir dumpfile=20120418.dmp logfile=20120418.log schemas=qhqy parallel=4;