达梦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