Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2005
    Posts
    5

    Unanswered: can't create blob ORA-03237

    Hi

    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.

    Thanx

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    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
    dok_text BLOB)
    STORAGE (INITIAL 256 NEXT 256)
    LOB (dok_text) STORE AS
    (TABLESPACE tsblob
    STORAGE (INITIAL 8192 NEXT 8192)
    );

  3. #3
    Join Date
    Oct 2005
    Posts
    5
    Maybe I don't understand...

    It doesn't work and I'm really clueless. I tried fiddling with teh extent
    values.

    My tablespace defaults to initial 16384 next 16384. It's also the value
    of min_extlen (it appears its not possible to go below).

  4. #4
    Join Date
    Oct 2005
    Posts
    5
    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
    tablespace.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •