Allocation of Temporary Segments for Temporary Tables and Indexes (28)

Oracle allocates segments for a temporary table when the first INSERT into that table is issued.
(This can be an internal insert operation issued by CREATE TABLE AS SELECT.) The first
INSERT into a temporary table allocates the segments for the table and its indexes,
creates the root page for the indexes, and allocates any LOB segments.
Segments for a temporary table are allocated in a temporary tablespace of the user
who created the temporary table.
Oracle drops segments for a transaction-specific temporary table at the end of the
transaction and drops segments for a session-specific temporary table at the end of the
session. If other transactions or sessions share the use of that temporary table, the
segments containing their data remain in the table.

1. 临时表在第一次insert into(ctas)时 , Oracle给分配临时段
2. 当事务结束时 , Oracle drops segments for a transaction-specific temporary table.
3. 当会话结束时 , Oracle drops segments for a session-specific temporary table.
4. 有其他事务或者会话共享临时表时 , 临时段依然保留着数据.

[@more@]

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

转载于:http://blog.itpub.net/10599713/viewspace-969414/