I've created a dblink under Oracle XE 12 to connect to an SQLite file via ODBC. A scheduled task is importing data from the SQLite dbfile into my oracle database every evening. But a user wants to update/replace the SQLite data file from time to time (vie an FTP access to the specific directory). Unfortunately after using the dblink once a process called "dg4odbc" is locking the SQL file. Currently the only chance to replace the sqlite file is killing the process in the task manager. But i can do it manually only. Any idea to solve this problem and kill the process automatically/scheduled?
Is it possible to...
- ... kill the process via SQL in Oracle?
- ... using a parameter in my configuration that forces Oracle to disconnect to the SQLite file after every query (I am aware that its a loss of performance. But it works with csv files as well. And the process runs once a day only, so, no problem)?
- ... using a parameter in my configuration that forces Oracle to disconnect to the SQLite file after being idle a specific time?
- ... finding out the id of the process and kill it at night anyway?