Determine Data size in Table with LONG RAW

From: "Jared Still" <jkstill@xxxxxxxxx>
To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 28 Feb 2008 15:49:52 -0800

Anyone here have a good method to determine the size of the
data in a table that includes a LONG RAW column?

Things I have tried:

Table statistics
Due to bug 58426286 no table with a LONG RAW column that is
analyzed with DBMS_STATS will get accurate statistics.

The workaround is to use 'ANALYZE...COMPUTE'
I find that to be inaccurate also.  The stats suggested 50k rows with a 7k
avg
row length.

That would be about 35 meg.
I am exporting the table now, and the export file just hit 300 meg.

COPY command
I thought maybe the SqlPlus copy command would work, creating a
densely packed table.

COPY works with LONG, but not LONG RAW.

Currently I am doing an export, but some other method would be preferable.

Any ideas?


-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Follow-Ups:

Re: Determine Data size in Table with LONG RAW
From: Jared Still

Determine Data size in Table with LONG RAW

Other related posts: