Oracle导库那些事儿(三)

2015-03-04 17:08:28 · 作者: · 浏览: 189
ee_space to radpcs; grant select on dba_data_files to radpcs;

?

4.在sqlplus下创建Directory

命令:createdirectory oracleDB as 'D:\OracleDB';

5.把读写权限授予特定用户

命令:Grantread,write on directory oracleDB to radpcs;

6.在dos窗口执行impdp导入命令

命令:impdp radpcs/ictradpcs@rdpcs directory=oracleDB dumpfile=20150226.dmp logfile=20150226.log;

漫长的等待后,dos窗口会提示导出命令,是否出错提示。