Re: Estimating required space in autoallocated tablespace

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 30 Aug 2002 11:32:12 +1000
Message-ID: <3Ozb9.18441$g9.57595@newsfeeds.bigpond.com>

Hi Yash,

Is there a reason why you're not considering a UNIFORM size ?

Cheers

Richard
"Yash R. Ganthe" <yash_ganthe_at_hotmail.com> wrote in message news:akl05s$9pa$1_at_news.vsnl.net.in...
> Hi,
> Perhaps a DBA should think over this.
> I know the approximate number of records that will be loaded in the table
> through SQL*Loader. The tablespace is autoallocated, locally managed . Is
it
> possible to estimate the space the entire data will take, before the
loading
> is actually done? I am using Oracle 8.1.7. I also know the approximate
space
> a single row will take. This is based on past performance with user
managed
> tablespaces. I am aware that the sizes of extents allocated in
autoallocated
> tablespaces is variable. That complicates my problem.
>
> Can somebody help?
>
> Yash
>
>
>
>
Received on Thu Aug 29 2002 - 20:32:12 CDT