远程连接和本地连接ORACLE导出备份脚本双击bat即可 且会根据年月日生成目录（可以写一个定时代码执行该脚本）+ 备份导出oracle

@echo off

rem 设置导出文件目录
set "EXPORT_DIR=C:\Users\Administrator\Desktop\bat\oracle\beifen\%date:~0,4%%date:~5,2%%date:~8,2%"

rem 创建目录
mkdir "%EXPORT_DIR%"

rem 执行导出命令
exp username/password@127.0.0.1:1521/orcl FILE="%EXPORT_DIR%\xsy_three_backup.dmp" LOG="%EXPORT_DIR%\expdp_three_xsy.log" OWNER=xsy

 

====================================远程导出失败就在本地用这个

sqlplus sys/sys as sysdba

CREATE DIRECTORY DATA_PUMP_DIR_NEW AS 'E:\oracle\20240516';

expdp xsy/password@127.0.0.1:1521/orcl DIRECTORY=DATA_PUMP_DIR_NEW DUMPFILE=dfg_backup2.dmp  LOGFILE=expdp_dfg2.log SCHEMAS=dfg