Oracle People:
I've had a bad time trying to find the size of the rows of a BLOB table. I got so far as to realize the "VSIZE" function could help-
But, it won't work on LONG RAW DATA:
SQL> select count(*), vsize(DATA) from cq06.user_blob;
select count(*), vsize(DATA) from cq06.user_blob
*
ERROR at line 1:
ORA-00997: illegal use of LONG datatype
-----------------------
Here is the "desc" of the offending table:
SQL> desc cq06.user_blob;
Name Null? Type
----------------------------------------- -------- ---------------------------- DBID NUMBER(10)
DATA LONG RAW
I'd really like to know the size of all the entries of DATA.
Thanx,
Roger
