RE: EnterpriseDB

From: Richard J. Goulet <rgoulet_at_kanbay.com>
Date: Wed, 21 Feb 2007 12:26:12 -0500
Message-ID: <C3EE2ADD31ACF64DAB1B236044A1968D5CE6B2@miaexc01.kanbay.com>

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_at_kanbay.com

: POWERING TRANSFORMATION

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield Sent: Wednesday, February 21, 2007 11:06 AM To: Richard J. Goulet
Cc: rjfeighery_at_gmail.com; Oracle-L List
Subject: Re: EnterpriseDB

On 2/21/07, Richard J. Goulet <rgoulet_at_kanbay.com> 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

-- http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 21 2007 - 11:26:12 CST