Re: Estimating required space in Autoallocated tablespace

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 28 Aug 2002 16:27:52 GMT
Message-ID: <3D6CF9EF.94D26434@exesolutions.com>

"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

Yes. Go to http://otn.oracle.com and you should quickly be able to locate documents telling you how to do it.

But hopefully you have a development machine? Why not use it?

Daniel Morgan Received on Wed Aug 28 2002 - 11:27:52 CDT