cannot read a blob from a table
Hi, I have an oracle 11 xe linux x86_64.
I have a table with many columns:
person(pk, raw(16), …..,face blob,…, PRIMARY KEY ("PK")) tablespace users LOB ("FACE") STORE AS BASICFILE (
TABLESPACE "USERS" DISABLE STORAGE IN ROW CHUNK 8192 RETENTION
NOCACHE LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ENABLE ROW MOVEMENT;
Database holds a few Gb of data and for one of the rows, the blob cannot be read, but we can see its length(23Kb):
SQL> select face from person where pk='F142B19DD50B4236B90E27451030B96C';