Getting ORA-03237 (Initial Extent of specified size cannot be allocated in tablespace (string)) when running Oracle User Wizard.
The tablespace mentioned in the error message is Auto Extend enabled.
The table quest_soo_PLAN_TABLE created by the Oracle User Wizard has a CLOB column.
For this reason the minimum extent size for the tablespace has to be 4 x the block size .
See script below:
CREATE TABLE quest_soo_PLAN_TABLE
( statement_id VARCHAR2(60),
timestamp DATE,
remarks VARCHAR2(2000),
operation VARCHAR2(30),
options VARCHAR2(30),
object_node VARCHAR2(128),
object_owner VARCHAR2(30),
object_name VARCHAR2(30),
object_instance NUMBER,
object_type VARCHAR2(30),
search_columns NUMBER,
id NUMBER,
parent_id NUMBER,
position NUMBER,
other CLOB,
collector VARCHAR2(31),
address VARCHAR2(16),
hash_value NUMBER,
optimizer VARCHAR2(255),
cost NUMBER,
cardinality NUMBER,
bytes NUMBER,
other_tag VARCHAR2(255),
partition_start VARCHAR2(255),
partition_stop VARCHAR2(255),
partition_id NUMERIC,
join_text VARCHAR2(1000),
filter_text VARCHAR2(1000),
view_text VARCHAR2(1000)
WORKAROUND 1:
Modify the minimum extend size for the tablespace. It has to be 4 x the block size .
WORKAROUND 2:
Create a separate tablespace with “EXTENT MANAGEMENT LOCAL AUTOALLOCATE” and install Spotlight in that tablespace. This way Oracle will manage the extent sizes automatically.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center