user11986571 wrote:Based on what you've told us, how would we know? Is your undescribed table simply a listing of pdfs and their locations as external files? Are the pdfs stored as blobs within the database?
I am trying to figure out how uploaded supplier contracts (PDF) are stored in the Oracle Database. Our legal department has been tasked with extracting all our originals. I have queried OKC_REP_CONTRACTS_ALL, so I have our entire inventory. I wanted to see if there is a "Silver Bullet" for me to extract all the actual soft-copies to PDF ie. are they stored on a directory that I can access via a SFTP tool?
user11986571 wrote:I assume you can at least connect to the database server with an account that is a member of the dba (*nix) or ora_dba (windows) group. BTW, what OS is this on?
To be honest, I am a totally new to the process and know little re the storage of this data. The table I have described is a key base table for users to retrieve and view contracts via the HTML frontend. From what I understand, several consultants spent weeks uploading individual PDF files via a Java based Front-End template and populating fields that are stored on the aformentioned table. There is a field that describes Storage ie. 11568183.PDF, etc, but nothing that I can drill back to a blob. Based on what I know about Oracle and the described process, I would assume that it's stored as blobs within the database. I do not know if I can simply find the BLOB in the database and extract from them. I have very limited knowledge and unfortunately our key people are no longer here. Is there something I can do to test?
Thanks in advance for your help!
copy the commands and results back to here on your next post.
sqlplus / as sysdba ---- this should get you connected to the database. Then: sql> desc OKC_REP_CONTRACTS_ALL