Database Administration (MOSC)

MOSC Banner

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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center