 | This article is rated Stub-class on Wikipedia's content assessment scale. It is of interest to the following WikiProjects: | ||||||||||||||||||||
| |||||||||||||||||||||
Tablespace types
editRegarding 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)
- 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)
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)
- 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)