I have a table which has a blob column in which most of the regular filetypes can be stored. What is the best/easiest way to select/query this table and write all the blob contents into a local file system? Am using oracle 10.2. Is there a way of somehow batch processing all the blobs and saving them to my local drive? Any and all help is appreciated. Thank you.