Dblink

2021-08-30 约 49 字预计阅读 1 分钟

查询所有触发器

1

select * from user_triggers;

根据名称禁用触发器

1

alter trigger LOGMNRGGC_TRIGGER disable;

查询所有 job

1

select * from user_jobs;

根据 id 禁用 job

1

BEGIN dbms_job.broken(4001,true); END;

禁用 oracle dblink

1
2


alter system set open_links=0 sid='$sid' scope=spfile;
alter system set open_links_per_instance=0 sid='$sid' scope=spfile;

启用 oracle dblink

1
2


alter system set open_links=4 sid='$sid' scope=spfile;
alter system set open_links_per_instance=4 sid='$sid' scope=spfile;

目录