Home » RDBMS Server » Server Administration » dbms_job with two database links
dbms_job with two database links [message #62027] Mon, 21 June 2004 00:24 Go to next message
_simma_dba
Messages: 34
Registered: November 2003
Member
I have procedure witch works on my test Db. I must insert some data in table on another db. That database is db02 and my database is db01. BUT I have also to update table on database db03. Can I use dbms_job to execute this procedure considering that I have two db links in my procedure.

Report message to a moderator

Re: dbms_job with two database links [message #62072 is a reply to message #62027] Wed, 23 June 2004 06:42 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

I'm sure you can! Try and let us know if it's not working.

Best regards.

Frank

Report message to a moderator

Previous Topic: difference between the dictionary and locally managed tablespaces in recovery process
Next Topic: ORA-00603 : ORA-01114:
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 10:25:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.