Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Import 7.3.4 Table Size Estimation Challenge

Re: Oracle Import 7.3.4 Table Size Estimation Challenge

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: Wed, 03 Mar 1999 17:55:56 GMT
Message-ID: <MIeD2.32595$rs2.9736068@client.news.psi.net>


Hi David,

    When in doubt allocate two times the size of the input file. Load it into its own tablespace so that you can move the table to a more realistically sized space once you have it loaded.

regards

Jerry Gitomer

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 Wed Mar 03 1999 - 11:55:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US