Convert Long to Long RAW in 10gR2

Folks

Of a 10gR2 Database, in a 700 GB Table the LONG Field contains standard JPEG Image with JFIF Compression.

Running CSSCAN to check Character Set conversion from US7ASCII(default) to AL32UTF8 shows all rows as "Lossy conversion"

Oracle Corp's reply "If you wan to store JPEG's in a Table then you need to use LONG RAW instead of LONG or better BLOB & you need to change this
*before* going to UTF8."

NOTE - A Pro*C Application accesses the respective LONG field to display the Respective JPEG Image.

Qs. What are easier ways to convert the LONG field to a LONG RAW field? Will conversion need an additional 700 GB Space?

Qs Will conversion to LONG RAW field impact the Image access Functions, respective Pro*C Code & thus need a corresponding Change? (Conversion to BLOB will certainly necessitate a Change in the manner of access i.e. respective Functions & Pro*C Code, to my understanding)

Thanks indeed

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
  ***INFOSYS******** End of Disclaimer ********INFOSYS***
  -- http://www.freelists.org/webpage/oracle-l