start_scn = 0 in flashback_transaction_query
Hi,
For a project, i need to capture the changements in database.
I use flashback_transaction_query to have the informations of an oracle transaction :
start_scn : scn when the transaction begins
commit_scn : scn when the transaction commits
and others informations of flashback_transaction_query
Sometimes in Oracle 10.2, Oracle 11.1 or Oracle 11.2, start_scn = 0 in flashback_transaction_query when i make opérations in tables (insert, update or delete) :
The request :
select * from flashback_transaction_query where xid = hextoraw('...');
(cf http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10795/adfns_fl.htm#1017342)
returns start_scn = 0 and not a valid scn.
For a project, i need to capture the changements in database.
I use flashback_transaction_query to have the informations of an oracle transaction :
start_scn : scn when the transaction begins
commit_scn : scn when the transaction commits
and others informations of flashback_transaction_query
Sometimes in Oracle 10.2, Oracle 11.1 or Oracle 11.2, start_scn = 0 in flashback_transaction_query when i make opérations in tables (insert, update or delete) :
The request :
select * from flashback_transaction_query where xid = hextoraw('...');
(cf http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10795/adfns_fl.htm#1017342)
returns start_scn = 0 and not a valid scn.
0