[Deploying Sakai] Lessons on Oracle possible issue

Charles Hedrick hedrick at rutgers.edu
Thu May 1 08:24:12 PDT 2014

When testing Lessons on Oracle, I got the following error:

ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM

when I tried to convert an extra field to CLOB.  I was able to do all the updates that are needed, but in testing I tried to do it to an extra column, and that didn’t work. I don’t know anything about Oracle, so I have little idea what this means, but I thought you might want to talk to your Oracle DBA. The most complex table in Lessons is lesson_builder_items. It has 5 fields that are CLOB. If this isn’t going to work, I can use fewer, but it would require significant code changes.

It’s unlikely that I will add more CLOB fields, as most new properties are being done in json as long as it’s not likely that we’ll need to search on them.

More information about the production mailing list