Re: dbms_job, dblinks & replication

On Mon, 22 May 2000 18:08:38 GMT, jzobel_at_my-dejanews.com (Joachim Zobel) wrote:

Oracles Advanced Replication only uses the dblink created for the repadmin user......which has enough privileges to do the job

I dont have the docs in front of me but I seem to remember that I created both a public and a private DBLINK from the Master Def Site to the Master site and vice versa.

Need more info? email me and I will see what I can do

Kelvin

>paulcinvt_at_aol.com (PaulCinVT) wrote:
>
>>In article <39224118.113620_at_dilbert.crrrwg.de>, jzobel_at_my-dejanews.com (Joachim
>>Zobel) writes:
>>
>>>
>>>The jobs in the job queue run in sessions that can not use dblinks.
>>>Oracles replication is done by such jobs and they can use dblinks. How
>>>is this done?
>>
>>Database Links and Jobs
>>If you submit a job that uses a database link, the link must include a username
>>and password. Anonymous database links will not succeed.
>>
>
>I'm not completely clear about this point, but its not what I want to
>know. I wonder how oracle replication manages to use dblinks from
>queued jobs. Does oracle have access to users passwords?
>
>Thanx,
>Joachim
>
> --
>"I read the news today oh boy" - The Beatles - A Day In The Life
>
>Althoug this message has a valid From header, replies
>to user_at_netcologne.de where user = nc-zobeljo
>are preferred.
Received on Tue May 23 2000 - 00:00:00 CDT