Migration from RAW LONG to BFILE
278203Apr 22 2009 — edited Apr 22 2009As part of our next release, we are looking at modifying the way we currently store image data. The current table has a RAW LONG column, and i want to move to external storage BLOBs. The new table will be in a different schema.
I believe I can covert the RAW column to BLOB, but that doesn't solve the external problem.
AT a high level, it seems like I will need to do the following:
- Go through the current rows and create an external image
- Reload all of the images into new table with BFILE column pointing to new image location
Anyone have any recommendations as to the steps I may need to perform??
_mike
Edited by: nibeck on Apr 22, 2009 2:49 PM
Edited by: nibeck on Apr 22, 2009 2:49 PM