Estimating required space in autoallocated tablespace

From: Yash R. Ganthe <yash_ganthe_at_hotmail.com>
Date: Thu, 29 Aug 2002 17:09:58 +0530
Message-ID: <akl05s$9pa$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 Thu Aug 29 2002 - 06:39:58 CDT