Oracle数据库备份_数据泵的导入、导出
数据泵导入:
impdp lxdba/comsys@tymhdb directory=dir_dp dumpfile=lxxt_202106221046bak_new_11g_formal.dmp logfile=lxxt_202106221046bak_new_11g_formal.log
导出:
expdp uiadata/ynmzdxszhxy@tymhdb directory=dir_dp dumpfile=uiadata_202107081512bak_new_11g_formal.dmp logfile=uiadata_202107081512bak_new_11g_formal.log
其中:
uiadata为用户名;
ynmzdxszhxy为账号密码;
uiadata_202107081512bak_new_11g_formal.dmp为备份的数据库名称;
uiadata_202107081512bak_new_11g_formal.log为日志文件文件名称。