Determine Data size in Table with LONG RAW
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:
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
That would be about 35 meg.
I am exporting the table now, and the export file just hit 300 meg.
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.
Certifiable Oracle DBA and Part Time Perl Evangelist
http://www.freelists.org/webpage/oracle-l Received on Thu Feb 28 2008 - 17:49:52 CST