BI Publisher (MOSC)

MOSC Banner

Extract BLOB PDF file from oracle database to Local storage

edited Aug 10, 2023 9:02PM in BI Publisher (MOSC) 1 commentAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center