Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I am connecting to an enterprise implementation of a PLM package that resides over Oracle 11g express edition. I would like to connect to that database from qlikview.
Question is how do i get to know what are all tables that are updated at a particular point of time using Qlikview that is connected to oracle instance ?
Afaik you to check the data in all the tables and compare that to what you retrieved earlier. Perhaps you can try to do something fancy with a log reader that can process oracle archive and redo log files, i.e. a change data capture application, but if all you have is Qlikview then you need to check every table for new and changed data. Search for Incremental Load on this site and you'll find lots of information and examples.
redo has to be triggered on each table. I have close to 4000 tables. also i dont have modify-date property in most of the tables.