数据链路(先修改目的方数据库的init.ora中的global_names为false,重新启动数据库): create database link linkname connect to user identified by usrpwd using 'demona';//demona为用net8 easy config创建的连接字符串job例子: VARIABLE jobno number; begin DBMS_JOB.SUBMIT(:jobno, 'Procdemo;', SYSDATE, 'SYSDATE + 1/48');//每半小时执行存储过程Procdemo一次 commit; end; /
create database link linkname
connect to user
identified by usrpwd
using 'demona';//demona为用net8 easy config创建的连接字符串job例子:
VARIABLE jobno number;
begin
DBMS_JOB.SUBMIT(:jobno,
'Procdemo;',
SYSDATE, 'SYSDATE + 1/48');//每半小时执行存储过程Procdemo一次
commit;
end;
/
global_names = false