[Deploying Sakai] Converting Oracle LONGs to LOBs?

Adams, David da1 at vt.edu
Tue May 26 12:45:06 PDT 2009


Great, thanks Seth. That covers LONG to CLOB, so I think we can feel
confident about converting those. Relatedly, has anyone switched LONG
RAW to BLOB?

On the particular problem we are having, we were just now able to
convert LONG RAW to BLOB on METAOBJ_FORM_DEF.SCHEMADATA in our test
environment and solves the problem reported in SAK-12914, but we haven't
had a chance yet to verify that other operations on that table continue
to work as expected.

Thanks for everyone's help so far.


-dave

> -----Original Message-----
> From: Seth Theriault [mailto:slt at columbia.edu]
> Sent: Tuesday, May 26, 2009 3:14 PM
> To: Adams, David
> Cc: production at collab.sakaiproject.org; Sakai-Dev Developers; Najdi,
> Jihane; Humphries, William
> Subject: Re: [Deploying Sakai] Converting Oracle LONGs to LOBs?
> 
> Adams, David wrote:
> 
> > 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.
> 
> Michigan posted a document on their experience here back in 2007:
> 
> http://jira.sakaiproject.org/jira/browse/PROD-2
> 
> Seth



More information about the production mailing list