Estimating required space in Autoallocated tablespace

From: Yash R. Ganthe <yash_ganthe_at_hotmail.com>
Date: Mon, 26 Aug 2002 13:25:46 +0530
Message-ID: <akclts$oq4$1@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 Mon Aug 26 2002 - 02:55:46 CDT