[Deploying Sakai] [Building Sakai] Converting Oracle LONGs to LOBs?

[mizematr at notes.udayton.edu]

I don't think so.  We converted a solitary table long before we converted 
all tables and did not run into trouble.
---------------------------------------------------------------------------
Matt Mize, Systems Administrator
 - Pay no attention to the man in the back office....
Matt.Mize at notes.udayton.edu
(937) 229-1024

UDit Department, University of Dayton
300 College Park, Dayton, OH, 45469-1302



Michael Appleby <michael.appleby at yale.edu> 
Sent by: sakai-dev-bounces at collab.sakaiproject.org
06/01/09 02:24 PM

To
Sakai-Dev Developers <sakai-dev at collab.sakaiproject.org>
cc
"production at collab.sakaiproject.org" <production at collab.sakaiproject.org>
Subject
Re: [Building Sakai] [Deploying Sakai] Converting Oracle LONGs to LOBs?







Is there any downside to converting only a single table 
(MAILARCHIVE_MESSAGE)?   We are seeing ORA-22295 coming from the Email 
Archive in the 2.6 code that we just put into production.   The existing 
XML column is LONG but the newly added BODY column is a CLOB. 

I've created an issue for this ( SAK-16463 ).

-Michael

Adams, David wrote:
> Hello,
> We've recently run into an Oracle error where updating a table
> (METAOBJ_FORM_DEF) with both a LONG and a LOB field using over 4k of
> data triggers an Oracle exception (ORA-22295[1]). This problem was
> reported in SAK-12914[2] but hasn't been resolved. Our DBAs have been
> bugging us to find a way to get rid of the LONG columns anyway, as they
> complicate management of backups and other processes.
>
> Folks from Michigan have mentioned in various places that they have
> converted at least some of their LONG columns to LOBs. I was wondering
> if they or anyone else could post (or point me to) the steps they took
> to do the conversion, and if any code changes were necessary. And is
> there any movement on getting rid of the LONG fields in the Sakai
> source?
>
> Thanks!
>
> -dave
>
> [1] http://www.error-code.org.uk/view.asp?e=ORACLE-ORA-22295
> [2] http://jira.sakaiproject.org/jira/browse/SAK-12914
>
> David Adams
> Director of Learning Systems Integration and Support
> Virginia Tech Learning Technologies
> 

-- 

Michael Appleby

Academic Media & Technology
Information Technology Services
Yale University

e michael.appleby at yale.edu
p 203.432.6686




_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev

TO UNSUBSCRIBE: send email to 
sakai-dev-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/20090601/2be2ede6/attachment.html