Re: space script

Why not analyze the table in question, and:

SELECT avg_row_len FROM user_tables
WHERE TABLE_NAME = 'the table in question'

Hope this helps. I found this to be useful when estimating data sizing for production environments from tables in the development environment.

Ed Lufker wrote:
>
> Hi All;
>
> Does anyone have a script that will calculate average row
> length????
>
> thanks in advance
> eddie lufker
 

-- 
 ------------------------------------------------------------
| JoeViau_at_ids.net | It's a paradox within an enigma, wrapped |
|                 | by a riddle dipped in special sauce,     |
|                 | with a pickle to go!                     |
 ------------------------------------------------------------