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 usage question....................................................................................................................................

Re: Tablespace usage question....................................................................................................................................

From: Vincent Birlouez <birlouezv_at_logica.com>
Date: 1998/03/30
Message-ID: <351FC4BD.71400CD2@logica.com>#1/1

Yes.

A Ustby wrote:

> The question I have deals with table space allocations within a tablespace.
>
> Lets say I have a tablespace allocated with 3 datafiles of 100M each (total
> of 300 M). I have found that if I have a table whose primary allocation is
> 120M, I'll have problems because the primary size is greater than one of the
> datafiles. So I have determined that the primary space must be held within
> a single datafile.
>
> My main question is, for a given table, that goes into multiple
> extents, can those extents be in different datafiles within the tablespace ?
Received on Mon Mar 30 1998 - 00:00:00 CST

Original text of this message

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