Results 1 to 4 of 4

Thread: Size of a BLOB

  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Question Unanswered: Size of a BLOB

    Is the a sql statement that I can use to get this size of a blob?

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    you mean a specific row?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    this query may help .....
    PHP Code:
    SELECT
    SEGMENT_NAME 
    "OBJECT",
    segment_type "TYPE",
    tablespace_name "TABLESPACE",
    to_char(bytes/1000000,'fm999,999,999,999,999')||' MB' "CURSIZE",
    extents,
    to_char(initial_extent/1000000,'fm999,999,999,999,999')||' MB' "INITIAL_EXT",
    to_char(next_extent/1000000,'fm999,999,999,999,999')||' MB' "NEXT_EXTENT",
    pct_increase "INC",
    bytes,
    next_extent "CHECKSIZE",
    max_extents
    FROM dba_segments
    WHERE segment_name IN 
    (SELECT segment_name FROM dba_lobs WHERE table_name 'WWV_DOCUMENT$'
    There are 10 types of people in the world, those that know Binary and those that don't.

  4. #4
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    Try this:

    SQL> select dbms lob.getlength(blob col) from schema.mytable;


    HTH,

    clio_usa - OCP 8/8i/9i DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •