This content has been marked as final. Show 4 replies
How did you create a db link ?
It is public or private ?
Did you set username and password when you create a db link ?
Private db link. Omitted "connect to usr idetified by xxxx".
That is probably the problem.
Drop DB link and create it again and use connect to user identified by password.
ORACLE uses processes for job but this processes are slightly different from process create when you directly connect as as user.
I recreated the link with the connect clause and it worked. Thank you for your suggestion.