Dear All,
I have a DB link and I am able to query remote_view data using this DB link. Below query is executing successfully and I can see the data.
CT * from remote_view@remote_db
SELECT * from remote_view@remote_db;
then I have used this remote-view in a procedure to populate data into local table..
-- Pseudocode
INSERT INTO local_table
SELECT * from remote_view@remote_db;
When I run this procedure, then it's executing successfully. I am getting no errors and I can see data inserted into local_table.
But when I schedule the same procedure to run as a job using DBMS_SCHEDULER.CREATE_JOB, then I am getting "ORA-12170: TNS:Connect timeout occurred error" for above insert statement.
Any clues what could be going wrong?
Regards,
Hari