var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: can't create blob ORA-03237
I'm quite new to Oracle.
When I try to create a table with a LOB in it,
CREATE TABLE TEST (ID NUMBER, B BLOB);
I get the error :
ORA-03237 Initial Extent of specified size cannot be allocated
This is so in all tablespaces and there is a lot of free space.
I searched Google and Oracle docs but found nothing.
If I should provide more information about the database, please
tell me what.
your blob definition does not fit into the inital extend size for your tablespace your are creating the table in ...
try somestring like this
CREATE TABLE dokument
( dok_id INTEGER
STORAGE (INITIAL 256 NEXT 256)
LOB (dok_text) STORE AS
STORAGE (INITIAL 8192 NEXT 8192)
Maybe I don't understand...
It doesn't work and I'm really clueless. I tried fiddling with teh extent
My tablespace defaults to initial 16384 next 16384. It's also the value
of min_extlen (it appears its not possible to go below).
Some info about my tablespace :
- 8k blocks
- 16k initial and next extents, 0 pctincrease
- 1 min_extent, many max_extent
- local management
- uniform allocation
- manual segment management
I found out that 16k is the bare minimum with manual segment management.
This is 2 blocks, + 1 extra block for the freelist group.
By the way, creating a table with 2 freelist groups gives the same error
as trying to create a table with a blob in it, because the initial extent
size is too small.
If I understand correctly, it's not possible to use blobs in tables in this