Folks - Greetings. Here is my setup.
1. One Public DBlink between 2 databases. Lets say the Server 1 has the dblink and Data being fetched from Server 2.
2. One Materialized View using the DBlink in Server 1 to transport Data from Server 2.
3. One Job in Server 1 calling for Refresh the above Materialized View.
When I (using my Userid) call the dbms_mview.refresh manually it successfully refreshes the MV. But when I call the Job I get the ORA-01017: invalid username/password; logon denied ? When I logon as schema itself the Job run successfully. Can anyone have an insight into this ? I know it's about Job authentication issue, but am not sure what can be done to work around this.