Query remote DB without DB Link
505318Jan 8 2010 — edited Jan 12 2010I have a nightly db job that runs to extract data from a remote DB. Due to a Change in the Security requirments at the remote location. DB Links are now prohibited. Is there a way to query the remote DB, without using a DB link? I have no say or control in doing anything on the remote DB other than inserting or querying records. No other types of objects can be created on that end. The package that runs Nightly, loops through a local configuration table, extracting data from the remote db based on conditions defined in the config table, and placing it in the local tables.