Figure 12-31 Use Case Diagram: Updating a BFILE by Selecting a BFILE From Another Table

Purpose

This procedure describes how to UPDATE a BFILE by selecting a BFILE from another table.

Usage Notes

There is no copy function for BFILEs, so you have to use UPDATE as SELECT if you want to copy a BFILE from one location to another. Because BFILEs use reference semantics instead of copy semantics, only the BFILE locator is copied from one row to another row. This means that you cannot make a copy of an external LOB value without issuing an operating system command to copy the operating system file.