Re: Oracle Import 7.3.4 Table Size Estimation Challenge

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Fri, 5 Mar 1999 10:06:46 -0000
Message-ID: <920628587.1013.0.nnrp-08.c2de6f3d@news.demon.co.uk>

If you knew the export was done with COMPRESS=Y, you could run the import with SHOW=Y and from the DDL definitions extract the initial extent sizes.

Otherwise, I'm lost :-(

David Lesnick wrote in message ...
>Does anybody out there in the orange tinted world of Oracle have any rules
>of thumb for estimating the following:
>Given a non-compressed import file is there any means for roughly gauging
>how big to allocate a data file required to accommodate the import. The
size
>of the file itself is known, but nothing else. Thanks.
>
>
Received on Fri Mar 05 1999 - 04:06:46 CST