[Deploying Sakai] Lessons on Oracle possible issue

[Steve Swinsburg]

If you are going to use a LONG datatype, you might as well just declare it as VARCHAR2(32767) as that is what you are limited to. If you are storing it as JSON and are unsure of the data length, I’d be using a CLOB. 

cheers,
Steve


On 2 May 2014, at 1:24 am, Charles Hedrick <hedrick at rutgers.edu> wrote:

> 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.
> 
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
> 
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"