Niall, Datafiles, not tablepaces. No you haven't missed anything. Dick Goulet, Senior Oracle DBA 45 Bartlett St Marlborough, Ma 01752, USA Tel.: 508.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795 RGoulet@xxxxxxxxxx : POWERING TRANSFORMATION ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Niall Litchfield Sent: Wednesday, February 21, 2007 11:06 AM To: Richard J. Goulet Cc: rjfeighery@xxxxxxxxx; Oracle-L List Subject: Re: EnterpriseDB On 2/21/07, Richard J. Goulet <rgoulet@xxxxxxxxxx> wrote: Where as in Oracle a database can have multiple tablespaces in postgresql they can have only one, but different databases can each have a separate tablespace or storage location. A lot better than MySql or Sql*Server, but not quite the same as Oracle. Why a lot better than SQLServer? SQLServer has supported multiple datafiles per database in separate locations for ages - at least since sql 2000. Or am I missing something? -- Niall Litchfield Oracle DBA http://www.orawin.info