oralce 导入导出命令

expdp userid='test/test' schemas=test directory=DATA_FILE_DIR dumpfile=test.dmp  logfile=test.log version=10.2.0.1.0
impdp userid='test/test@orcl' DIRECTORY=DATA_FILE_DIR dumpfile=TEST.dmp  version=10.2.0.1.0

 

1.查看目录及权限

SELECT privilege, directory_name, DIRECTORY_PATH FROM user_tab_privs t, all_directories d WHERE t.table_name(+) = d.directory_name ORDER BY 2, 1;

2.创建DIRECTORY

create OR REPLACE directory DATA_FILE_DIR as 'E:\oracle\demo\schema\sales_history';

3.授权

Grant read,write on directory DATA_FILE_DIR to dcops;