Re: Fixing ORA-03237
From: Jeroen van den Broek <nltaal_at_baasbovenbaas.demon.nl>
Date: Tue, 15 Jan 2008 08:54:58 -0800 (PST)
Message-ID: <83c90151-e3c7-45a3-b699-d6ae7c884ee1@e25g2000prg.googlegroups.com>
Date: Tue, 15 Jan 2008 08:54:58 -0800 (PST)
Message-ID: <83c90151-e3c7-45a3-b699-d6ae7c884ee1@e25g2000prg.googlegroups.com>
On Jan 15, 7:53 am, Boogha <boo..._at_gmail.com> 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
HTH
-- JeroenReceived on Tue Jan 15 2008 - 10:54:58 CST