SYMPTOM:
When creating statistics tables in an Oracle database in Strategy 9.x and 10.x, an error message similar to the one shown below appears. The error can be received during the creation of other statistics tables also.
ORA-01658: unable to create INITIAL extent for segment in tablespace
MSTR_META_DATA Connection String: DSN=Production META;UID=MSTR;SRVR=MS;.
SQL Statement: CREATE TABLE IS_REP_STEP_STATS(
DAY_ID DATE NOT NULL,
HOUR_ID NUMBER NOT NULL,
MINUTE_ID FLOAT NOT NULL,
JOBID NUMBER(10) NOT NULL,
STEPSEQUENCE NUMBER(10) NOT NULL,
SESSIONID CHAR(32) NOT NULL,
SERVERID CHAR(32) NULL,
STEPTYPE NUMBER(10) NULL,
STARTTIME DATE NOT NULL ,
FINISHTIME DATE NULL ,
QUEUETIME FLOAT NULL ,
CPUTIME FLOAT NULL ,
STEPDURATION FLOAT NULL ,
RECORDTIME DATE NULL,
SERVERMACHINE VARCHAR2(768) NULL,
PROJECTID CHAR(32) NULL,
PRIMARY KEY (SESSIONID, JOBID,STEPSEQUENCE)
)
PARTITION BY RANGE (DAY_ID)
SUBPARTITION BY HASH(StepType) subpartitions 25
(
PARTITION P_1 VALUES LESS THAN (TO_DATE('01-01-2001', 'DD-MM-YYYY')),
PARTITION P_2 VALUES LESS THAN (TO_DATE('01-02-2001', 'DD-MM-YYYY')),
PARTITION P_3 VALUES LESS THAN (TO_DATE('01-03-2001', 'DD-MM-YYYY')),
PARTITION P_4 VALUES LESS THAN (TO_DATE('01-04-2001', 'DD-MM-YYYY')),
................
................
PARTITION P_172 VALUES LESS THAN (TO_DATE('01-04-2015',
'DD-MM-YYYY')),
PARTITION P_173 VALUES LESS THAN (TO_DATE('01-05-2015',
'DD-MM-YYYY')),
PARTITION P_174 VALUES LESS THAN (TO_DATE('01-06-2015',
'DD-MM-YYYY')),
PARTITION P_175 VALUES LESS THAN (TO_DATE('01-07-2015',
'DD-MM-YYYY')),
PARTITION P_176 VALUES LESS THAN (TO_DATE('01-08-2015',
'DD-MM-YYYY')),
PARTITION P_177 VALUES LESS THAN (TO_DATE('01-09-2015',
'DD-MM-YYYY')),
PARTITION P_178 VALUES LESS THAN (TO_DATE('01-10-2015',
'DD-MM-YYYY')),
PARTITION P_179 VALUES LESS THAN (TO_DATE('01-11-2015',
'DD-MM-YYYY')),
PARTITION P_180 VALUES LESS THAN (TO_DATE('01-12-2015',
'DD-MM-YYYY')),
PARTITION P_MAX VALUES LESS THAN(MAXVALUE)
).
2012-01-20 14:30:10.008-05:00 ConfigManager::GetServerDefSetting():
ServerDef not initialized: Long SettingId=75.”