Can I use flashback in application, especially DBMS_FLASHBACK.TRANSACTION_BACKOUT. I import some information (from files) in my database and after that I want to revert that transaction(delete imported data). I did some test I took xid of the transaction from v$transaction and then executed DBMS_FLASHBACK.TRANSACTION_BACKOUT with that XID for parameter. Everything is fine but that time there was only one transaction, when there are many transaction how can I get the exact XID. I can use dbms_transaction.local_transaction_id to get information for transaction which is running. And when i tried to use flashback that way a deadlock occur and db killed the other transaction.
Is your problem that you cannot identify which single transaction to backout? If so, you can use flashback queries (projecting pseudo-columns such as VERSIONS_STARTTIME, VERSIONS_ENDTIME, and VERSIONS_XID) to find it. But be quick, or you'll get an ora-1555.
Sorry for the misinformation. The import is from Java Application written from our developers. The import is done in 2 transactions and I need their XIDs so I could use them in DBMS_FLASHBACK.TRANSACTION_BACKOUT procedure.