Re: Are BLOBs logged?

"Paul Watson" <wfsoftware@cix.compulink.co.uk> wrote in article <E8Gswx.3DE@cix.compulink.co.uk>... > >I have a naive and simple question: are the full contents of BLOBs > >logged? I've heard contradictory assertions on this, and I want to find > >out why our transaction logs are filling up so fast. > > Basically, the data within the blobs are not logged but the changes to > descriptor areas are. The correct answer is: it depends. Blobs located in the tblspace are logged in full. Blobs stored in blobspaces are handled as Paul describes above. When you create a table with a blob column, you can specify where you want the blob stored, in tblspace or blobspace. If you do not specify, it will be located in the tblspace by default. Dave