Talk:Tablespace

This article is rated Stub-class on Wikipedia's content assessment scale. It is of interest to the following WikiProjects:

Computing: Software Low‑importance This article is within the scope of WikiProject Computing, a collaborative effort to improve the coverage of computers, computing, and information technology on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.ComputingWikipedia:WikiProject ComputingTemplate:WikiProject ComputingComputing Low This article has been rated as Low-importance on the project's importance scale. This article is supported by WikiProject Software. Databases (inactive) This article is within the scope of WikiProject Databases, a project which is currently considered to be inactive.DatabasesWikipedia:WikiProject DatabasesTemplate:WikiProject DatabasesDatabases

Regarding the three types of tablespaces: are those three types common to all databases which support tablespaces, or is that just an Oracle thing?

No, it's an oracle thing. PostgreSQL and MySQL only have a single type of tablespace, for example. There are often different ways of handling the same problem though. MySQL's InnoDB engine, for instance, does have seperate files for logs (effectively an undo tablespace), but it these aren't called "undo tablespaces". Rather, a tablespace is more like a collection of data files and log files together. I'm not sure specifics on how other databases externalize these concepts. Tablespace is a pretty universal concept, but these three subtypes is more of an oracle invention. These also weren't available in older versions of oracle - they evolved over time. Warthog32 18:24, 8 August 2006 (UTC)Reply

That's not true. PostGreSQL has tablespaces and so does DB2. - Tbsdy lives (formerly Ta bu shi da yu) ^talk 01:17, 25 April 2009 (UTC)Reply

Oracle stores data logically in tablespaces and physically in datafiles associated with the corresponding tablespace.

Retrieved from "http://en.wikipedia.org/wiki/Tablespace"

Do you mean: "Oracle stores data physically in tablespaces and logically in datafiles"? —Preceding unsigned comment added by 86.90.130.198 (talk) 19:07, 27 February 2008 (UTC)Reply

No, data is physically stored within a datafile. They aren't logically stored in data files! - Tbsdy lives (formerly Ta bu shi da yu) ^talk 10:02, 23 April 2009 (UTC)Reply