Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Row size script

Re: Row size script

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 21 Feb 2001 16:04:45 -0000
Message-ID: <970ov0$fq8$1@soap.pipex.net>

what oracle version?
"Feldman Roger" <qrarofe_at_era.ericsson.se> wrote in message news:3A93C25E.92ED04CC_at_era.ericsson.se...
> 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 - 10:04:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US