Extract BLOB PDF file from oracle database to Local storage
I want to extract only PDF files from the BLOB column to local storage. The total size of the BLOB - log segment is 35 TB. I don't find any optimal way to extract without impacting the production. Considering the large amount of data that needs to extract I believe it is not achievable thru PL/SQL code. I'm looking for a solution to extract the data in a fast manner with minimal impact to the production system.
Thanks in advance.