ORACEL数据库导入导出命令 expdp/impdp

教程:

http://blog.csdn.net/giianhui/article/details/7788550

http://www.cnblogs.com/fjfzhkb/archive/2007/09/03/879807.html

 

SQL语句命令(expdp/impdp方法):

create or replace directory expdir as 'D:\backup ';

grant read,write on directory expdir to public

select * from dba_directories

CMD命令:

expdp zbwlnew/111111@BKWL schemas=zbwlnew dumpfile=20170608.dmp
directory=expdir

CMD正式机命令(博科数据库):

expdp zbwl/zbwl@zbwl schemas=zbwl dumpfile=201706081.dmp
directory=expdir

 

地址为10.0.0.172服务器上D:\app\Administrator\admin\zbwl\dpdump\20170608.dmp

 

SQL语句命令(exp/imp方法):

导入:

imp zbwlnew/111111@BKWL FILE=F:\博科数据库备份文件

\zbwl20170602.dmp     ignore=y full=y

导出:

exp zbwl/zbwl@zbwl file=d:\daochu.dmp full=y

posted @ 2017-06-08 15:40  zhenximeiyitian  阅读(179)  评论(0编辑  收藏  举报