Re: Estimating required space in autoallocated tablespace

Yash R. Ganthe wrote:
>
> 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

If you can, probably the most accurate way is to load up a sample, run an analyze and check xxx_tables. The takes into account the various block and row overheads.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."