Re: SQL Server for Oracle DBAs
From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 31 May 2008 10:43:52 -0700
Message-ID: <1212255843.194945@bubbleator.drizzle.com>
>
> So I fully expect you as a professional will go and fix your comparison
> article:
>
> http://www.psoug.org/reference/sqlserver.html
>
> The SQL Server FILE GROUP maps to a Oracle TABLESPACE and not a Logical
> File Name as you state.
>
> A Logical File Name in SQL Server is a component of a File Group and
> there can be many Logical File Names as you put it per File Group
Date: Sat, 31 May 2008 10:43:52 -0700
Message-ID: <1212255843.194945@bubbleator.drizzle.com>
Tony Rogerson wrote:
>> This webpage is near zero-value. An Oracle DBA doing this will be nearly >> clueless based on the very substantial amount of information that is >> either incorrect or missing. >> >> Among the obvious factual errors: >> "Because an extent is a contiguous allocation of blocks, large extents >> aid in better I/O rate while reading huge amounts of data." >> >> "Oracle tablespaces are at the instance level."
>
> So I fully expect you as a professional will go and fix your comparison
> article:
>
> http://www.psoug.org/reference/sqlserver.html
>
> The SQL Server FILE GROUP maps to a Oracle TABLESPACE and not a Logical
> File Name as you state.
>
> A Logical File Name in SQL Server is a component of a File Group and
> there can be many Logical File Names as you put it per File Group
Done. The only reason I hadn't updated it before is I am working on a project involving 2008 and have been working on a new version.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sat May 31 2008 - 12:43:52 CDT