Remote Select opening transaction
- From: "Marc Demlenne" <marc.demlenne@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 3 Apr 2007 14:07:34 +0200
Hello,
In Oracle 8, when performing a select query on another database threw DB
link, Oracle opens a transaction that could only be closed by commit or
rollback. That could be harmful when developers are not aware of this and
don't close transaction. (leading to ORA-01562.)
What is the reason of this behaviour ? Is there some docs / faq explaining
this ?
Is this feature also common to later versions of Oracle ?
Thanks a lot for any piece of information given,
--
Marc
Other related posts:
