Re: ORA-03237 with LOB and locally managed tablespace

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Mon, 22 Sep 2003 05:24:39 -0800
Message-ID: <F001.005D0B30.20030922052439@fatcity.com>

Luc,

got this for u from metalink.

---

Solution Description

---

You need to ensure that the extent size specification in the tablespace is at least four times the db_block_size. i.e: create tablespace local_t1 datafile 'path/filename.dbf' size 20M

extent management local uniform size N;      ***   where N = 4*db_block_size  ***  The problem is 
due to the extent size specified in the tablespace.     SQL> create tablespace local_t1     2  
datafile '/oracle10/local_t1/dbf' size 20m     3  extent management local  uniform size 16k;      

SQL> create table temp (a1 blob) tablespace local_t1;

This generates the ORA-3237 if the db_block_size is >= 8K.   

Explanation

---

Whilst Oracle enforces the a minimum uniform extent size of two database blocks, other objects may require larger extents than this, either by virtue of how they are built internally (i.e. an RBS requires at least four blocks and a LOB at least three) or by virtue of their storage specification when being created.

---

Jp.

22-9-2003 21:54:40, Luc.Demanche_at_astrazeneca.com wrote:
>Hi gurus,
>
>Could you explain that.
>Working with tablespace in locally managed, with uniform extends size, we
>want to create LOB but we must have the uniform extend size 3 times the
>db_block_size, right?
>Otherwise we got ORA-03237.
>
>With dictionnary managed tablespace we don't have this problem.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Sep 22 2003 - 08:24:39 CDT