Solved

oracle 10g table containing BLOBS

Posted on 2016-07-19
3
39 Views
Last Modified: 2016-07-19
Guys, We upload to oracle multiple pdf documents and they are stored in the table as a BLOB this is fine. What I would like to know is it possible to know what the size of the record that has been inserted or how big the pdf file is.

The reason I am asking is I have reason to believe that the automated method that we use to upload to oracle had an off day and has been uploading empty 0kb file to oracle and I want to check if this is true.

It may have only been doing this for a short period of time.

Any ideas
0
Comment
Question by:DarrenJackson
  • 2
3 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
dbms_lob.getlength

http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_lob.htm#ARPLS66709

select dbms_lob.getlength(your_blob_column) from your_table;
0
 

Author Comment

by:DarrenJackson
Comment Utility
This is perfect exactly what I am looking for

Thank you
0
 

Author Closing Comment

by:DarrenJackson
Comment Utility
Thank you
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now