oracle11g postdbcreation.sql这个脚本在安装好的哪里
答案:1 悬赏:60 手机版
解决时间 2021-02-15 19:57
- 提问者网友：箛茗
- 2021-02-15 12:17
oracle11g postdbcreation.sql这个脚本在安装好的哪里
最佳答案
- 五星知识达人网友：撞了怀
- 2021-02-15 13:41
@echo off
@rem 数据库开始备份......
set V_DATE=%date:~0,4%%date:~5,2%%date:~8,2%
set V_HOUR=%time:~0,2%
if "%time:~0,1%" == " " set V_HOUR=0%time:~1,1%
set V_DATETIME=%V_DATE%%V_HOUR%%time:~3,2%%time:~6,2%
set ORACLE_HOME=F:\oracle\product\10.2.0\client_1
"F:\oracle\product\10.2.0\client_1\BIN\exp.exe" user/passwd@IP_SID BUFFER=307200 file=F:\dbbak\user%V_DATETIME%.dmp log=F:\dbbak\user%V_DATETIME%.log statistics=none
"C:\Program Files\WinRAR\WinRAR.exe" a -df -ep1 -afzip F:\dbbak\user%V_DATETIME%.zip F:\dbbak\*.dmp F:\dbbak\*.log
@REM zip -Am zipFile.zip *.dmp
forfiles /p "F:\dbbak" /m *.zip /d -30 /c "cmd /c del @path"
@rem 数据库开始备份......
set V_DATE=%date:~0,4%%date:~5,2%%date:~8,2%
set V_HOUR=%time:~0,2%
if "%time:~0,1%" == " " set V_HOUR=0%time:~1,1%
set V_DATETIME=%V_DATE%%V_HOUR%%time:~3,2%%time:~6,2%
set ORACLE_HOME=F:\oracle\product\10.2.0\client_1
"F:\oracle\product\10.2.0\client_1\BIN\exp.exe" user/passwd@IP_SID BUFFER=307200 file=F:\dbbak\user%V_DATETIME%.dmp log=F:\dbbak\user%V_DATETIME%.log statistics=none
"C:\Program Files\WinRAR\WinRAR.exe" a -df -ep1 -afzip F:\dbbak\user%V_DATETIME%.zip F:\dbbak\*.dmp F:\dbbak\*.log
@REM zip -Am zipFile.zip *.dmp
forfiles /p "F:\dbbak" /m *.zip /d -30 /c "cmd /c del @path"
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯