bobmagan wrote:SELECT * FROM LOG_TABLE WHERE DML_TIMESTAMP > SYSTIMESTAMP - 15/1440;
I have a table that has a TIMESTAMP column that stores the last time the record was changed. I have to create a dbms_scheduler job (repeats at on 15 min interval) that will give me a list of all the table changes that happened during the timeframe. So I created a job that calls a stored procedure and executes every 15 minutes:
(job_name => 'CHECK_TABLE_DATA_JOB',
job_type => 'PLSQL_BLOCK',
repeat_interval => 'FREQ=MINUTELY; INTERVAL=15'
I'm a little unsure of the best way to query the changes in my procedure. I need to make sure that I catch all changes only 1 time, so I need to be precise on querying the 'last_change_date' timestamp column with time when job runs. Any ideas?
bobmagan wrote:I'm not sure that a flashback query could be guaranteed to survive a shutdown/startup?
What about using the flashback versions feature?
from emp versions between timestamp systimestamp - interval '15' minutes and systimestamp:
Is that more reliable than the Advanced Que?