Temporary Segments, Tablespaces, and Groups
SQL statements often require temporary work areas. For example, when you create an index for a large table, Oracle typically must allocate some temporary system space so that it can sort all of the index entries before building the index's segment. When processing a SQL statement that requires temporary workspace, Oracle allocates small temporary segments from a tablespace in the database. When the statement completes, Oracle releases the segments back to the tablespace so that other objects can use the space—thus the term "temporary segment."
To optimize the overhead associated with temporary segment allocation, the default Oracle XE database has a temporary tablespace named TEMP. A temporary tablespace ...
Get Hands-On Oracle Database 10g Express Edition for Windows now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
