| |
- Causa
- A LOB COLUMN IS TOO LARGE TO BE LOGGED.
One of the following has occurred:
- a CREATE TABLE statement for an auxiliary table stores a BLOB, CLOB or DBCLOB column whose length exceeds 1 gigabyte but whose associated LOB
table space was defined with the LOG YES attribute.
- an ALTER TABLESPACE statement of a LOB table space specifies the LOG YES clause but the auxiliary table in the LOB table space stores a BLOB or
CLOB column whose length exceeds 1 gigabyte or a DBCLOB column whose length exceeds 500 megabyte characters.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- Either change the attribute of the LOB table space to LOG NO or drop the base table, and recreate it with columns of an acceptable length for
logging.
SQLSTATE: 42993
© Copyright IBM Corp.
|
| |
