-- Drop existing database link drop database link PROD.WORLD; -- Create database link create database link PROD.WORLD connect to user identified by MANAGER using 'PROD';DBMS_JOB:begin sys.dbms_job.submit(job => :job, what => 'dbms_refresh.refresh(''"user"."ETAISHODO"'');', next_date => to_date('14-06-2003 08:23:06', 'dd-mm-yyyy hh24:mi:ss'), interval => 'sysdate + 1/(60*24)'); commit; end;
[email protected]
drop database link PROD.WORLD;
-- Create database link
create database link PROD.WORLD
connect to user identified by MANAGER
using 'PROD';DBMS_JOB:begin
sys.dbms_job.submit(job => :job,
what => 'dbms_refresh.refresh(''"user"."ETAISHODO"'');',
next_date => to_date('14-06-2003 08:23:06', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'sysdate + 1/(60*24)');
commit;
end;