Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temporary Tablespace
Extents are not be deallocated but the extents/blocks used be the completed transaction/query will be released so that next transaction can use that space. It works the same as rollback segments . Database restart will clear the allocated extents. Received on Tue Feb 04 1997 - 00:00:00 CST