|Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)
Part Number A88879-01
External LOBs (BFILEs), 41 of 41
"Use Case Model: External LOBs (BFILEs)" for all basic operations of External LOBs (BFILES).
This procedure describes how to DELETE the row of a table containing a BFILE.
Unlike internal persistent
LOB value in a
BFILE does not get deleted by using SQL DDL or SQL DML commands -- only the
BFILE locator is deleted. Deletion of a record containing a
BFILE column amounts to de-linking that record from an existing file, not deleting the physical operating system file itself. An SQL
DELETE statement on a particular row deletes the
BFILE locator for the particular row, thereby removing the reference to the operating system file.
See the following syntax reference:
TABLE statements delete the row, and hence the
BFILE locator that refers to
gif, but leave the operating system file undeleted in the filesystem.
The following examples are provided in SQL and apply to all programmatic environments: