达梦dexpdp和dimpdp

只能在数据库服务器上执行

 

创建directory
su - dmdba
[dmdba@host135 tmp]$mkdir -p /dmdbms/mydir
disql sysdba/dameng123
SQL> create directory "dmdir" as '/dmdbms/mydir';
注意这里需要双引号引起来,而且不能使用/tmp目录

赋予目前权限给到具体用户

SQL>grant write,read on directory "dmdir" to HXL;

 

全库:
/dmdbms/product/bin/dexpdp userid=sysdba/dameng123 file=full.dmp log=full.log full=y directory=dmdir;

指定用户:
/dmdbms/product/bin/dexpdp userid=sysdba/dameng123 file=hxl.dmp log=hxl.log owner=hxl directory=dmdir;

指定模式:
/dmdbms/product/bin/dexpdp userid=sysdba/dameng123 file=moshi_hxl.dmp log=moshi_hxl.log schemas=hxl directory=dmdir;

指定表:
/dmdbms/product/bin/dexpdp userid=sysdba/dameng123 file=aa.dmp log=aa.log tables=hxl.tb_test02 directory=dmdir;

指定查询语句:
/dmdbms/product/bin/dexpdp userid=sysdba/dameng123 file=bb.dmp log=bb.log tables=hxl.tb_test02 directory=dmdir query="where id=1";

 

例子1(dexpdp/dimpdp):

 

导出
dexpdp userid=sysdba/dameng123 file=HXL.dmp log=HXL.log owner=HXL directory=dmdir;

导入到同个用户:
dimpdp userid=sysdba/dameng123 FILE=HXL.dmp DIRECTORY=dmdir LOG=imp.log OWNER=HXL

导入不同用户:
dimpdp userid=sysdba/dameng123 FILE=HXL.dmp DIRECTORY=dmdir LOG=imp.log REMAP_SCHEMA=HXL:HXL01

 

例子2(dexp/dimp):

dexp 导出
dexp userid=sysdba/dameng123 file=/tmp/HXL.dmp log=/tmp/HXL.log owner=HXL;

导入到同个用户:
dimp userid=sysdba/dameng123 FILE=/tmp/HXL.dmp LOG=/tmp/imp.log OWNER=HXL

导入不同用户:
dimp userid=sysdba/dameng123 FILE=/tmp/HXL.dmp LOG=/tmp/imp.log REMAP_SCHEMA=HXL:HXL01