使用expdp、impdp导入导出数据
一、导出某张表数据
使用超级管理员登录
sqlplus sys/change_on_install@orcl as sysdba
create directory dbbak2 as 'D:\\bak2';
grant read,write on directory dbbak2 to public; --授权
退出
exit;
expdp 'sdj/sdj@orcl' directory=dbbak2 dumpfile=sdj_historydata.dmp tables=sdj.HISTORYDATA
二、导入某张表数据
使用超级管理员登录
sqlplus sys/change_on_install@orcl as sysdba
create directory dbbak2 as 'D:\\bak2';
grant read,write on directory dbbak2 to public; --授权
退出
exit;
impdp 'sdj/sdj@orcl' directory=dbbak2 dumpfile=sdj_historydata.dmp tables=sdj.HISTORYDATA
