Re: calculate Tablespace

On Tue, 25 Sep 2001, stefan.porges_at_berlin.de wrote:

> could somebody please help. I dont know, how to calculate the
> needed tablespace. Sample table with 30 columns( 1 - column
> Number and 29 columns char(20) ) initial data = 3000 rows
> average growth = 10 rows per day
>
> How many kb - tablespace should i furnish and why?

Your question is a bit confused. A tablespace's size isn't really calculated, a tablespace is made up of datafiles. Take the size of all the files in a tablespace and that's how big your tablespace will be. So, you need to decide how big your files will be, but you don't really have to do this either, because you can have your datafiles autoextend.

So, your question becomes more of a, "How should I manage my datafiles?" type question. To answer this question, one needs much more information than provided.

Does this make sense?

Other than that, I assume you aren't asking us to do the math for you?

-- 
Galen Boyer
Everyone in town, now, they probably all agree,
I'm _lying_ in the bed I made.