Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Row Size Question
David Spencer wrote:
>
> Hi Folks,
>
> I'm attempting to estimate the amount of disk space an Oracle7 database
> requires. I have about a hundred tables and know approximately how many
> rows will be in each table. What I need is a way to find how many bytes
> a row in a given table will occupy. The column types (mostly) have a
> fixed size. Is there a tool or command that does this?
>
> thanks,
> David Spencer
Try using the analyze command on the required tables...
HTH
Received on Thu Oct 29 1998 - 06:21:33 CST