----------fdjExpdp_准备--------------
--sys/Jacjqwl123@orcl
--directory创建(要存放dmp文件端数据库执行)
select * from dba_directories;
create or replace directory jacfdj_data as 'D:\jac_fdj\auto_oracl_bak'
grant read,write on directory jacfdj_data to fdjtest
--network_link创建(要存放dmp文件端数据库执行)
create public database link fdjtest92 connect to
fdjtest identified by fdjtest using '192.168.33.92/orcl'
----------fdjExpdp.bat-------------- REM 设置所有者 REM 创建备份用目录,目录结构为backup/YYYYMMDD/ REM 调用ORACLE的exp命令导出用户数据 REM 删除DELDAYS天的备份文件 |
--------------del.sql------------------
conn fdjtest/fdjtest@192.168.10.92/orcl
delete from exception_log e where trunc(to_date(to_char(sysdate,'yyyy-MM-dd hh24:mi:ss')
,'yyyy-MM-dd hh24:mi:ss') - to_date(to_char(e.oper_date,'yyyy-MM-dd hh24:mi:ss')
,'yyyy-MM-dd hh24:mi:ss'),4)*1 >=30;
exit;
------------------------案例2------------------
--------jac_sclExpdp_准备--------
--sys/Jacjqwl123@orcl
--directory创建(要存放dmp文件端数据库执行)
select * from dba_directories;
create or replace directory jacscl_data as 'D:\jac_scl\auto_oracl_bak'
grant read,write on directory jacscl_data to jac_scl
--network_link创建(要存放dmp文件端数据库执行)
create public database link jac_scl136 connect to jac_scl
identified by jac_scl using '192.168.33.136/jqwlscl'
--------jac_sclExpdp.bat-------- REM 设置所有者 REM 创建备份用目录,目录结构为backup/YYYYMMDD/ REM 调用ORACLE的exp命令导出用户数据 REM 删除DELDAYS天的备份文件 |
-----scldel.sql---------
conn jac_scl/jac_scl@192.168.11.136/jqwlscl
delete from exception_log e where trunc(to_date(to_char(sysdate,'yyyy-MM-dd hh24:mi:ss')
,'yyyy-MM-dd hh24:mi:ss') - to_date(to_char(e.oper_date,'yyyy-MM-dd hh24:mi:ss')
,'yyyy-MM-dd hh24:mi:ss'),4)*1 >=30;
exit;