row size script
From: Feldman Roger <qrarofe_at_era.ericsson.se>
Date: Wed, 21 Feb 2001 14:27:54 +0100
Message-ID: <3A93C25A.C0835B3C_at_era.ericsson.se>
SQL> desc cq06.attachments_blob
Name
Null? Type
Date: Wed, 21 Feb 2001 14:27:54 +0100
Message-ID: <3A93C25A.C0835B3C_at_era.ericsson.se>
[Quoted] Hello again:
I've got a table which is a BLOB table which contains lots of attachments for a program. Each attachment(Oh yes ! word docs and other garbage) are placed into a row.
When these babies get to big my buffers start to moan during imports.
Q:
How do I determine the size of each row ?
Anybody got a script ?
Here is how the table looks:
SQL> desc cq06.attachments_blob
Name
Null? Type
- -------------------------------------------------
ATTACHMENTS_DBID
NUMBER(10)
ENTITY_DBID
NUMBER(10)
ENTITY_FIELDDEF_ID
NUMBER(10)
DATA
LONG RAW
THANX,
Roger
~
~
~
Received on Wed Feb 21 2001 - 14:27:54 CET