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'.