Re: Fixing ORA-03237

From: Jeroen van den Broek <>
Date: Tue, 15 Jan 2008 08:54:58 -0800 (PST)
Message-ID: <>

On Jan 15, 7:53 am, Boogha <> wrote:
> Has anyone come across the error ORA-03237. I am trying to upgrade an
> application and while it is modifying the schema by adding a new
> column of type NCLOB it stops and throws this error:
> ORA-03237: Initial Extent of specified size cannot be allocated to
> tablespace (TABLESPACE_NAME)
> How can I fix this?

Tablespaces that are locally managed and contain a table with LOB columns should have an extent size that is (at least) 4 times the db_block_size.
See Metalink Note:116310.1


Received on Tue Jan 15 2008 - 10:54:58 CST

Original text of this message