The FREETEMPORARY stored procedure releases BLOBs or CLOBs in the default temporary tablespace.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
DBMS_LOB.FREETEMPORARY (
lob_loc IN OUT NOCOPY BLOB);
DBMS_LOB.FREETEMPORARY (
lob_loc IN OUT NOCOPY CLOB CHARACTER SET ANY_CS);
Parameters
| Parameter | Description |
|---|---|
| lob_loc | The locator of the LOB. For more information, see Usage notes. |
Usage notes
If no temporary
LOBis used in the same duration (session or call) when you attempt to create a temporaryLOB, a new temporaryLOBsegment is created. After a temporaryLOBis released, the occupied space is released to the temporary segment. If no otherLOBsexist within the same duration, the temporary segment is also released.After you call the
FREETEMPORARYprocedure, the locator of the releasedLOBis marked as invalid.