ITPub博客

首页 > 应用开发 > IT综合 > Parent and Child Transactions (169)

Parent and Child Transactions (169)

原创 IT综合 作者:tsinglee 时间:2007-11-09 10:02:39 0 删除 编辑

Transaction-specific temporary tables are accessible by user transactions and their
child transactions. However, a given transaction-specific temporary table cannot be
used concurrently by two transactions in the same session, although it can be used by
transactions in different sessions.

If a user transaction does an INSERT into the temporary table, then none of its child
transactions can use the temporary table afterward.

If a child transaction does an INSERT into the temporary table, then at the end of the
child transaction, the data associated with the temporary table goes away. After that,
either the user transaction or any other child transaction can access the temporary
table.

父事务与子事务
1. 事务临时表能够被用户事务和他们的子事务所访问 , 事务临时表不能在同一个会话中被两个并发事务所同事访问
2. 如果一个用户事务对临时表做了insert操作 , 他的子事务将不能使用这个临时表
3. 如果在子事务中对临时表做了insert操作d , 子事务结束后 , 相关的数据将被清除.
然后父事务或者其他子事务可访问此临时表 .

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-981376/,如需转载,请注明出处,否则将追究法律责任。

下一篇: External Tables (170)
请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892345