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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: EnterpriseDB

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

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

Original text of this message

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