sys远程删除Oracle用户,sys用户删除其他用户私有dblink

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%';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29337971/viewspace-1129917/，如需转载，请注明出处，否则将追究法律责任。