15.00 - 8505 LOB ID could not be generated - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

8505 LOB ID could not be generated

Explanation:

A unique LOB identifier could not be generated because there are no more unused IDs for the specified key.

Generated By:

lobCreate

For Whom:

Site support representative or customer.

Notes:

A LOB identifier is composed of a key based on the primary index of the table and an additional 16 bits for uniqueness. This error indicates that all the possible uniqueness values are currently in use. It could occur if the table that contains the LOB column has more than 65534 rows with the same primary row hash value.

Remedy:

Redesign the table so that its primary index has fewer rows with the same primary index value.