The sbspace
An sbspace is a logical storage area that contains one or more chunks and stores only smart large objects.
The sbspace can contain the following parts:
- A metadata area The database server writes the following information to the metadata area of an sbspace:
- Internal information that helps the smart-large-object optimizer manage the data efficiently
- Storage characteristics for the smart large object
- Status information for the smart large object
- A user-data area
User applications write smart-large-object data to the user-data area of an sbspace.
In Figure 1, the sbspace1_100 sbspace holds the actual employee image that the LO handle identifies.
The onspaces database utility creates and drops
sbspaces for the database server.
Important: Smart large
objects can only be stored in sbspaces. They cannot be stored in dbspaces.
You must create an sbspace before you attempt to insert smart large
objects into the database.