[SAK-7977] Change fields from long to clob for Oracle Created: 07-Oct-2006 Updated: 30-Jun-2014 Resolved: 14-Feb-2010
|Component/s:||Database service (Pre-K1/2.6)|
|Affects Version/s:||2.2.0, 2.2.1, 2.2.2, 2.2.3, 2.3.0, 2.3.1, 2.3.2, 2.4.0, 2.4.1, 2.5.0|
|Reporter:||John Leasia (Inactive)||Assignee:||Unassigned|
|Remaining Estimate:||Not Specified|
|Time Spent:||Not Specified|
|Original Estimate:||Not Specified|
This relates to
On Thu, Aug 10, 2006 at 02:49:25PM -0400, Drew Zhu wrote:
|Comment by Peter A. Knoop [ 05-Oct-2007 ]|
LONG is deprecated in Oracle, so we need to switch to CLOB for the next release (2.6). This will involve both conversion scripts and code changes.
|Comment by David Horwitz [ 23-Jan-2010 ]|
Maintenance team review: If this issue is being worked on please take ownership of it by assigning it to yourself. Otherwise it is likely to be closed as an abandoned issue. If this is not being pursued please close the issue.
|Comment by David Horwitz [ 14-Feb-2010 ]|
[Bulk Change]: MAINT TEAM REVIEW: this appears to be an abandoned issue if this is still being activly followed please update the information and make sure is is assinged to the developer/team adressing it.
|Comment by Earle R Nietzel [ 28-Mar-2013 ]|
If someone comes by this issue and creates a script to do this please share it.
|Comment by David Adams [ 29-Mar-2013 ]|
I've cleaned up and generified the script we used to address this issue originally. See:
The script will by default just scan for LONG and LONG RAW fields but will not change any data. See the usage notes for the command line argument needed to convert the LONG fields to LOB fields. This works on my systems, but I can't guarantee it will work for everyone, or for all versions of Oracle (we run 188.8.131.52) or SQL*Plus. Always understand what the script is doing before you try to run it and test it thoroughly on a non-production system with realistic data before attempting it with your production systems.