Sunday, March 02, 2008

Differences Between MS SQL Server 2005 and Oracle Database 10g

  • Oracle Tablespaces & SQL Server Filegroups

    Tablespaces in Oracle are equivalent to SQL Server Filegroups. They each are logical groupings of physical data files used to store related database objects, such as tables, indexes, etc. In Oracle 10g, two tablespaces are created when creating a database, by default: SYSTEM and SYSAUX. In SQL Server, one filegroup is created when creating a database, by default: PRIMARY. In both RDBMSes, you can create user-defined tablespaces and filegroups, in addition the the preceding mentioned.

    In Oracle 10g, you have the added benefit of being able to mark a tablespace as temporary, allowing tables added to be managed on a per-user-basis. For example, data added to a table in a temporary tablespace will only be modifiable by that user and that user only. There are other tablespace features, such as making them dictionary or locally managed.

  • Oracle Blocks, Extents, and Segments & SQL Server Pages & Extents

1 comment:

Anonymous said...

I was expecting to read more on how SQL Server competes with tablespaces concept of Oracle?