When a new test is being saved, it fails indicating only unable to save the test, or when a scenario previously created is being tried to be used the workload tab doesn’t work.
The w3wp log shows the below error
ORA-01653: unable to extend table MI_LRDB.SCHEDULERS by 8 in tablespace USERS
Failed to allocate an extent for table segment in tablespace.
This error does not necessarily indicate whether or not you have enough space in the tablespace, it merely indicates that Oracle could not find a large enough area of free contiguous space in which to fit the next extent.
Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated, velow few possible ways to fix this.
Manually Coalesce Adjacent Free Extents
ALTER TABLESPACE COALESCE;
The extents must be adjacent to each other for this to work.
– Add a Datafile:
ALTER TABLESPACE ADD DATAFILE ” SIZE ;
– Resize the Datafile:
ALTER DATABASE DATAFILE ” RESIZE ;
– Enable autoextend:
ALTER DATABASE DATAFILE ?? AUTOEXTEND ON MAXSIZE UNLIMITED;
– Defragment the Tablespace:
– Lower "next_extent" and/or "pct_increase" size:
ALTER STORAGE ( next pctincrease );
– If the tablespace is being used as a temporary tablespace, temporary segments may be still holding the space.