Lob locators

摘要

A method and system for performing operations on large objects (LOBs) in a database system are provided. A server receives from a client a command that identifies a row of a table. The table includes a LOB column that contains LOBs. The server responds to the command by sending the client a first set of data from the row. The first set of data includes a locator for a LOB that belongs in the LOB column of the row. The locator includes a LOB identifier that uniquely identifies the LOB and snapshot information that identifies a particular version of the LOB. The server receives from the client a request to perform an operation on the LOB. The request passes the locator for the LOB to a routine provided by the server. The server performs the operation on the particular version of the LOB that is identified in the snapshot information contained in the locator passed to the server by the client.