Odd behaviour of queries over database link with dbms_flashback in logon trigger
We have a setup such that users have a choice of seeing live data, or
data as at end of business day the previous day.
For the historic data, this is achieved using a logon trigger, which
checks whether the connection is to a particular service.
If it is, then we use dbms_flashback.enable_at_time to set the session to query at the appropriate date/time.
This is all in the same database (undo retention is set to >1 day to allow it)
This works fine, except for certain operations over a database link to the system.
E.g. where "direct" is a link to the "live" data (i.e. no flashback enable), "flashback" is a link to the service which triggers flashback (in this case to 4-Oct-2010 00:00)
If it is, then we use dbms_flashback.enable_at_time to set the session to query at the appropriate date/time.
This is all in the same database (undo retention is set to >1 day to allow it)
This works fine, except for certain operations over a database link to the system.
E.g. where "direct" is a link to the "live" data (i.e. no flashback enable), "flashback" is a link to the service which triggers flashback (in this case to 4-Oct-2010 00:00)
0