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: Tablespace Size Requirement

Re: Tablespace Size Requirement

From: tmgn <tmgn_at_excite.com>
Date: Mon, 23 Aug 1999 16:12:46 -0400
Message-ID: <37C1AB3E.472BDE2C@excite.com>


Hard to predict ..becos of various facotrs like Compression ratios,Os Filesystem characterstics etc.
But you can do a
Imp rows=n show=y file=
and look at the Table&Index Storage Characterstics. That will give you an idea of what to expect and how to Size u'r Objects or Tablespace.

Size the Tablespace atleast 3-5 times the Size of the Export file to start with..

-Thiru

bp_at_bp.com wrote:

> Hello,
>
> Anyone with a rule of thumb for tablespace size requirements based on size
> of Oracle export file to be recovered ?
>
> Thanks,
>
> M.
Received on Mon Aug 23 1999 - 15:12:46 CDT

Original text of this message

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