Oracle数据泵导入和导出命令

–oracle传统方式备份exp/imp

1. deferred_segment_creation 参数设置true 默认空表无法导出。需要设置false。

exp ecard/ecard@orcl file=d:\2023106.dmp log=d:\20231206.txt direct=y recordlength=65535
imp ecard/ecard@orcl file=d:\2023106.dmp log=d:\20231206imp.txt buffer=102400000

–管理员方式登录，新建表空间和用户，并建立文件夹映射路径并授权

``
CREATE DIRECTORY directory_name AS ‘path_to_directory’;
grant read,write on directory directory to backup

**

—数据泵EXPDP多线程备份数据库脚本–dblink–可以修改为命令行

@echo off
       set curdate=%date:~0,4%%date:~5,2%%date:~8,2%
       expdp backup/backup  directory=jndx schemas=ccense dumpfile=%curdate%jndx%%U.dmp   logfile=%curdate%jndx.log network_link='jndx_public_dblink' compression
1
2