[Deploying Sakai] Lessons on Oracle possible issue

[Charles Hedrick]

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.