Chapter 16. LOBs
Large objects, generically known as LOBs, seem to keep the hard-drive manufacturers in business. Whether it's images, word-processing documents, video clips, full-length movies, or XML documents, large objects are frequently found on web sites for download by customers who want them now.
Storing these types of objects on disk is only half the picture—they need to be easily managed, organized, and retrieved. Not only do LOBs need to be easily and quickly accessible, they need to be backed up and kept consistent with their associated metadata. In other words, an Oracle database with its high level of redundancy, availability, and recoverability becomes an ideal platform in which to store LOBs.
LOBs come in a number of different flavors. ...
Get Oracle SQL Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
