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: Thu, 22 Feb 2001 13:17:07 -0000
Message-ID: <9733gr$5rt$1@soap.pipex.net>

The reason I asked version is that in a brain dead moment I thought that you could use sql*loader direct path. This of course does not work for LOBs. Sorry.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Feldman Roger" <qrarofe_at_era.ericsson.se> wrote in message
news:3A94DAAE.685F6F23_at_era.ericsson.se...

> Niall Litchfield wrote:
>
> > what oracle version?
>
> The real version is on oracle 7 ...
>
> I'm testing on 8i
>
>
> So far I've been fooling around with :
>
>
> select DATA, vsize('DATA') "bytes" from cq06.user_blob;
>
> But that doesnt give the right info- I'm trying :-)
>
>
> Thanks !
>
> Roger
>
Received on Thu Feb 22 2001 - 07:17:07 CST

Original text of this message

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