[Deploying Sakai] Lessons on Oracle possible issue

[Qinsheng Zhu]

Take a look and see where the table is created by running the following
query:

select table_name,tablespace_name from user_tables where lower(table_name)='
lesson_builder_items';

If the result is SYSTEM, then it means the table is created in SYSTEM
tablespace (may be along with all the other tables) and you need to move
them to other tablespaces.  This is unlikely the case.

You may just need to ask your DBA to increase the size of the SYSTEM
tablespace.

Thanks,
Drew



On Thu, May 1, 2014 at 11: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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20140501/8966de57/attachment.html