Re: 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:58:01 -0800
Oh, never mind, I can't do simple arithmetic this week.
The stats from ANALYZE were accurate, as that should have
been 350 Meg, not 35 Meg.
Jared
On Thu, Feb 28, 2008 at 3:49 PM, Jared Still <jkstill@xxxxxxxxx> wrote:
>
> 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
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
