Problem solve
Get help with specific problems with your technologies, process and projects.
Converting Long Raw to Blob
Expert Greg Williams explains when and how to convert Long Raw to Blob using PL/SQL.
I have to migrate the data of Schema1.table1 to schema2.table2. The Long Raw column data is not getting migrated as expected. It is showing a numeric error. How do I do this using PL/SQL script?
Since long (raw) will be going away, in future releases of Oracle database, I would recommend that you convert your Long Raw to a Blob and your Long to Clob. Then you can migrate your table to another schema within the same database release or to a higher database release.
The following statement will convert your long raw to a Blob:
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
Step 2 of 2:
ALTER TABLE long_tab MODIFY ( long_col bLOB );
Where the column long_col was a long raw datatype converted to a blob datatype.
Here's some more information on the advantages of using a lob over a long raw.
This was last published in February 2008
Dig Deeper on Oracle development languages
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments