oracle用数据泵导入导出数据

1、新建导出目录，进入sys用户create or replace directory data as 媪青怍牙'G:\baidu\data';grant read, write on directory data to wll;在G盘手工建好baidu文件夹，baidu文件夹下建好data文件夹。

2、导出：在cmd下执行命令expdp wll/wll@orc盟敢势袂l directory=data dumpfile=wll0823.dmp logfile=wll0823.log

3、导入impdp wll/wll@orcldirectory=datadumpfile=wll0823.dmp logfile=impdpwll0823.log

4、检查是否导入数据