Sunday, April 20, 2008

ORA-03237: Initial Extent of specified size cannot be allocated in tablespace (string)

ORA-03237: Initial Extent of specified size cannot be allocated in tablespace (string)

Cause: Too large a size for an initial extent due to freelist group specification

Action: Reduce number of freelist groups specified for segment


ORA-03237: "Initial Extent of specified size cannot be allocated":

Unable to create queues, or tables containing CLOBs

If you see the following error:

ORA-03237: Initial Extent of specified size cannot be allocated

while creating queue tables (which contain a BLOB column) or tables that contain CLOBs, it may be because of a database tablespace configuration problem. This only applies to the 9i databases which have been configured to use locally managed tablespaces.

This is a documented restriction in Oracle that LOBs cannot be created in 'locally managed uniform extent tablespaces with extent size less than 3 blocks'.

No comments: