1、查看所有的目标dblink
select owner||'.'||db_link from dba_db_links where db_link not like '%OGG%';
2、创建job
exec dbms_scheduler.create_job(job_name=>'UCR_CEN8.test',job_type=>'PLSQL_BLOCK',job_action=>'BEGIN execute immediate ''drop database link UCR_CEN1_TO_CEN'';END;');
3、运行job
exec dbms_scheduler.run_job('UCR_CEN8.test');
4、删除job
exec dbms_scheduler.drop_job('UCR_CEN8.test');
5、查看job
select OWNER,JOB_NAME from DBA_SCHEDULER_JOBS;
6、验证操作
select owner||'.'||db_link from dba_db_links where db_link not like '%OGG%';
select owner||'.'||db_link from dba_db_links where db_link not like '%OGG%';
2、创建job
exec dbms_scheduler.create_job(job_name=>'UCR_CEN8.test',job_type=>'PLSQL_BLOCK',job_action=>'BEGIN execute immediate ''drop database link UCR_CEN1_TO_CEN'';END;');
3、运行job
exec dbms_scheduler.run_job('UCR_CEN8.test');
4、删除job
exec dbms_scheduler.drop_job('UCR_CEN8.test');
5、查看job
select OWNER,JOB_NAME from DBA_SCHEDULER_JOBS;
6、验证操作
select owner||'.'||db_link from dba_db_links where db_link not like '%OGG%';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29337971/viewspace-1129917/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
