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