FREETEMPORARY

2024-12-02 03:48:27  Updated

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 the 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 Considerations.

Considerations

  • If no temporary LOB is used in the same duration (session or call) when you attempt to create a temporary LOB, a new temporary LOB segment is created. After a temporary LOB is released, the occupied space is released to the temporary segment. If no other LOBs exist within the same duration, the temporary segment is also released.

  • After you call the FREETEMPORARY procedure, the locator of the released LOB is marked as invalid.

Contact Us