Recently I’m stuck with this error suddenly while writing data to this Oracle XE edition. Of course, it’s kind of frustrating to see this kind of errors in the middle of our tasks without even knowing the origin of these. I did few searches on the web, and able to cross the issue with below fix.
Root cause of the error:
Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created.
1. Create and add a datafile to the database, for additional space to the tablespace.
ALTER TABLESPACE SYSTEM ADD DATAFILE 'path/to/file' SIZE 1600M;
2. Since, over the period the given size may gets filled as well, so what i did is to extend the size automatically as below.
ALTER DATABASE DATAFILE 'path/to/file' AUTOEXTEND ON;
After doing the above, i finally avoided this bugging issue and continue to use Oracle XE edition for project use.