Re: Converting TEXT/BLOB types

>Attempting to load Informix tables into Oracle 7.1 tables.. >Is there a way to convert an Informix text/blob field type to a >varchar or even a char datatype. > >thanks..chet Geez, Chet, your first mistake is in trying to downgrade to Oracle! ;^) You can't convert a BLOB because it is a binary object - you should be able to export it from Informix and insert it in the Oracle datatype that stores binary objects (whatever it is). I would export the text to flat ascii and then load it into Oracle after parsing with a front end program (if necessary). Bill Williams E-Mail: bwilliam@jaxnet.com Flames: nobody@nowhere.com -or- redirect to /dev/null +-----------------------------------------------------------------+ | Disclaimer: My views, opinions, and judgments are my own. | +-----------------------------------------------------------------+ | "Free scientific inquiry" is a redundancy. | | "Free governmental inquiry" is self-contradictory. | | | | Be sure to read "Atlas Shrugged" by Ayn Rand. It's the world's | | greatest novel, rated #2 of those books readers said had the | | most impact on their lives (NY Times readership poll)! | +-----------------------------------------------------------------+